Sr Analytics & Reporting Consultant

W3R Consulting; Chicago (IL); Hybrid; USD 110,000 - 160,000; Full time

Job summary

W3R Consulting focuses on healthcare analytics, delivering robust data pipelines, and scalable data solutions across claims, pharmacy, and population health domains.

We seek a capable data engineer with 4+ years of experience, strong SQL and Python skills, and hands-on Databricks expertise to support data-driven decision making in a fast-paced environment.

Qualifications

• Bachelor's degree and 4+ years in healthcare analytics or related field.
• 3+ years designing, developing, and supporting data pipelines and reporting.
• Strong SQL, Python, Databricks for data transformation and analytics.
• ETL/ELT processes for large healthcare/pharmacy datasets.
• Data modeling, data warehousing concepts, data marts for reporting.
• Experience with cloud data platforms and distributed computing.
• Collaboration with stakeholders to deliver scalable data solutions.
• Focus on data quality, performance, and reliability.
• Knowledge of healthcare data structures and governance standards.
• Experience creating BI datasets with Power BI/Tableau.

Responsibilities

• Deliver scalable data solutions aligning with organizational objectives.
• Develop, maintain, and optimize data pipelines and ETL/ELT processes.
• Collaborate with analysts and tech teams to understand data requirements.
• Support dashboards, ad hoc analysis, and downstream data deliveries.
• Ensure data quality, security, and regulatory compliance.

Skills

SQL

Python

Databricks

Data pipelines

ETL/ELT

Data modeling

Data warehousing

Cloud computing

Data governance

Data profiling

Education

Bachelor's degree

Tools

Databricks

Airflow

Azure Data Factory

Power BI

Tableau

Spark

Delta Lake

Job description

JOB REQUIREMENTS

• Bachelor's Degree and 4+ years of experience in healthcare analytics, healthcare services, statistical analysis, data engineering, business intelligence, insurance economics, or a related field.


• 3+ years of experience designing, developing, and supporting data pipelines, data integration processes, and reporting solutions utilizing healthcare and pharmacy data.


• Strong experience with SQL, Python, Databricks, and modern data engineering frameworks for data transformation, automation, and analytics.


• Experience developing, maintaining, and optimizing ETL/ELT processes to support large-scale healthcare, claims, pharmacy, and population health datasets.


• Proficiency in data modeling, relational database design, data warehousing concepts, and creation of data marts that support reporting and analytics initiatives.


• Experience working with cloud-based data platforms and distributed computing environments to process and analyze large datasets efficiently.


• Partners with business stakeholders, analysts, and technology teams to understand data requirements and deliver scalable data solutions.


• Solves moderately complex to complex business and technical problems with a focus on data quality, performance, scalability, and reliability.


• Supports strategic initiatives through the development of trusted data assets, automated workflows, and self-service analytics capabilities.


• Participates in cross-functional project teams to deliver data solutions, enhancements, and operational improvements aligned with organizational objectives.


• Demonstrates understanding of healthcare data structures including claims, eligibility, pharmacy, provider, and population health data domains.


• Applies data governance, security, and regulatory compliance standards when managing healthcare data assets.


• Supports data framework for dashboards, ac hoc analysis, and downstream data deliveries.


• Supoort with complex data inquiries and data profiling.

PREFERRED REQUIREMENTS

• Advanced SQL expertise, including complex joins, window functions, query optimization, stored procedures, and performance tuning.


• Strong experience with Databricks, Spark, Delta Lake, and distributed data processing frameworks.


• Strong Python programming skills for data engineering, automation, data quality monitoring, and analytics enablement.


• Experience building and orchestrating ETL/ELT pipelines using tools such as Databricks Workflows, Airflow, Azure Data Factory, or similar technologies.


• Experience developing scalable data lake, data warehouse, and data mart solutions that support enterprise reporting and analytics.


• Knowledge of healthcare data standards and structures, including medical claims, pharmacy claims, member eligibility, provider, and population health data.


• Experience creating and supporting semantic layers, reporting datasets, and business intelligence solutions using Power BI, Tableau, or similar platforms.


• Familiarity with CI/CD practices, source control management (Git), automated testing, and DevOps concepts for data platforms.


• Experience implementing data quality frameworks, monitoring processes, and production support practices.