Data & Integration Engineer

Title: Data & Integration Engineer Location: Chicago, Illinois, United States

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.