Enterprise Architect (Data Warehouse)

California  ‐ Onsite
This project has been archived and is not accepting more applications.
Browse open projects on our job board.

Keywords

Description

We are in need for a seasoned architect to consult with a client on their Enterprise Data Warehouse to make sure they are following best practices and that they have made sustainable choices on their architecture. 

The company is working on several fronts to make better use of their information for performance management and decision-making purposes.

  • Data Quality and Governance - They are establishing a systematic approach for defining, controlling and validating their information.  Once a fully defined focus area of their business, use that as a requirement specification for build out of EDW (using "Business Insight" - Consensus for organizing requirements and definitions)
  • Enterprise Data Warehouse - Data is stored and organized in a dimensional model, and further processed into OLAP cubes.  An ETL process is utilized to automate the population and maintenance of these data structures (using SQL Server 2012 DB Engine, SSAS for OLAP, SSIS for ETL).
  • Executive Scorecards - Plan is to build to build out scorecards based on corporate budget/goals and utilize OLAP/EDW data to ensure drill-down capability along hierarchical data categories (using SharePoint 2010 PerformancePoint as executive scorecard tool).
  • We have 1-2 technology resources that are dedicated to build-out of EDW and ETL, and a larger group of 7-8 resources working on defining data, business logic, source-target mapping and aligning with business users to define scorecard content. Their goal is to bring a seasoned architect in to consult with them to make sure they are following best practices and that they have made sustainable choices on the architecture. 

    The resource they are looking for should have in depth mortgage industry experience and should have demonstrated success in implementing similar solutions for large mortgage operations. This would be a 1-2 month engagement.

    Please send in your updated Resume in Word format along with rate expected/hour(to move and take decision immediately), contact details and availability status.

    Start date
    1 week
    Duration
    Up to 2 months
    From
    DG Business Solutions Inc
    Published at
    20.11.2013
    Project ID:
    630068
    Contract type
    Freelance
    To apply to this project you must log in.
    Register