Advisory Consultant - Healthcare Exp SQL Reporting

Optum is a global organization that delivers care, aided by technology to help millions of people live healthier lives. The work you do with our team will directly improve health outcomes by connecting people with the care, pharmacy benefits, data and resources they need to feel their best. Here, you will find a culture guided by inclusion, talented peers, comprehensive benefits and career development opportunities. Come make an impact on the communities we serve as you help us advance health optimization on a global scale. Join us to start Caring. Connecting. Growing together.

Primary Responsibilities

• Lead and execute clinical data conversion and migration projects across various EMR platforms (Epic, Cerner, Allscripts, Meditech, NextGen)
• Work in EHR-agnostic environments to design scalable, flexible data conversion solutions that support diverse clinical systems
• Design, develop, and optimize SQL queries, stored procedures, and ETL processes for data extraction, transformation, and loading
• Handle data from various sources including flat files (CSV, TXT), XML, JSON, and other structured/unstructured formats
• Analyze legacy data structures and map them to target EMR schemas ensuring data integrity and compliance
• Collaborate with clinical informatics teams, data analysts, and IT stakeholders to validate data accuracy and completeness
• Ensure compliance with HIPAA and other regulatory standards during data handling and migration
• Troubleshoot data anomalies and provide resolution strategies
• Document data mapping, conversion logic, and validation processes
• Comply with the terms and conditions of the employment contract, company policies and procedures, and any and all directives (such as, but not limited to, transfer and/or re-assignment to different work locations, change in teams and/or work shifts, policies in regards to flexibility of work benefits and/or work environment, alternative work arrangements, and other decisions that may arise due to the changing business environment). The Company may adopt, vary or rescind these policies and directives in its absolute discretion and without any limitation (implied or otherwise) on its ability to do so
  
  

• Solid expertise in MS SQL Server (T-SQL, SSIS)
• Experience in handling clinical data either in the field of data conversion or reporting using Powerbi/tableau
• Experience with data validation, QA, and UAT processes
• Proficiency in handling data from flat files, XML, JSON, and other data formats
• Familiarity with HL7, FHIR, CCD, and other healthcare data exchange standards
• Proven excellent problem-solving and communication skills
  
  

• Proven experience with at least one of the top EMRs: Epic, Cerner, Allscripts, Meditech, NextGen, eClinicalWorks
• Experience working in EHR-agnostic environments and integrating with various clinical systems