Back to jobs

Data & Integration Engineer

Chicago, Illinois, United States

Actively hiring, first seen by us 8 days ago
Pay
Pay not listedSimilar roles state $127K–$190K
Work setting
Not stated
Employment
Not stated

What you’ll work on

Full posting

The Data & Integration Engineer is a hands-on technical role responsible for building and maintaining Compass Health Center's data platform, integrations, pipelines, and trusted data foundation.

You’ll help shape and strengthen Compass's data environment by centralizing and standardizing data, reducing manual and fragile processes, and building scalable solutions using Microsoft Fabric and related technologies.

  • Build and maintain data pipelines, integrations, lakehouse structures and data models

  • Bring data from EMR/EHR, finance, HR, CRM, scheduling and payer systems into a governed platform

  • Replace manual, file-based, or fragile processes with reliable, scalable solutions

  • Monitor pipelines and data quality, and troubleshoot failures quickly

  • Build logging, alerting, error handling and recovery processes

From the employer’s posting
The Data & Integration Engineer is a hands-on technical role responsible for building and maintaining Compass Health Center's data platform, integrations, pipelines, and trusted data foundation. In this role, you’ll 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.
You’ll help shape and strengthen Compass's data environment by centralizing and standardizing data, reducing manual and fragile processes, and building scalable solutions using Microsoft Fabric and related technologies.
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.
Replace manual, file-based, or fragile processes with reliable and scalable solutions.
Monitor pipelines, refreshes, integrations, and data quality and quickly troubleshoot failures.
Build appropriate logging, alerting, error handling, and recovery processes.

What you’ll bring

All qualifications

Core experience

  • Experience using SQL, Python/PySpark, and APIs to move and transform data
  • Experience with Microsoft Fabric and related technologies

Preferred experience

  • 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.
Qualification wording
Use SQL, Python/PySpark, APIs, dataflows, notebooks, connectors, gateways, and other appropriate tools to move and transform data.
building scalable solutions using Microsoft Fabric and related technologies
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.
Education & alternatives
Required Qualifications - Bachelor’s 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.

Benefits in the posting

Full benefits wording
  • 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.

From the employer’s posting.

About Compass Health Center

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

In the employer’s words · Read in context

Apply at Compass Health Center

Posting record

Report an error

Actively hiringFirst seen by us 8 days ago, still listed, and not a repost of an earlier posting.

Status in our records
Live
First seen by us
Nov 11, 20268 days ago
Recorded sightings
9
Last seen by us
Nov 19, 2026

These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.

How this job compares

Pay

$127K–$190K is typical

The middle half of what similar US postings state. This one doesn’t list pay.

From 2,396 postings in the last year. Stated ranges, not salaries paid.

Time since we first saw it

Day 8

Similar jobs usually come down between day 6 and day 56.

From 14,152 similar postings that came down. Coming down is not always a hire.

Compass Health Center is hiring

2 open jobs

Open jobs by the week we first saw them, last 12 weeks.

Hiring record

See how this role fits your experience

Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.

  • PHP
  • Python
  • SQL
  • Azure
  • Power BI
  • PySpark
Where the posting names them
Who We Are Compass Health Center is a recognized leader in crisis-level mental health, bringing passion, connection, and patient-centered care to the Partial Hospitalization and 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 programming. Compass 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.
- 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.
- 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 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 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.
- 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.
- 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.

Your next step

Complete your application on job-boards.greenhouse.io. The employer’s form will show what is required.

Applying through Greenhouse

  • No account needed: the form is one page, with an “Autofill my application” option that reads your resume.
  • Greenhouse doesn’t read resumes over 2.5 MB, or details placed in a header, footer, text box, table or second column. The file still attaches, but a recruiter has to type you in by hand.

Already applied? Track this application

Job description

View original posting ↗

Weekly outpatient therapy isn't always enough, and a trip to the ER isn't the only answer. Patients and their families rely on Compass Health Center when in crisis – every day, we help 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 Center's data platform, integrations, pipelines, and trusted data foundation. In this role, you’ll 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.

You’ll help shape and strengthen Compass's 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 You'll 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

  • Bachelor’s 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 descriptions can be intimidating, so if this sounds like an opportunity for you, please don't 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 Partial Hospitalization and 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 programming. Compass 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.  

What’s 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 – we’d be grateful to hear from you! 

 

Demand for Data Engineer roles

New Data Engineer postings at the employers we follow are up 14% over the last 6 weeks compared with the 6 before.

Weekly new Data Engineer postings at the same employers, from the week of August 17 to the week of November 9. The fewest in a week was 860, the most 1,353, and the latest week had 1,020.
August 17Last week

Each bar is one week of new postings. The darkest bars are the last 6 weeks.

Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.

About the role

We file this job under Data Engineer, by the work the posting describes.

Data engineers build and run the pipelines that copy data out of apps and outside services into a warehouse or lake, and fix them when a source changes or a load fails.

Expect SQL, Python, a cloud platform, a scheduler such as Airflow, and often tools for large data such as Spark or Kafka.

An analytics engineer works one step later, turning the raw data a data engineer lands into clean tables people can query.

US government figures for database architects

Median yearly pay, May 2025
$139,500
Expected change, 2025 to 2035
9.4% more jobsagainst 3.5% for all jobs

The government has no code for data engineers, so these figures are for the closest group, database architects, which includes data integration and data warehousing specialists.

Source: US Bureau of Labor Statistics, Occupational Employment and Wage Statistics (May 2025) and Employment Projections (2025 to 2035). Occupation code 15-1243.

Source details

View original posting ↗

Source notes

Source excerpts

Selected passages from the saved posting. Check the full description for conditions and exceptions.

Pay

No pay amount identified in the saved description.

Location & working pattern

Chicago, Illinois, United States

Working pattern and location restrictions need checking in the full posting.

Work authorization

No clear work-authorization passage found. Eligibility is unconfirmed.

Find answers in the posting

AI
How answers work

AI selects complete passages from this posting. Check them for conditions and exceptions.

Uses this posting and your question. No profile needed.