Remote Senior Data Engineer: Cloud Data Warehouse & Analytics

Pharmacy Data Management, Inc.; Poland Township (OH); A distancia; USD 120.000 - 180.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Best Employer in Ohio

Meaningful work

Collaborative environment

Fully remote

Descripción de la vacante

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.

Formación

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

Responsabilidades

• 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.

Conocimientos

ETL development

Data engineering

SQL development

Data warehousing

BI/analytics

Data governance

Educación

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

Herramientas

Amazon Redshift

Microsoft SQL Server

SSRS

AWS data services

Tableau

Git

CI/CD

Descripción del empleo

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.