Information Technology New York, New York


Description

SiriusXM and Pandora have joined together to create the leading audio entertainment company in the U.S. Together, we are uniquely positioned to lead a new era of audio entertainment by delivering the most compelling subscription and ad-supported audio experiences to millions of listeners -- in the car, at home and on the go. Our talent, content, technology and innovation continue to be at the forefront, and we want you to be a part of it! Check out our current openings below and at www.siriusxm.com/careers.

 

Position Summary:

The Lead Developer is responsible for leading the design, data analysis, development, and data integration aspects of data delivery for the Enterprise Data Office supporting the enterprise community across all brands. The Lead Developer will be expected to work closely with other development teams, business analysts, product managers and delivery managers across IT to deliver data products that meet or exceed EDO/Enterprise expectations.

Duties and Responsibilities:

  • Work with various business stakeholders to identify their information needs
  • Work with Data Architecture team to understand the source and target data models
  • Work closely with cross-functional business and business intelligence teams to document ETL requirements and turn them into ETL jobs
  • Developing, adhering to, and being a proponent for Data Warehouse development standards, including ETL standards and best practices
  • Providing documentation for all developed ETL processes, including process flow and source and target mapping
  • Conduct ETL performance tuning and troubleshooting
  • Work with Business Intelligence Operations team to ensure control objectives are implemented for all data movement processes, implement change control for production data, establish and follow proper incident management procedures
  • Ensure compliance with all applicable data privacy regulations and policies as they relate to both firm and client/contact data

Supervisory Responsibilities:

  • There is no supervisory responsibilities associated with this job

Minimum Qualifications:

  • Bachelor’s Degree or higher
  • Minimum of 7 years of experience in ETL/ELT development in Business Intelligence/Data Integration projects
  • Minimum of 7 years of data analysis and data quality
  • 7+ years of experience working with Talend, Informatica, GoldenGate, etc.,
  • 7+ years of experience working with Relational Databases like Redshift, Aurora, Teradata, Vertica, Oracle, SQL Server, etc.,
  • 5+ years of experience working with Unix Shell Scripts
  • Knowledge of MS-Office Suite (Word, Excel, Powerpoint)

Requirements and General Skills:

  • Experience in writing complex SQLs to analyze and troubleshoot the issues/problems
  • Strong data analysis and troubleshooting skills
  • Experience in integrating technologies with internal and external data sources
  • Goal oriented and creative personality with good interpersonal skills
  • Ability to manage multiple assignments simultaneously and follow up on unfinished business
  • Ability to work independently and in a team environment
  • Ability to pay attention to the details and be organized
  • Commitment to internal client and customer service principles
  • Ability to project professionalism over the phone and in person.
  • Willingness to take initiative and to follow through on projects
  • Excellent time management skills, with the ability to prioritize and multi-task in a fast paced environment
  • Excellent communication and motivation skills, and ability to interact appropriately with senior level colleagues and business users                                         

Technical Skills:

  • Experience with data analysis, data architecture, data cleansing and data quality
  • Experience with data integration tools like Informatica, Data Stage, Talend
  • Experience working with big-data solutions using technologies like EMR, S3, Spark and an in-depth understanding of data partitioning and sharding techniques.
  • Experience loading and querying both on premise and cloud-hosted databases such as Teradata, Redshift, Aurora, Big Query, DocumentDB, and Graph DB (Preferably Neo4j)
  • Familiarity with binary data serialization formats such as Parquet, Avro, and Thrift.
  • Expertise with high volume heterogeneous data, preferably with distributed systems.
  • Knowledge of data modeling, data access, and data storage techniques.
  • Appreciation of agile software processes, data-driven development, reliability, and responsible experimentation.
  • Familiar with metadata management, data lineage, and principles of data governance.
  • Must have legal right to work in the U.S. 

 

More details about our company benefits can be found here!

 

 

Our goal at SiriusXM+Pandora is to provide and maintain a work environment that fosters mutual respect, professionalism and cooperation. SiriusXM+Pandora 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.