Previous Job
Data Architect
Ref No.: 17-00227
Location: New York, New York
Position Type:Contract
Start Date / End Date: 03/10/2017 to 09/10/2017
Detailed Job Description:
The Senior Data Architect for the 360L Marketing initiative will be responsible for defining logical to physical attribution, modeling and architecture, and data casting/transformations and data flows for Marketing Business Intelligence for the 360L project.
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, SalesForce is a plus.
5. Prior experience working with contact preferences desirable.
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+ recordset 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.
Technical Skills:
- Teradata, Oracle, Vertica. 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.