Data Engineer

Description

The Data Engineer will design, build, and maintain secure, scalable data pipelines, integrations, and data platforms that support CNS Healthcare’s clinical, operational, quality, and billing functions.

CNS Healthcare, a leading provider of Mental Health Services in southeast Michigan is seeking a Data Engineer to join our dynamic and fast-paced team. The Data Engineer is responsible for enabling secure exchange of healthcare data, particularly involving State of Michigan CHAMPS systems for direct billing, while ensuring strict adherence to HIPAA and other regulatory requirements governing PHI/PII.

• Employer-paid benefits including dental, vision, life, and short-term disability insurance
• Retirement program with generous company default contribution and match
• Generous PTO program starting at 18 days annually
• 16 paid holidays, including 3 floating holidays
• Paid parental leave
• Student loan forgiveness eligibility, including Public Service Loan Forgiveness (PSLF), HRSA, and more

• Design, develop, and maintain scalable ETL/ELT pipelines to ingest, process, and transform healthcare data from EHRs, billing systems, quality systems, HR systems, and external partners.
• Ensure high data quality through validation, cleansing, reconciliation, observability, and monitoring processes.
• Support real-time and batch data workflows for clinical reporting, analytics, quality measures, CCBHC reporting, and billing operations.
• Build reusable data assets and pipelines that support operational reporting, revenue cycle analytics, quality bonus reporting, and executive dashboards.

• Design, develop, and maintain scalable ETL/ELT pipelines to ingest, process, and transform healthcare data from EHRs, billing systems, quality systems, HR systems, and external partners.
• Ensure high data quality through validation, cleansing, reconciliation, observability, and monitoring processes.
• Support real-time and batch data workflows for clinical reporting, analytics, quality measures, CCBHC reporting, and billing operations.
• Build reusable data assets and pipelines that support operational reporting, revenue cycle analytics, quality bonus reporting, and executive dashboards.

• Support and extend the Proactive Solutions data platform and related reporting tools, including the Productivity Report and future data mart / analytics capabilities.
• Partner with Proactive Solutions, CNS IT leadership, and the data team to move the platform from development to production in a secure, supportable manner.
• Help define and implement production support practices, including deployment procedures, release management, environment configuration, monitoring, incident response, and issue escalation.
• Ensure the platform can be maintained by CNS over time through clear documentation, knowledge transfer, runbooks, and repeatable support processes.
• Design solutions that allow CNS to evolve toward a longer-term architecture without requiring unnecessary rebuilds.

• Support AI-assisted and agentic data engineering capabilities, including secure use of tools such as Git Hub Copilot, Open Code, Azure OpenAI, OpenAI, Anthropic, or other approved enterprise AI services.
• Help implement secure BYOK/API-key patterns where appropriate, including credential management, access controls, audit logging, usage monitoring, and vendor compliance requirements.
• Collaborate with IT leadership and vendors to ensure that any AI-enabled coding, data query, or analytics capabilities are implemented in a HIPAA-compliant and security-approved manner.
• Assist in evaluating AI tool performance, cost, security posture, and operational fit for CNS’s data engineering and analytics workflows.
• Develop practical patterns for using AI safely to accelerate SQL development, pipeline generation, documentation, test generation, data quality checks, and troubleshooting.

• Build and maintain secure interfaces and integrations with Michigan CHAMPS (Community Health…