Sr Analytics & Reporting Consultant

W3R Consulting; Chicago (IL); Ibrido; USD 110.000 - 160.000; Tempo pieno

Descrizione del lavoro

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.

Competenze

• 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.

Mansioni

• 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.

Conoscenze

SQL

Python

Databricks

Data pipelines

ETL/ELT

Data modeling

Data warehousing

Cloud computing

Data governance

Data profiling

Formazione

Bachelor's degree

Strumenti

Databricks

Airflow

Azure Data Factory

Power BI

Tableau

Spark

Delta Lake

Descrizione del lavoro

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.