Data Warehouse Administrator -4 LOCS


Healthcare - Upstate NY - Watertown, NY
Watertown, New York


Last Day to Apply: August 16, 2024

Data Warehouse Analyst            

 

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.

Dimensions Education:

  • Bachelor’s Degree in Computer Science, Information Systems, or another 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.

 

Skip to the main content