Senior Data Engineer - Data Corpus

<p>SoundCloud empowers artists and fans to connect and share through music. Founded in 2007, SoundCloud is an artist-first platform empowering artists to build and grow their careers by providing them with the most progressive tools, services, and resources. With over 375 million tracks from 40 million artists, the future of music is SoundCloud.</p> <p>We are looking for an experienced Senior Data Engineer (Level 3) to join the Data Foundations department in our Data Corpus team. You will help us continue building our unified and standardized data warehouse, Corpus, which is used across SoundCloud for reporting, data science, and analytics, building data products, or simply answering questions. You will also help us build out our business-ready data layer to be used in dashboarding and for simplified data usage. You can read more about Data Corpus in our <a href="https://developers.soundcloud.com/blog/the-journey-of-corpus">blog post</a>.</p> <p><br/><strong>About the role</strong></p> <p>The Data Corpus team is responsible for building and maintaining SoundCloud’s petabyte-scale GCP data warehouse. You will build and maintain the warehouse to abstract the complexity of SoundCloud’s vast data ecosystem to exploit and get value from data. You will work closely with business reporting, data science, and product teams. You will gather and refine requirements, design data architecture and solutions, and build ETL pipelines using Airflow to land data in BigQuery and beyond. You will model and build out the business-ready data layer, designed to feed dashboarding tools with KPIs and simplify data access for business and product stakeholders. You will have knowledge and passion for analytics engineering. You are a strong individual contributor who thrives in a dynamic environment and is motivated by solving challenging data problems.</p> <p><strong>About you</strong></p> <p>As a Senior individual contributor, you will be able to manage stakeholders, plan and lead technical projects, and identify and focus the business value of projects. </p> <p>Must have:</p> <ul> <li>Senior Level Data Professional</li> <ul> <li>+6 years experience ideal, +4 years minimum experience.</li> </ul> <li>Experience working with Cloud technologies</li> <ul> <li>GCP (required)</li> <li>AWS/Azure is also nice to have</li> </ul> <li>Experience working with BigQuery</li> <li>Advanced SQL knowledge</li> <li>Python experience</li> <li>Airflow experience</li> <li>Experience working with big data (terabyte/petabyte scale)</li> <li>Experience in Data Architecture/solution design</li> <li>Experience working in Agile methodology, ideally working with Jira.</li> <li>Experience in data warehousing and analytical data modelling.</li> <li>Experience working with CI/CD pipelines and code repositories (Git preferred)</li> <li>Experiencing in building complex and high-reliability ETL pipelines</li> <li>Experience building data for BI Tools (Looker preferred)</li> <li>Experience building datasets for product and business KPIs</li> <li>Knowledge of basic statistical concepts and methods</li> <li>Experience producing high-quality technical documentation</li> <li>Excellent English-speaking communicator and demonstrator</li> </ul> <p>Nice to have:</p> <ul> <li>Experience in basic QA engineering and testing methodologies</li> <li>Experience with experimentation (A/B testing) tools and processes</li> <li>Experience working with subscription-based businesses</li> <li>Experience integrating third-party tools and systems</li> <li>Data visualisation skills</li> <li>Experience with terraform</li> </ul> <p><strong>About us</strong></p> <ul> <li>We are a multinational company with offices in the US (New York and Los Angeles), Germany (Berlin), and the UK (London)</li> <li>We provide a flexible work culture that offers the opportunity to collaborate and connect in person at our offices as well as accommodating work from home</li> <li>We are deeply committed to ensuring diversity, equity and inclusion at all levels of our organization and fostering a community where everyone’s voice, perspective and experience is respected and heard</li> <li>We believe a strong team is made by investing in employees through mentorship, workshops and enrichment opportunities</li> </ul> <p><strong>Benefits</strong></p> <ul> <li>Not located in Berlin? No worries, we offer extensive relocation support including allowances, one way flights, temporary accommodation and, by partnering with Expath, on the ground support on arrival</li> <li>Interested in a gym membership, photography course or book? We have a Creativity and Wellness benefit!</li> <li>Employee Stock Ownership Plan</li> <li>Generous professional development allowance</li> <li>Fertility and Family Building program</li> <li>Flexible vacation and public holiday policy where you can take up to 35 days of PTO annually</li> <li>16 paid weeks for all parents (birthing and non-birthing), regardless of gender, to welcome newborns, adopted a