Job Title: BI Specialist (Ref code: 082913-ROBTIM-IO40-E-VIC)

Location: IRVINE, CA

Duration: Long Term

JOB DUTIES

Candidates need to be Local to Southern, CA or able to interview in person in Southern, CA.
Data Warehouse Specialist responsible for designing and developing data warehouse solution in support of users' BI needs Gathering user data requirements, identifying and analyzing source data to meet user requirements
Designing relational data models for handling integration of source data and dimensional models for BI reporting
Designing and developing the integration components (e.g. UNIX scripts, Stored Procedures, PowerCenter ETLs) to enable final delivery of data to BI layer
Leading the strategic design and maintenance of business intelligence applications
Identifies, researches, and resolves technical problems
Ensures that the use of business intelligence applications enhances business decision making capabilities
Work closely with BSA and business users in gathering requirements, source system teams to understand and analyze data patterns, DBAs to fine tune physical data structures and developers to execute on the overall data warehouse solution


REQUIRED EXPERIENCE
Oracle - 6 + Years

Data Analysis - 6 + Years
Data Modeling - 6 + Years
Data Warehousing - 6 + Years
Integration - 6 + Years

CORE SKILLS
Data Analysis
Data Modeling (conceptual, logical, & Physical)
Data Warehousing
Data Integration

DETAILED SKILLS
Oracle 11g
Ability to write SQL Statements
Stored procedures
Performance Tuning
Data Modeling
Case Tool experience Erwin
Data Warehouse
Understand Data Warehouse Architecture
o Different layers to Data Warehousing
Data Flow - how data flows from 1 area to the next within data warehouse.
Staging area
Will be given sample data and expected to demonstrate what needs to be done.
Will work closely with ETL Developers
Unix
Good communication skills (requirements gathering)

 

 

Please mention the job Title in the subject line: "BI Specialist "

Please rush your resumes to careers@iormyx.com