Job Description :
Title: Senior Data Architect
Location: NYC
Duration: Year end and extendable
Interview Type: Telephonic Call followed by In-person interview
Position Summary:
The Senior Data Architect, Business Intelligence will be responsible for defining logical to physical attribution, modeling and architecture, and data casting/transformations and data flows for Marketing Business Intelligence projects. The Senior Data Architect, Business Intelligence will collaborate closely with Business Solution Management teams to understand business and functional requirements and guide functional design that produce scalable solutions to meet them. The individual should be proficient in areas such as; Core Data Architecture principles, enterprise data warehouse modeling. Experience with campaign tools like Aprimo, SalesForce desired.
Duties and Responsibilities:
Work as a 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.
Guide developers on efficient ETL design and development.
Bachelor''s degree in computer science, information systems or related course study required or equivalent, relevant expeirence.
7 years of experience, or a Master''s degree and 5 years, in data architecture with Oracle, teradata, Vertica and/or SQL Server;
Minimum of 5 years of experience in designing conceptual, logical and physical data models, data dictionary maintenance, and metadata management.
Minimum of 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:
Have thorough understanding of data integration techniques
Must have extensive industry experience in data modeling, best practices and standards.
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.
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.
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