Oracle Fusion Financial Technical Consultant

Job Description

Job Description 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 Required Knowledge, Skills and Experience: 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 Suitewith 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) Preferred Qualifications: Oracle Cloud Financial Certification Physical Requirements Work is primarily performed at a desk and/or in an office environment for 3/4 of the day and up The office noise level in the work environment is typically, moderate Generally, spend the workday sitting at a workstation and operating computer devices, such as, but not limited to keyboard, mouse, and screen Generally, spend the workday performing repetitive motions that involve or affect the hands, head, and other parts of your body