Senior Data Engineer

Pharmacy Data Management, Inc.; Poland Township (OH); Remote; USD 120,000 - 180,000; Full time

Benefits offered by this job

Best Employer in Ohio

Meaningful work

Collaborative environment

Fully remote

Job summary

PDMI is seeking a Senior Data Engineer to design, build, and optimize enterprise data integration, reporting, and analytics solutions. The role focuses on modernizing legacy SQL Server/SSRS to a scalable cloud architecture using Amazon Redshift, S3, Lambda, and Tableau.

You will develop scalable ETL pipelines, governed data products, and secure data delivery while enabling self-service access to trusted business information for enterprise reporting and analytics.

Qualifications

• Bachelor's degree in a related field or equivalent experience.

Responsibilities

• Design, develop, optimize, and support scalable ETL pipelines and data integration solutions for reporting and analytics.
• Develop and optimize complex SQL queries, stored procedures, data transformations, and data models across Amazon Redshift and SQL Server.
• Migrate legacy SQL Server/SSRS to AWS-based architectures and cloud-based data warehouses.
• Develop governed data models, datasets, and data products for Tableau reporting and self-service analytics.
• Build scalable data extract, file delivery, and reporting solutions to reduce manual processes and improve reliability.
• Analyze and optimize ETL workflows, queries, and warehouse performance for large datasets and complex workloads.
• Collaborate with stakeholders to translate business needs into scalable technical solutions.
• Implement data security, RBAC, and governance standards across data platforms.
• Monitor and troubleshoot data pipelines and reporting issues during modernization.
• Apply CI/CD, version control, testing, and automation to data engineering work.
• Leverage cloud-native services and AI-assisted tools to improve development and operations.

Skills

ETL development

Data engineering

SQL development

Data warehousing

BI/analytics

Data governance

Education

Bachelor's degree in Data Management, Information Systems, Computer Science, Analytics

Tools

Amazon Redshift

Microsoft SQL Server

SSRS

AWS data services

Tableau

Git

CI/CD

Job description

PDMI is looking to add a Senior Data Engineer to our team! This position is responsible for designing, developing, optimizing, and supporting enterprise data integration, reporting, and analytics solutions. The Senior Data Engineer plays a key role in modernizing the organization’s data ecosystem by transitioning legacy SQL Server and SSRS solutions to a scalable, cloud-based architecture centered on Amazon Redshift, AWS data services, and Tableau. This position develops scalable ETL pipelines, data warehouse solutions, governed data products, and secure data delivery capabilities that enable reliable enterprise reporting, analytics, and self-service access to trusted business information.

Since 1984, PDMI has provided pharmacy data processing and otherflexible, scalable solutions to help our clients meet their businessobjectives. We offer transparent, pass-through pharmacy processing and other services for private label Pharmacy Benefit Managers (PBMs), vertically integrated healthplansand hospital systems. In addition to Pharmacy Benefit Administrative Services, we offer 340B Administration, Hospice and Long-Term Care Services.

Why Join Us:

• Best Employer:PDMI was votedBestEmployer in Ohio for the 5th consecutive year in 2025!
• Meaningful Work:Contribute to improving healthcare quality and efficiency.
• Collaborative Environment:Work with passionate professionals who share your drive.
• Exciting Challenges:Every day brings new opportunities to excel.
• Flexible Work:Fully remote opportunity with a company thatcares.

Key Responsibilities:

• Design, develop, optimize, and support scalable ETL pipelines and data integration solutions that enable enterprise reporting, analytics, and data delivery.
• Develop and optimize complex SQL queries, stored procedures, data transformations, and data models across Amazon Redshift and Microsoft SQL Server environments.
• Support the modernization of legacy SQL Server and SSRS reporting solutions by migrating data pipelines, reporting processes, and analytics capabilities to AWS-based architectures.
• Design and maintain cloud-based data warehouse solutions using Amazon Redshift and related AWS services to support scalable, reliable, and high-performing data processing.
• Develop governed data models, datasets, and data products that enable Tableau reporting, enterprise analytics, and self-service access to trusted business information.
• Build and enhance scalable data extract, file delivery, and reporting solutions that reduce manual processes and improve the reliability and efficiency of enterprise data delivery.
• Analyze and optimize ETL workflows, SQL queries, data models, and warehouse performance for large-scale datasets and complex reporting workloads.
• Partner with business and technical stakeholders to gather requirements, understand reporting and data needs, and translate business requirements into scalable technical solutions.
• Implement and maintain appropriate data security, role-based access controls, and governance standards across enterprise data and analytics solutions.
• Monitor, troubleshoot, and resolve data pipeline, data quality, performance, and reporting issues while supporting critical legacy systems throughout modernization efforts.
• Apply modern software development practices, including source control, code review, testing, CI/CD, documentation, and automation, to data engineering and analytics development.
• Evaluate and leverage cloud-native services, automation, and AI-assisted development tools to improve development efficiency, monitoring, data operations, and analytics capabilities.
• Collaborate with Data, Engineering, Product, and business teams to establish sustainable data solutions, reduce reliance on manual reporting and external development resources, and support the continued evolution of the enterprise data platform.

Work & Education Experience Requirements:

• Bachelor's degree in Data Management, Information Systems, Computer Science, Analytics, or a related field required, or equivalent combination of education and experience.
• 7+ years of experience in ETL development, data engineering, business intelligence, data warehousing, or a related discipline required.
• Hands-on experience designing, developing, optimizing, and supporting enterprise data warehouse and ETL solutions, including Amazon Redshift, required.
• Advanced SQL development expertise, including complex query development, data transformation, and performance optimization required.
• Strong knowledge of data warehousing concepts, dimensional modeling, enterprise reporting architectures, and large-scale data processing required.
• Experience gathering business requirements and translating them into scalable data integration, reporting, and analytics solutions required.
• Experience with Microsoft SQL Server, including legacy data extraction and migration support, required.
• Experience with SSRS reporting solutions and migrating legacy SQL Server/SSRS environments to modern cloud-based data platforms preferred.
• Experience developing cloud-native data pipelines using AWS services such as Glue, S3, Lambda, Athena, ECS/EKS, or similar technologies preferred.
• Experience developing Tableau dashboards, semantic data models, governed data products, and enterprise self-service analytics solutions preferred.
• Experience implementing data governance, role-based security, Git, CI/CD pipelines, and modern software development practices preferred.
• Experience within PBM, healthcare, pharmacy claims, 340B, rebate, or claims adjudication environments preferred.
• Experience using AI-assisted development tools or developing AI-enabled automation, analytics, monitoring, or reporting solutions preferred.

AI Usage & Candidate Authenticity:

AI tools may be used forresumeformatting or drafting application materials; however,submittingcontent that misrepresents your experience, including copied job descriptions or unverifiable work history, is not acceptable. Candidates must be prepared to clearly and confidently speak to allexperiencelisted. PDMI may request work samples, portfolio links, or other forms of validation during the process. Use of AI tools during interviews or assessments, unless explicitlypermitted, will result in disqualification.

All offers are contingent upon successful completion of a pre-employment background check, including employment and education verification, as well as a 4-panel drug screen.