67-62-28

Company Description

Porter Airlines has revolutionized short-haul flying with a warm and effortless approach to hospitality, restoring glamour and refinement to air travel. Porter is an Official 4 Star Airline® in the World Airline Star Rating® and also rated as Best Regional Airline in North America by Skytrax.

The airline currently offers flights to Toronto, Ottawa, Montreal, Quebec City, Fredericton, Saint John, Moncton, Halifax, St. John’s, Thunder Bay, Sault Ste. Marie, Sudbury, Timmins, Windsor, New York (Newark), Chicago (Midway), Boston, and Washington (Dulles), and has seasonal flights to Mt. Tremblant, Que., Stephenville, N.L., Myrtle Beach, S.C., Burlington, Vt., and Orlando-Melbourne, Fla

Job Description

FUNCTION:

Data is one of the key contributors in driving efficiencies, performance and growth. Do you enjoy collecting, transforming and making data available for analysis and business goals? Have you worked with business groups to improve data processes to help them get the data they need for their analysis? This position is a key implementer of designing, developing and expanding the use of data across Porter using ETL and DI processes, data warehousing and big data techniques.


DUTIES AND RESPONSIBILITIES:

  • Work with business groups  to define and document requirements
  • Maintain and support multiple projects and deadlines, working with project managers to establish timelines and effort
  • Document  the structure, business processes and requirements for the  data processes, databases and data warehouse
  • Design, develop and maintain ETL and data integration processes for internal and external systems
  • Design, develop and maintain subject  areas in the data warehouse
  • Prototype and develop new and innovative ideas with big data, real-time data collection and data analysis
  • Responsible for analyzing and improving data quality and integrity in the data warehouse
  • Analyze the strengths and weaknesses of Porter’s data processes and provide recommendations for improvement
  • Mentoring junior team members on best practices for data processes and the data warehouse
  • Provide occasional support for data processes after hours and weekends
  • Any other duties as requested by the Director

BEHAVIOURAL COMPETENCIES:

  • Concern for Safety - Identifying hazardous or potentially hazardous situations and taking appropriate action to maintain a safe environment for self and others.
  • Teamwork - Working collaboratively with others to achieve organizational goals.

  • Customer Service - Providing service excellence to internal and/or external customers (passengers).

  • Initiative - Dealing with situations and issues proactively and persistently, seizing opportunities that arise.

  • Results Focused - Focusing efforts on achieving high-quality results consistent with the organization’s standards.
  • Fostering Communication - Listening and communicating openly, honestly, and respectfully with different audiences, promoting dialogue and building consensus

QUALIFICATIONS:

  • Post-secondary degree in Computer Science, Mathematics, Engineering or similar degree preferred
  • Expert  knowledge of database design, data warehouse methodologies and data techniques
  • 7+  years of experience developing data integration and ETL processes
  • 7+ years of experience designing and developing data and data warehouse solutions
  • Exceptional analytical and problem-solving skills
  • Excellent SQL experience with multiple  database systems such as SQL Server, MySQL, PostgreSQL , Redshift or similar
  • Excellent written and verbal communication skills, to communicate with business stakeholders, project teams and project managers
  • Experience with various SDLC methodologies and requirements gathering
  • Experience with distributing data systems
  • Experience in the airline industry is an asset

TECHNICAL SKILLS:

  • 5 + years of experience in developing and maintaining data integration (ETL) processes using tools such as Microsoft SSIS, Pentaho, Matillion or other open source products
  • 5 + years of experience using open source programming languages such as Python
  • 5 + years of experience using SQL Server, PostgreSQL, MySQL or similar databases
  • 2 + years  designing and developing data pipelines
  • Experience with Amazon Web Services (AWS) products and services, especially Redshift, Kinesis, Lambda, EMR, RDS or other cloud services
We are sorry, but this opportunity is no longer available.
Close button
Content Loading