Senior Data Quality Assurance Analyst

Duties And Responsibilities

• Develop, implement, and maintain data quality standards, validation rules, and monitoring procedures for state public health datasets
• Develop 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

Qualifications

• 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