Data Quality Assurance Analyst

Summary

Mindlance is a company seeking a Data Quality Assurance Analyst to ensure the accuracy and integrity of public health data. The role involves collaborating with various stakeholders to develop and implement data quality standards and monitor the data used for health analytics.

Responsibilities

• Develop, implement, and maintain data quality standards, validation rules, and monitoring procedures for state public health datasets
• Development of Test plan that defines the scope, strategies, and evaluation criteria for testing of data quality, visualizations and end to end pipelines, based on business requirements and compliance standards
• Develop Test cases for testing data quality and that the data meets the quality dimensions and the underlying datasets to meet the compliance and business rules
• Develop Test cases to validate the visualization dashboards including complex calculations, ETL for aggregations, functionality, usability etc
• Implement EDP quality checks and validation procedures as informed by Epidemiologists/data stewards
• Monitor key data quality dimensions including accuracy, completeness, consistency, timeliness, and validity
• Identify, document, track, and support resolution of data quality issues affecting the METRIK project and the various Data Assets needed to power public health analytic use-cases
• Establish and perform processes to monitor technical integrity of data pipelines
• Partner with epidemiologists, program managers, data stewards, and developers to assess the impact of data quality issues on analysis, reporting, and program outcomes
• Validate data at various steps in the data ingestion process from staging to curation to making data available to analytics
• Execute Test cases, document test findings, and translate into actionable insights for both business and technical stakeholders
• Support development and maintenance of data dictionaries, metadata, and business rules
• Participate in data governance and stewardship activities, including data access controls, data lineage, and standardization efforts
• Support system enhancements, onboarding of new data sources, and policy-driven data changes with quality assurance testing

Skills

• Effective and good communications skills
• Ability to work with teams and independently
• Undergraduate degree in a STEM discipline, Business, Computer Science, Public Health, related field, or equivalent experience
• Experience with state or local public health data systems (e.g., disease surveillance, immunization registries, ELR, syndromic surveillance, vital records)
• Familiarity with state data standards (e.g., HL7)
• Knowledge of HIPAA, state privacy laws, and data use agreements
• Familiarity with analytic tools such as R, Python, or SAS; and reporting/visualization tools such as Tableau or Power BI or AWS Quicksight
• Experience in creating, reviewing and maintaining end-to-end data platform requirements
• Thorough knowledge and experience of data warehouse and a cloud-based Enterprise Data solution
• Cloud database platform experience such as Snowflake
• Familiarity with AWS cloud services
• Intermediate or better SQL query skills
• Working knowledge with at least one Business Intelligence tool such as Tableau
• Public Health experience
• Amazon Web Services experience
• Snowflake certification
• Tableau or any other BI tool certification

Qualifications

Must Haves

• Effective and good communications skills
• Ability to work with teams and independently
• Undergraduate degree in a STEM discipline, Business, Computer Science, Public Health, related field, or equivalent experience
• Experience with state or local public health data systems (e.g., disease surveillance, immunization registries, ELR, syndromic surveillance, vital records)
• Familiarity with state data standards (e.g., HL7)
• Knowledge of HIPAA, state privacy laws, and data use agreements
• Familiarity with analytic tools such as R, Python, or SAS; and reporting/visualization tools such as Tableau or Power BI or AWS Quicksight
• Experience in creating, reviewing and maintaining end-to-end data platform requirements
• Thorough knowledge and experience of data warehouse and a cloud-based Enterprise Data solution
• Cloud database platform experience such as Snowflake
• Familiarity with AWS cloud services
• Intermediate or better SQL query skills
• Working knowledge with at least one Business Intelligence tool such as Tableau

Nice to Haves

• Public Health experience
• Amazon Web Services experience
• Snowflake certification
• Tableau or any other BI tool certification