Power BI Developer (Oracle EBS)

Introduction Our client requires a dedicated Microsoft Power BI Developer to design, develop, test, and implement a new suite of financial reporting solutions. The required reports are brand-new developments, with no existing Power BI reports currently available for these requirements. The development will cover Finance Annual Performance Plan (APP), Strategic Performance Plan (SPP) Monthly Reporting, and Treasury Reports , providing stakeholders with accurate, timely, and interactive financial insights. The Power BI Developer will be responsible for developing these reports from the ground up, including data integration, dataflows, data transformation, data modelling, DAX calculations, KPI development, visualisations, testing, validation, and deployment to the Power BI Service, in alignment with client’s business, technical, data governance, security, and architectural requirements. The specialist will be responsible for the development and implementation of the following solutions: 1. APP Finance KPI and SPP Monthly Reports: Development of approximately 20 new Power BI reports covering Finance Annual Performance Plan (APP) and Strategic Performance Plan (SPP) Monthly Reporting , including KPI-specific calculations, business rules, DAX measures, data models, and interactive visualisations to provide accurate and timely performance insights. 2. Treasury Reports: The Power BI solution will comprise approximately 10 new Treasury reports covering Treasury Operations, Cash Management, Investment Tracking, and Risk Analytics , including relevant financial calculations, KPIs, business rules, data models, and interactive visualisations to provide accurate, timely, and actionable financial insights. 3. Dataflows and Automated Data Preparation: Development of new Power BI dataflows to source, transform, cleanse, and prepare the required data for the reports. Automated refresh processes will be implemented to ensure that the APP Finance KPI and Treasury reports are automatically updated with the latest available data, eliminating the need for manual data updates. 4. Testing, Validation and Deployment: Perform data reconciliation, KPI validation, testing, UAT support, performance optimisation, and deployment of the completed APP Finance KPI and Treasury reports, semantic models, and dataflows to the Power BI Service. The final solution will provide automated data refresh and reporting, ensuring that both APP Finance and Treasury reports remain current without manual intervention. The successful Microsoft Power BI Developer must have strong hands-on experience in Microsoft Power BI development, including Power BI Desktop, Power BI Service, Power Query, DAX, data modelling, dataflows, and integration with relevant data sources such as Oracle EBS, Oracle databases, SQL Server, and other enterprise systems. The specialist must ensure all solutions comply with client’s technical, data governance, security, reporting, and BI architectural standards. Job Description Business Requirements: Finance Annual Performance Plan (APP) and Strategic Performance Plan (SPP) – Power BI Reporting Requirements: The purpose of this project is to automate the collection, consolidation, validation, analysis, and reporting of Finance Annual Performance Plan (APP) and Strategic Performance Plan (SPP) monthly performance information using Microsoft Power BI. The solution will replace the existing manual and spreadsheet-based reporting processes with a centralised, automated, transparent, and auditable reporting platform. It will provide management with timely visibility of performance against approved APP and SPP targets and enable effective monitoring of performance trends, variances, risks, and areas requiring management attention. Business Requirements: • Automate Finance APP and SPP monthly performance reporting using Microsoft Power BI. • Replace manual spreadsheet-based reporting with a centralised and standardised reporting solution. • Provide a single source of truth for APP and SPP performance information. • Integrate APP and SPP data from approved source systems and files. • Develop Power BI dataflows and semantic models to support the reporting requirements. • Automate data extraction, transformation, validation, and scheduled refresh processes. • Develop approximately 20 APP Finance KPI reports based on approved business requirements and KPI definitions. • Develop SPP Monthly Performance reports covering strategic objectives, indicators, and targets. • Implement approved KPI calculations, business rules, and performance measures. • Provide actual versus target, variance, achievement, and performance status reporting. • Provide historical, monthly, year-to-date, and trend analysis. • Develop interactive APP and SPP management dashboards with appropriate filtering and drill-through functionality. • Implement appropriate security, access controls, and data governance requirements. • Deploy the reports, semantic models, and dataflows to the Power BI Service. • Minimise manual intervention by providing automated report updates and timely access to the latest approved performance information. 2. Treasury Power BI Reporting Requirements: The purpose of the project is to develop an automated Microsoft Power BI reporting solution for the Treasury and Investment Department, providing timely and interactive visibility into cash management, cash flow, investments, credit cards, suspense accounts, bank accounts, liquidity, and financial risk. The solution will consolidate information from relevant sources, including Oracle, ITS, and Visa Spend, into centralised Power BI reports and dashboards. Treasury Reports: 1. Cash Management Report 2. Monthly Cash Flow Report 3. Monthly Cash Flow Report 4. Investment Portfolio Performance Report 5. Credit Card Summary Report 6. Credit Card Transgression Listing Report 7. Credit Card Monthly Spend per Classification Report 8. Credit Card Outstanding Allocations Report 9. Allocated Bank Accounts Report 10. Suspense Account Balance and Age Analysis Report 11. Bank Account Balance and Analysis Report 12. Executive Treasury Dashboard Business Requirements: • Develop a centralised Power BI reporting solution to support Treasury and Investment operations. • Provide visibility of cash positions across bank accounts, entities, and reporting periods. • Provide weekly, monthly, quarterly, and annual analysis of cash inflows, outflows, and cash flow movements. • Provide visibility into investment balances, returns, yields, valuations, and portfolio performance. • Provide monitoring of liquidity positions, available cash, projected cash requirements, and liquidity risks. • Provide analysis of credit card expenditure, spending trends, classifications, and outstanding allocations. • Identify and monitor credit card transactions that do not comply with approved policies and requirements. • Provide visibility of suspense account balances, outstanding items, movements, and ageing. • Provide analysis of bank account balances, allocations, transactions, and account movements. • Provide an executive-level view of key Treasury KPIs, financial metrics, risks, and exceptions. • Integrate relevant data from Oracle, ITS, Visa Spend, and other approved source systems. • Implement data validation and reconciliation processes to ensure accurate and reliable Treasury information. • Automate data extraction, transformation, reporting, and scheduled data refreshes to minimise manual intervention. • Enable interactive filtering, drill-down, and drill-through from summary information to detailed transaction-level data. • Provide a single source of truth with timely, consistent, and actionable Treasury information to support management decision-making. Resource Requirements: (Microsoft Power BI Senior Developer) • Design and develop scalable, secure, and high-performing Power BI solutions aligne