Sr. Clinical Informatics Data Engineer

Mingle Health seeks a Senior Clinical Informatics Data Engineer to translate CMS specifications into robust database structures for analysis and quality measures. The role involves building data pipelines, ensuring data quality, and supporting CMS submissions and Medicare reporting for healthcare clients. This position is remote and collaborative within a distributed team.

Responsibilities

• Understand, interpret, and codify CMS specifications for the Quality Payment Program (QPP)
• Analyze accuracy and performance of claims and clinical data using MS SQL and related tools
• Utilize internal web based applications to provide data mapping for claims and clinical datasets
• Translate measure specifications into database objects used to calculate quality measures
• Provide consultative support to assigned clients, including health practices and hospital systems, to facilitate successful CMS submissions
• Develop ad hoc SQL reports to support client consulting engagements
• Validate data load processes into clinical data repositories
• Collaborate with colleagues to document data needs and metric definitions
• Perform quality assurance on data integration processes and repository metrics
• Operate effectively within a distributed, remote team environment and contribute to both client facing and internal development projects

Requirements

• Minimum 5 years of experience in healthcare or clinical informatics
• Experience with medical or clinical information systems used by clients, such as EHR or Practice Management systems
• Familiarity with medical processes and terminology, physician office workflows, or billing including Medicare and other payers
• Experience with Quality Reporting and related programs
• Understanding of MIPS and APP programs
• Ability to review, interpret, compare, and edit clinical documentation, such as CMS Measure Specifications Manual for Claims and Registry Reporting
• Capacity to listen to client requirements and translate them into actionable solutions
• Guidance for clients to construct queries, extract data, assess quality, and continually improve data quality, flow, and metrics
• Strong programming skills with proficiency in SQL
• Ability to develop, execute, and evaluate Microsoft SQL queries
• Experience building and optimizing data pipelines
• Develop pipelines to transform raw data into reliable information for analysis
• Build data migration scripts and procedures using SSIS and/or Python
• Facilitate importing third party data into data structures using database, programming, and ETL tools to maintain efficient loading processes
• Investigate exceptions in data migrations
• Contribute to planning, analysis, design, and development of data management, data integration, data warehouse, and BI solutions
• Ability to analyze large datasets in detail to resolve issues, including reading error logs, executing stored procedures, and understanding data structures
• Basic understanding of best practices for effective database design and maintenance
• Comfort with a rapidly changing environment, incomplete documentation, and fluid roles
• Strict adherence to HIPAA privacy and security policies

Technologies

SQL, SQL Server, SSIS, Python

Location

Remote