Oracle Field Service (OFS) Data Integration & Power BI Specialist

Zoondia Software Pvt Ltd; Kozhikode district; On-site; INR 900,000 - 1,300,000; Full time

Job summary

Zoondia Software Pvt Ltd in Kerala is seeking an experienced Oracle Field Service Data Integration & Power BI Specialist to design and maintain an end-to-end reporting solution for OFS. You will work with OFS APIs, data extraction, integration, and automated ETL/ELT pipelines to deliver actionable dashboards.

You will build Power BI reports, ensure data accuracy and historical tracking, and collaborate with OFS specialists to optimize data flows and plugin options where appropriate.

Qualifications

• Strong SQL and relational DB development skills.
• Experience with data warehouses, ETL/ELT, and data modelling.
• Hands-on ETL/ELT process development and automation.
• Advanced Power BI skills including data modelling and DAX.
• Knowledge of Oracle Field Service APIs, data structures, and limitations.
• Understanding of field service operations and reporting requirements.

Responsibilities

• Analyze OFS data structures, REST APIs, XML interfaces, and data extraction options.
• Develop automated data extraction, transformation, and synchronization processes.
• Build Power BI dashboards, KPIs, and operational reports.
• Ensure data accuracy, historical tracking, and reporting performance.
• Collaborate with OFS functional specialists to identify data and integration approaches.
• Assess feasibility of embedding dashboards or OFS plugins based on capabilities.

Skills

SQL

Data warehouse design

ETL/ELT

Power BI

Oracle Field Service APIs

Data modelling

REST APIs

Job description

Oracle Field Service (OFS) Data Integration & Power BI Specialist

About the Role

Zoondia is looking for an experienced Oracle Field Service (OFS) Data Integration & Power BI Specialist to develop and maintain an end-to-end operational reporting solution for Oracle Field Service.

The ideal candidate will have strong expertise in Oracle Field Service APIs, data extraction, integration, transformation, and reporting. You will be responsible for building structured data warehouses, developing automated ETL/ELT processes, and creating interactive dashboards using Power BI to support operational decision-making.

Key Responsibilities

• Analyze Oracle Field Service data structures, REST APIs, XML interfaces, and available data extraction mechanisms.
• Develop automated data extraction, transformation, and synchronization processes.
• Build Power BI dashboards, KPIs, operational reports, and analytical insights.
• Ensure data accuracy, consistency, historical tracking, and reporting performance.
• Collaborate with Oracle Field Service functional specialists to identify available data, API limitations, and suitable integration approaches.
• Assess the feasibility of embedding dashboards or using Oracle Field Service plugins where required, based on supported capabilities.

Mandatory Skills & Experience

• Strong SQL and relational database development experience.
• Hands-on experience with data warehouse design, ETL/ELT, and data modelling.
• Experience developing ETL/ELT processes and automated data extraction.
• Strong Power BI skills, including data modelling, DAX, and dashboard development.
• Working knowledge of Oracle Field Service, its data structures, APIs, and technical limitations.
• Understanding of field service operational processes and reporting requirements.

Preferred Qualifications

• Previous experience delivering reporting solutions for Oracle Field Service Cloud.
• Knowledge of Oracle Database, PL/SQL, Oracle Integration Cloud (OIC), or other integration platforms.
• Familiarity with Power BI Service, scheduled refreshes, and data warehouse concepts.
• Assessment of OFS data availability, APIs, extraction options, and limitations.
• Recommended reporting architecture and data flow.
• Automated data extraction and transformation processes.
• Reporting data model and operational dashboards.
• Technical documentation and a maintainable reporting solution.

Why Join Zoondia?

Be part of a technology-driven team where you can work on practical enterprise technology challenges, build scalable data solutions, and contribute to meaningful digital transformation initiatives.