Lead Technical Subject Matter Expert - Database / SQL

Lead Technical Business Systems Analyst 

CAE Flight Operations Solutions is an industry-leading digital platform trusted by the world’s top airlines and business aviation companies to optimize their operations. ✈ Every year, more than 50 million flights and over 200,000 crew members are supported by CAE's flight operations software backed by a global team and unparalleled expertise.

Spanning crew, flight, movement, airport, on-board catering, and cost management, CAE's customizable end-to-end solution improves decision making by harnessing the power of integrated data and advanced technologies to improve operational performance, profitability, employee satisfaction and passenger experience.

Lead Technial Business Systems Analyst specializes in implementing, upgrading and migrating CREW products and other airline operations management solutions / modules as part of the CREW Manager suite for various airlines across the world. CAE Delivery Team is spread across the globe, presence in Dallas, Montevideo, Bangalore, Krakow, Shangai. This member applies advanced skills and concepts to oversee large, complex projects.  

The role we are offering you: 

• Be responsible for planning, conducting and directing the analysis of highly complex business problems to be solved with automated systems, cross-functions and cross business domain within the aviation flight crew area. 
• Work on high value (revenue) projects with large scale customer impact and able to operate under limited direction and minimal oversight. Delineate requirements to solve complex business problems using differing technologies and systems views across multiple functional domains (within company and between company and its customer) on high profile and/or mission critical efforts and projects. 
• Create Business Plans/supports (including business cases) to assure plans meet company goals and integrates these with technical programs and project plans. 
• Support Development staff by assisting with functionality questions, addressing testing issues, training on new products and all delivery planning aspects for deployment of a service or product, as assigned. 
• Provide guidance and direction to less experienced business systems analysts. 
• Be responsible to install software, conduct data migration, setup integration, documentation 
• Identify areas where technical solutions would improve business performance. 

Our ideal candidate has: 

• DBMS experience Oracle, MongoDB 
• Strong competency and experience in writing DB queries using SQL or PL/SQL 
• Knowledge on integration and web services e.g. SOAP, XML, JSON , Postman 
• Some experience working with global team and customers 
• Willingness to travel 30% of the time 

In addition to the following experience, nice to have: 

• Ability to solution complex system integration and ETL processes 
• Knowledge on cloud technology, e.g. AWS 
• Experience with installations of applications in Unix or Windows 
• Knowledge and experience of any programming languages e.g. Java, Python 
• Experience with training/demo to internal teams or customer 
• Hands on experience/expertise in the Crew Management area – either worked in airline in scheduling, training, tracking, IT or the end-to-end implementation of crew enterprise

CAE offers:

• an environment where your initiatives will be recognized and valued.
• the opportunity to travel internationally.
• the opportunity to work on a variety of projects on a multidisciplinary team.
• the opportunity to represent the organization at external conventions and conferences.
• the possibility to work from home occasionally.
• flexible schedules.
• attractive employee benefits.

👉 Come share your passion with us!

With over 13,000 employees in more than 40 countries, CAE is a global leader in training for the civil aviation, defence and security, and healthcare markets. To learn more: www.cae.com.