Job Summary
The Data Warehouse (DW) Programmer/Analyst works in conjunction with the Data Warehouse team to develop and support organization-wide reporting, ETL, data warehouse, and data analysis technologies.  The DW Programmer/Analyst shall participate in gathering and documenting requirements, designing and building reporting solutions for internal departments.  This position will participate in the design and development of data warehouse and reporting infrastructure using SQL Server technologies.  The DW Programmer/Analyst shall have a significant role in hands on development as well as high level design of these initiatives.

Position Responsibilities

·         Participate in the development of business and functional requirements for Data Warehouse related projects.

·         Participate in Business Intelligence working sessions.

·         Participate in data normalization and governance exercises.

·         Serve as a subject matter expert across the organization and assist users with reporting and analysis activities and tools, including ad hoc reporting. 

·         Ensure project activity is customer focused, results oriented, performance driven, and in compliance with all applicable internal and external requirements and policies.

·         Employ analytical, conceptual, and creative thinking skills to improve overall business and systems performance.

·         Design, develop and implement Reports as necessary to fulfill business requirements

·         Design, develop and support ETL processes to populate the operational data stores, data warehouse, and data marts as required.

·         Study, evaluate, and document current and future business processes.

·         Support user training, documentation, and roll-out of reports and end-user reporting tools.

·         Maintain effective working relationships with the DW Team, other Information Services teams and the organization as a whole.

·         Other projects and duties as assigned.

Experience & Education

·         3 -5 years general relational database and reporting development experience. 

·         3+ years experience with BI/data warehousing analysis and development including database design, ETL and reporting.

·         3+ years experience using Microsoft SQL Server stored procedures and SSIS/DTS packages and using reporting tools such as Crystal Reports and/or Microsoft SQL Server Reporting Services.

·         Bachelor's degree in a related field.

·         Experience using modeling techniques as a tool for application design and development.

Knowledge of:

·         Advanced knowledge of SQL Server development including database design and stored procedures.

·         Advanced knowledge of SSIS/DTS package design and development.

·         Advanced knowledge of Crystal Reports and/or Microsoft Reporting Services including report design and development.