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 its US Delivery Center to design, build, and optimize Snowflake-based data pipelines and ETL/ELT processes. The onsite role in Mechanicsburg, PA includes migration support, integration with analytics and BI tools, and ownership of engineering practices such as CI/CD, data quality, and performance.
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 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, 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, Analysis Data Sources, Cortex, and Python.
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
Compensation
Estimated wage range: $110,000 to $150,000 per year.
Similar Jobs
