12/27/05 01890

IES BUSINESS WAREHOUSE SPECIALIST

DEFINITION: This is advanced technical and analytical work in the development, design, configuration, and performance of enterprise data warehouse software solutions for the Commonwealth’s Integrated Enterprise System (IES) SAP Business Warehouse system.

An employee in this job is a member of a technical business warehouse team that analyzes enterprise data warehouse needs and models, designs, develops, and implements enterprise data warehouse solutions. The work includes assisting in reviewing and analyzing strategic and analytical data and information needs; determining the most appropriate way to provide and support those needs using the Business Warehouse software; analyzing the cost of supporting the data and information needs using the data warehouse software; designing the data warehouse solution; configuring the enterprise data warehouse software; developing specifications for customized changes to the enterprise data warehouse structures; and managing communications and impacts to enterprise data warehouse users, and other Commonwealth business and technical teams. A significant aspect of the work includes understanding the relationship among data structures, information requirements, and the options for satisfying those requirements. The work also requires providing technical assistance to system users, database administrators, Basis administrators, business operations teams, and application developers. Emphasis at this level is on learning to use and configure the enterprise software and understanding and analyzing the data needs to design data warehouse solutions. Work is distinguished from the higher level by the more narrow scope of assignments, more detailed review of work in progress and upon completion, and absence of responsibility for serving in a project leadership role. Work is assigned by an IES Business Warehouse Supervisor and is reviewed for overall effectiveness and satisfactory completion of assignments.

EXAMPLES OF WORK: Serves as a member of a technical business warehouse team for a business operations area to analyze, design, configure, and optimize enterprise data warehouse solutions.

Assists in analyzing the requirements and designing the data models to support enterprise data warehouse solutions.

Assists in the configuration of the enterprise data warehouse software to support enterprise data warehouse solutions.

Participates in coordinating and executing data warehouse and source system integration activities with business functional area specialists, technical specialists and user representatives to ensure that all integration issues and user impacts are considered when developing or modifying enterprise data warehouse solutions.

Assists in developing detailed functional specifications that describe custom changes that are needed to support Commonwealth enterprise data warehouse solutions.

Participates in the design, development, documentation, and support of data recovery strategies to ensure the accuracy and completeness of data restoration in the event of data corruption or data load failure.

Participates in the monitoring, analysis, and optimization of data warehouse performance.

Creates aggregates or indexes, compresses data targets, remodels data targets, and other enterprise data warehouse objects to improve performance levels.

Participates in the preparation of analyses and cost benefit projections for development and support of enterprise data warehouse solutions.

Prepares, develops, executes, and validates testing of enterprise data warehouse solutions.

Participates in the analysis, research, and resolution of complex data warehouse problems.

Makes recommendations on the most appropriate design to support enterprise data warehouse solutions.

Analyzes and assesses report and data archiving requirements.

Participates in modeling, designing, and configuring the enterprise data warehouse to support the long-term strategy for archiving.

Assists in the preparation of training materials and scenarios.

Performs related work as required.

REQUIRED KNOWLEDGES, SKILLS, AND ABILITIES: Knowledge of database principles, practices, and techniques.

Knowledge of the principles and practices of project management.

Knowledge of systems analysis principles, practices, and techniques.

Ability to learn data warehousing principles, practices, and techniques.

Ability to learn to analyze requirements and model, design, and configure the enterprise data warehouse solutions.

Ability to work in a team environment.

Ability to establish and maintain effective working relationships with end users, technical staff, consultants, and coworkers.

Ability to communicate effectively, both orally and in writing.

Ability to learn Commonwealth business processes.

Ability to perform technical duties in a large scale enterprise environment.

Ability to identify technical problems and recommend solutions.

Ability to work independently.

Ability to use all components of Microsoft Office software.

MINIMUM EXPERIENCE AND TRAINING: Four years of professional work in data warehousing, database administration, or related field;

                                                                                                                                                                                  or

Two years of professional work in data warehousing, database administration, or related field, and an associate’s degree in computer science or related discipline;

                                                                                                                                                                                  or

A bachelor’s degree in computer science or related discipline;

                                                                                                                                                                                  or

An equivalent combination of experience and training.