Job Description

Position Title: Data & Analytics Expert - Finance Systems

Reporting to: Finance Systems Team Lead

Job Group: 2B / 3

Location: Islamabad

Division: Telenor Shared Services Pakistan

Department: Finance and Procurement Tribe

Unit: Finance Systems Squad

Why you should join Telenor Shared Services Pakistan

At Telenor Shared Services Pakistan, we give you the opportunity to thrive as a skilled professional in your field. Being rated as the top employer of the country, we enable you to realize your dreams in an environment of diversity and openness to new mindsets.

About Telenor Shared Services Pakistan

Telenor Shared Services Pakistan delivers transactional business services in the areas of Finance & Accounting, HR and IT. TSS delivers efficient business support to Telenor employees to make their work easier.

Position Related

We’re looking for a Data & Analytics Expert responsible for the development and operation of data integration, data warehousing and analytics solutions on Oracle ADW, Oracle Analytics Cloud (OAC) and Oracle Data Integrator (ODI) according to the best practices and customers’ expectations. This position requires to be familiar with Agile way of work as per agile practices.

ERP at Telenor

Telenor is using cloud-based Oracle Fusion ERP to provide financial solution and having integrations with other cloud-based ERPs and Coupa. As a Data & Analytics expert you will be working closely on integrated ERP data solutions, using Oracle ADW, ODI and OAC to support Fusion ERP reporting.

Goals

• Working in cloud environment to provide support for the delivered components
• Responsible for providing technical support to different projects for implementation of data warehousing, data integration and analytics solutions on Oracle ADW, ODI and OAC
• Responsible for delivering on KPIs in Service Level Agreement (SLA) and report on performance as agreed with customers
• Responsible for operations and development of various data and reporting solutions for Finance

Your Typical Day at Work

• Design, develop and support data warehouse solutions on Oracle ADW, sourced from Oracle Fusion ERP, Oracle EBS R12.x and other systems
• Build and maintain ETL/ELT pipelines using ODI, including scheduling, monitoring and resolving load failures
• Work with multiple application teams, developers and business users to gather and deliver reporting requirements
• Develop dashboards, reports, datasets and data flows in Oracle Analytics Cloud
• Performance tuning and monitoring of ADW, ODI jobs and OAC content
• Working and following up with Oracle support
• Application/code bug fixing
• Ad hoc data extraction and reports development
• Fusion data extraction and reporting using BICC, OTBI and BI Publisher, where required

Note: Above goals and job descriptions are indicative and subject to change.

Eligibility Criteria

Education

• Bachelor’s degree or higher in IT/Computer Sciences or similar along with technical overview of Financials/SCM processes.

Work Experience

• Have 6+ years of experience in data warehousing / BI development, with hands-on work on Oracle ADW, Oracle Analytics Cloud and ODI

Skillsets

• Strong hands-on experience with Oracle Autonomous Data Warehouse (ADW): schema design, data loading, SQL/PL-SQL development and performance tuning
• Hands-on experience with Oracle Data Integrator (ODI): mappings, packages, load plans, knowledge modules, scheduling and monitoring
• Hands-on experience with Oracle Analytics Cloud (OAC): datasets, data flows, workbooks/dashboards, data actions and semantic modeling
• Advanced SQL & PL/SQL, dimensional data modeling (star schema) and ETL/ELT best practices.
• Oracle Fusion technical knowledge (added advantage): BICC, OTBI, BI Publisher, REST/SOAP APIs, ADF Desktop Integrator and Fusion data extraction
• Working knowledge of Oracle Financials, Supply Chain and Projects data (added advantage); EBS R12.2 exposure is a plus
• Relevant certification (e.g. Oracle Analytics Cloud, Autonomous Database, ODI) or experience in the tools and technologies

Functional Skills / Knowledge Areas

• Structured and self-driven, with a focus on deliverables
• Solution oriented
• Ability to work within multiple time zones and diverse culture.
• Ability to perform duties during public holidays, in shifts and off days
• Have good communication skills and proficiency in English.

Potential Career Path

• Expand and develop expertise in Oracle data and analytics (ADW, ODI, OAC) together with Oracle ERP cloud, Record to Report, Source to Pay and Order to Cash exposure in Global environment.
• Vertical growth in roles of Sr. Expert Finance Systems