Data Engineer

Data Engineer role supporting scalable data and analytics for Pharmacy Benefit Management clients in Cleveland, OH with remote flexibility.

Responsibilities

• Participate in an Agile delivery model and contribute 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 guide future development decisions.
• Test, debug, and enhance existing code, data processes, and reports.
• Maintain production processes, including VisualCron schedules, SQL/ETL procedures, and reporting workflows.
• Troubleshoot pharmacy claim related issues across reports and processes.
• Support .NET applications and associated SQL code tied 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 recommend improvements for reliability and maintainability.
• Analyze and research software requirements to assess design feasibility within time and cost constraints.
• Act as a technical expert across design, development, coding, testing, and debugging of new software or complex enhancements.
• Learn new technologies and solve integration challenges with Cloud and product infrastructure.
• Proactively raise problems and propose solutions to staff engineers and management.
• Communicate and present updates, changes, and risks to stakeholders.
• Share knowledge and provide mentorship to help advance team capability.
• Stay current on emerging trends and database development best practices.

Requirements

• Bachelor's degree in Computer Science (or similar technical field), or 4+ years of related experience (or equivalent education and experience).
• Master’s degree in Computer Science (or similar technical field) preferred.
• Proficiency in database design, normalization, and data modeling.
• Strong understanding of dimensional data modeling and OLAP principles.
• 10+ years of SQL database development using the full Microsoft SQL Server toolset: SSIS, SSRS, SSMS, SSAS, and RDBMS.
• 5+ years experience with Data Warehouse methodologies.
• 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 including DBO creation, management, and indexing.
• Experience implementing high availability, high throughput, and 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 tools such as AWS, GitLab, and Visual Studio.
• Agile methodology experience (Scrum, Kanban, Lean, etc.) preferred.
• Familiarity with .NET, C#, JSON, XML, and VisualCron plus 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).
• Experience in healthcare technology, online pharmacy claims adjudication 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.
• Demonstrated ability to architect, design, develop, and implement solutions for micro-service and monolithic architectures.
• Strong written and verbal communication; ability to collaborate with a team and work independently as needed.
• Initiative and follow-through on projects with minimal supervision or guidance.
• Expertise across multiple technical areas or disciplines; interest and ability to learn additional coding languages and technologies as needed.

Required Technologies

• SQL, Microsoft SQL Server, SSIS, SSRS, SSMS, SSAS
• VisualCron
• .NET, C#, JSON, XML
• PowerShell, Python
• 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
• Paid holidays
• Medical, dental and vision coverage effective 1st of the month following date of hire

Physical/Mental Demands

• Administrative position requiring: hearing, seeing, sitting, standing, talking, and walking.
• Must be able to commute to multiple site locations within the assigned territory.
• Extended hours may be necessary.

Schedule

• Full-time; average expectation of 40 hours per week.
• Available outside normal business hours on an ad-hoc basis to meet customer expectations.
• Schedules are set to accommodate role requirements and organizational needs and may change as needed.

Location: Cleveland, OH (remote)

Experience: 10+ years

Employment Type: Full-time