Senior Data Engineer

ExactCare; United States; Remote; USD 120,000 - 180,000; Full time

Benefits offered by this job

Medical insurance

Dental insurance

Vision coverage

Retirement savings

Job summary

ExactCare is seeking an experienced data engineer to maintain and extend data systems supporting pharmacy benefits management, reporting, and claims processes. The role covers data warehousing, SQL development, application support, and new solution delivery with a focus on healthcare data compliance and reliable operations.

Responsibilities include designing and delivering data and software solutions in an Agile environment, maintaining SQL/ETL pipelines, and troubleshooting data submission

Qualifications

• Bachelor's degree in computer science or related field, or at least four years of related experience.
• Ten or more years of SQL database development using Microsoft SQL Server tools (SSIS, SSRS, SSMS, SSAS).
• At least five years of data warehouse methodology experience, with strong database design, normalization, data modeling, and OLAP knowledge.
• Advanced SQL skills, including query tuning, indexing, performance optimization, troubleshooting, and root cause analysis.
• Experience with scalable, high-throughput systems and cloud database services such as Azure SQL or AWS RDS.
• Ability to work independently and collaboratively, communicate clearly, and support both existing and new systems.

Responsibilities

• Design, build, test, and deliver data and software solutions within an Agile development process, coordinating with product owners and stakeholders.
• Maintain and enhance SQL and ETL procedures, scheduled workflows, reports, and supporting .NET applications.
• Troubleshoot pharmacy claim, reporting, and data submission issues, including systems tied to pharmacy encounter data.
• Produce technical specifications, investigate requirements, and assess design feasibility against delivery constraints.
• Monitor database performance, tune queries and indexes, and recommend changes that improve reliability and maintainability.
• Share technical knowledge, mentor teammates, raise risks and solutions, and keep current with relevant database practices.

Skills

Advanced SQL

Data warehouse design

ETL development

Query tuning

Education

Bachelor's degree in CS or related field

Tools

SSIS

SSRS

SSMS

SSAS

Azure SQL

AWS RDS

Job description

Role overview

Maintain and extend data systems used for pharmacy benefit management, reporting, and claims-related processes. The work spans data warehousing, SQL development, application support, and new solution delivery, with care required around healthcare data compliance and dependable operations.

Responsibilities

• Design, build, test, and deliver data and software solutions within an Agile development process, coordinating with product owners and stakeholders.
• Maintain and enhance SQL and ETL procedures, scheduled workflows, reports, and supporting .NET applications.
• Troubleshoot pharmacy claim, reporting, and data submission issues, including systems tied to pharmacy encounter data.
• Produce technical specifications, investigate requirements, and assess design feasibility against delivery constraints.
• Monitor database performance, tune queries and indexes, and recommend changes that improve reliability and maintainability.
• Share technical knowledge, mentor teammates, raise risks and solutions, and keep current with relevant database practices.

Requirements

• Bachelor's degree in computer science or a related technical field, or at least four years of related experience or an equivalent combination.
• Ten or more years of SQL database development using Microsoft SQL Server tools, including SSIS, SSRS, SSMS, and SSAS.
• At least five years of data warehouse methodology experience, with strong database design, normalization, data modeling, and OLAP knowledge.
• Advanced SQL skills, including query tuning, indexing, performance optimization, troubleshooting, and root cause analysis.
• Experience with scalable, high-throughput systems and familiarity with cloud database services such as Azure SQL or AWS RDS.
• Ability to work independently and collaboratively, communicate clearly, and support both existing and new systems.

Nice to have

• A master's degree in computer science or a similar field.
• Healthcare technology or online pharmacy claims experience, with knowledge of standards such as NCPDP, HL7, or ANSI X12, or Medicare Part D and pharmacy benefit processes.
• Experience with microservices and monolithic architectures.

Benefits and work setup

• Remote, full-time role. The listing notes occasional availability outside standard hours may be needed to meet customer….
• Benefits described include medical, dental, and vision coverage, retirement savings, paid time off, holidays, life insurance, and disability coverage.