SQL Data Architect-NYC - Georgia IT Inc.

SQL Data Architect
City Of NY- Department of Citywide Administrative Services
Location- NYC
Rate - opened
 
Proven ability to architect/design/process 10-15 TB data structures. 
1.10+ years' experience with at least 5+ years of experience as an ETL Architect, designing and architecting data acquisition and integration processes. 
2.  7+ years developing solutions, design and architecture using relational databases, preferably MS SQL Server, etc
 

Microsoft SQL Server Data Architect / Developer in New York, New York (NY). Project Deliverables: * Lead and work collaboratively with business and technology stakeholders to establish and maintain the enterprise data reporting architecture, strategy, and roadmap * Create data architecture and data integration programs for complex systems * Serve as a Subject Matter Expert (SME) and provide technical leadership for all data initiatives (i.e. design principles, ETL and BI architectures, business rules/logic, Operational Data Stores, enterprise data warehouse, source-to-target mappings, data lineage and meta data requirements) * Responsible for the definition, design, development and implementation of standards and best practices for dimensional data modeling, describing data entities, master data, Meta data, data quality, and data governance. ? Build and deploy SQL server integration services packages (SSIS) * Create/deploy SQL server reports using SQL server reporting services (SSRS) * Provide support and database technical guidance to software developers and business users Required Skills * Proven ability to architect/design/process 10-15 TB data structures * 10+ years relevant IT experience with at least 5+ years of experience as an ETL Architect, designing and architecting data acquisition and integration processes ITCS 3- NAE 4Template 1: - Requisition for Consultant Services 5-2-2016 ITCS 4 -SQL Server Data Warehouse Architect Page 2 of 3 * 7+ years developing solutions, design and architecture using relational databases, preferably MS SQL Server, etc. * Extensive experience with SSIS package design, implementation, and deployment including custom scripts using .NET code * Expert level knowledge and experience with SQL server reporting services (SSRS) * Provide support and database technical guidance to software developers and business users Please send in the following details.   Full Name: Contact No.: Best time to call: Interview Activity/ Offer Pending: Email ID: Work authorization: SSN Number (Last four Digits): Current Location (city/state): Rate: Please give rate of the last 3 Projects Date of Birth (Just need the Month and Day, Not the year): Total IT Experience: US IT Experience: Relocation (Yes/No): Able to do Onsite Interview (Yes/No): Availability Date to Start: If the candidate has been presented to the company in the past, please answer (Y/N)?: Brief Description of why the candidate qualifies: (3- 4 Sentences)