Data Engineer

AnewHealth; Cleveland (OH); Remote; USD 110,000 - 150,000; Full time

Benefits offered by this job

Medical benefits

Flexible spending

Life insurance

401(k)

PTO & holidays

Job summary

AnewHealth is seeking a Data Engineer in Cleveland (remote) to support Pharmacy Benefit Management clients by building scalable data solutions for analytics and BI while complying with healthcare data standards.

You will work in an Agile environment, enhancing ETL processes, supporting database performance, and contributing technical expertise across new development and complex enhancements.

Qualifications

• Bachelor’s degree in Computer Science or similar technical field, or 4+ years of related experience required.

Responsibilities

• Participate in Agile development activities and Scrum ceremonies.
• Design, develop, and deliver data solutions aligned to requirements and schedules.
• Collaborate with Product Owner to evaluate systems and inform future development.
• Test, debug, and implement enhancements to code, processes, and reports.
• Monitor and optimize database performance, including query tuning and indexing.
• Create technical specifications from requirements and designs.
• Mentor teammates and share knowledge on best practices.

Skills

SQL Server

C#

Python

PowerShell

Data modeling

ETL

Cloud platforms

Agile

Education

Bachelor’s degree in Computer Science or related field

4+ years of related experience

Tools

Azure SQL Database

AWS RDS

Visual Studio

GitLab

VisualCron

PowerBI

Tableau

MongoDB/Cassandra

Job description

The Data Engineer role supports Pharmacy Benefit Management clients by maintaining and improving complex data systems. The position focuses on building scalable data solutions for analytics and business intelligence while adhering to healthcare data compliance requirements.

Role Overview

In an Agile environment, this role partners with cross-functional stakeholders to design, develop, test, and optimize data solutions. Responsibilities include enhancing existing ETL and reporting processes, supporting database performance, and contributing technical expertise across new development and complex enhancements.

Key Responsibilities

• Participate in Agile development activities, including contributing to all Scrum ceremonies.
• Design, develop, and deliver solutions aligned to requirements and committed schedules.
• Collaborate with the Product Owner to evaluate current systems and inform future development decisions.
• Test, debug, and implement enhancements to existing code, processes, and reports.
• Maintain existing processes, including VisualCron schedules, SQL/ETL procedures, and reporting.
• Assist in troubleshooting pharmacy claim related issues, reports, and processes.
• Support existing .NET applications and related SQL code connected to NCPDP Pharmacy Encounter data submissions.
• Create detailed technical specifications based on requirements and design.
• Monitor and optimize database performance, including query tuning and indexing strategies.
• Review existing and new processes and provide recommendations for reliable and maintainable code.
• Analyze and research software requirements to determine feasibility within time and cost constraints.
• Act as a technical expert for the design, development, coding, testing, and debugging of new software and complex enhancements.
• Learn and integrate new technologies with cloud and product infrastructure.
• Escalate problems and proposed solutions to staff engineers and management.
• Communicate updates, changes, and risks to stakeholders and propose solutions.
• Share knowledge through mentorship to help advance the team.
• Stay current with emerging trends and best practices in database development and related technologies.

Required Qualifications

• Bachelor’s degree in Computer Science or similar technical field, or 4+ years of related experience (or equivalent education and experience combination) required.
• Master’s degree in Computer Science or similar technical field preferred.
• Proficient in database design, normalization, and data modeling.
• Strong capability in dimensional data modeling and OLAP principles.
• 10+ years of SQL database development using the Microsoft SQL Server toolset (SSIS, SSRS, SSMS, SSAS, RDBMS).
• 5+ years of 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, and scalable systems.
• Expertise in identifying and diagnosing application and database issues, performing root cause analysis, and recommending corrective actions.
• Experience with PowerShell and Python.
• Experience using provided tools (AWS, GitLab, Visual Studio).
• Agile methodology experience (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).
• Healthcare technology and 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 for micro-service and monolithic architectures.
• Skilled in written and verbal communication, with ability to collaborate and work independently as needed.
• Initiative and follow-through on projects with minimal supervision.
• Demonstrated expertise across multiple technical areas or disciplines.
• Interest and ability to learn additional coding languages and technologies as needed.

Location and Work Setup

• Location: Cleveland, OH (remote)
• Experience level: 10+ years minimum

Technology Stack

• SQL, Microsoft SQL Server (SSIS, SSRS, SSMS, SSAS, RDBMS), VisualCron
• .NET, PowerShell, Python, C#, JSON, XML
• NCPDP, NCPDP Pharmacy Encounter data submissions
• Azure SQL Database, AWS RDS, AWS, GitLab, Visual Studio
• PowerBI / Power BI, Tableau
• MongoDB, Cassandra, Hadoop, Spark
• HL7, ANSI X12

Benefits

• Medical/dental/vision
• Flexible spending
• Company-paid life insurance and short-term disability
• Voluntary benefits
• 401(k)
• Paid Time Off and paid holidays
• Medical, dental, and vision coverage effective 1st of the month following date of hire

Physical and Mental Demands

• This position is administrative in nature and requires hearing, seeing, sitting, standing, talking, and walking.
• Must be able to commute to multiple site locations within assigned territory.
• Extended hours may be necessary as needed.

Schedule

• Full-time position with an expectation to work an average of 40 hours per week.
• Availability outside of normal business hours may be required on an ad-hoc basis to meet customer expectations.
• Schedules may be adjusted to meet position requirements and organizational needs.

About Compliance

The role supports healthcare data compliance requirements while delivering improvements and new solutions for Pharmacy Benefit Management clients.