Senior Data Engineer

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 needs. - Benefits described include medical, dental, and vision coverage, retirement savings, paid time off, holidays, life insurance, and disability coverage.