Wellmark - Des Moines Data Governance Analyst in Des Moines, Iowa
What’s the role? In this role, you will ensure the integrity of data within Wellmark’s data warehouse through the proper execution of tasks as outlined below. During the BUILD of data warehouse assets, you will have oversight of the Design and Development phases of the SDLC software development life cycle process, such as working as a member of an IP team to coordinate work, conducting a Data Impact Assessment of the proposed design, profiling data to ensure it is fit for use, conducting Source to Target reviews, and identifying and loading Code Sets and Metadata. During the RUN of data warehouse assets, you will support smaller ACR (fix or enhancement) requests, the creation of Data Scorecards, or helping to research and resolve data issues.
What does it take to make the cut? At least one year of experience in a data management or analytics type role that reflects knowledge and use of data management tools and processes. A background in SAS, data warehousing, and data management are ideal and will help set you up for success in this role. You are analytically minded and have a tried-and-true approach to problem solving. To be a high performer, you have a passion for getting things done right and even investing extra time when needed to do so. Your friends and coworkers are quick to note your holistic perspective, especially as it relates to seeing a project through its lifecycle.
Why Wellmark? We are a mutual insurance company owned by our policy holders across Iowa and South Dakota, and we’ve built our reputation on over 80 years’ worth of trust. We are not motivated by profits. We are motivated by the well-being of our friends, family, and neighbors–our members. If you’re passionate about joining an organization working hard to put its members first, to provide best-in-class service, and one that is committed to sustainability and innovation, consider applying today!
Bachelor’s degree or direct and applicable work experience.
1+ year of experience in a business analyst, business systems-type role which reflects analytics and business intelligence tools usage.
Analytical skills with the ability to work with modeling, designing and implementation of quality management solutions while working closely with key business stakeholders.
Ability to identify issues or inconsistencies, obtain relevant information, relate, and compare data from different sources, and recommend alternative, “out of the box” solutions.
Technical skills and ability to work with SQL and/or Business Objects and/or metadata tools such as Tableau.
Demonstrated high attention to detail.
Proven organizational and time management skills with the ability to continually re-prioritize and/or multi-task.
Ability to communicate effectively verbally and in writing, expressing complex concepts clearly and concisely in order to deliver messages suited for the audience.
- Bachelor’s degree.
a. Perform as a member of an IP Team to help coordinate work user stories and identify tasks to be scheduled to sprints as part of SDLC projects or ACRs as submitted by the business.
b. Conduct data Impact Assessments to review the appropriateness of the proposed design for SDLC projects, and the second order impacts to data integrity to the rest of the data warehouse.
c. Perform Data Profiling and analysis to provide descriptive statistics and insights in order to aid other Data Governance and Technology resources in defining data requirements, the design of data assets, the creation of Source to Target documentation, testing, and the development of technical and business metadata.
d. Assist in implementation and maintenance of Business Metadata by entering new and/or updating existing business/logical names, definitions, and valid values in the business metadata repository. Maintain Technical Metadata from source to target data mappings in metadata repository. Communicate business metadata changes when data assets are released to production.
e. Support the development of data assets by entering code sets and code translation rules in Cross Reference Tables such as STAR, CDMA and Informatica RDM used during ETL processing.
f. Perform Source to Target reviews Design Reviews or Code Reviews as needed.
g. Support the remediation of data issues found in testing and production through data analysis when appropriate.
h. Develop, publish, and maintain Data Quality Scorecards in collaboration with the Data Stewards in order to automate the collection and monitoring of critical data elements. Create Data Quality Trend Statistics and identify potential data quality risks to lead Data Governance Analysts.
i. Identify potential data quality issues found through Data Quality Scorecards or Data Profiling. Provide support in the triage, impact analysis and resolution of data quality issues as needed by data steward or technology resources.
j. Develop tools to support the building and maintenance of data assets such as Testing, or Reporting tools needed by other Data Governance or Analytics resources. Will work with SQL programming and in applications such as SAS and Informatics to help create efficiencies and better business processes.
k. Keep informed, support and adhere to regulations and processes including Wellmarks software development lifecycle SDLC, data warehouse requirements / standards, Data Governance policies and procedures and business analysis and reporting protocols.
l. Other duties as assigned.
Requisition ID: 214399
REQUIRES NON-COMPETE?: No
External Company Name: Wellmark Blue Cross and Blue Shield
External Company URL: www.wellmark.com