Medica
is hiring
Senior Data Analyst
About Our Company
At Medica, we are committed to earning the trust of those we serve through our unwavering commitment to high quality, affordable health care.
We are a nonprofit health plan that serves communities in Minnesota, Arizona, Iowa, Kansas, Missouri, Nebraska, North Dakota, Oklahoma, South Dakota, Wisconsin and Wyoming.
As a company, we empower communities by listening to their voices, learning about community needs, and devoting time and resources to help.
Medica partners with the communities it serves in many ways, including the Medica Foundation, a nonprofit, charitable grant-making foundation. The Medica Foundation largely funds community-based programs and initiatives that provide sustainable, measurable improvements in the availability, access, equity and quality of health care.
In 2021, we formed a joint venture with SSM Health, and through that invested in Dean Health Plan. Medica and Dean Health Plan, both mission-driven health plans, have significant similarities in our histories, operations, cultures, and deep community commitment. Our new relationship is driven by technology, a mission driven vision, and innovation. Together we have an even greater opportunity to support the health care needs of members and patients, and to further enhance our provider relationships.
Job Description & Responsibilities
The Senior IT Data Analyst should have a background of Business, Systems, and Data Analysis. The role will involve working with the product owner to understand the business request and product need, perform detailed analysis of the requirements and data and creating user stories that will result in the data outcomes required. This position combines business process and data knowledge with experience in information technology to enable and improve business capabilities. Responsible for performing detailed data requirements analysis, documenting processes, and performing some user acceptance testing. To succeed in this role you should have a natural analytical way of thinking and be able to explain difficult concepts to non-technical users.
Key Accountabilities
- Evaluating business processes, anticipating requirements, identifying areas for improvement, and developing and implementing solutions using data analysis and data profiling.
- Gathering critical information from multiple stakeholders to specify and validate business reporting or data extracts using data mapping and data quality techniques.
- Establishing accurate data definitions and producing audience appropriate data models for the business or project domain. Coordinating and assisting developers and QA analysts to ensure data is accurately recorded and used.
- Understand requirements and identify non-functional requirements that will impact the data design.
- Decompose Product Features into User Stories
- Actively engaged as core member of scrum teams to deliver on data programs\projects.
- Work with ETL and QA to ensure all requirements are met by the solution. Work with DBA’s to tune performance
- Create and maintain source to target mapping documents.
- Conducting meetings and presentations to share ideas and findings.
- Performing requirements analysis.
- Documenting and communicating the results of your efforts.
- Effectively communicating insights and plans to cross-functional team members and management.
- Working closely with clients, technicians, and managerial staff.
- Providing leadership, training, coaching, and guidance to junior staff.
- Ensuring solutions meet business needs and requirements.
- Managing projects, developing project plans, and monitoring performance.
- Prioritizing initiatives based on business needs and requirements.
- Serving as a liaison between stakeholders and users.
Requirements
Qualifications
- BS in Computer Science or equivalent experience
- 7+ years of experience in software development and database applications with a majority of this experience in data strategy, sourcing, modeling, integration, and architecture
EXPERIENCE PREFERRED:
- Strong knowledge of SQL and query tools
- 3+ years of Erwin tool experience
- Experience in health care payer domain
- Experience in data analysis, data profiling, data mapping, and data quality
- Understanding of logical, physical, dimensional or relational data models; ERwin experience is desired
- Experience working with data warehouses and data marts
- Experience in ETL, reporting and analytics, or business intelligence tools is nice to have
What we offer
This position will requires an employee to occasionally come onsite to the designated office – Minnetonka, MN – for applicable heads-up work. Frequency is determined by business need as decided by leadership - but typically 1-2 days/week.
The full salary range for this position is $108,400 - $185,900. Annual salary range placement will depend on a variety of factors including, but not limited to, education, work experience, applicable certifications and/or licensure, the position's scope and responsibility, internal pay equity and external market salary data. In addition to base compensation, this position may be eligible for incentive plan compensation in addition to base salary. Medica offers a generous total rewards package that includes competitive medical, dental, vision, PTO, Holidays, paid volunteer time off, 401K contributions, caregiver services and many other benefits to support our employees.
The compensation and benefits information is provided as of the date of this posting. Medica’s compensation and benefits are subject to change at any time, with or without notice, subject to applicable law.
