Senior Business Intelligence Specialist

Pegasus Hava Taşımacılığı A.Ş.

ABOUT PEGASUS AIRLINES

Pegasus Airlines, Turkey’s leading low-cost airline, has transformed the aviation sector in the country with an experienced team of over 6,000 and by offering its guests affordable and quality services together with a flawless security record.

Believing it’s everyone’s right to fly, Pegasus offers its guests low fares, on-time departures, and new more comfortable aircraft as part of its “low-cost airlines” model. Pegasus Airlines flies to 110 destinations on its ever-growing network in 42 countries including 35 domestic and 75 international destinations. Pegasus has Turkey’s youngest fleet with an average age of 5.3 years old and average on-time departure performance of 87.74% in 2019 Q2. Pegasus Airlines is the first airline to have been admitted to the state-subsidized brand-building program Turquality.

Now, we are seeking a Senior Business Intelligence Specialist to join our team!

QUALIFICATIONS

• Graduated from Computer Engineering, CTIS, MIS and relevant departments of universities
• Excellent written and verbal communication skills both in Turkish and English
• At least 5 years of proven experience in Data Warehouse, ETL, Reporting Visualization & Analytics
• Good knowledge and practice in PL/SQL (as in stored procedures and package compilation), hands on development experience in Cognos BI, Power BI and relevant reporting and visualization tools. Professional expertise and experience on software development with Oracle DB
• Experience in at least one of the ETL tools like Talend, ODI, etc
• Experience in IBM Cognos Planning Analytics (TM1) (preferable)
• Experience with R and Python (preferable)
• Analytical approach and good problem-solving skills
• Team player who builds success together
• Strong in research
• No military obligation for male candidates
• Preferably residing in Asian side of İstanbul

JOB DESCRIPTION

• To carry out system analysis of business intelligence projects
• Being responsible for the technical/data architect of one or more subject areas (Datamarts) according to the size of the project
• Being responsible for designing database and data structures in project teams preparing E-R diagrams and documentation for this purpose
• To carry out tasks for ETL processes, report design & development, accordance with the project plan and time plan
• Performs tests for the performance of the reports, SQL Queries and ETL processes to ensure they use the system resources effective and suggest improvement actions and coordinates them with the manager or project manager
• To follow new technologies in aviation, business intelligence & analytics