Senior Database Developer Data Warehousing & BI

Role Overview

We are seeking a highly skilled Senior Database Developer to join our team, focusing on the architecture and maintenance of enterprise-grade data warehouse solutions. You will be instrumental in bridging the gap between complex backend database systems and high-impact business intelligence. The ideal candidate will excel at designing scalable data models, optimizing high-volume query performance, and maintaining robust ETL/ELT pipelines within an AWS ecosystem.

Key Responsibilities

• Database Architecture: Design, develop, test, and maintain enterprise database and data warehouse solutions that drive business intelligence, analytics, and operational reporting.
• Advanced Development: Develop, optimize, and document complex stored procedures, packages, functions, triggers, and views to support core business logic.
• Data Engineering: Build and maintain scalable ETL/ELT processes to integrate data from diverse sources, ensuring data quality, lineage, and integrity.
• Performance Engineering: Lead performance tuning, query optimization, indexing, and partitioning strategies for high-volume, mission-critical environments.
• Automation: Utilize Python and PySpark to automate database processes, data integration workflows, and monitoring solutions.
• Cross-Functional Collaboration: Partner with BI analysts, data engineers, and stakeholders to translate business requirements into technical specifications for tools such as Power BI, MicroStrategy, or Tableau.
• Production Excellence: Manage deployments, conduct rigorous code reviews, and provide 24/7 production support, including incident management, troubleshooting, and root cause analysis (RCA).
• Leadership: Mentor junior developers, contribute to technical strategy, and uphold development best practices within an Agile framework.

Nice-to-Have

• Domain Expertise: Prior experience in the airline or aviation industry (specifically dealing with PNR, booking, revenue, or flight data systems).
• Big Data: Exposure to Hive, Spark, or other distributed Big Data technologies.
• Certifications: Active AWS or Oracle Professional certifications.
• Leadership: Demonstrated experience leading technical initiatives or formal mentorship.

What We Offer

• Global Mobility: Visa sponsorship/Work Visa support for qualified candidates.
• Travel Benefits: Annual air tickets to support your work-life balance.
• Comprehensive Health: Full medical insurance coverage.
• Financial Security: End-of-service gratuity scheme.
• Time Off: Competitive paid time off and leave policies.