Focus Solutions is looking for a Senior SQL Developer to lead complex data conversion projects for healthcare organizations transitioning between EHR systems, aiming to enhance clinical and operational efficiency by integrating fragmented technologies.
Requirements
- Advanced SQL Server expertise, including performance tuning, complex joins, indexing strategies, and query optimization.
- Experience with HL7, FHIR, CCD, X12, and other healthcare data exchange standards.
- Experience with data conversion frameworks and ETL tools.
- Git-based source control (Azure DevOps preferred).
- Azure Data Studio and/or Visual Studio Code.
- Strong skills in Microsoft Excel for data validation and transformation.
- 7+ years of hands-on SQL development experience, with at least 3+ years in a senior or lead role.
Responsibilities
- Lead complex EHR conversion projects from planning through implementation, ensuring successful, timely, and high-quality outcomes.
- Translate client data mapping and requirements into advanced SQL logic and conversion frameworks.
- Design, develop, and optimize SQL scripts, stored procedures, and ETL processes for large-scale healthcare datasets.
- Act as the primary technical point of contact for clients during data conversion efforts, providing guidance and troubleshooting expertise.
- Establish and enforce data quality standards, ensuring accuracy, consistency, and compliance with HIPAA and other healthcare regulations.
- Mentor junior SQL developers, providing code reviews, training, and ongoing knowledge-sharing.
- Document and refine conversion processes to build scalable, repeatable methodologies across projects.
Other
- Proven, hands-on experience leading EHR/EMR data conversions. Must have successfully managed full lifecycle migrations involving systems such as Epic, Cerner, Allscripts, NextGen, eClinicalWorks, or similar.
- Deep knowledge of HL7 v2/v3, FHIR, CCD, and other interoperability standards in healthcare environments.
- Expertise in healthcare data standards, regulatory compliance (HIPAA, PHI handling), and best practices.
- Strong leadership and mentoring experience, with the ability to coach junior developers and lead teams.
- Exceptional analytical, organizational, and problem-solving skills.
