Data Engineer

AnewHealth is seeking an experienced Data Engineer to maintain complex data systems and drive ongoing improvements for Pharmacy Benefit Management (PBM) clients. In this remote role based in Cleveland, OH, you will help deliver analytics and business intelligence solutions while supporting healthcare data compliance. Work is performed in an Agile environment with cross-functional stakeholders, with a focus on designing, developing, and optimizing scalable data solutions.

How you will contribute

• Participate in Agile development and actively contribute to all Scrum ceremonies.
• Design, develop, and deliver solutions according to requirements and committed schedules.
• Partner with the Product Owner to evaluate current systems and help shape future development decisions.
• Test, debug, and enhance existing code, processes, and reports.
• Maintain existing processes including VisualCron schedules, SQL/ETL procedures, and reporting.
• Support troubleshooting of pharmacy claim-related issues, reports, and processes.
• Support existing .NET applications and associated SQL code tied to NCPDP Pharmacy Encounter data submissions.
• Produce detailed technical specifications based on requirements and design.
• Monitor and optimize database performance through query tuning and indexing strategies.
• Review new and existing processes and provide recommendations for reliable, maintainable code.
• Analyze and research software requirements to determine feasibility within time and cost constraints.
• Serve as a technical expert across design, development, coding, testing, and debugging of new software or complex enhancements.
• Learn new technologies and address integration challenges with Cloud and product infrastructure.
• Proactively raise problems and propose solutions to staff engineers and management.
• Communicate and propose solutions related to updates, changes, and risks to stakeholders.
• Share knowledge through mentorship to help advance the team.
• Stay current with emerging trends and best practices in database development and related technologies.

What you bring

• 10+ years of experience; Bachelor’s degree in Computer Science or a similar technical field (or 4+ years of related experience).
• Master’s degree in Computer Science or a similar technical field preferred.
• Proficiency in database design, normalization, and data modeling.
• Strong dimensional data modeling skills and understanding of OLAP principles.
• 10+ years of SQL database development with full Microsoft SQL Server toolset experience (SSIS, SSRS, SSMS, SSAS, and RDBMS).
• 5+ years of experience with Data Warehouse methodologies.
• Expertise in query tuning, performance optimization, and troubleshooting.
• Familiarity with cloud database solutions such as Azure SQL Database and AWS RDS.
• Advanced SQL skills, including data modeling, DBO creation/management, and indexing.
• Experience implementing high availability, high throughput, and scalable systems.
• Ability to identify and diagnose application and database issues, perform root cause analysis, and recommend corrective actions.
• Experience with PowerShell and Python.
• Experience using tools including AWS, GitLab, and Visual Studio.
• Agile methodology experience (Scrum, Kanban, Lean, etc.) preferred.
• Familiarity with .NET, C#, JSON, XML, VisualCron, and PowerBI.
• Familiarity with reporting and visualization tools such as Power BI and 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 experience preferred.
• Knowledge of pharmacy industry standards such as NCPDP, HL7, ANSI X12, and related drug database terminologies/classifications.
• Knowledge of Medicare Part D, PDE submissions and returns, pharmacy claims, and benefit management.
• Ability to architect, design, develop, and implement solutions across micro-service and monolithic architectures.
• Strong written and verbal communication skills, with the ability to collaborate and work independently as needed.
• Initiative and follow-through on projects with minimal supervision.
• Ability to work across multiple technical areas and learn additional coding languages and technologies as needed.

Technologies involved

• SQL, Microsoft SQL Server, SSIS, SSRS, SSMS, SSAS
• VisualCron, .NET, PowerShell, Python
• NCPDP, NCPDP Pharmacy Encounter data submissions
• Azure SQL Database, AWS RDS, AWS
• GitLab, Visual Studio, C#, JSON, XML
• 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
• Paid holidays
• Medical, dental and vision coverage effective 1st of the month following date of hire

Schedule and location

• Full-time role with an expectation to work an average of 40 hours per week.
• Must be available outside normal business hours on an ad-hoc basis to meet customer expectations.
• Schedules accommodate role and organization needs and may be adjusted as needed.
• Remote location; must be able to commute to multiple site locations within the assigned territory.

Physical and mental demands

• Administrative position requiring hearing, seeing, sitting, standing, talking, and walking.
• May require extended hours as needed.