Senior Data Engineer

This is a fully remote position, open to applicants in United States.

📋 Description

• Oversee intricate data systems and enhance current processes

• Develop new data solutions for clients in Pharmacy Benefit Management

• Collaborate with fellow engineers, business stakeholders, cross-functional teams, and the Product Owner

• Operate within an Agile development environment and engage in Scrum ceremonies

• Design, develop, test, debug, and deliver software solutions in accordance with requirements and timelines

• Maintain VisualCron schedules, SQL/ETL procedures, reports, existing .NET applications, and associated SQL code

• Resolve pharmacy claim issues, reports, and processes

• Support SQL code related to NCPDP Pharmacy Encounter data submissions

• Generate comprehensive technical specifications from requirements and designs

• Monitor and enhance database performance through query tuning and indexing strategies

• Evaluate processes and suggest reliable, maintainable code

• Analyze software requirements for design feasibility and market needs within time and budget constraints

• Act as a technical authority in design, development, coding, testing, and debugging

• Integrate new technologies with cloud and product infrastructures

• Identify problems and propose solutions to engineering staff and management

• Communicate proposed solutions, updates, changes, and risks to stakeholders

• Mentor team members and disseminate knowledge

• Keep abreast of emerging trends and best practices in database development and related technologies

⛳️ Requirements

• Bachelor's degree in Computer Science, a related technical field, or 4+ years of relevant experience and/or an equivalent combination of education and experience required

• Master's degree in Computer Science or a similar technical field is preferred

• 10+ years of SQL database development using the Microsoft SQL Server toolset, including SSIS, SSRS, SSMS, SSAS, and RDBMS

• 5+ years of experience with data warehouse methodologies

• Proficient in database design, normalization, and data modeling

• Strong competency in dimensional data modeling and OLAP principles

• Expertise in query tuning, performance optimization, and troubleshooting

• Familiarity with cloud-based database solutions such as Azure SQL Database and AWS RDS

• Advanced SQL skills, encompassing data modeling, DBO creation, management, and indexing

• Experience in implementing high-availability, high-throughput, scalable systems

• Expertise in diagnosing application and database issues, conducting root cause analysis, and recommending corrective measures

• Experience with PowerShell and Python

• Familiarity with AWS, GitLab, and Visual Studio

• Knowledge of .NET, C#, JSON, XML, VisualCron, and Power BI

• Familiarity with reporting and visualization tools like Power BI and Tableau

• Understanding of non-relational databases such as MongoDB and Cassandra, along with big data technologies like Hadoop and Spark

• Knowledge of pharmacy industry standards such as NCPDP, HL7, ANSI X12, and related drug database terminologies and classifications

• Familiarity with Medicare Part D, PDE submissions and returns, pharmacy claims, and benefit management

• Capability to architect, design, develop, and implement both microservice and monolithic architectures

• Ability to work collaboratively and independently

• Willingness to learn additional coding languages and technologies as required

• Must be eligible to work in the United States

• Must be able to travel to multiple site locations within the designated territory

• May require working extended hours and being available outside of normal business hours on an as-needed basis

🏝️ Benefits

• Medical, dental, and vision insurance

• Flexible spending options

• Company-paid life insurance

• Short-term disability coverage

• Optional benefits

• 401(k) retirement plan

• Paid Time Off

• Paid holidays

• Remote work opportunity

• Flexible schedules based on position and organizational needs