Overview
Senior Software Engineer - Database & BI at Kamayi — Dubai, United Arab Emirates. Salary: AED 10,000 – 14,000 per month Benefits: Work visa, air tickets, medical insurance, gratuity, paid time off **JOB PURPOSE** We're seeking a Senior Software Engineer – Database & BI to be deployed with our airline client, a major international airline headquartered in Dubai, to support the Reservations BI Enhancement programme. The successful candidate will design and build robust database and data integration solutions, working across complex and disparate data sources to deliver transformation, analysis, and warehousing capabilities.
Full job description
Salary: AED 10,000 – 14,000 per month
Benefits: Work visa, air tickets, medical insurance, gratuity, paid time off
JOB PURPOSE
We're seeking a Senior Software Engineer – Database & BI to be deployed with our airline client, a major international airline headquartered in Dubai, to support the Reservations BI Enhancement programme. The successful candidate will design and build robust database and data integration solutions, working across complex and disparate data sources to deliver transformation, analysis, and warehousing capabilities. The role requires strong SQL and PL/SQL expertise combined with mandatory Oracle Database experience and working knowledge of Amazon Redshift or a comparable cloud data warehouse, and the ability to generate actionable data insights for cross-functional business and IT teams.
KEY RESPONSIBILITIES
Database Design & Development: Design and build database solutions including schemas, stored procedures, and data pipelines to support reservations BI and back-office reporting requirements.
SQL & PL/SQL Engineering: Write, optimise, and debug complex SQL queries and PL/SQL procedures; apply advanced techniques for bulk data processing and performance tuning of data flows and queries.
Data Integration & Warehousing: Work with complex, disparate data sources to perform data transformation, cleansing, and analysis across Oracle and Amazon Redshift environments.
Requirements & Solution Design: Gather and analyse data integration requirements; design scalable solutions that align technical architecture with business objectives.
Reporting & Analytics: Build reports and dashboards to generate data insights; support business and IT stakeholders with timely, accurate data to drive operational decisions.
Troubleshooting & Collaboration: Identify and resolve data-related issues efficiently; collaborate with cross-functional IT and business teams to deliver shared programme goals.
REQUIRED SKILLS & EXPERIENCE
Experience 5–8 years in database engineering or data integration roles; experience delivering BI and data warehouse solutions in enterprise environments.
SQL & PL/SQL Strong skills in writing, optimising, and debugging complex SQL queries and stored procedures; experience with bulk data processing and advanced PL/SQL techniques.
Oracle Database Mandatory: hands-on Oracle Database experience including data modelling, schema design, and query optimisation. Candidates without Oracle experience will not be considered.
Redshift / Cloud DW Required: working experience with Amazon Redshift or a comparable cloud data warehouse platform (e.g., Snowflake, BigQuery); ability to optimise queries and manage data flows in a cloud environment.
Data Integration Expertise in gathering and analysing data integration requirements; ability to design and build scalable ETL/ELT solutions and data warehouse pipelines.
Performance Tuning Proven experience in performance tuning of SQL queries and data flows; ability to identify bottlenecks and implement optimisations at scale.
Big Data & Cloud Experience with Hadoop, Hive, or Spark frameworks and AWS cloud services is preferred; familiarity with cloud-based data architectures is an advantage.
Domain Airline or travel sector experience is preferred; understanding of reservations, revenue, or back- office data domains is an advantage.
Tips for this job
Practical Job and Scholarship guidance. These tips do not replace official rules or create new eligibility requirements.
- Tailor the CV and application to the responsibilities and required skills stated on the official employer page.
- Use concrete evidence of relevant work, projects and measurable results rather than generic claims.
- Confirm location, work authorization, remote restrictions and sponsorship terms before applying.
- Apply through the original employer or official recruitment destination shown on this page.
Verification notes
Imported from freehire's public, keyless open-job API after the index reported the posting open. The upstream record supplied this canonical employer, ATS, or official public-board URL; repost-only sources and protected portal URLs are excluded. No login, CAPTCHA, private candidate data, or protected job-board session was accessed.
Job and Scholarship is the discovery and verification layer. Confirm eligibility, dates, salary/funding and application instructions on the original source before submitting anything.
Kamayi Careers (Manatal) ↗Browse current Job and Scholarship listings from Kamayi Careers (Manatal) →
