Sr. Data Solutions Engineer

• 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.

• 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.
• Healthcare application or EHR data experience is preferred.
• Experience with AI-assisted coding, analysis, documentation, or data-quality tools is preferred.
• Strong analytical, troubleshooting, communication, and collaboration skills.
• Ability to mentor team members and provide technical leadership.

ELLKAY offers a comprehensive and competitive benefit package that starts day one!

• Medical, Dental, and Vision benefits
• Employer-paid Life and LTD
• 401k w/ matching – once eligibility is met
• Work/life balance

• Flexible working hours
• Generous FTO
• Remote work options
• Employee Discounts
• Parental Leave
• Gym membership / Exercise class stipends

Our awesome culture includes:

• Working with talented, collaborative, and friendly people who love what they do
• Professional growth within
• Innovation environment
• On site in HQ Free daily lunches

Additional information

At ELLKAY, we are committed to operating as a hybrid workplace, offering employees flexibility in how they structure their time between in-office and remote work.

We recognize the significance of fostering connections, collaboration, and creativity within our office culture and its positive impact on our business.

Our philosophy of operating as a hybrid workplace underscores our dedication to enabling employees to tailor work-life balance to their individual preferences.

For those who do not live within 40 miles of one of our offices, we are open to considering remote work for candidates whose skills and experience strongly align with the role.

While we prioritize a hybrid work environment for most roles, we understand the importance of flexibility and are open to remote work for specific positions and specialized skill sets.

For more information on our company, visit www.ELLKAY.com.

ELLKAY LLC is a Smoke-Free Workplace.

ELLKAY, LLC provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.