Senior Data Engineer
New
P
PDMIPharmacy Data Processing
Fully remote opportunityFull-TimeSenior
Salary not disclosed
Apply NowOpens the employer's application page
Job Details
- Experience
- 7+ years
- Required Skills
- AWSSQLETLGitMicrosoft SQL ServerTableau
Requirements
- Bachelor's degree in Data Management, Information Systems, Computer Science, Analytics, or a related field, or equivalent combination of education and experience.
- 7+ years of experience in ETL development, data engineering, business intelligence, data warehousing, or a related discipline.
- Hands-on experience designing, developing, optimizing, and supporting enterprise data warehouse and ETL solutions, including Amazon Redshift.
- Advanced SQL development expertise, including complex query development, data transformation, and performance optimization.
- Strong knowledge of data warehousing concepts, dimensional modeling, enterprise reporting architectures, and large-scale data processing.
- Experience gathering business requirements and translating them into scalable data integration, reporting, and analytics solutions.
- Experience with Microsoft SQL Server, including legacy data extraction and migration support.
- Experience with SSRS reporting solutions and migrating legacy SQL Server/SSRS environments to modern cloud-based data platforms.
- Experience developing cloud-native data pipelines using AWS services such as Glue, S3, Lambda, Athena, or ECS/EKS.
- Experience developing Tableau dashboards, semantic data models, and governed data products.
- Experience implementing data governance, role-based security, Git, and CI/CD pipelines.
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 and analytics capabilities to AWS-based architectures.
- Design and maintain cloud-based data warehouse solutions using Amazon Redshift and related AWS services.
- Develop governed data models, datasets, and data products that enable Tableau reporting and enterprise self-service analytics.
- Partner with business and technical stakeholders to translate business requirements into scalable technical solutions.
- Implement and maintain appropriate data security, role-based access controls, and governance standards.
- Apply modern software development practices, including source control, code review, testing, CI/CD, and documentation.
View Full Description & ApplyYou'll be redirected to the employer's site
