Senior Data Architect, Business Intelligence-New York, NY - Georgia IT Inc.

New York, NY

About the Job

Senior Data Architect, Business Intelligence
Location: New York, NY
Position: Contract
Pay rate: DOE

US Citizen, Green Card, TN, GC EAD only No Third-party agencies
Corp to corp not available

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.

This position requires:

Bachelor's degree in computer science, information systems or related course study required or equivalent, relevant experience.
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.
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).
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.

Required Skills:

BI Architecture, Business Intelligence, Data Modeling, Data Warehouse, SQL Queries, Teradata

Preferred Skills:

Oracle; SQL Server; SOAP; Rest; MS Office

Source : Georgia IT Inc.