
Advisory Consultant - Healthcare exp, SQL+Reporting
- Hyderabad, Telangana
- Permanent
- Full-time
- 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