ETL Developer

n

• Create and support data load processes via SSIS (SQL Server Integration System) and database refreshes \n

• Communicate effectively in both verbal (i.e. day-to-day discussions, team meetings) and written (requirements and design specifications) form, as well as have an overall ability to be clear and concise in all communications \n

• Development/management of schema data model through all data warehouse environments \n

• Perform detailed data analysis (i.e. determine the structure, content, and quality of the data through examination of source systems and data samples) \n

• Design and develop ETL programs to extract data from transactional database systems and load to the Data Warehouse using SSIS (SQL Server Integration System) \n

• Create technical design documentation, which includes database design models and ETL program specifications for the implementation of the data model \n

• Create and maintain documentation as it relates to data configuration, mapping, standards, and processes \n

• Maintain mappings of data sources, data movement, interfaces, and analytics, with the goal of ensuring data quality \n

• Understand technical requirements and confirm that needs are met or exceeded \n

• Provide appropriate information to elicit or help clarify around the requirements \n

• Complete all required training applicable to this position \n

• Regular and predictable attendance is an essential function of this position \n

• Other duties, as assigned \n

• BA/BS in Computer Science or related field is preferable. Equivalent combination of experience, education and training will be considered \n

• 5 years of experience and proficiency in Microsoft SQL Server 2005/ 2008 R2/2012/2014 or an equivalent combination of education, training, and experience. \n

• Knowledge of ETL processing. SSIS Technology preferred \n

• Hands on experience with ETL data integration, enrichment, consolidation and aggregation; capture and transformation; error handling \n

• High-level development skills and experience with Complex T-SQL \n

• Experience with Data Warehousing Methodology and best practices, Kimball preferred \n

• Experience and familiarity with the following: MS Office Products, MS CRM, MS Project, MS Visio, MS PowerPoint, and MS Team Foundation Server (TFS) \n

• Ability to read, analyze and interpret technical documents. \n, * Proficiency in Microsoft SQL Server 2005/ 2008 R2/2012/2014 \n

• Knowledge of ETL processing \n

• Hands on experience with ETL data integration, enrichment, consolidation and aggregation; capture and transformation; error handling \n

• High-level development skills and experience with Complex T-SQL \n

• Experience with Data Warehousing Methodology and best practices, Kimball preferred \n

• Experience and familiarity with MS Office Products, MS CRM, MS Project, MS Visio, MS PowerPoint, and MS Team Foundation Server (TFS) \n

• Ability to read, analyze and interpret technical documents.