Interests
Experience
Company Type
Skills
Workhours

Job Title

Lead Developer, ETL

Location

District Of Columbia

Schedule

Full-time

Type of Position

Regular

Job Description

Position Summary:

The Lead Developer, ETL is responsible for the data integration to support the end to end process for Internal Music Royalties program at SiriusXM. The Music Royalty integration includes but not limited to, Metadata, Playlist data, OnDemand, Direct Licensor metadata, MDM integration, Consumption, Listen Crunch and Partner Payment data. This position works closely with ETL Manager/BI Director, ETL and BI Developers, various business stakeholders to support and provide quality of delivery for SiriusXM's data extraction, transformation and load needs through the development of new and/or enhancement of existing routines.

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.
  • Develop, adhere to, and be a proponent for Data Warehouse development standards, including ETL standards and best practices.
  • Provide 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 are no supervisory responsibilities associated with this job.

Minimum Qualifications:

  • Bachelor's Degree or higher and/or equivalent combination of education and experience preferred.
  • 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 Informatica, GoldenGate, etc.
  • 7+ years of experience working with Relational Databases like Teradata, Vertica, Oracle, SQL Server, etc.
  • 5+ years of experience working with Unix Shell Scripts.
  • Experience in writing complex SQLs to analyze and troubleshoot the issues/problems.
  • Knowledge of MS-Office Suite (Word, Excel, Powerpoint).
  • Must have legal right to work in the U.S.

Requirements and General Skills:

  • Experience in writing complex SQLs to analyze and troubleshoot the issues/problems.
  • Excellent communication and motivation skills, and ability to interact appropriately with senior level colleagues and business users.
  • 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.
  • 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.
  • Experience with data analysis, data architecture, data cleansing and data quality.
  • Experience with data integration tools like Informatica, Data Stage.
  • Experience with databases technologies like Oracle, Teradata and Vertica.

Technical Skills:

  • 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 Informatica, GoldenGate, etc.
  • 7+ years of experience working with Relational Databases like Teradata, Vertica, Oracle, SQL Server, etc.
  • 5+ years of experience working with Unix Shell Scripts.
  • Knowledge of MS-Office Suite (Word, Excel, Powerpoint).

Equal Opportunity/Affirmative Action Employer - Minorities/Females/Protected Veterans/Disabled.

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

Read Full DescriptionHide Full Description
Confirmed 16 hours ago. Posted 30+ days ago.

Discover Similar Jobs

Suggested Articles

One Step Register
Need an account? Sign Up