Sr. Clinical Informatics Data Engineer

At Mingle Health, a remote-first organization focused on healthcare data solutions, the Senior Clinical Informatics Data Engineer will translate CMS specifications into database structures used for analysis and quality measurement. The role centers on building scalable data pipelines, validating data quality, and supporting CMS submissions and Medicare reporting for healthcare clients. You will collaborate with a distributed team to ensure data accuracy and timely reporting across client projects.

Responsibilities

• Interpret and codify CMS Quality Payment Program specifications, translating them into robust data models and database objects for quality measures.
• Analyze accuracy and performance of claims and clinical data using MS SQL and related tools, ensuring data quality across datasets.
• Provide data mapping for claims and clinical datasets via internal web application software.
• Translate measure specifications into database structures used to compute quality measures.
• Act as a client consultant for assigned practices and hospital systems to support successful CMS submissions.
• Develop ad hoc SQL reports to support client consulting needs.
• Validate data load processes into clinical data repositories to maintain data integrity.
• Collaborate with colleagues to document data requirements and metric definitions.
• Perform quality assurance for data integration processes and repository metrics.
• Participate effectively within a distributed, remote team and contribute to client-facing and internal development efforts.
• Apply strong communication and interpersonal skills to manage projects and coordinate with stakeholders.

Requirements

• Minimum five years of experience in healthcare or clinical informatics.
• Hands-on experience with medical or clinical information systems used by clients, such as electronic health records and practice management systems.
• Familiarity with medical processes, terminology, physician office systems, or billing including Medicare and other payers.
• Experience with quality reporting and familiarity with MIPS and Advanced Payment Models programs.
• Ability to review, interpret, compare, and edit clinical documentation, including CMS Measure Specifications Manual for Claims and Registry Reporting.
• Strong client requirements gathering and the ability to translate needs into actionable solutions.
• Ability to guide clients in constructing queries, extracting data, assessing data quality, and improving data quality, flow, and metrics.
• Solid programming skills with proficiency in SQL; ability to develop, execute, and evaluate Microsoft SQL queries.
• Experience building and optimizing data pipelines and transforming raw data into analysis-ready information.
• Ability to create data migration scripts using SSIS and/or Python, and facilitate importing of third-party data into data structures.
• Experience maintaining efficient data loading processes and investigating data migration exceptions.
• Contribute to planning, analysis, design, and development of data management processes, data integration, data warehousing, and BI solutions.
• Ability to analyze large datasets in detail to diagnose issues, including reading error logs, executing stored procedures, and understanding data structures.
• Foundational understanding of best practices for database design and maintenance.
• Comfort with a fast-changing environment, incomplete documentation, and evolving roles while maintaining strict HIPAA privacy and security compliance.

Technologies

• SQL
• SQL Server
• SSIS
• Python