Data Warehouse Analyst

Responsibilities

General Characteristics 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.

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

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

• 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.
• Positions may not be available immediately, and job locations, assignments, and start dates may vary depending on agency requirements.