Snowflake Data Engineer
Job Description
Deloitte is hiring a US Delivery Center Snowflake Data Engineer to design and optimize Snowflake-based data pipelines and data platform solutions onsite in Gilbert, AZ.
Responsibilities
- Design, develop, and optimize data pipelines using Snowflake capabilities
- Build and maintain ETL/ELT workflows for ingestion, transformation, and data 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 gather requirements and deliver data solutions
- Integrate data with BI tools to enable reporting and analytics
- Implement and maintain CI/CD processes for code deployment and release management
- Promote data quality, performance, security, and maintain clear documentation
Requirements
- Hands-on experience with Snowflake across 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 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
- ETL/ELT
- Microsoft SQL Server
- SSIS
- Tableau
- Power BI
- Alteryx
- AWS (Amazon S3, AWS Glue, AWS Database Migration Service (DMS), AWS Lambda)
- CI/CD
- DevOps
- SQL
- Agile
- Cortex
- Python
Team / Opportunity Context
- Deloitte’s Government & Public Services (GPS) practice supports federal, state, and local government clients and public higher education institutions
- Deloitte’s AI & Data offering delivers solutions for designing, developing, and operating data and AI platforms, products, insights, and services
- This role is within the Deloitte US Delivery Center model focused on impactful business services
- The US Delivery Center offers a small-business feel with big-business impact
- Nominal travel requirements
Wage Range
- Estimated range: $110,000 - $150,000 per year
- May be eligible for a discretionary annual incentive program