SCOPE OF WORK / DUTIES / ROLES

Under the general direction of the BI Service Delivery Manager and Technical Lead, the incumbent will perform duties such as the following functions:

Power BI Integration:

• Proficiently manage Power BI Report Server and Power BI Desktop proficient, including setup, configuration and optimization;
• Write SQL and integrate various data sources (including Oracle) in Power BI;
• Develop and publish interactive dashboards and reports in Power BI;
• Create and maintain data models in Power BI;
• Utilize DAX (Data Analysis Expressions) for advanced data analysis and calculations;
• Ensure data accuracy, consistency, and security within the Power BI environment;
• Troubleshoot activities and resolve issues related to Power BI Report Server and Power BI Desktop.

Oracle Expertise:

• Identify data objects from OBIA data warehouses and data marts;
• Perform data extraction, transformation, and loading (ETL) processes;
• Troubleshoot and resolve OBIA-related issues;
• Integrate data from multiple sources, including flat files, APIs, and other databases, into Oracle Data Base;
• Write SQL and optimize database queries, ODI mappings, and ETL processes for performance and scalability (including OBIA);
• Stay current with the latest OBIA best practices and technologies.

Consulting & Project Management:

• Conduct data analysis and requirements gathering sessions with clients;
• Provide expert consultation on data warehousing, business intelligence, and data visualization best practices;
• Communicate effectively with clients and stakeholders;
• Manage project timelines, budgets, and deliverables.