Key Responsibilities:

• Become a data expert at Sonos, help to educate and evangelize data usage across Sonos.
• Work with fellow data services team members, data scientists and analysts to connect data sources, understand insights and transform data into information that drives business processes.
• Create and maintain technical documentation.
• Assist in the ongoing development of technical best practices for data movement and storage.
• Mentor junior team members and lead complex projects that require collaboration with other Data Engineers, DevOps Engineers, and Test Engineers.
• Have the ability to work closely with project managers, business analysts, data modelers and solution architects in the timely execution of project deliverables.

 
 

Qualifications

• Strong SQL skills, including data modeling and architecture of relational (3NF) and reporting optimized (Star/Snowflake Schema) data structures. 
• In depth experience with ETL development.
• Strong Snowflake SQL experience.
• DBT ETL development experience.
• Expertise in writing custom ETL tasks.
• Including custom sources and destinations.
• Strong query optimization skills.  
• Should understand indexing and partitioning of tables.
• Experience writing technical documentation for your data loads.
• Good analytical skills and ability to communicate effectively, both verbally and in writing.
• Ability to prioritize, manage and work on multiple tasks in order to meet key milestones and deadlines.
• Proven experience in working closely with both internal customers and external customers.
• 5+ years Data Engineering experience building reliable, scalable, low latency systems.

 
 

Preferred: 

• Knowledge of Agile Development methodology.
• SQL Server T-SQL experience
• Git
• Apache Airflow
• Experience with NoSQL databases, particularly Cassandra.
• Experience engineering in an AWS cloud environment
• Python data development with SQL, API, and raw file (XML, JSON, CSV) sources and destinations.