Data Warehousing & DB Solutions Architect

IBS Software; Abu Dhabi; On-site; AED 246,000 - 379,000; Full time

Job summary

IBS Software in Abu Dhabi is seeking a data professional to design and build database solutions across complex data sources. You will transform data and create scalable data integration and warehouse solutions to support cross-functional business needs.

The role emphasizes SQL optimization, data modeling, and performance tuning of data flows, with hands-on experience in Oracle and Redshift. Collaboration with IT and business teams is essential to deliver reliable insights.

Qualifications

• Proficient in writing and debugging complex SQL
• Bulk data processing with SQL/PLSQL
• Data modeling and schema design
• Oracle and Redshift databases
• Data integration requirement gathering
• Ability to build reports and insights
• Troubleshoot data issues efficiently
• Performance tuning of data flows and queries
• Cross-functional collaboration
• Hadoop Hive Spark experience preferred
• AWS cloud Airlines domain experience preferred
• Design and build data warehousing solutions
• Work with diverse data sources and transformations

Responsibilities

• Design and build database solutions.
• Work with diverse data sources and perform transformations.
• Collaborate with IT and business teams to deliver goals.
• Create scalable data integration and warehouse solutions.
• Build reports and deliver data insights.
• Tune and optimize data flows for performance.

Skills

SQL Queries

Stored Procedures

Bulk Data Processing

Data Modeling

Oracle & Redshift

Data Integration

Reporting & Analytics

Performance Tuning

Hadoop Spark

AWS Cloud

Tools

Oracle

Amazon Redshift

Job description

IBS Software in Abu Dhabi is seeking a data professional to design and build database solutions across complex data sources. You will transform data and create scalable data integration and warehouse solutions to support cross-functional business needs.

The role emphasizes SQL optimization, data modeling, and performance tuning of data flows, with hands-on experience in Oracle and Redshift. Collaboration with IT and business teams is essential to deliver reliable insights.