Job
Description
Role & responsibilities Generating data and reporting requirements to support solution design and future business requirements Build Oracle BI Publisher (BIP) reports using data models. Assist with data mapping between Oracle Fusion data tables and current database table structures in Snowflake Create business reports, info tiles, and related dashboards with Oracle Fusion Design and implement custom reports using Oracle Fusion reporting tools to address company needs and business requirements Maintain expert product knowledge and use an analytical approach to identifying opportunities for enhancements; understand the Oracle out-of-the-box standard reporting options Create documentation and maintain custom reports, dashboard, and info tiles throughout quarterly upgrades; develop test scripts and manage execution Create and maintain standards and controls around productivity metrics and reporting for consistency across the department; maintain documentation for report creation and procedures Monitor and analyze key performance indicators to assess reports, performance, user engagement, and impacts on business outcomes Assist users with personalization, mobile features, report scheduling, and processing Preferred candidate profile 3-5 years of experience in Oracle Cloud ERP Financials applications, including General Ledger, Payables, Expenses, Assets and Receivables Hands-on experience in building Oracle BIP, OTBI reports, and Analysis reports using data models. Proficiency in creating templates such as RTF, eText, Excel, etc. Expertise in Oracle technologies such as OTBI, BIP/XML Publisher, SQL, PL/SQL, and Oracle Reports Experience in customizing reports using BI templates. Familiarity with using SOAP UI Bachelors degree in finance, Accounting, IT, Computer Science or related field Excellent problem-solving skills with experience in solutioning and troubleshooting Strong analytical skills and ability to think in a complex and rapidly changing environment Excellent oral and written communication and interpersonal skills, with the ability to effectively collaborate with diverse stakeholders, both technical and non-technical Extensive experience in working with reporting software, including knowledge of SQL and basic table structures Strong business acumen and the ability to translate business requirements into technical specifications and vice versa Deep understanding of corporate reporting standards Project management skills to coordinate and oversee reporting strategies for current and future implementations Training and presentation skills to effectively educate and support employees in utilizing the dashboards, info tiles, and reports Analytical mindset and problem-solving abilities to identify process inefficiencies and propose effective solutions Proficient in Office 365 Suite with emphasis on Microsoft Excel Proficiency in data analysis tools (e.g., Sigma, Python, R, SQL) and data visualization tools (e.g., MicroStrategy, Tableau, Power BI)
