Remote Senior Data Engineer: Data Warehouse & SQL Expert

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

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