Data & Integration Engineer

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!