Sr. Clinical Informatics Data Engineer

The Senior Clinical Informatics Data Engineer at Mingle Health will operate in a remote capacity, translating CMS specifications into robust database structures for analysis and quality measures. The role centers on building data pipelines, ensuring data quality, and supporting CMS submissions and Medicare reporting for healthcare clients.

Responsibilities

• Interpret, document, and codify CMS specifications related to the Quality Payment Program (QPP).
• Analyze claims and clinical data using SQL Server and related tools to assess accuracy and performance.
• Leverage internal web applications to map data for claims and clinical datasets.
• Transform measure specifications into database objects used to calculate quality metrics.
• Provide client facing consultative support for practices and hospital systems to enable successful CMS submissions.
• Create ad hoc SQL reports to support client consulting engagements.
• Validate data loading processes into clinical data repositories.
• Collaborate with colleagues to document data needs and metric definitions.
• Perform quality assurance for data integration processes and repository metrics.
• Collaborate effectively within a distributed, remote team environment.
• Apply interpersonal skills to manage client facing projects and internal development initiatives.

Requirements

• 5+ years of experience in Healthcare or Clinical Informatics.
• Experience with medical and clinical information systems used by clients, such as electronic health records and practice management solutions.
• Knowledge of medical processes and terminology, physician office systems, or billing including Medicare and other payers.
• Experience with Quality Reporting and familiarity with MIPS and APP programs.
• Ability to review, interpret, compare, and edit clinical documentation, including CMS Measure Specifications Manual for Claims and Registry Reporting.
• Strong client interaction skills to translate requirements into actionable solutions.
• Ability to guide clients in constructing queries, extracting data, assessing data quality, and improving data quality, flow, and metrics.
• Proficient programming skills with emphasis on SQL and Microsoft SQL querying.
• Experience designing, executing, and evaluating SQL queries to support data analytics.
• Experience building and optimizing data pipelines to transform raw data into usable information.
• Experience developing data migration scripts and procedures using SSIS and/or Python.
• Ability to facilitate importing of third party data into data structures using database, programming, and ETL tools.
• Skill in investigating exceptions in data migrations and implementing corrective actions.
• Participation in planning, analysis, design, and development of data management, integration, data warehouse, and BI solutions.
• Ability to analyze large datasets in detail to identify and resolve issues, ensuring data integrity and accuracy.
• Understanding of best practices for effective database design and maintenance.
• Comfort working in a rapidly changing environment with incomplete documentation and fluid roles.
• Strict adherence to HIPAA privacy and security policies.

Technologies

• SQL
• SQL Server
• SSIS
• Python