SiriusXM Data Architecct.-NYC - Georgia IT Inc.
NYC, GA
About the Job
Job Title: SiriusXM Data Architecct.
Location:NYC
Rate : $70/ hour.
1. Large data set exp
2. Provide Tier2 support for all BI jobs
3. Strong knowledge of Teradata, Informatica and UNIX is must
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 data casting / transformations and data flows for SiriusXM BI's Digital Asset Metadata Management system.
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:
• Minimum 8 years experience of 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.
Please provide the following details along with your resume to make a productive submission.
Full Name:
Current Location:
Relocation:
Contact number:
Mail ID:
Skype ID:
Visa Status:
SSN Number(Last four Digits):
Availability(immediate/days/weeks):
Did you apply for the same position before?
Do we have the right to represent you?
Location:NYC
Rate : $70/ hour.
1. Large data set exp
2. Provide Tier2 support for all BI jobs
3. Strong knowledge of Teradata, Informatica and UNIX is must
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 data casting / transformations and data flows for SiriusXM BI's Digital Asset Metadata Management system.
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:
• Minimum 8 years experience of 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.
Please provide the following details along with your resume to make a productive submission.
Full Name:
Current Location:
Relocation:
Contact number:
Mail ID:
Skype ID:
Visa Status:
SSN Number(Last four Digits):
Availability(immediate/days/weeks):
Did you apply for the same position before?
Do we have the right to represent you?
Source : Georgia IT Inc.