 |
|
Data Warehouse Architect
Location
Chicago
Job Description
As a Data Warehouse Architect, you will act as the primary technical architect for our data warehousing projects to solve some of the toughest challenges in business intelligence today. The successful candidate should possess deep technical expertise in database design, ETL, reporting and analytics and will have previous consulting experience utilizing a structured delivery methodology.
Job Requirements
- A minimum of 5 years experience architecting large scale data warehouses using Oracle
- A minimum of 7 years of relevant consulting experience preferred or 10 years of corporate IT
- Expert data modeling skills (i.e. conceptual, logical and physical model design, experience with Operation Data Stores, Enterprise Data Warehouses and Data Marts
- Expert RDBMS knowledge of Oracle (release 9i and 10g)
- Implementation experience with ETL concepts and tools such as: Oracle Warehouse Builder, Informatica, DataStage, and ab Initio
- Implementation experience with one or more of the following BI/Enterprise Reporting tools: Oracle Discoverer, Business Objects, Cognos, Brio, and Microstrategy
- Functional knowledge of Java and J2EE integration technologies
- Possess strong communication and client management skills.
- Ability to effectively manage multiple projects simultaneously
- Ability to travel to client site as needed
- BS in Computer Science or equivalent experience in a relevant field
Responsibilities
- Translate client user requirements into technical architecture vision and implementation plan
- Design and develop the architecture for all data warehousing components (e.g. tool integration strategy; source system data ETL strategy, data staging, movement and aggregation; information and analytics delivery; and data quality strategy)
- Design of the data warehouse data storage strategy/technique (ODS, EDW, DM, ROLAP, MOLAP, etc.)
- Design of data warehouse health sub-system (e.g. QA/QC, ETL and Query metrics)
- Oversight of tool evaluation and selection
- Hardware recommendations, sizing and configuration
- RDBMS installation, configuration and tuning
- Oversight and/or coordination of system testing phase
- Problem and issue resolution
- Mentoring and developing junior staff
- Participation in proposal development and client presentations
|
|
|
|
