Job Description :
Position Summary:
The Senior Data Architect will be responsible for defining & understanding the existing logical to physical data model in CV system, and mapping the same into the existing Sirius Marketing data model. The individual should be proficient in areas of data analysis and data
modelling. She/he also should be hands-on in understanding existing Informatica mappings, stored procedures to reverse engineer business processes and rules. S/he should compare the two systems to validate the ETL work and debug any deficiency if required.

Duties and Responsibilities:

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.
Minimum Qualifications:

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:

The Senior Data Architect must have extensive industry experience in data modeling, best practices and standards.
Excellent SQL skills for complex data analysis and data quality assurance.
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.
Excellent 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.