The Data & Analytics Expert - Finance Systems will play a critical role in developing and operating data integration, warehousing, and analytics solutions using Oracle Autonomous Data Warehouse (ADW), Oracle Analytics Cloud (OAC), and Oracle Data Integrator (ODI). Reporting to the Finance Systems Team Lead, this position is based in Islamabad within Telenor Shared Services Pakistan’s Finance and Procurement Tribe. The role involves working closely with cloud-based Oracle Fusion ERP and other integrated ERP systems to support financial reporting and analytics. The ideal candidate will be experienced in Agile methodologies and able to manage multiple stakeholders while ensuring high-quality data solutions that meet business needs.
Key Responsibilities
- Design, develop, and maintain data warehouse solutions on Oracle ADW, integrating data from Oracle Fusion ERP, Oracle EBS R12.x, and other sources.
- Build and manage ETL/ELT pipelines using Oracle Data Integrator (ODI), including scheduling, monitoring, and troubleshooting data loads.
- Collaborate with application teams, developers, and business users to gather requirements and deliver reporting solutions.
- Develop dashboards, reports, datasets, and data flows within Oracle Analytics Cloud (OAC).
- Perform performance tuning and monitoring of ADW databases, ODI jobs, and OAC content to ensure optimal operation.
- Provide technical support for data warehousing and analytics projects, adhering to Service Level Agreements (SLAs) and reporting on KPIs.
- Address application and code bugs and handle ad hoc data extraction and report generation requests.
- Extract and report Fusion ERP data using BICC, OTBI, and BI Publisher as needed.
- Liaise with Oracle support for issue resolution and system enhancements.
Required Qualifications
- Bachelor’s degree or higher in IT, Computer Science, or a related field, with a technical understanding of financial and supply chain management processes.
- Minimum of 6 years of hands-on experience in data warehousing and business intelligence development, specifically with Oracle ADW, Oracle Analytics Cloud, and Oracle Data Integrator.
- Strong expertise in Oracle Autonomous Data Warehouse, including schema design, data loading, SQL/PL-SQL development, and performance tuning.
- Proficient in Oracle Data Integrator for creating mappings, packages, load plans, and scheduling.
- Skilled in Oracle Analytics Cloud for developing datasets, data flows, dashboards, and semantic models.
- Advanced knowledge of SQL and PL/SQL, dimensional data modeling (star schema), and ETL/ELT best practices.
- Excellent communication skills with proficiency in English and ability to work across multiple time zones and diverse cultures.
- Self-driven, structured, and solution-oriented with the flexibility to work shifts, including public holidays and off days.
Preferred Qualifications and Benefits
- Experience with Oracle Fusion technical tools such as BICC, OTBI, BI Publisher, REST/SOAP APIs, and ADF Desktop Integrator is an advantage.
- Familiarity with Oracle Financials, Supply Chain, and Projects data, as well as exposure to Oracle EBS R12.2, is beneficial.
- Relevant certifications in Oracle Analytics Cloud, Autonomous Database, or ODI are highly desirable.
- Opportunity for vertical career growth into senior expert roles within Finance Systems.
- Gain exposure to global environments and expand expertise in Oracle ERP cloud modules including Record to Report, Source to Pay, and Order to Cash.
Joining Telenor Shared Services Pakistan offers a dynamic and inclusive work environment recognized as one of the country’s top employers, fostering professional growth and innovation in finance systems and analytics.