Job Description :
Role: Data warehouse Analyst
Location: Madison, WI
Duration: Long Term

Locals or Nearby Preferred.

This request is for advanced data warehouse business analysis, database design, ETL design, and data warehouse support. Best-qualified candidates will have strong experience using Oracle, Erwin and Business Objects in a business intelligence/data warehouse environment.

This position will do the following: work with advanced-level accountants and other business customers to understand their data analysis and reporting requirements; design data warehouse table structure to satisfy business requirements, identify data source, develop strategies for data extraction from source systems, design transformation and loading into data warehouse target systems; develop, implement, and follow technical and process standards; develop strategies for system fault tolerance, data recovery and purge; work to improve the efficiency of data warehouse applications through the use of indexes, compression, and other techniques; work within both formal and “agile” application development project management methodologies; function as a database liaison on the data warehouse team.

Information Technology - Databases
Data flow and structure modeling 8 years
Data Warehouse - Experience in data warehouse design and development 8 years
Data Warehouse - Experience in requirements gathering for data warehouse 8 years
Data Warehouse - Performance tuning 8 years
Data warehousing 8 years
Logical database design 8 years
Oracle 8 years
Oracle SQL tuning 8 years
SQL Client tools 8 years
Information Technology - Design
Data modeling 8 years
Information Technology - Languages/Tools
Business Objects 8 years
SQL 8 years
Information Technology - Network/Infrastructure
Experience with Oracle PL/SQL 8 years
Information Technology - Requirements
Documenting requirements 8 years
Experience as a developer in large, very complex organization 8 years
In-Depth Knowledge of System Development Life Cycle Deliverables for each Phase of Development 8 years
Requirements analysis 8 years
Requirements gathering 8 years