Data Warehouse Developer New York City, NY Premiere Insurance company is seeking a talented Data Warehouse Developer. This growing development team is looking for somebody to work alongside the Team Lead to develop data marts/warehouse for various busi

Data Warehouse Developer
New York City, NY
Premiere Insurance company is seeking a talented Data Warehouse Developer. This growing development team is looking for somebody to work alongside the Team Lead to develop data marts/warehouse for various business departments using ETL, OLAP tools and within SQL Server. Qualified candidates will be considered immediately for a consulting to hire role or direct-hire.   Responsibilities: · Mapping of data sources, data movement and reconciliation with the dual goals of ensuring data quality & consistency and ability to satisfy relevant business requirements. · Develop data transformation and data movement components of Global Data Warehouse, using approach and architecture defined by Technical Lead. · Collaboration with Business Analysis and business stakeholders to ensure a thorough understanding of strategic data requirements. · Data analysis / data profiling to understand gaps, inconsistencies and other quality issues in existing source system data, and develop data sourcing solutions. · Identify data gaps, inconsistency and quality issues and collaborate with stakeholders to identify, document and implement corrections / business rules. · Comprehensive documentation of all developed software & repositories. · Proactively propose and prototype new ideas / approaches. · Design and develop presentation vehicles including reports, queries and analytics as specified.   Requirements: · Prior development and implementation of data warehouse / mart solutions for large, complex datasets · using ETL tools · Experience in implementation of controls and reconciliation reports · Hands-on experience in working with OLAP tools, job scheduling, publishing and distribution of reports · T-SQL development including the use of views, stored procedures and indexing techniques · SQL Server database (versions 2000, 2005, 2008) · SQL Server Integration Services     IT Insurance
www.allcountyjobs.com - October 4