Role:
BI/DWH Architect
Duration:
1 plus year
Location:
Houston, TX
Role
Description:
As a Data Warehouse Architect, you will
act as the primary technical architect for 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.
Required skills :
A minimum of 10 years’ experience architecting large
scale data warehouses
A minimum of 7 years of relevant consulting experience
preferred or 15 years of corporate IT
Expert data modeling skills (i.e. conceptual,
logical and physical model design - with both traditional 3 rd normal
form as well as dimensional modeling (star, snowflake), experience with
Operation DataStores, Enterprise Data Warehouses
and Data Marts
Expert with pro's and con's of multiple warehouse
architectures
Expert in Data Sourcing from multiple sources.
Expert RDBMS knowledge of Oracle (release 9i and 10g)
including very large databases
Expert in load design strategies and optimization
techniques
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
Possess strong communication and client management
skills.
Ability to effectively manage multiple projects
simultaneously
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 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
For more requirements and hotlist please
visit our blog www.sulaanjobs.blogspot.com
Kevin | IT
Recruiter | www.sulaan.com
Sulaan Solutions, Inc.
Consulting | Staffing | Outsourcing