Data Engineer

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

Benefits offered by this job

Medical coverage

Dental coverage

Vision coverage

Flexible spending options

Life insurance

Short-term disability coverage

Retirement benefits

Paid time off

Paid holidays

Job summary

exactcare is seeking a data engineer to design, maintain, and improve data systems that support pharmacy benefit management, analytics, reporting, and operations. The role combines data engineering, database development, application support, and problem-solving in a regulated environment.

You will work in an Agile team, optimize SQL/ETL, support claims data including NCPDP, and collaborate with product, cloud and infrastructure teams.

Qualifications

• Bachelor’s degree in Computer Science or related field, or 4+ years of relevant experience.
• Extensive SQL Server development experience (SSIS/SSRS/SSMS/SSAS) and strong SQL.
• Experience in database design, normalization, dimensional modeling, and data warehousing.
• Familiarity with cloud DB services (Azure SQL DB or AWS RDS) and HA/throughput architectures.
• Strong problem solving and ability to work independently or in teams; good communication.

Responsibilities

• Design, develop, test, debug, and deliver data solutions within Agile/Scrum.
• Maintain and enhance SQL/ETL procedures, reporting workflows, and .NET applications.
• Support pharmacy claims processes and data submissions (NCPDP related).
• Create technical specifications and evaluate feasibility, cost, schedule, and long-term maintainability.
• Monitor database performance with query tuning, indexing, and root-cause analysis.
• Collaborate with product owners, engineers, stakeholders, and cloud teams; communicate risks and mentor colleagues.

Skills

SQL Server development

Data warehousing

Communication

Education

Bachelor’s degree in Computer Science or related field

Tools

SSIS

SSRS

SSMS

SSAS

Azure SQL Database

AWS RDS

Indexing

Relational databases

Job description

Role overview

This role designs, maintains, and improves data systems that support pharmacy benefit management, analytics, reporting, and healthcare operations. The work combines data engineering, database development, application support, and technical problem-solving in a regulated environment where reliability, maintainability, and data quality are essential.

Responsibilities

• Design, develop, test, debug, and deliver data solutions within an Agile/Scrum development process.
• Maintain and enhance SQL/ETL procedures, reporting workflows, scheduled processes, and existing .NET applications.
• Support pharmacy claims processes and data submissions, including systems associated with NCPDP Pharmacy Encounter data.
• Create technical specifications and evaluate requirements for feasibility, cost, schedule, and long-term maintainability.
• Monitor database performance and apply query tuning, indexing, troubleshooting, and root-cause analysis techniques.
• Collaborate with product owners, engineers, business stakeholders, and cloud or infrastructure teams; communicate risks and mentor colleagues.

Requirements

• Bachelor’s degree in Computer Science or a related technical field, or at least four years of relevant experience or an equivalent combination.
• Extensive SQL Server development experience, including SSIS, SSRS, SSMS, SSAS, relational databases, advanced SQL, database objects, and indexing.
• Strong background in database design, normalization, dimensional modeling, OLAP principles, data warehousing, performance optimization, and scalable systems.
• Experience with cloud database services such as Azure SQL Database or AWS RDS, as well as high-availability and high-throughput architectures.
• Ability to diagnose application and database issues, perform root-cause analysis, and work across multiple technical disciplines.
• Strong written and verbal communication, initiative, follow-through, and ability to work independently or collaboratively.

Nice to have

• A master’s degree in a related technical field.
• Experience with healthcare technology, pharmacy claims adjudication, NCPDP, HL7, ANSI X12, drug data standards, Medicare Part D, or PDE submissions.
• Experience designing solutions across microservice and monolithic architectures and integrating systems with cloud infrastructure.

Benefits and work setup

This is a full-time remote position, generally averaging 40 hours per week. Occasional availability outside normal business hours may be required.

• medical coverage
• dental coverage
• vision coverage
• flexible spending options
• life insurance
• short-term disability coverage
• retirement benefits
• paid time off
• paid holidays