Senior Data Engineer
Employment Information
Report this job
Job expired or something wrong with this job?
Job Description
Senior Data Engineer modernizing PDMI’s pharmacy data platforms with AWS, Redshift, ETL, and Tableau. Building governed pipelines, warehouses, and analytics solutions for healthcare reporting.
Responsibilities:
- 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
Similar Jobs
AWS Data Engineer
AWS Data Engineer joining Devoteam, a European digital strategy and technology consultancy. Building AWS data solutions with Spark, Python, SQL, Airflow, Docker, and ECS from Spain.
Lead Data Engineer
Lead data architecture and transformation for Fortune 500 insurance clients. Owning enterprise data platforms, delivery teams, stakeholder alignment, and governance through go-live.
SAP BODS, Data Migration Manager
SAP data migration manager leading SAP S/4HANA transformation programs for enterprise clients. Managing BODS-driven migrations, governance, data quality, and cross-functional delivery teams.
Data Engineer
Data Engineer designing SQL Server data models and ETL systems for Analytica’s U.S. government technology programs. Deploying analytics applications and models through CI/CD in agile client teams.
Data Engineer II
Data Engineer II building scalable data pipelines and self-serve platforms for Slate’s affordable electric vehicles. Supporting analytics, machine learning, and critical business decisions.
Senior Data Engineer
Engenheiro de Dados Sr desenvolvendo IA, pipelines e infraestrutura para projetos tecnológicos da Spassu. Otimizando dados, bancos e integrações em larga escala.
Senior Data Engineer
Engenheiro de Dados SR projetando arquiteturas modernas e pipelines escaláveis para a Triggo.ai, empresa brasileira de Analytics, IA e transformação digital.
Senior Data Engineer
Senior Data Engineer building automated payments reporting and analytics for SPD Technology’s client. Designing cloud data pipelines, financial data models, and KPI dashboards for trusted variance analysis.
Senior Data Engineer
Senior Data Engineer building AWS ETL/ELT pipelines and dbt models for Tango’s cloud real-estate and facilities SaaS. Managing databases, data quality, warehousing, and observability.
Senior Data Engineer
Senior Data Engineer building AWS and dbt data pipelines for Tango’s cloud real-estate and facilities SaaS platform. Managing databases, warehouses, data quality, and analytics-ready datasets.
Senior Azure Data Architect
Senior Azure Data Architect developing predictive HR solutions for the U.S. Marine Corps. Leading data strategy, machine learning models, Azure deployment, and data science teams.
Azure Data Architect
Azure Data Architect developing predictive models and Azure data solutions for Sparibis's HR and defense projects. Leading data science strategy, governance, visualization, and team mentorship.
Senior Data Engineer
Senior Data Engineer productionizing cyber-risk data products for Asian-market insurance brokers. Building Python/Airflow pipelines, PostgreSQL systems, and GraphQL data services in a remote LATAM team.
Staff Engineer – Data Modeler
Staff Data Modeler designing secure unstructured-knowledge data products for Nagarro, a digital product engineering company. Governing metadata, domains, and Unity Catalog registration for KM platforms.
Senior Data Engineer, Finance
Senior Data Engineer owning finance data pipelines and models for Instacart, a grocery delivery platform. Supporting accounting, billing, revenue, and financial reporting at scale.
Ingeniero de Datos
Ingeniero de datos en TP, líder mundial en gestión omnicanal de experiencia del cliente. Garantizando calidad de datos, optimizando SQL y apoyando reportes y nómina.
Senior Architect, Licensed Building Architect, Data Centers
Licensed architect leading hyperscale cloud and colocation data center design for AECOM, a global infrastructure consulting firm. Guiding projects from concept through construction closeout.
Senior Architect, Licensed Building Architect, Data Centers
Licensed architect leading hyperscale and colocation data center projects for AECOM, a global infrastructure consulting firm. Developing secure, scalable facilities from concept through construction closeout while coordinating multidisciplinary teams and clients.
Senior Architect, Licensed Building Architect, Data Centers
Lead architect designing hyperscale cloud and colocation data centers for AECOM, a global infrastructure consulting firm. Guiding integrated design, construction administration, compliance, and client delivery across complex mission-critical projects.
Senior Architect, Licensed Building Architect, Data Centers
Licensed architect leading hyperscale and colocation data center design for AECOM, a global infrastructure consultancy. Coordinating multidisciplinary delivery from concept through construction closeout for U.S.-based clients.