Snowflake Data Engineer
Job Description
Deloitte seeks a US Delivery Center Snowflake Data Engineer for an onsite role in Gilbert, AZ. In the Government & Public Services (GPS) practice, you will support federal, state, and local government clients and public higher education institutions by building and optimizing data platforms and pipelines. Within Deloitte’s AI & Data offering, this position focuses on designing, developing, and operating Snowflake-based data solutions that advance reporting, analytics, and modernization goals.
What you’ll do
- 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 package development.
- Collaborate with business and technical teams 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.
Skills and experience
- 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 skills with strong written and verbal communication for engaging both technical and business stakeholders.
- Experience working in Agile environments.
- Experience supporting enterprise-scale data and analytics platforms.
- Active public sector security clearance.
- Active working knowledge of AI Awareness & Solutions, including Analysis Data Sources, Cortex, and Python.
Team and work model
- GPS focuses on impact for federal, state, and local government clients as well as public higher education institutions.
- Deloitte’s AI & Data offering supports the design, development, and operation of Data and AI platforms, products, insights, and services.
- This role is within the Deloitte US Delivery Center model, designed to deliver impactful business services.
- The US Delivery Center has a small-business feel with big-business impact, with nominal travel requirements.
Compensation
The reasonable estimate for this role is $110,000 to $150,000 per year. You may also be eligible to participate in a discretionary annual incentive program.