_{17th April, 2025}

Nationality: Omani
Location: Muscat, Oman
Reports to: Data Management Lead
 
Job Purpose:
This role is responsible for managing and maintaining data management related technologies used for ongoing operations and support such as data quality, ETL, data integration, master data management and data warehouse environments, ensuring agreed service levels are met.
 
Key Responsibilities:
 
Administration activities:
 

• Managing day-to-day administration for data management technologies such as (SSIS, MDS, MDM, KAFKA, Python, Data Lake).
• Managing the implementation of data management application(s) upgrades, infrastructure changes, and/or data migrations.
• Plan for and schedule installation, configuration, and deployment activities, organize/execute functional, data integrity, and integration.
• Manage and support in Installing, configuring, maintaining, patching, and upgrading data management application activities
• Monitor data management applications
• For given scope, ensure Service Level Agreement(s) (SLAs) are met, Key Performance Indicators (KPIs) are delivered, applicable ITIL processes are followed, and critical business needs are responded to appropriately.
• Build and maintain relationships with business resources, peers within IDD, and key service provides.
• Enforce HSE, IRM, and all other compliance requirements across the team.
• Document application functionalities, processes and user & maintenance procedures.

 
Extract, Transform, Load activities:
 

• Responsible for development of ETL/replication solutions using Microsoft SQL Server Integration Service (SSIS), Kafka, PySpark and setup of processing structures in order to facilitate periodic (monthly/daily/realtime) loads.
• Responsible for supporting the ETL and data replication processes that continuously collect data from multiple client, and subsequent integration of data into client repositories.
• Provider support in maintaining data integration pipelines. Proactively manage and monitor data integration/orchestration flows, and scheduled tasks.
• Responsible for optimizing performance to support near real time data processing.
• Gather requirements related to either system and/or process change(s) by meeting with customers and listening actively.
• Help data warehouse end-users understand and query data to fulfill their business needs.
• Responsible for implementing data validation based on business requirements.
• Provide highly-responsive analysis of issues to diagnose and resolve with sense of urgency.
• Work collaboratively as part of the DM team.

 
 
Enterprise Data Quality activities:
 

• Support the business in conducting data quality profiling using using Microsoft SQL Server Integration Service (SSIS), Kafka, PySpark and Information Quality Metrics.
• Support the business in Implement data quality rules for standardizing and cleansing data.
• Perform business requirement gathering.
• Support the business in generateing data quality reports.
• Document test plans and integration plans, and take the lead to perform these tests.

 
Key Requirements:
 

• Graduate in Computer Science or related with min 7+ years experience.
• Knowledge of E&P processes and data and information management
• Experiance in Microsoft SQL Server 2019
• Experience in SSIS administration
• Experience in Data warehouse and data lake environments
• Experience in Linux administration
• Experience in SQL, SQL scripting
• Experience in PySpark scripting
• Experience in Kafka administration
• Organizational and problem-solving skills

 
 

Apply For Job