Sr Global Business Analyst (BI)

Wold leading manufacturer of coatings based in Cleveland, Ohio.

The Senior Global BI Business Analyst’s role is to work with business users and IT to understand reporting requirements, articulate and develop reporting solutions by covering how to retrieve data and what elements from the data source (EBS) makes up the data. Understand OBIEE and BI Apps subject areas, metrics, dashboards and answer questions from the business and BI developers on how they map to ERP functionality.

Essential Functions

Strategy & Planning

• Work with business partners to understand reporting needs and create functional requirements for each report.

• Evaluate new reporting requirements, identifies data sources and recommends to other business areas if applicable across multiple groups and environments.

• Evaluate BI Apps and identifies missing key elements, works with Enterprise BI team to extend BI Apps functionality to meet business requirements.

Acquisition & Deployment

• Understand BI Apps metrics and dashboards, train business on how to leverage them to get access to critical decision data.

• Work with business and Enterprise BI team to define, design and develop ERP ad-hoc reporting requirements.

• Train business on how to leverage ad-hoc reporting environment to access critical data to support their business decision.

Operational Management

• Understand ERP business processes and answers questions on data mapping between ERP, data warehouse and presentation layer.

• Identify inconsistent data across different instances and makes recommendation to business and MDM team to address them accordingly.

• Build specifications, models, dashboards, and reports for BI Apps and train business on how to leverage them.

• Assist users with problems and resolves issues independently.

• Create test plans, test cases, test scripts and performs testing and reconciliation of the BI Apps and related environments to improve data accuracy.

• Promote BI benefits to the organization and usage of our tools to relevant business groups.

• Provide ongoing support of existing BI implementations.

• Mentor and/or provide leadership to junior members of the team.

• Plan and organize personal tasks, reports progress to manager.

Incidental Functions

• Assist with projects as may be required to contribute to efficiency and effectiveness of the work.

• Participate in hiring activities and fulfilling affirmative action obligations and ensuring compliance with the equal employee opportunity policy.

• Attend management meetings on behalf of team.

• Normal office maintenance tasks such as loading printers and configuring personal computers software and hardware.

• Up to 25% travel as required (International & Domestic).

• Working outside the standard office 7.5 hour work day as required.

Experience Required:

• 5+ years IT and/or business experience

• 5+ years of experience implementing and/or supporting Oracle ERP (recent R12 experience required) in complex, multinational, multi GAAP environment.

• 2+ years’ experience of supporting OBIEE (or Siebel Analytics).

• 2+ years’ experience of supporting Oracle Financials, Procurement Analytics, Supply Chain Analytics with Oracle EBS 11i and R12 as a source.

• Experience with source system analysis and data maps linking source and target systems.

• Expert understanding of EBS/OBIEE tables and structures and BI Apps mapping.

• Experience with BI Answers and prior implementation of ad-hoc reporting for EBS.

• Ability to gather and validate functional requirements and provide the design specification for the OBIEE solution.

Preferred Qualifications and Skills

• Experience with ETL concepts and tools such as Informatica and ODI.

• Experience in implementing and deploying out-of-box OBIEE Analytics against Oracle EBS.

• Experience with Oracle APCC and EPM reporting is a plus.

• Experience with Oracle Discoverer is a plus.

• Knowledge of star schemas and dimensional design concepts a plus.

Senior Global BI Business Analyst (Oracle)

Salary range: up to $96K

Location: Cleveland, OH

Travel Required: YES - 25%

Relocation Assistance: YES