Data & Integration Engineer
compasshealthcenter
A complete application in a minute
Tailored resume and cover letter, ready to send.
Job summary
Compass Health Center seeks a Data & Integration Engineer to build and maintain a scalable data platform, pipelines, and integrations across clinical, operational, financial, and business systems.
You will enable analytics and AI-enabled workflows by centralizing data, standardizing processes, and ensuring data security and governance. This role collaborates with analysts and stakeholders to translate needs into robust data solutions.
Qualifications
- Bachelor's degree or equivalent in a related field.
- 5+ years of experience in data engineering, data integration, software engineering, BI engineering, or related work.
- Experience building and supporting production data pipelines and integrations.
- Strong SQL skills and experience 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.
Responsibilities
- 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.
- Monitor pipelines, refreshes, integrations, and data quality and troubleshoot failures.
- Build 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.
- Build trusted data foundation 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 for Power BI, advanced analytics, and AI workflows.
- Partner with Senior Clinical Data Analyst and Technology leadership to enable analytics and AI capabilities.
- Establish scalable patterns for governed data access.
- Identify opportunities to use Microsoft Fabric and related tools to improve engineering, integration, quality, and automation.
- Cross-functional collaboration with Analytics, Infrastructure, Security, EMR, application owners, and vendors when data crosses systems.
Skills
Education
Tools
Job description
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.
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.
- 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.
- 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.
- 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.
- 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.
- 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.
- Experience with Microsoft Fabric, including Lakehouse, Data Factory, pipelines, notebooks,
'/%3e%3cpath%20d='M101.744%2012.4726L102.894%2016.1947L99.0021%2013.2201L101.744%2012.4726ZM105.3%208.40937H100.488L99.0026%203.59473L97.5116%208.41047L92.7%208.40385L96.5965%2011.3834L95.1055%2016.1942L99.0021%2013.2196L101.408%2011.3834L105.3%208.40992V8.40937Z'%20fill='white'/%3e%3cdefs%3e%3clinearGradient%20id='paint0_linear_5593_1381'%20x1='90'%20y1='9.44471'%20x2='99'%20y2='9.44471'%20gradientUnits='userSpaceOnUse'%3e%3cstop%20stop-color='%2300AD70'/%3e%3cstop%20offset='0.998594'%20stop-color='%2300B67A'/%3e%3cstop%20offset='1'%20stop-color='%23DCDCE6'/%3e%3c/linearGradient%3e%3c/defs%3e%3c/svg%3e){kind=small}
