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
Preferred experience/skills:
Public Health experience
Amazon Web Services experience
Snowflake certification
Tableau or any other BI tool certification
JOB TITLE: Data Analyst
JOB LOCATION: Quincy MA
WAGE RANGE*: $65-$68
JOB NUMBER: ITS77-EHS-FY27-DATA ANAL- QA – 002- 180 – 7/10/
JOB DESCRIPTION:
DPH is executing large-scale data modernization across the agency as part of DMI. This includes creating a consolidated Enterprise Data Platform on modern cloud tools (including AWS & Snowflake,) and re-platforming existing business data applications from solutions such as SAS and legacy databases to the new platform. DPH data systems enable epidemiologists, public health researchers, state and local public health officials, and business leaders to analyze public health trends and drive policy decisions.
The ideal candidate is an expert in assuring accuracy, completeness, timeliness, and consistency of data used by the State Department of Health to support disease surveillance, population health monitoring, program evaluation, and statutory reporting. This position works collaboratively with epidemiologists, program staff, analytics teams, developers, and external partners to maintain data integrity across state public health information systems and reporting processes.
In this role, you are comfortable speaking to both business and technical stakeholders to ensure combined understanding and collaborative solutions. This role will be expected to own tasks and follow-up related to cloud data platform requirements and implementation activities and establish well documented best practices and processes.
Duties and 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
Equal opportunity employer as to all protected groups, including protected veterans and individuals with disabilities
* While an hourly range is posted for this position, an eventual hourly rate is determined by a comprehensive salary analysis which considers multiple factors including but not limited to: job-related knowledge, skills and qualifications, education and experience as compared to others in the organization doing substantially similar work, if applicable, and market and business considerations. Benefits offered include medical, dental and vision benefits; dependent care flexible spending account; 401(k) plan; voluntary life/short term disability/whole life/term life/accident and critical illness coverage; employee assistance program; sick leave in accordance with regulation. Benefits may be subject to generally applicable eligibility, waiting period, contribution, and other requirements and conditions. Benefits offered are in accordance with applicable federal, state, and local laws and subject to change at TCM's discretion.