Porter Airlines Logo

Intermediate Data Integration Specialist (ETL Developer)

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®.

The airline currently offers flights to Toronto, Ottawa, Montreal, Quebec City, Fredericton, Saint John, Moncton, Halifax, St. John’s, Stephenville, N.L., 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., Myrtle Beach, S.C., Burlington, Vt., and Orlando-Melbourne, Fla.

Job Details

FUNCTION:

Do you like developing data processes to manage billions of records from many different systems and applications?  Have you built databases and ETL processes on cloud computing platforms?

The data integrator role is a key contributor and solution provider on our big data challenges, expanding the data warehouse and providing data across porter for applications and analytics.  The role will use many existing and new products offered by AWS and Google to advance the use of data at Porter.

DUTIES AND RESPONSIBILITIES:

  • Develop and maintain ETL and data integration processes between internal and external systems
  • Expand and enhance the data areas in the data warehouse
  • Responsible for improving data quality and integrity in the data warehouse
  • Work with business groups to define and document requirements for data projects
  • Provide guidance and assistance to business and technology groups on their data needs
  • Maintain and support multiple projects, working with the technology teams, project managers, and business groups
  • Actively participate in Porter’s Safety Management System(SMS) including, reporting hazards and incidents encountered in daily operations; understand, comply with and promote Company Safety Policy
  • Provide support for data processes after hours when needed
  • 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.
  • Passenger/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 Focus: 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
  • Excellent knowledge of database design, data warehouse methodologies, and data techniques
  • 3 to 5 years of experience developing data integration and ETL solutions
  • 3 to 5 years of experience designing and developing big data or data warehouse solutions
  • Experience with AWS products and services including S3, RDS, Lambda, Redshift, Kinesis, Sagemaker, Athena, EMR
  • Experience with Google products and services including Drive, Docs, Sheets, Slides
  • Exceptional analytical and problem-solving skills
  • Excellent SQL experience with cloud-based database systems such as AWS Redshift and Google BigQuery
  • 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 in the travel or airline industry is an asset

TECHNICAL SKILLS:

  • 3 + years of experience developing data integration (ETL) processes using tools such as Matillion, Microsoft SSIS, Pentaho, Talend
  • 3 + years of experience using open source programming languages such as Python, Scala, or R
  • Experience analyzing data using Google Sheets or Excel
  • Experience with Amazon Web Services (AWS) products and services, especially Redshift, Kinesis, Lambda, EMR, or RDS
  • Experience working with big data technologies and tools such as Hadoop or Spark

  • October 5, 2018
  • 40-27-69

Instructions

Please fill out your contact information below before proceeding.

Link your social profiles (optional)
Select
  • Powered by rivs.com

    By applying to a job using rivs.com you are agreeing to comply with and be subject to the rivs.com Terms and Conditions for use of our website. To use our website, you must agree with the Terms of Service and both meet and comply with their provisions.

  • * required field
Close button
Content Loading