- Company Name
- SoundCloud
- Job Title
- Senior Data Analyst - Platform Enablement
- Job Description
-
**Job Title:** Senior Data Analyst – Platform Enablement
**Role Summary:**
Senior data analyst responsible for designing, building, and maintaining scalable data models, ETL/ELT pipelines, and reporting layers that support platform‑wide initiatives such as marketing technology, privacy & consent, and observability. Acts as a technical liaison between analytics, engineering, and business stakeholders while driving data quality, performance, and architectural best practices.
**Expectations:**
- 7+ years in data engineering, analytics engineering, or related roles.
- Expert‑level SQL proficiency with performance tuning.
- Proven experience designing and operating Apache Airflow workflows.
- Hands‑on experience deploying services in cloud environments (GCP or AWS).
- Strong communication and collaboration skills; ability to mentor junior team members.
**Key Responsibilities:**
- Develop and optimize SQL data models and queries for analytics, reporting, and operational use cases.
- Design, implement, and maintain reliable ETL/ELT pipelines using Apache Airflow.
- Translate business requirements into automated data pipelines and curated datasets.
- Own data‑quality frameworks; create validation checks and monitor metric integrity.
- Build and sustain reporting layers for dashboards and BI tools (e.g., Looker).
- Diagnose and tune SQL performance; optimize schema, indexing, and partitioning.
- Contribute to data architecture decisions, including schema design and workflow scheduling.
- Mentor junior engineers and champion best‑practice standards.
**Required Skills:**
- Advanced SQL (CTEs, window functions, analytical query design, performance tuning)
- Apache Airflow (DAG design, scheduling, monitoring) – Python scripting preferred
- Cloud platforms: GCP or AWS (service deployment, security, scaling)
- Data modeling, schema design, partitioning, and data warehousing concepts
- ETL/ELT workflow orchestration and data integrity testing
- BI/reporting tools experience (Looker or comparable)
- Strong written and verbal communication; collaborative mindset
- Ability to mentor and lead technical discussions
**Required Education & Certifications:**
- Bachelor’s degree in Computer Science, Information Systems, Data Science, Statistics, or related quantitative field (master’s preferred).
- Relevant certifications desirable (e.g., Google Cloud Professional Data Engineer, AWS Certified Data Analytics, Snowflake, or similar).