Data Engineer III

    • SiriusXM
  • Irving, TX
  • Posted 25 days ago | Updated 6 hours ago

Overview

On Site
Full Time

Skills

Google Cloud
Data warehouse architecture
Attention to detail
A/B testing
Marketing analytics
Operational efficiency
Data engineering
Extract
transform
load
Use cases
Statistical models
Data modeling
Time management
Apache Spark
Audio
Music
Software development
Leadership
Podcast
Streaming
IMPACT
Data
Transformation
Collaboration
Analytics
Marketing
Research and development
Analytical skill
Python
SQL
Dashboard
Apache Hive
Communication
Tableau
Linux
cron
Scripting
R
Amazon Web Services
Cloud computing
Regression analysis
Legal
SAP BASIS

Job Details

Who We Are:

SiriusXM and its brands (Pandora, SiriusXM Media, AdsWizz, Simplecast, and SiriusXM Connected Vehicle Services) are leading a new era of audio entertainment and services by delivering the most compelling subscription and ad-supported audio entertainment experience for listeners -- in the car, at home, and anywhere on the go with connected devices. Our vision is to shape the future of audio, where everyone can be effortlessly connected to the voices, stories and music they love wherever they are.

This is the place where a diverse group of emerging talent and legends alike come to share authentic and purposeful songs, stories, sounds and insights through some of the best programming and technology in the world. Our critically-acclaimed, industry-leading audio entertainment encompasses music, sports, comedy, news, talk, live events, and podcasting. No matter their individual role, each of our employees plays a vital part in bringing SiriusXM's vision to life every day.

Pandora , a subsidiary of SiriusXM, is the largest ad-supported audio entertainment streaming service in the U.S. Pandora provides consumers with a uniquely-personalized music and podcast listening experience with its proprietary Music Genome Project and Podcast Genome Project technology. Pandora is available through its mobile app, the web, and integrations with more than 2,000 connected products.

How you'll make an impact:

SiriusXM is looking for a Data Engineer to join the Marketing Analytics & Technology team. The ideal candidate will develop and automate data transformation pipelines integrating data sources from various parts of the business to drive listener understanding and operational efficiency. As a Data Engineer, you will collaborate with departments across the organization to build data transformation pipelines, your responsibilities will include supporting the development, maintenance, and operational stability of data engineering and analytics infrastructure.

What you'll do:
  • Architect, build and launch scalable data pipelines that support marketing growth efforts
  • Build integrations and ETL processes with 3rd party data to automatically pull data from external sources into operational and analytical data pipelines using a combination of Python and SQL
  • Use SQL and Python to write production-quality code to meet the data transformation needs of analysts, data scientists, and other business partners
  • Streamline and automate tasks as well as innovate by building reusable components that can be used across multiple use cases and by the marketing analytics team in Google Cloud Platform
  • Visualize, communicate and present statistical model outputs and analysis to various technical and non-technical stakeholders across the company
  • Develop automated and ad hoc reports, dashboards, and models to help guide business decision

What you'll need:
  • 3-5 years of Data Engineer experience.
  • Proficient in SQL, ideally with Hive, Presto and or BigQuery syntaxes
  • Proficient in Python
  • Knowledge of data warehouse architecture and data modeling
  • Experience developing scalable ETL processes using SQL and Python
  • Knowledge of statistical modeling concepts and techniques
  • Excellent time management and attention to detail
  • Excellent written and oral communication skills
  • Experience with creating and maintaining production dashboards in Tableau or Zeppelin
  • Experience working with cross-functional teams in a fast-paced environment
  • Quantitative marketing analytics experience
  • Understanding of basic A/B testing concepts
  • Experience with Airflow
  • Experience with Linux concepts (e.g. Cron, scripting)
  • Experience with Python
  • Experience with R
  • Experience with Google Cloud Platform,AWS or any other cloud-based platform
  • Experience with Apache Spark
  • Familiarity with statistical regression techniques and applications
  • Must have legal right to work in the U.S.

Our goal at SiriusXM is to provide and maintain a work environment that fosters mutual respect, professionalism and cooperation. SiriusXM is an equal opportunity employer that does not discriminate on the basis of actual or perceived race, creed, color, religion, national origin, ancestry, alienage or citizenship status, age, disability or handicap, sex, gender identity, marital status, familial status, veteran status, sexual orientation or any other characteristic protected by applicable federal, state or local laws.

The requirements and duties described above may be modified or waived by the Company in its sole discretion without notice.
R-2024-03-76