Senior Data Architect
Previous Job
Senior Data Architect
Ref No.: 18-00342
Location: New York, New York
Position Type:Contract
Start Date: 10/03/2017
The individual should have strong skills in:
1. Datawarehouse Design
2. Logical and Physical Data Modeling, preferably on marketing databases.
3. SQL Analysis of large data sets.
4. Familiarity with campaign tools like Aprimo, Unica is a plus.

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, 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
  • 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.
Technical Skills:
  • Teradata, Oracle, Vertica.
  • 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