DataJobs.io
← Back to all jobs

Job Description

Deloitte is hiring a Snowflake Data Engineer for its US Delivery Center. In this onsite role in Mechanicsburg, PA, you will design, build, and optimize Snowflake-based data pipelines and ETL/ELT workflows that connect upstream systems to analytics and BI tooling.

The position focuses on delivering reliable data solutions, including migrations from legacy platforms to cloud environments, maintaining data performance and quality, and supporting secure, well-documented deployments through CI/CD practices. Collaboration with both business and technical stakeholders is central to understanding requirements and translating them into data products.

Responsibilities

  • Design, develop, and optimize data pipelines using Snowflake capabilities.
  • Build and maintain ETL/ELT processes for data ingestion, transformation, and integration.
  • Support migrations from legacy systems to cloud-based platforms.
  • Develop and maintain database solutions using Microsoft SQL Server and SSIS.
  • Collaborate with business and technical teams to understand requirements and deliver data solutions.
  • Integrate data with business intelligence tools to enable reporting and analytics.
  • Implement and maintain CI/CD processes for code deployment and release management.
  • Promote data quality, performance, security, and clear documentation.

Requirements

  • Hands-on experience with Snowflake, including data engineering, data modeling, data analysis, and pipeline development.
  • Strong understanding of data warehousing, ETL/ELT frameworks, and data integration practices.
  • Extensive experience with Microsoft SQL Server and SSIS package development.
  • Experience with data migration projects and modernization initiatives.
  • Experience with Tableau, Power BI, and Alteryx.
  • Strong AWS experience, including S3, AWS Glue, AWS Database Migration Service (DMS), and AWS Lambda.
  • Experience with CI/CD pipelines and DevOps deployment practices.
  • Strong SQL development, troubleshooting, and performance-tuning skills.
  • Analytical and problem-solving capabilities, with strong written and verbal communication skills for engaging technical and business stakeholders.
  • Experience working in Agile environments.
  • Experience supporting enterprise-scale data and analytics platforms.
  • Active public sector security clearance.
  • Advanced Communication.
  • Intermediate experience with AI Awareness & Solutions, including Analysis Data Sources, Cortex, and Python.
  • Experience with: Snowflake, Snowflake data analysis, SQL Server, SSIS, AWS S3, Glue, DMS, Lambda, Tableau, Power BI, Alteryx, ETL/ELT, data migration, data warehousing, CI/CD, and cloud data engineering.

Technologies

  • Snowflake
  • Microsoft SQL Server, SSIS
  • ETL, ELT
  • Tableau, Power BI, Alteryx
  • AWS (S3, AWS Glue, AWS Database Migration Service (DMS), AWS Lambda)
  • CI/CD, DevOps
  • SQL, Cortex, Python

Estimated Pay Range

$110,000 - $150,000 per year (reasonable estimate).

Similar Jobs