Sirius XM Radio Inc. Senior Data Architect, Business Intelligence in New York, New York
Senior Data Architect, Business Intelligence
Type of Position
Location: New York, NY
The Senior Data Architect, Business Intelligence will be responsible for defining conceptual, physical and logical data models and overall data flow for all business intelligence projects. The senior architect will collaborate closely with business intelligence and marketing business solution management teams to understand business and functional requirements and guide functional design that produce scalable solutions. The individual should be proficient in areas such as; core data architecture principles, enterprise data warehouse modeling, data integration expertise using batch as well as near-real time methodologies
Duties and Responsibilities:
Understand and configure the Metadata Administration Utility for Teradata CIM to meet attribute requirements for marketing campaign segmentation.
Work as senior technical member of cross-departmental teams on multi-platform database development projects.
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.
Have thorough understanding of data integration techniques and guide developers on efficient ETL design and development.
Bachelor's degree in computer science, information systems or equivalent, relevant experience.
7 years of experience (or a Master's degree and 5 years) in data architecture with Oracle, Teradata, and/or SQL Server.
Minimum 5 years of experience in data architecture with one or more of the following: Teradata, Oracle, Vertica, and/or SQL Server.
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.
Comprehensive understanding of Data warehouse design principles; and ability to proactively identify, troubleshoot and resolve complex data integrity issues.
Requirements and General Skills:
Extensive industry experience in data modeling, best practices and standards.
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.
Must have legal right to work in the U.S.
Excellent SQL skills for complex data analysis and data quality assurance.
Strong Teradata desired. Oracle, MS SQL Server, Vertica, Netezza, etc. can be alternates.
Hands-on experience with Teradata MAU.
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 REST/SOAP protocols desirable.
Thorough knowledge of MS-Office Suite (Word, Excel, PowerPoint, Access).
As an EEO/Affirmative Action Employer all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran status.
The requirements and duties described above may be modified or waived by the Company in its sole discretion without notice.
Company EEO Statement
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.