Senior Data Engineer

Job not on LinkedIn

🔥 0 minutes ago

🏈 Ohio – Remote

🏈 Ohio – Remote

⏰ Full Time

🟠 Senior

🚰 Data Engineer

Apply Now

Find Similar Remote Jobs

Set Up Email Alert For New Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

Pharmacy Data Management, Inc. (PDMI)

WebsiteLinkedInAll Job Openings

51 - 200 employees

Founded 1988

🏥 Healthcare

💼 Consulting

📦 Logistics

Healthcare • Consulting • Logistics

Pharmacy Data Management, Inc. (PDMI) is a company specializing in pharmacy data processing and administration services. Founded in 1984, PDMI offers a range of services tailored to private label Pharmacy Benefit Managers (PBMs), vertically integrated health plans, and hospital systems. The company emphasizes transparency and provides clients with full access to their data 24/7. PDMI offers Pharmacy Benefit Administrative Services, 340B Administration, as well as Hospice and Long-Term Care Services, ensuring efficient and effective solutions for their clients. The company prides itself on its independence from wholesalers and specialty pharmacies, allowing for unbiased service without hidden agendas or fees.

📋 Description

• Design, develop, optimize, and support scalable ETL pipelines and data integration solutions for 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 • Modernize legacy SQL Server and SSRS reporting solutions by migrating pipelines, reporting processes, and analytics capabilities to AWS architectures • Design and maintain cloud-based data warehouses using Amazon Redshift and AWS services • Develop governed data models, datasets, and data products for Tableau reporting, enterprise analytics, and self-service access • Build scalable data extract, file delivery, and reporting solutions to reduce manual processes and improve data delivery reliability • Analyze and optimize ETL workflows, SQL queries, data models, and warehouse performance • Gather requirements from business and technical stakeholders and translate them into scalable technical solutions • Implement data security, role-based access controls, and governance standards • Monitor, troubleshoot, and resolve data pipeline, data quality, performance, and reporting issues • Apply source control, code review, testing, CI/CD, documentation, and automation practices • Evaluate cloud-native services, automation, and AI-assisted development tools • Collaborate with Data, Engineering, Product, and business teams to establish sustainable data solutions and evolve the enterprise data platform

🎯 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 and migrating legacy SQL Server/SSRS environments to modern cloud-based data platforms preferred • Experience developing cloud-native data pipelines using AWS 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 in 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 • Candidates must be able to clearly and confidently speak to all experience listed • Work samples, portfolio links, or other validation may be requested • Successful completion of a pre-employment background check, including employment and education verification, and a 4-panel drug screen required for offers

🏖️ Benefits

• Voted Best Employer in Ohio for the 5th consecutive year in 2025 • Meaningful work contributing to improving healthcare quality and efficiency • Collaborative environment • Fully remote opportunity • Pre-employment background check and 4-panel drug screen as offer contingencies