Onsite/hybrid in Chicago
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.
Notes:
Onsite/hybrid in Chicago
This is a contract role with the possibility of conversion to full-time based on business needs and performance
VIVA is an equal opportunity employer. All qualified applicants have an equal opportunity for placement, and all employees have an equal opportunity to develop on the job. This means that VIVA will not discriminate against any employee or qualified applicant on the basis of race, color, religion, sex, sexual orientation, gender identity, national origin, disability or protected veteran status