Senior Data Engineer

AnewHealth

2d • Remote

About The Position

AnewHealth is hiring a Senior Data Engineer to maintain and improve complex data systems and develop new solutions for Pharmacy Benefit Management clients. The role collaborates with engineers and business stakeholders to deliver quality solutions, follow engineering best practices, and meet business demands while respecting healthcare data compliance requirements.

The Senior Data Engineer works with cross-functional teams to design and implement scalable data solutions that support analytics, business intelligence, and improved financial and clinical outcomes. The position requires strong data management and warehousing knowledge, functional programming understanding, and familiarity with modern software engineering practices. This is a remote, full-time position averaging 40 hours per week, with availability outside normal business hours on an ad hoc basis to meet customer expectations. Schedules may be adjusted to accommodate organizational needs.

Requirements

• Bachelor's degree in Computer Science or a similar technical field, or at least 4 years of related experience and/or an equivalent combination of education and experience.
• At least 10 years of SQL database development experience using the Microsoft SQL Server toolset, including SSIS, SSRS, SSMS, SSAS, and RDBMS.
• At least 5 years of experience with data warehouse methodologies.
• Proficiency in database design, normalization, and data modeling.
• Strong ability with dimensional data modeling and OLAP principles.
• Expertise in query tuning, performance optimization, and troubleshooting.
• Advanced SQL skills, including data modeling, DBO creation and management, and indexing.
• Experience implementing highly available, high-throughput, scalable systems.
• Ability to identify and diagnose application and database issues, conduct root cause analysis, and recommend corrective actions.
• Experience with PowerShell and Python.
• Experience using AWS, GitLab, and Visual Studio.
• 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 and returns, pharmacy claims, and benefit management.
• Ability to architect, design, develop, and implement solutions involving microservice and monolithic architectures.
• Strong written and verbal communication skills and ability to collaborate with a team or work independently.
• Initiative and follow-through on projects with minimal supervision or guidance.
• Ability to work across multiple technical areas or disciplines and learn other coding languages and technologies as needed.
• Ability to meet the physical demands of the role, including hearing, seeing, sitting, standing, talking, and walking, and to commute to multiple site locations within the assigned territory.
• Must be eligible to work in the country.

Nice To Haves

• Master's degree in Computer Science or a similar technical field.
• Familiarity with cloud-based database solutions such as Azure SQL Database or AWS RDS.
• Experience with Agile methodologies such as Scrum, Kanban, or Lean.
• Familiarity with .NET, C#, JSON, XML, VisualCron, and Power BI.
• Familiarity with reporting and visualization tools such as Power BI and Tableau.
• Knowledge of non-relational databases such as MongoDB or Cassandra and big data technologies such as Hadoop or Spark.
• Experience in healthcare technology or online pharmacy claims adjudication.
• Creativity, flexibility, and passion for building quality solutions.

Responsibilities

• Work in an Agile development environment and participate in Scrum ceremonies.
• Design, develop, and deliver solutions according to requirements and committed schedules.
• Work with the Product Owner to evaluate current systems and make decisions about future development.
• Test, debug, and enhance existing code, processes, and reports.
• Maintain processes, including VisualCron schedules, SQL/ETL procedures, and reporting.
• Troubleshoot pharmacy claim-related issues, reports, and processes.
• Support existing .NET applications and related SQL code for 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 processes and recommend reliable, maintainable code improvements.
• Analyze software requirements and assess design feasibility against market requirements, time, and cost constraints.
• Provide technical expertise in designing, developing, coding, testing, and debugging new software and complex enhancements.
• Learn new technologies and address challenges integrating them with cloud and product infrastructure.
• Proactively raise problems and solutions to staff engineers and management.
• Communicate and propose solutions related to updates, changes, and risks to stakeholders.
• Mentor colleagues and share knowledge to support team development.
• Keep up to date with emerging trends and best practices in database development and related technologies.

Benefits

• Medical, dental, and vision coverage, effective the first day of the month following hire.
• Flexible spending account.
• Company-paid life insurance and short-term disability.
• Voluntary benefits.
• 401(k).
• Paid time off.
• Paid holidays.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior