• Responsible for gathering and assessing business information needs and preparing system requirements.
• Performs analyses, development, and evaluation of data mining in a data warehouse environment which includes data design, database architecture, metadata, and repository creation.
• Uses data mining and data analysis tools.
• Reviews and validates data loaded into the data warehouse for accuracy.
• Interacts with user community to produce reporting requirements.
• Provides technical consulting to users of the various data warehouses and advises users on conflicts and inappropriate data usage.
• Responsible for prototyping solutions, preparing test scripts, and conducting tests and for data replication, extraction, loading, cleansing, and data modeling for data warehouses.
• Maintains knowledge of software tools, languages, scripts, and shells that effectively support the data warehouse environment in different operating system environments.
• Possesses working knowledge of Relational Database Management Systems (RDBMS) and data warehouse front-end tools.
• Must have an extensive knowledge of data warehouse and data mart concepts.

Dimensions Education:

Bachelor’s Degree in Computer Science, Information Systems, or other related field. Or equivalent work experience.

Experience:

A minimum of 3 years of IT work experience in business intelligence tools and systems.

Complexity:

Intermediate professional level role. Provides data warehouse architectural design, development and support in multi-platform environments. Works on multiple projects as a team member and may lead projects of moderate complexity. May coach more junior technical staff.