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
If an employer mentions a salary or salary range on their job, we display it as an "Employer Estimate". If a job has no salary data, Rise displays an estimate if available.
As a Senior Global Business Analyst (BI) at a world-leading coatings manufacturer in Cleveland, Ohio, you'll find yourself at the intersection of technology and business strategy. In this role, you will partner with business users and IT professionals to dive deep into reporting requirements, ensuring that you understand how to effectively extract and utilize data from Oracle EBS and BI Apps. Your analytical skills will shine as you evaluate existing BI functionality and identify gaps, collaborating with the Enterprise BI team to enhance applications' performance. Leveraging your expertise in metrics and dashboards, you'll train team members on how to make the most of BI tools to make informed decisions. Your work will be pivotal in creating specifications, building models, and developing essential reports that drive the business forward. This position offers a dynamic environment where you'll work on operational management, support BI implementations, and mentor junior analysts. Additionally, you’ll have the opportunity to travel up to 25%, enhancing your professional network and gaining insights from various business units. If you have a strong background in Oracle ERP and BI Apps, and are eager to leverage your skills in a thriving organization, this role could be perfect for you!
Subscribe to Rise newsletter