Job Description:
Principle Consultant / Software Engineer  

BI Consulting Group is looking for a Principal Consultant/Software Engineer who will analyze business user needs, perform gap analysis of the business user needs against Oracle BI Analytic Applications, design BI solutions, and manage the development of the solution; meet with business owners, IT managers and business users to gather and assess system and business requirements; assign and review the work of the development team (Business Intelligence and Data Warehouse developers and ETL programmers); design complex architectures, providing for data security, multicurrency, multilingual, scalability and disaster recovery of data warehouse, business intelligence and database solutions; review and approve Informatica ETL, Oracle BI EE Metadata, and Oracle BI EE prior to implementation; and provide expert service reviews on existing Oracle BI Implementations.

The position requires a Masters degree in Computer Science, Engineering or Electronics, or a closely-related field, and two (2) years of software engineering experience which must include experience with Oracle BI EE and ETL architecture and development. The successful candidate must be certified in ETL tools including Informatica Power Center and DAC, databases including Oracle 9i/10g/11g, and reporting tools including Oracle BI EE, Oracle.s Disconnected Analytics, and must have experience with Oracle.s Analytic Applications, specifically Finance Analytics, Order Management Analytics and Service Analytics.

Job Description:
OBIEE + Lead(Hyperion Application Lead)  

Hyperion Application Lead responsibilities:

·          Responsible for positioning and delivering Essbase projects and cross building applications into new and existing Hyperion and Oracle customer base.Assess existing client data sources

·          Participate in pre-sales activity working with prospective client helping BI Consulting Group to win new business, strengthening the message on OBI EE +.

·          Provide guidance and direction to more junior consultants and client resources; be a natural leader, independent in nature; take and give direction well and work well in a team environment, regardless of technology selected to deliver the solution

·          Have substantial experience designing and implementing two or more products and/or technologies offered by Hyperion Solutions (especially Hyperion Planning, Hyperion Financial Management and/or Hyperion Essbase)

·          Will be seen as best practice leaders in the company; responsible for actively document and share knowledge and mentor consultants with less experience on the Hyperion product line

·          Complete cross training in OBI EE and also help cross-train, mentor, and developing existing staff

Hyperion Application Lead Skills and Experience:

·          Four years or more of full time consulting work experience and/or four years of full time experience working as a Hyperion Application Lead with two or more of Hyperion Solutions’ products. (especially Hyperion Essbase, Hyperion Financial Management and/or Hyperion Planning)

·          In-depth knowledge and experience with BPM and/or BI solutions

·          Knowledge of financial accounting processes

·          Strong critical thinking and analytical background

·          MBA or Bachelors with 5-7 years related work experience

·          Excellent presentation and communication skills both written and verbal

·          Excellent technology skills related to product implementation

·          Experience with databases (Oracle, Essbase, etc.)

·          Ability to complete implementation work without direction

·          Willingness to travel up to 80%

·          Product certification from Hyperion Solutions in Hyperion Essbase, Hyperion Financial Management and/or Hyperion Planning a plus

·          Dual major, separate, or advanced degrees related to accounting/finance and information technology

·          A professional accounting designation (e.g. CPA, CMA, CGA, CA), advanced degrees (MBA, MFA), and/or other professional designations or certifications (applicable to accounting/finance and information technology)

Job Description:
Data Integration Analyst

Data Integration Analyst responsibilities:

·          Contribute on teams that analyze, design, build and test physical data architectures that enable world class business intelligence systems

·          Assess existing client data sources

·          Assist with data mapping technical gap analysis

·          Build, test/validate, maintain mappings that extract, transform and load (ETLs) data

·          Collaborate with DBAs and OBIEE developers to meet BI Project needs

Data Integration Analyst should:

·          Have a Passion for business intelligence

·          Have a good understanding of data architectures (Ralph Kimball)

·          Have a good understanding of ETL architectures, including data staging architectures, source dependent extracts, source independent loads; ETL tool sets (e.g. Informatica, Ascential, etc.)

·          Be willing to learn new business models, business functions, BI tools, and implementation methodologies

·          Be able apply to conformed physical data (dimensions & facts) to end-user business requirements

·          Be willing to travel

Job Description:
Business Intelligence Designer

Business Intelligence Designer responsibilities:

·          Support team that assesses client organization’s use of business intelligence capabilities

·          Contribute on teams that gather, analyze and create business intelligence requirements

·          Contribute on teams that design, build and test metadata (logical data) architectures that enable world class business intelligence systems

·          Design, build and test end-user BI dashboards, reports and work flows

·          As per BICG Methodology, Manage BI testing efforts

·          As per BICG Methodology, Manage client training efforts

Business Intelligence Designer skills:

·          Have a Passion for business intelligence

·          Have a good understanding of data architectures (Ralph Kimball)

·          Be willing to learn new business models, business functions, BI technical tools, and implementation methodologies

·          Have excellent business acumen, including how to apply business intelligence to common business processes in Finance (GL, FA, AR, AP), HR, Sales, Marketing

·          Excellent communication, teaching  or coaching skills

·          Deep MS Office skills (Excel, Access, etc.)

·          Understand organizational design nice to have

·          Experience with Business Objects, Cognos, etc. nice to have

·          Be willing to travel

Job Description:
Business Intelligence Training Designer

Business Intelligence Training Designer responsibilities:

•          Define and develop BICG Implementation training requirements. Including communications, training support, organization, training metrics, and training strategy requirements

•          Design the training content, communications, training support standards and related deliverables.

•          Ensure that training, training support, communications, and organization designs fulfill training requirements and complement each other and do not duplicate effort.

•          Assess and identify BICG’s training’s affects on client-based roles, jobs, teams, based on the changes in the insights/business intelligence, associated processes and tools.

•          Review project-based training, training support, and organization design deliverables throughout development to ensure quality and traceability to requirements.

•          Manage the training, training support, and organization analysis, design, and build effort.

•          Ensure that the resources responsible for developing any technical architectures or applications for the training and performance support products thoroughly understand training requirements and designs.

•          Identify and communicate cross-functional issues that may affect other areas of training.

•          Work with other leads to ensure that the enabled capabilities (applications) meet objectives and metrics as defined in the requirements.

•          Ensure quality management standards by participating in quality reviews.

Business Intelligence Training Designer skills & experience:

•          Project management and leadership skills. Including work estimation, work planning, issue and risk management.

•          Deep Training  Content/Course Design, Development  skills and course instruction experience

•          Deep Communication Management skills. Includes Strategy Creation, Planning, Execution & Analysis

•          Deep Organization Design skills. Includes organization assessment, organization and role and responsibility designs and role skill definitions.

•          Minimum 3 years of consulting/industry experience.

•          Minimum 3 years training development experience.

•          1-2 full life cycle training implementation experience or equivalent

•          Experience with Business Intelligence in an operations and sustainment role, helpdesk, or power user capacity.

Job Description:
Business Intelligence Application Lead

Business Intelligence Application Lead responsibilities:

•          Design & Develop BI Metadata/Logical Data Model

•          Translate BI requirements into analytics BI subject areas

•          Design & Develop BI user interface objects (e.g. reports, dashboard, BI work flow, etc.)

•          Drive collaboration with the DBAs & Data Integration Lead to:

•          Design & Develop Physical Data Model

•          Determine whether measure calculations and processing should be done in ETL or metadata

•          Determine requirements for aggregate tables and SCDs

•          Define BI application and data security model

•          Understand BI Business Strategy & Requirements

•          Estimate OBIEE Project & Support Efforts

•          Mentor/lead OBIEE Developers thru implementation efforts

•          Communicate design, build and test effort progress & issues to BI Project Manager

•          Apply BICG BI Governance to OBIEE Project Efforts (Design, Build, Test, Deploy, Support)

Business Intelligence Application Lead skills & experience:

•          5+ full phase implementation experience with Business Objects,  Cognos, OBIEE/Siebel Analytics

•          5+ years of BI application design, build, test, experience  including requirements gathering,  ownership of metadata  and dashboards/reports

•          Deep project management skills, including work estimation, work plan creation/maintenance, issue management, risk management, change request management, and project communications

•          Excellent spoken and written communications

•          Project leadership experience

•          Technical and functional experience with one or more of the following Oracle Financials (GL, FA, AR, AP), PeopleSoft Campus Solutions/Financials/HR, etc.

Job Description:
Business Intelligence Data Integration Lead

Business Intelligence Data Integration Lead responsibilities:

•          Own/Design BI Data Integration Architecture

•          Collaborate with DBAs and BI Leads to design/maintain:

•          Physical Data Model

•          Determine whether measure calculations and processing should be done within ETL or metadata

•          Determine requirements for aggregate tables and SCDs

•          Define BI application and data security model

•          Understand BI Business Strategy & Requirements

•          Estimate Data Integration Project & Support Efforts

•          Mentor/lead Data Integration Developers thru implementation efforts

•          Communicate design, build and test effort progress & issues to BI Project Manager

•          Apply BICG BI Governance to Data Integration Project Efforts (Design, Build, Test, Deploy, Support)

Business Intelligence Data Integration Lead skills & experience:

•          5+ full phase implementation experience with Informatica , Assential or similar ETL tool

•          5+ years of Data warehouse and ETL design, build, test experience  including requirements assessment,  ownership of data integration architecture and ETL scheduling

•          Deep project management skills, including work estimation, work plan creation/maintenance, issue management, risk management, change request management, and project communications

•          Excellent spoken and written communications

•          Technical and functional experience with one or more of the following Oracle Financials (GL, FA, AR, AP), PeopleSoft Campus Solutions/Financials/HR, etc.