Lead BI Architect–San Clemente, California



Our client based out of Los Angeles (Downtown Arts district) is transforming the way people work, create, and collaborate. Our client’s radically innovative, immersive technology is changing the face of computing. It’s the only product that truly enables rich, real time collaborative work between users situated in the same room or across distances.

Job Title: Lead BI Architect
Job Location: San Clemente, California
Project Length: Fulltime Perm

Position Summary:
The BI Architect is responsible for the design, development and implementation of the enterprise business intelligence platform. The BI Architect defines and manages the overall BI solution architecture including data architecture, ETL implementations and reporting solutions. This position also guides external BI Developers to deliver sustainable ETL and reporting solutions with optimal end user performance.

Essential Duties & Responsibilities:

  • Design relational and dimensional enterprise BI data models
  • Design the data integration from source to interactive reports and data visualizations
  • Develop and implement the BI architecture which includes data warehousing, OLAP, ETL, ODS, data integration, report data sets
  • Work with product owner and business users to understand and translate user stories/requirements into data structures, models and reports
  • Find answers to business questions through hands-on exploration of data sets via SQL for dashboards, statistical analysis and data visualizations
  • Maintain and enhance the enterprise BI data architecture to increase the robustness, performance, and scalability of systems
  • Review and explore source data as it relates to business concepts as well as how it relates to other data elements
  • Map data from original source to the BI database layer to the presentation database layer and communicate and document that to guide the BI Developer
  • Manage the reporting and analytics platform(s) to ensure that scheduled jobs are successfully run and analytics data aligns to timeliness and completeness of requirements
  • Work with database administrators to ensure that databases feeding the reporting platforms are tuned for optimal performance
  • Stay current with latest BI industry trends and software versions
  • Participate in 24/7 department on-call program
  • Work on special assignments as they arise

Knowledge, Skills & Qualifications:

  • Solid understanding of large ERP systems (e.g. Oracle EBS or SAP)
  • Excellent verbal/written communication skills and strong analytical/problem solving skills
  • Excellent collaboration skills and able to work in a team environment
  • Able to work quickly and effectively under pressure and to efficiently handle multiple priorities simultaneously

Education and Experience:

  • Bachelor’s degree from an accredited college or university in Computer Science, Information Systems, or related IT field
  • Minimum 3 years of experience in an IT BI reporting environment, preferably as a BI Architect
  • Minimum 5 years of experience working with the following BI software and technologies: MS SQL/Oracle 11g, Data warehousing, OLAP – MS Analysis Services/Essbase, MS Reporting Services, OBIEE/OBIA, Sharepoint 2010, BI Publisher, Oracle Discoverer, ETL tools – Informatica, SSIS, ODI
  • Experience working for a mid-sized to large organization; manufacturing experience preferred

Minimum Qualifications:

  • Must be 18 years of age and must pass pre-employment drug screen and background check

Interested? Please contact santosh@param-solutions.com for immediate consideration.

This entry was posted in Careers and tagged . Bookmark the permalink.

Copyright © 2013 Param Solutions.com All Rights Reserved

Real Time Web Analytics