Data Engineer

About the role

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.

Responsibilities

• 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.
• Proactively support and extend the Proactive Solutions data platform and related reporting tools, including the Productivity Report and future data mart / analytics capabilities.
• Design solutions that allow CNS to evolve toward a longer-term architecture without requiring unnecessary rebuilds.
• Enable and support AI-assisted and agentic data engineering capabilities, including secure use of tools such as GitHub Copilot, Open Code, Azure OpenAI, OpenAI, Anthropic, or other approved enterprise AI services.
• Implement and maintain robust data protection controls to safeguard Protected Health Information (PHI) and Personally Identifiable Information (PII).
• Collaborate with compliance, security, and vendor teams on risk assessments, audits, vendor reviews, and AI governance requirements.
• Manage and optimize data infrastructure across cloud and/or on-premises environments, ensuring reliability, scalability, performance, and cost-effectiveness.
• Monitor pipelines, integrations, AI-enabled services, and platform components for performance, failures, anomalies, and security events.
• Train and mentor members of the data team on platform support, SQL development patterns, pipeline troubleshooting, source control practices, and safe use of AI-enabled development tools.

Requirements

• Bachelor’s degree in computer science, Information Systems, Engineering, Data Science, or related field, or equivalent professional experience.
• 10 years of experience in data engineering, data architecture, software engineering, analytics engineering, or a related technical role.
• Strong programming skills in Python, SQL, and/or Java/Scala.
• Experience with ETL/ELT tools and modern data platforms such as Azure Data Factory, SSIS, Databricks, dbt, Synapse, Fabric, or similar technologies.
• Knowledge of relational databases, NoSQL databases, data modeling techniques, and data warehouse / data mart design.
• Experience with source control, release management, deployment practices, and production support for data or software platforms.
• Ability to create clear technical documentation, runbooks, and support procedures for systems that must be maintained by internal teams.
• Proficiency with Power BI or similar data analytics application.
• Ability to explain technical issues to technical and nontechnical internal and external stakeholders.

Qualifications

• Master’s degree in health informatics, computer science, data science or similar.

Skills

• Strong programming skills in Python, SQL, and/or Java/Scala.
• Experience with ETL/ELT tools and modern data platforms such as Azure Data Factory, SSIS, Databricks, dbt, Synapse, Fabric, or similar technologies.
• Knowledge of relational databases, NoSQL databases, data modeling techniques, and data warehouse / data mart design.
• Experience with source control, release management, deployment practices, and production support for data or software platforms.
• Ability to create clear technical documentation, runbooks, and support procedures for systems that must be maintained by internal teams.
• Proficiency with Power BI or similar data analytics application.
• Ability to explain technical issues to technical and nontechnical internal and external stakeholders.

Benefits

CNS Healthcare provides a robust total rewards program to support our team members and their loved ones. We’ve shared some highlights below, but you can visit the benefits guide posted on our careers page to learn more!

• Comprehensive medical insurance options
• Employer-paid benefits including dental, vision, life, and short-term disability insurance
• Retail 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

Pay

TBD

Schedule

TBD