Data Engineer - Source AI
mckinsey
Job Description
YOUR QUALIFICATIONS AND SKILLS
- SnowPro Core and/or SnowPro Advanced: Data Engineer certification preferred
- 3+ years of experience in data engineering, with strong Snowflake expertise and a builder mindset
- Hands-on experience with AI-assisted development tools (e.g., Cursor, Claude Code, GitHub Copilot) to build MVPs, prototype data pipelines, and accelerate analysis
- Comfort using LLMs and AI agents in day-to-day engineering for code generation, debugging, documentation, and data exploration
- Strong proficiency in SQL (including Snowflake SQL) and Python for transformations, scripting, and automation
- Expertise in building and managing end-to-end Snowflake pipelines using features such as Warehouses, Snowpipe, Streams, Tasks, and Secure Views, with Amazon S3 integration
- Skilled in Snowflake performance optimization, including clustering, materialized views, and query profiling
- Experience with CI/CD for Snowflake using tools such as GitHub Actions
- Knowledge of data governance, secure data integration, and compliance requirements such as PII handling, GDPR, and HIPAA
- Proficiency in working with semi-structured data formats such as JSON, Avro, and Parquet in Snowflake
- Demonstrated success migrating data from legacy systems to Snowflake
- Strong understanding of data quality frameworks, including validation, monitoring, and anomaly detection