Senior Data Analyst/Data Analyst III

Medica is a nonprofit health plan with more than a million members that serves communities in Minnesota, Nebraska, Wisconsin, Missouri, and beyond. We deliver personalized health care experiences and partner closely with providers to ensure members are genuinely cared for.

We're a team that owns our work with accountability, makes data-driven decisions, embraces continuous learning, and celebrates collaboration — because success is a team sport. It's our mission to be there in the moments that matter most for our members and employees. Join us in creating a community of connected care, where coordinated, quality service is the norm, and every member feels valued.

This 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. Performs other duties as assigned.

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
  
  

Required Qualifications

• Bachelor's degree in computer science or equivalent experience in related field
• 5 years of experience in software development and database applications with a majority of this experience in data strategy, sourcing, modeling, integration, and architecture
  
  

Preferred Qualifications

• 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
  
  

Skills And Abilities

• Strong analytical and conceptual thinking skills
• Influencing stakeholders and work closely with them to determine acceptable solutions
• Familiarity with technology and data management principles.
• Excellent documentation skills
• Fundamental analytical and conceptual thinking skills
• Experience creating detailed reports and giving presentations
• A track record of following through on commitments
• Planning, organizational, and time management skills
  
  

This position is an Office role, which requires an employee to work onsite, at our Minnetonka, MN office on average, 3 days per week.

The full salary grade for this position is $98,400 to $168,600. While the full salary grade is provided, the typical hiring salary range for this role is expected to be between $98,400 - $140,500. 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.

Eligibility to work in the US: Medica does not offer work visa sponsorship for this role. All candidates must be legally authorized to work in the United States at the time of application. Employment is contingent on verification of identity and eligibility to work in the United States.

We are an Equal Opportunity employer, where all qualified candidates receive consideration for employment indiscriminate of race, religion, ethnicity, national origin, citizenship, gender, gender identity, sexual orientation, age, veteran status, disability, genetic information, or any other protected characteristic.