Data Engineer III

Job Description

SurveyMonkey is seeking a Data Engineer III to join their central data organization. The successful candidate will be responsible for building and managing end-to-end data pipelines using modern cloud technologies. This role involves providing actionable insights into key business functions.

The Data Engineer III will report to the Senior Manager, Data Engineering, and will lead data engineering initiatives to build analytical solutions that are highly available, scalable, stable, secure, and cost-effective.

What this role involves:

• Designing, architecting, and building data pipelines to support existing data models
• Ensuring data quality by building quality checks into data pipelines
• Building new data models (Fact vs Dimension)
• Writing performant/idempotent transformations in Snowflake
• Building data pipelines using Python scripting
• Writing well-tested, production-ready code in Python and Snowflake SQL
• Implementing ETL (or ELT) best practices
• Translating business requirements into technical specifications
• Writing complex data engineering Snowflake - SQL jobs
• Documenting systems for internal and external stakeholders
• Monitoring and debugging data pipelines running on Airflow
• Participating in code reviews
• Mentoring data engineers on best practices and coding standards

Requirements:

• 5+ years of experience in data engineering and Data warehousing technologies
• 3+ years of experience in Snowflake/ETL or similar technologies like Redshift
• Experience with AWS cloud services: S3, EC2, RDS, Spark, EMR etc
• Experience with object-oriented/object function scripting languages: Python (preferred), Java, Scala, etc.
• Experience in orchestrating, automating and deploying production data pipelines using Airflow/Luigi, etc
• Experience with DevOPS: Git, Github actions, CI/CD pipelines, Terraform etc
• Experience with tools such as DBT or other similar technologies
• Experience with transforming, developing data structures, metadata, dependency and data workflows to support an Analytics function
• In-depth knowledge of Data lakes, EDW concepts, data modeling (Star, Snowflake and Galaxy schemas)

What SurveyMonkey offers:

• In-person collaboration opportunities
• Inclusive workplace
• Forward-looking benefits policies
• Employee programs
• Award-winning culture
• Annual holiday refresh
• Annual week of service
• Learning and development opportunities