DW Analyst and Modeler

BrassringJobId: - ArbitaJobId:

Job Location

San Francisco, US - California - San Francisc

Job Description

Will be responsible for data modeling of operational data store, data warehouse and data marts;  Perform requirements gathering, analysis and design of integrated solutions in conjunction with the BI and ETL architects and developers. Expected to lead projects and provide mentoring and support to other team members. 

Job Qualifications


  • Senior level data warehouse analyst/modeler with at least 8 years experience in data warehouse and BI solutions
  • Must have experience with source to target mapping using multiple types of data sources (experience with mainframe files (cobol copybook defined) are highly desired).

       

  • Proficient in Data warehousing and Business Intelligence concepts

       

       

  • Must have strong understanding of metadata management and its role in data integration and data management

       

       

  • Strong SQL skills with experience using Oracle 10G / RAC - Oracle DBA skills are strongly desired (creating objects, partition, tuning)

       

       

  • Must have excellent communication, organization and analytic skills

       

       

  • Knowledge and Experience with Informatica 8.6.x and Microstrategy 9.x is a major plus.

       

       

  • Experience with data modeling tools is required (ER/Studio is a plus)

       

Job Salary

Salary commensurate with experience