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:
This position requires:
Required Skills:
Preferred Skills:
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.