Senior Data Engineer

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

Benefits offered by this job

Medical/dental/vision

Flexible spending

Company-paid life insurance

Short-term disability

Voluntary benefits

401(k)

Paid Time Off

Paid holidays

Job summary

AnewHealth is seeking an experienced data engineer to join our remote team, delivering robust SQL data warehouse solutions for healthcare claims and analytics. You will design, develop, test, and optimize data pipelines on Microsoft SQL Server and cloud platforms, collaborating with Product Owner and engineers to ensure reliability and performance.

You will work with PowerShell, Python, and .NET tools, participate in Agile ceremonies, and contribute to scalable, maintainable code across

Qualifications

• Experience with SQL Server tooling and data warehousing concepts.
• Strong knowledge of data modeling, ETL, and performance tuning.
• Experience in healthcare data standards and claims processing is a plus.

Responsibilities

• Design, develop and deliver SQL data solutions per requirements and schedules.
• Collaborate with Product Owner to evaluate current systems and plan enhancements.
• Test, debug, and optimize existing data processes, reports and ETL pipelines.
• Maintain and optimize VisualCron schedules and related SQL procedures.
• Troubleshoot pharmacy claim related data issues and reports.
• Produce technical specifications and monitor database performance.

Skills

SQL

SSIS

SSRS

SSMS

SSAS

PowerShell

Python

C#

Power BI

Azure SQL

Education

Bachelor's degree in Computer Science

Master’s degree in Computer Science

Tools

AWS

GitLab

Visual Studio

PowerBI

Job description

Job Details

AnewHealth is one of the nation’s leading pharmacy care management companies that specializes in caring for people with the most complex, chronic needs—wherever they call home. We enable better outcomes for patients and the healthcare organizations who support them. Established in 2023 through the combination of ExactCare and Tabula Rasa HealthCare, we provide a suite of solutions that includes comprehensive pharmacy services; full-service pharmacy benefit management; and specialized support services for Program of All-Inclusive Care for the Elderly. With over 1,400 team members, we care for more than 100,000 people across all 50 states.

Responsibilities

• Work in an Agile development environment; actively participate in and contribute to all Scrum ceremonies.
• Design, develop and deliver solutions per requirements and committed schedules.
• Work closely with Product Owner in evaluating current systems and making decisions on future development.
• Test, debug, and add enhancements to existing code, processes, or reports.
• Maintain existing processes, including but not limited to: VisualCron schedules, SQL/ETL procedures, and reporting.
• Assist in troubleshooting pharmacy claim related issues, reports and processes.
• Support existing .NET applications and subsequent SQL code tied to NCPDP Pharmacy Encounter data submissions.
• Produce detailed technical specifications based on requirements and design.
• Monitor and optimize database performance, including query tuning and indexing strategies.
• Review new and existing processes and provide recommendations for reliable and maintainable code.
• Analyze and research software requirements to determine feasibility of design and market requirements within time and cost constraints.
• Serve as a technical expert in the design, development, coding, testing, and debugging of new software or complex enhancements to existing software.
• Learn new technologies and resolve challenges involved with integrating them with our Cloud and product infrastructure.
• Proactively raise problems and solutions to staff engineers and management.
• Communicate and propose solutions to updates, changes, and risks to stakeholders.
• Share knowledge to help develop and advance the team through mentorship.
• Keep abreast of emerging trends and best practices in database development and related technologies.

Qualifications

• Education Bachelor's degree in Computer Science, similar technical field of study, or 4+ years of related experience and/or equivalent combination of education and experience required.
• Master’s degree in Computer Science, similar technical field of study preferred.
• Proficient in database design, normalization, and data modeling.
• Strong ability with dimensional data modeling and OLAP principles.
• 10+ years of SQL database development, working with the full Microsoft SQL Server toolset (SSIS, SSRS, SSMS, SSAS, RDBMS).
• 5+ years’ experience with Data Warehouse methodologies.
• Expertise in query tuning, performance optimization, and troubleshooting.
• Familiarity with cloud-based database solutions (e.g., Azure SQL Database, AWS RDS).
• Advanced SQL skills, including data modeling, DBO creation, management, and indexing.
• Experience implementing high availability, high throughput, scalable systems.
• Expertise in identifying and diagnosing application and database related issues, perform root cause analysis, and recommend corrective actions.
• Strong ability with dimensional data modeling and OLAP principles.
• Experience with PowerShell, Python.
• Experience using provided tools (AWS, GitLab, Visual Studio).
• Experience with agile methodology (Scrum, Kanban, Lean, etc.) preferred.
• Familiarity with .NET, C#, JSON, XML, VisualCron, PowerBI.
• Familiarity with reporting and visualization tools (e.g., Power BI, Tableau).
• Knowledge of non-relational databases (e.g., MongoDB, Cassandra) and big data technologies (e.g., Hadoop, Spark).

Skills & Abilities

• Experience in healthcare technology, online pharmacy claims adjudication preferred.
• Knowledge of pharmacy industry standards such as NCPDP, HL7, ANSI X12, and/or related drug database terminologies and classifications.
• Knowledge of Medicare Part D, PDE submissions & returns, pharmacy claims and benefit management.
• Demonstrated ability to be creative, flexible, and passionate about building quality solutions.
• Demonstrated ability to architect, design, develop and implement solutions around a micro-service and monolithic architectures.
• Skilled in written and verbal communication with demonstrated ability to work collaboratively with a team and independently as needed.
• Has initiative and follow-through on projects with minimal supervision or guidance.
• Demonstrated expertise to work in multiple technical areas or disciplines.
• Interest and ability to learn other coding languages and technologies as needed.

Physical/Mental Demands

This position is administrative in nature and will present physical demands requisite to a position requiring: hearing, seeing, sitting, standing, talking, and walking. The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Must be able to commute to multiple site locations within assigned territory. May be necessary to work extended hours as needed.

Schedule

This is a full-time position with an expectation to work an average of 40 hours per week and be available outside of normal business hours to meet customer expectations on an ad-hoc basis. Schedules are set to accommodate the requirements of the position and the needs of the organization and may be adjusted as needed. This is a remote position.

Benefits

AnewHealth offers a comprehensive benefit package for full-time employees that includes medical/dental/vision, flexible spending, company-paid life insurance and short-term disability as well as voluntary benefits, 401(k), Paid Time Off and paid holidays.

• medical/dental/vision
• flexible spending
• company-paid life insurance
• short-term disability
• voluntary benefits
• 401(k)
• Paid Time Off
• paid holidays

Equal Opportunity & Diversity

AnewHealth offers equal employment opportunity to all qualified applicants regardless of race, color, religion, national origin, sex, sexual orientation, gender identity, age, disability, genetic information, or veteran status, or other legally protected classification in the state in which a person is seeking employment. Applicants are encouraged to confidentially self-identify when applying. Local applicants are encouraged to apply. AnewHealth and its affiliated companies are equal opportunity employers. We celebrate diversity and are committed to fostering an inclusive environment for all employees. We maintain a drug-free work environment. Applicants must be eligible to work in this country.

Company Culture

Want to learn more about working at AnewHealth? Visit our website to explore who we are, discover our award‑winning culture and benefits, and watch our video to get a closer look.