Data & Integration Engineer

Compass Health Center•Chicago, IL

About The Position

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. The role connects data across clinical, operational, financial, and business systems, ensuring it is reliable, secure, well-structured, and accessible for reporting, analytics, and AI-enabled use. The engineer will help centralize and standardize data, reduce manual and fragile processes, and build scalable solutions using Microsoft Fabric and related technologies. The role works with Analytics, Infrastructure, Security, EMR and application owners, vendors, analysts, business owners, and Technology leadership. It translates business and analytical requirements into practical technical solutions, supports governed access to data, and helps improve how information moves across the organization.

Requirements

Bachelor’s degree in Computer Science, Information Systems, Data Engineering, Software Engineering, or a related field, or equivalent relevant experience.
At least 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 sensitive information.

Nice To Haves

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.

Responsibilities

Build, maintain, and improve data pipelines, integrations, transformations, lakehouse structures, and data models.
Ingest 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, scalable solutions, including integrations between cloud-based and SaaS systems.
Evaluate new data sources and determine appropriate ingestion, integration, and ongoing support approaches.
Monitor pipelines, refreshes, integrations, and data quality; troubleshoot failures and build logging, alerting, error-handling, and recovery processes.
Resolve issues involving source-system changes, schemas, credentials, gateways, and data availability.
Improve the reliability, performance, and maintainability of data workflows and reduce dependence on individual users, workstations, manual file movement, and undocumented processes.
Maintain documentation, lineage, naming standards, and technical ownership of data assets.
Support appropriate data access, security, privacy, and handling of PHI and other sensitive information.
Build a trusted data foundation for reporting, self-service analytics, and AI-enabled analysis.
Partner with analysts and business owners on data requirements, definitions, quality issues, and priorities; structure and document data for use in Power BI, advanced analytics, and AI-assisted workflows.
Partner with the Senior Clinical Data Analyst and Technology leadership to evaluate and enable analytics and AI capabilities, establish scalable patterns for governed data access, and identify useful applications of Microsoft Fabric and related tools.
Collaborate with Analytics, Infrastructure, Security, EMR, application owners, and vendors when data or integrations cross systems.
Communicate technical issues, tradeoffs, and recommendations clearly to technical and non-technical stakeholders, and identify opportunities to simplify the environment and improve data movement.