SQL Data ArchitectCity 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 roadmapCreate data architecture and data integration programs for complex systemsServe 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 usersRequired Skills:Proven ability to architect/design/process 10-15 TB data structures10+ years relevant IT experience with at least 5+ years of experience as an ETL Architect, designing and architecting data acquisition and integration processes7+ 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 codeExpert level knowledge and experience with SQL server reporting services (SSRS)Provide support and database technical guidance to software developers and business users