Senior Programmer/Analyst - Data Warehouse

QUALIFICATIONS:

· This position is responsible for development of data warehouse projects.

· Components include gathering business and analytical requirements, designing and developing ETL processes, reporting, and analytics to meet business needs.

· Minimum of 2 years experience of hands-on ETL development in a data warehousing environment.

· Understanding of star schema architecture.

· Strong working knowledge of programming analysis and design.

· Demonstrated understanding of best practices for software development with a strong emphasis in the data warehouse/business intelligence discipline.

· Applied knowledge of data warehousing methodologies and best practices.

· Demonstrated competence developing and maintaining complex ETL processes from diverse data sources.

· Working knowledge of Business Intelligence applications.

· Advanced Transact-SQL development skills.

· Experience with database engines such as DB2.

· Experience with IBM DB2 Data Warehouse Edition is desired.

· Understanding of retail environment is desired.

· Ability to handle multiple projects.

· Ability to read, analyze, and interpret common scientific and technical journals, financial reports, and legal documents.

· Ability to define problems, collect data, establish facts, and draw valid conclusions. Ability to interpret an extensive variety of technical instructions in mathematical or diagram form and deal with several abstract and concrete variables.


JOB RESPONSIBILITIES:

· Participate in requirement gathering/development process with business clients.

· Design, develop, test, performance tune, deploy, and maintain reports, analytics, alerts, and dashboards.

· Design, develop, test, performance tune, deploy and maintain ETL processes.

· Collect and/or creates test data and programs. Corrects system defects.

· Provide input on the configuration, maintenance, and security of all data warehouse environments.

· Analyze information needs for functional areas to assure data and methods are within cost and schedule constraints.

· Analyze more complex business and technical system problems and design/develop technology solutions to meet business needs.

· Writes or reviews system specifications, including output requirements and flow charts.

· Develop and implement ETL processes necessary to support client requirements.

· Act as technical resource for data warehouse reporting applications.

· Provide on-going support of the warehouse and continually reevaluate processes and techniques for increased efficiency and maintainability.

· Provide training for less experienced team members and serve as a technical resource for programmers, business analysts, and database users.

· Must be able to provide data warehousing/business intelligence support in an on-call rotation.
REQUIREMENTS
· ETL development in a data warehousing environment

· Advanced Transact-SQL development skills.

· Experience with database engines such as DB2.