Note: The job is a remote job and is open to candidates in USA. ELLKAY provides healthcare data management, interoperability, and technology solutions across laboratories, ambulatory practices, hospitals, health systems, healthcare IT vendors, and health plans. The Senior Data Solution Engineer designs, develops, and maintains data solutions and system adapters for EHR data migration and archival projects. The role analyzes legacy systems, transforms healthcare data, develops SQL and ETL processes, assures data quality, supports clients, and provides technical leadership and mentorship.
Responsibilities
- Analyze legacy databases, schemas, relationships, application functionality, and workflows to identify the data required for migration or archival
- Use approved AI tools to review discovery notes, technical documentation, schemas, and metadata; identify project requirements, dependencies, gaps, risks, and complexity; and support more accurate effort estimates
- Use AI to summarize application documentation, analyze database objects and code, trace potential data flows, and develop hypotheses about how application features relate to stored data. Validate all findings through technical analysis and stakeholder review
- Define and document source-to-target mappings between legacy systems and ELLKAY’s data model. Use AI tools, where appropriate, to suggest field relationships, identify mapping gaps, and accelerate documentation
- Design, optimize, and maintain SQL queries and transformation processes for extracting, cleansing, standardizing, and loading healthcare data. Use AI coding assistants to support query development, optimization, and peer-review preparation
- Validate query results and migration outputs for accuracy, completeness, and consistency. Use AI-assisted analysis to identify anomalies, reconciliation issues, missing data, and unexpected patterns
- Investigate complex database, application, performance, and data-quality issues. Use AI tools to help analyze errors, compare possible root causes, and evaluate potential solutions
- Work with Data Migration Engineers, Project Managers, clients, and other stakeholders to clarify scope, confirm requirements, manage expectations, and resolve technical challenges. Participate in client calls when project complexity requires senior technical support
- Maintain documentation for systems, workflows, mappings, transformation rules, queries, assumptions, and testing results. Use AI to help create summaries, standardize documentation, and capture reusable knowledge
- Serve as a data migration subject matter expert, mentor team members, establish development best practices, and promote the secure and responsible use of AI-assisted engineering tools
Skills
- Bachelor's degree in Computer Science, Information Technology, Data Science, or a related field; equivalent professional experience may be considered
- Five or more years of experience in data engineering, database development, data migration, or a related role
- Advanced SQL skills and experience analyzing complex relational databases
- Strong experience with data modeling, ETL processes, data transformation, and quality assurance
- Experience scoping technical projects and translating application workflows into data requirements
- Familiarity with cloud technologies such as Azure, AWS, or Google Cloud
- Strong analytical, troubleshooting, communication, and collaboration skills
- Ability to mentor team members and provide technical leadership
- Healthcare application or EHR data experience is preferred
- Experience with AI-assisted coding, analysis, documentation, or data-quality tools is preferred
Benefits
- Medical, Dental, and Vision benefits
- Employer-paid Life and LTD
- 401k w/ matching – once eligibility is met
- Work/life balance
- Paid Volunteer Program
- Flexible working hours
- Generous FTO
- Remote work options
- Employee Discounts
- Parental Leave
- Gym membership / Exercise class stipends
- Working with talented, collaborative, and friendly people who love what they do
- Professional growth within
- Innovation environment
- On site in HQ Free daily lunches
- Hybrid workplace, offering employees flexibility in how they structure their time between in-office and remote work
- For those who do not live within 40 miles of one of our offices, remote work may be considered for candidates whose skills and experience strongly align with the role
Company Overview
Company H1B Sponsorship