Snowflake Data Engineer
Analytics
Business Intelligence
Cloud
Cloud Data Engineering
Cloud Data Warehouse
Cloud Data Warehouse
Cloud Operations
Cloud Platform
Cloud Platforms
Data
Data Analysis
Data Analytics
Data Engineer
Data Engineering
Data Integration
Data Integration Tools
Data Pipeline
Data Platform
Data Processing
Data Visualization
Data Warehouse
Data Warehousing
Database
Databases
Design
Digital Marketing
ETL
Informatica
Information Technology (IT)
Reporting and Analytics
Snowflake
Software Development
SQL
Visual Design
Job Description
Deloitte is hiring a Snowflake Data Engineer for the US Delivery Center in Mechanicsburg, PA (onsite). In this role, you will design and improve Snowflake-based data pipelines and ETL/ELT workflows that power analytics and business intelligence. You will also help modernize data platforms, integrate with reporting tools, and strengthen reliability through CI/CD, data quality, performance, and security practices.
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 packages.
- Collaborate with business and technical stakeholders to understand requirements and deliver data solutions.
- Integrate data with BI tools to support 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 supporting 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, plus strong written and verbal communication 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, cloud data engineering.
Compensation
The wage range for this role is estimated at $110,000 to $150,000 per year.