We believe that the health insurance industry should do far more than just provide access to doctors and cover or administer claims. We believe health care plans should help people live healthier. Which is exactly what makes us different. As a health plan management and administrative services company, we’re leading the charge on everything from expanding network physician and provider options to creating innovative approaches to wellness, prevention and community well-being. That’s because at Quartz, we’re a company committed to good health.

Beginning in mid-2017, Gundersen Health Plan, Unity Health Insurance and Physicians Plus have joined forces under the Quartz brand name. Together, we provide our members with high-quality service and affordable coverage.

We manage services for those health insurance plans as well as provide administrative services for self-funded health plans as Quartz ASO, while serving 350,000+ customers who live in southern and western Wisconsin, parts of Illinois, Iowa, and Minnesota from offices located in Onalaska and Fitchburg, Wisconsin.

The Data Analyst – Quality Assurance will partner with the business to evaluate data needs and translate into deliverables for internal users and analytics applications as well as external entities including third party data feeds, regulatory, and governmental data needs. This position is responsible for collecting requirements, turning them into technical specifications, monitoring the quality of deliverables, and monitoring and governing the overall quality of the Enterprise Data Warehouse and the processes that feed it.

Responsibilities

• Collaborate with business users, external vendors and/or government entities to obtain data requirements for new analytics applications and data feeds or enhancement of existing products.
• Uncover appropriate sources of data for proposed application or data warehousing extension profiling data to ensure fitness for business purpose.
• Coordinate business requirements for the data and provide consultation to internal stakeholders to support their data needs.
• Understand source and target data structures, using standard data tools to review required data and fully profile the data to analyze its ability to meet the business needs.
• Complete impact assessments and ad hoc analyses to ensure that production issues and other reported deficiencies are adequately understood and resolved by updating requirements.
• Translate requirements into technical requirement specifications, appropriately documenting the solution via Report Specifications, Data Flow Diagrams, and Source to Target (STT) documents.
• Map source system data to data warehouse models.
• Work closely with data team to define appropriate logical and physical models to accurately reflect business processes and meet business needs.
• Validate final products meet business requirements and service level agreements.

Qualifications

• Bachelor’s Degree or equivalent work experience will be considered in lieu of education requirement, advanced certifications preferred
• 3+ years of relevant experience
• Strong communication skills with a passion for bridging the gap between business and technical users
• Knowledge of QA methodology and software development life cycle
• Experience with source to target documentation
• Excellent documentation and written communication skills
• Domain knowledge (healthcare, EHS, managed care, Medicare, etc)
• Intermediate knowledge of SQL, analytical software, query tools
• Intermediate knowledge of data warehousing principles including provenance, lineage, etc and applies best practices
• Ability to manage multiple projects simultaneously, work independently, under pressure, and be adaptable to change
• Must be inquisitive and seek answers to complex questions without being prompted
• Create strong relationships and provide positive experiences for internal partners