Bachelor's degree in Information Systems, Data Analytics, Computer Science, Business Analytics, or related field; equivalent experience considered.
5+ years of experience in data analysis, business intelligence, data warehousing, or related analytical roles within enterprise data environments.
Advanced SQL skills for data analysis, validation, reconciliation, and source-to-target data mapping.
Experience with data warehouses, reporting platforms, and enterprise data environments.
Knowledge of healthcare quality, utilization, cost, and population health metrics for value-based care reporting and analytics.
Strong analytical, problem-solving, and communication skills for effective collaboration with technical and business stakeholders.
Responsibilities
Analyze and document data structures, tables, relationships, and business logic across multiple source systems and data environments.
Conduct a comprehensive inventory of available data assets and compare them against existing data warehouse tables and models.
Validate the accuracy, completeness, and integrity of data loaded into the data warehouse.
Identify gaps, inconsistencies, and alignment issues between source system data and warehouse data structures.
Create and maintain documentation related to data mappings, lineage, transformation logic, and validation results.
Partner with technical teams to define requirements for new tables, fields, and backend data structures needed to support reporting and analytics.
Escalate reporting and data inconsistencies to technical teams for timely remediation and accurate reporting.
Validate front-end portal reports and dashboards against backend data sources.
Ensure reporting calculations, KPIs, and business rules are correctly implemented.
Benefits
Opportunity to work on a critical data integration and validation initiative.
Collaborative environment with analytics teams, business stakeholders, and external vendors.
Potential for contract extension beyond three months.
Engagement in the healthcare sector, contributing to better and more affordable healthcare.
Full Job Description
About the role
We are seeking a highly analytical and detail-oriented Data Analyst to support a critical data integration and validation initiative. In this role, you will partner with analytics teams, business stakeholders, and external vendors to map, validate, and reconcile data across source systems and data warehouse environments.
The ideal candidate has strong SQL and data warehouse expertise, experience validating data and reporting, and a passion for turning complex data into actionable business insights. Success in this role requires strong problem-solving, attention to detail, and the ability to collaborate effectively across technical and business teams.
What you'll do
Data Discovery & Data Warehouse Validation
Analyze and document data structures, tables, relationships, and business logic across multiple source systems and data environments.
Conduct a comprehensive inventory of available data assets and compare them against existing data warehouse tables and models.
Validate the accuracy, completeness, and integrity of data loaded into the data warehouse.
Identify gaps, inconsistencies, and alignment issues between source system data and warehouse data structures.
Create and maintain documentation related to data mappings, lineage, transformation logic, and validation results.
Partner with technical teams to define requirements for new tables, fields, and backend data structures needed to support reporting and analytics.
Escalate reporting and data inconsistencies to technical teams to ensure timely remediation and accurate reporting.
Dashboard and Reporting Validation
Validate front-end portal reports and dashboards against backend data sources.
Ensure reporting calculations, KPIs, and business rules are correctly implemented.
Report identified data and reporting discrepancies to the technical team for resolution.
Qualifications
Bachelor's degree in Information Systems, Data Analytics, Computer Science, Business Analytics, or a related field; equivalent experience considered.
5+ years of experience in data analysis, business intelligence, data warehousing, or related analytical roles within enterprise data environments.
Advanced SQL skills with experience performing data analysis, validation, reconciliation, and source-to-target data mapping.
Experience working with data warehouses, reporting platforms, and enterprise data environments.
Knowledge of healthcare quality, utilization, cost, and population health metrics used in value-based care reporting and analytics.
Strong analytical, problem-solving, and communication skills with the ability to collaborate effectively with technical and business stakeholders.
Compensation
This is a three-month contract position (with potential to expand) requiring 40 hours per week, with an hourly rate of $46.
Come join us on the journey to better and more affordable healthcare!
