Enter a job title or keyword

Data & Integration Engineer


Job Location:

Chicago, IL - USA

Monthly Salary: Not provided by the employer
Posted: 15 November 2026 (5 days ago)
Application Deadline: 12 February 2027
Vacancies: 1 Vacancy

Job Summary

Weekly outpatient therapy isnt always enough and a trip to the ER isnt the only answer. Patients and their families rely on CompassHealth Center whenincrisis every day wehelp people overcome depression anxiety suicidality obsessions/compulsions trauma chronic pain and other obstacles in order for our patients to live freely.

About This Role

The Data & Integration Engineer is a hands-on technical role responsible for building and maintaining Compass Health Centers data platform integrations pipelines and trusted data this role youll play an important part in connecting data across clinical operational financial and business systems ensuring it is reliable secure well-structured and accessible to support reporting analytics and AI-enabled use.

Youll help shape and strengthen Compasss data environment by centralizing and standardizing data reducing manual and fragile processes and building scalable solutions using Microsoft Fabric and related technologies.

Our dedicated operations teams work behind the scenes to bring our shared mission to life. Each department delivers their own set of strengths which empower our clinicians to focus on their expertise and ultimately perform the meaningful work that we do.

What Youll Do

Data Engineering & Integration

  • Build maintain and improve data pipelines integrations transformations lakehouse structures and data models.
  • Bring data from EMR/EHR finance HR CRM scheduling payer and other systems into a governed data platform.
  • Use SQL Python/PySpark APIs dataflows notebooks connectors gateways and other appropriate tools to move and transform data.
  • Replace manual file-based or fragile processes with reliable and scalable solutions.
  • Build integrations between cloud based and SaaS systems.
  • Evaluate new data sources and determine the best approach for ingestion integration and ongoing support.

Reliability Quality & Security

  • Monitor pipelines refreshes integrations and data quality and quickly troubleshoot failures.
  • Build appropriate logging alerting error handling and recovery processes.
  • Resolve issues related to source-system changes schemas credentials gateways and data availability.
  • Improve the reliability performance and maintainability of existing data workflows.
  • Reduce dependencies on individual users workstations manual file movement and undocumented processes.
  • Maintain clear documentation lineage naming standards and technical ownership of data assets.
  • Support appropriate data access security privacy and handling of PHI and other sensitive information.

Analytics & AI Enablement

  • Build the trusted data foundation needed for reporting self-service analytics and AI-enabled analysis.
  • Partner with analysts and business owners to understand data requirements definitions quality issues and priorities.
  • Structure and document data so it can be used confidently in Power BI advanced analytics and AI-assisted workflows.
  • Partner with the Senior Clinical Data Analyst and Technology leadership to evaluate and enable new analytics and AI capabilities.
  • Help establish scalable technical patterns for governed access to data.
  • Identify opportunities to use Microsoft Fabric and related tools to improve data engineering integration quality and automation.

Cross-Functional Partnership

  • Partner with Analytics Infrastructure Security EMR application owners and vendors when data or integrations cross systems.
  • Translate business and analytical requirements into practical scalable technical solutions.
  • Communicate technical issues tradeoffs and recommendations clearly to both technical and non-technical stakeholders.
  • Identify opportunities to simplify the environment and improve how data moves across the organization.

Who You Are

Required Qualifications

  • Bachelors degree in Computer Science Information Systems Data Engineering Software Engineering or a related field or equivalent relevant experience.
  • 5 years of experience in data engineering data integration software engineering business intelligence engineering or related work.
  • Experience building and supporting production data pipelines and integrations.
  • Strong SQL skills and experience working with relational and analytical data.
  • Experience with Python PySpark or similar data transformation technologies.
  • Experience with ETL/ELT APIs data modeling data quality and integration patterns.
  • Experience working with modern cloud data platforms.
  • Ability to independently troubleshoot complex data and integration issues.
  • Ability to turn business and analytical needs into scalable technical solutions.
  • Strong documentation communication and cross-functional partnership skills.
  • Understanding of data security access controls privacy and handling of sensitive information.

Preferred Qualifications

  • Experience with Microsoft Fabric including Lakehouse Data Factory pipelines notebooks dataflows gateways or related capabilities.
  • Experience with Power BI and designing data structures that support reporting and analytics.
  • Experience integrating EMR/EHR finance HR CRM scheduling payer or other enterprise systems.
  • Experience working in healthcare or another regulated environment involving PHI or sensitive data.
  • Experience with Microsoft Azure and Microsoft 365 technologies.
  • Experience modernizing legacy manual and file-based data processes.
  • Familiarity with data governance lineage metadata management and AI-enabled analytics.

We know job descriptionscan be intimidating so if this sounds like an opportunity for you please dont hesitate to apply!

Who We Are

Compass Health Center is a recognized leader in crisis-level mental health bringing passion connection and patient-centered care to the PartialHospitalizationand Intensive Outpatient space (PHP/IOP). Based in Chicagoland we serve hundreds of patients every day ranging from ages 5 through adulthood in our onsite facilities or through our flourishing virtual fills a critical gap between outpatient and inpatient care through an intermediate level of Behavioral Healthcare.

A few more things we want you to know: our values are super important to us and hopefully will be to you too. Cultural humility teamwork continuous improvement connection patient centered care passion innovation and agility should be your power sources. Joining Compass is an opportunity to feel fulfilled through a joint mission towards healing our communities.

Benefits & Perks

We know that you will be dedicated to your purpose here. We look at that investment as a two-way street. We are proud to offer plenty of space for growth and opportunities to pursue continuous development within our organization.

For eligible positions our other benefits include: comprehensive medical/dental/vision plans 401k program with company matching generous PTO (including competitive parental leave after 1 year of employment) and continuous training through CEU seminars and volunteering opportunities.

Whats Next

Compass is committed to cultivating diverse and dynamic teams who exude passion for their craft so whether or not you check all the boxes we encourage you to apply wed be grateful to hear from you!


Required Experience:

IC


About Company

Company Logo

Compass Health Center provides PHP & IOP level mental health care across Illinois, with a deep commitment to clinical quality & patient satisfaction. Call now.

View Profile View Profile