Senior Data Engineer

🕒 August 14

🏈 Ohio – Remote

🏈 Ohio – Remote

⏰ Full Time

🟠 Senior

🚰 Data Engineer

👻 Ghost score 23%

What it means: how likely this posting is sitting open without active hiring.How to read it: 60% or higher means we think this is a ghost. Lower scores are less of a worry.How we score it: age, reposts, open roles vs team size, how fast jobs close, and whether pay is listed.Fine print: an estimate from public data, not a judgment of the company. Real jobs can score high, so treat it as a hint, not a fact.

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 warehouse solutions using Amazon Redshift and related AWS services • Develop governed data models, datasets, and data products for Tableau reporting, enterprise analytics, and self-service access • Build and enhance scalable data extract, file delivery, and reporting solutions • Analyze and optimize ETL workflows, SQL queries, data models, and warehouse performance • Gather requirements and translate business needs 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 cloud-based data platforms preferred • Experience with AWS services such as Glue, S3, Lambda, Athena, ECS/EKS, or similar preferred • Experience developing Tableau dashboards, semantic data models, governed data products, and 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 solutions preferred • Successful pre-employment background check, including employment and education verification, and 4-panel drug screen • Candidates must be able to speak clearly and confidently to all claimed experience; work samples or validation may be requested • AI tools during interviews or assessments are prohibited unless explicitly permitted

🏖️ Benefits

• Voted Best Employer in Ohio for the 5th consecutive year in 2025 • Meaningful work contributing to improving healthcare quality and efficiency • Collaborative environment • Exciting challenges and opportunities to excel • Fully remote opportunity