This job has expired, please see additional jobs below
Senior Data Architect
Sirius XM
New York, NY, United States
Job Details - this job has expired, please see similar jobs below
Position Summary:
The Senior Data Architect for the internal Royalty Processing initiative will be responsible for defining logical to physical attribution, modeling and architecture, and date casting/transformation and data flows for SiriusXM BI's Digital Asset Metadata Management system. S/he will be responsible for working with the MDM team and ensuring the correct match rules are created. S/he will also assist in validating the various domains. The individual should be proficient in areas of analysis such as; Weblog data analysis, Royalties processing and reporting, Web methods interface to source data.
Duties and Responsibilities:
• The Senior Data Architect must have extensive industry experience in data modeling, best practices and standards.
• Work as Senior Technical member of cross-departmental teams on multi-platform database development.
• Analyze data across multiple sources to design and document logical and physical data models, and maintain the Enterprise Data Warehouse Data Model.
• Gather and define data requirements based on specific application business requirements.
• Define conceptual, logical and physical data models.
• Prepare normalized models and dimensional models.
Supervisory Responsibilities:
• There are no supervisory responsibilities associated with this job.
Minimum Qualifications
• Bachelor's degree in Computer Science, Information Systems or related course study required and/or equivalent combination of education and experience preferred.
• Minimum 8 years experience in data architecture with one or more of the following: Teradata, SQL Server, Vertica, and Oracle.
• Minimum 5 years of experience in designing conceptual, logical and physical data models, data dictionary maintenance, and metadata management.
• Minimum 5 years of experience in dimensional data modeling and business intelligence tools.
Requirements and General Skills:
• Excellent SQL skills for complex data analysis and data quality assurance.
• Exceptional data modeling skills.
• Strong analytical and problem solving capabilities.
• Experience designing and implementing large data retrieval processes, billion+ records association and aggregations.
• Demonstrated ability to work independently and with large teams.
• Demonstrated Ability to communicate and gather requirements from the business.
• Ability to partner with enterprise architects, business architect, analysts and development team to deliver rapid iterations of complex solutions.
• Client facing skills.
• Excellent oral and written communication skills.
• Project organization, planning, vendor management and leadership skills.
• Ability to manage multiple assignments simultaneously and follow up on unfinished business.
• Must have legal right to work in the U.S.
Technical Skills:
• Strong Teradata desired. Oracle, MS SQL Server, Vertica, Netezza , etc. can be alternates. Hadoop desirable.
• Comprehensive understanding of Data Warehouse design principles.
• Ability to proactively identify, troubleshoot and resolve complex data integrity issues.
• MS and Teradata Certification preferred.
• Subscription-based industry experience preferred.
• Knowledge and understanding of SOAP protocols desirable.
• Experience in analyzing large volume datasets like weblogs desirable.
• Thorough knowledge of MS-Office Suite (Word, Excel, PowerPoint, Access).
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.