Senior BI Engineer

Facilitative Employment Services - Kamayi; Dubai; On-site; AED 576,000 - 720,000; Full time

Benefits offered by this job

Work visa

Air tickets

Medical insurance

Gratuity

Paid time off

Job summary

Facilitative Employment Services - Kamayi seeks a Senior BI Engineer to design and implement robust database solutions for a major airline. You will work with large datasets to transform, analyze and build scalable data integration and warehousing systems.

The role requires 5-7 years of hands-on experience with PL/SQL and MicroStrategy, plus strong SQL, data modeling and cloud-based data infrastructure skills. On-site position at client premises in Dubai, UAE with visa and full benefits.

Qualifications

• 5–7 years of relevant BI/ETL experience.
• Experience with PL/SQL and MicroStrategy.
• Experience with data warehousing and large-scale data sets.

Responsibilities

• Design and implement robust database solutions for complex data needs.
• Develop data integration and warehousing for diverse sources.
• Transform and analyze data to support scalable BI solutions.
• Collaborate with IT and business units to deliver projects on time.
• Optimize queries and ETL processes for performance.

Skills

PL/SQL

SQL

Data modeling

Performance tuning

ETL concepts

Tools

MicroStrategy

Amazon Redshift

Oracle DB

AWS Cloud

Hive/Spark

Job description

Senior BI Engineer (PL/SQL & MicroStrategy)

Location: Client Premises Dubai UAE

Salary: AEDper month

Benefits:

• Work visa
• air tickets
• medical insurance
• gratuity
• paid time off

Experience Required: Minimum 5 to 7 years of relevant work experience

This role is critical for designing developing and implementing robust database solutions for a major international airline. You will work with complex data sets to transform analyze and build scalable data integration and warehousing systems. The position requires close collaboration with various IT and business departments to achieve project objectives.

Key Responsibilities

• Database Solution Design: Design and build advanced database solutions to meet evolving data requirements.
• Data Integration & Warehousing: Develop and implement data integration and warehousing solutions for complex disparate data sources.
• Data Transformation & Analysis: Perform comprehensive data transformation and analysis on large- scale datasets.
• Collaborative Delivery: Collaborate effectively with cross-functional teams to deliver common project goals.
• Performance Optimization: Optimize database queries and ETL processes for maximum efficiency and scalability.

Required Skills & Experience

• Core Expertise: 5-7 years hands‑on experience with PL/SQL and Amazon Redshift.
• BI Platform Proficiency: Demonstrated experience with MicroStrategy BI platform development and implementation.
• Advanced SQL/PL/SQL: Strong skills in writing optimizing and debugging complex SQL queries and stored procedures.
• Data Modeling: Proficiency in data modeling schema design and query optimization on Oracle and Redshift.
• Cloud & Big Data: Experience with Amazon Cloud Services (AWS) and a preference for Hadoop Hive or Spark frameworks.
• Domain Knowledge: Prior experience within the airline domain is highly preferred.