Previous Job
Senior Data Architect, Business Intelligence-New York, NY
Ref No.: 18-02396
Location: New York, New York
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
  • 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