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
- 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