Apply now »

ETL Engineer

Canadian Pacific (CP) and Kansas City Southern (KCS) are now CPKC. As the only truly North American railway, we are making big moves! Drawing on our strong foundations and heritage, CPKC moves essential goods across our 20,000-mile network to support economic growth throughout Canada, the U.S. and Mexico. Be a part of history as we connect a continent and create exciting career opportunities across our new transnational network. Visit cpkcr.com to learn about the CPKC advantage, our purpose and culture.

 

PURPOSE OF THE POSITION:

As an ETL Engineer, you will be responsible for data integration using Power Center, IICS Data Integration, and IICS Application Integration. In addition to developing ETL workflows, you will also apply your data engineering skills to design, build, and optimize data pipelines and workflows for efficient data processing and analysis. Collaborating with cross-functional teams, you will ensure seamless data integration and drive data-driven insights for business decision-making.

 

POSITION ACCOUNTABILITIES:

  • Utilize Power Center, IICS Data Integration, and IICS Application Integration to perform data integration tasks
  • Develop and maintain ETL workflows, adhering to team standards for naming, promotion, data flow, documentation, and code repository
  • Design, build, and optimize data pipelines and workflows for efficient data processing and analysis
  • Collaborate closely with project teams, including Business Analysts, Solution Architects, Project Managers, Application Developers, and BI Developers
  • Collaborate with operational teams such as DBAs, Service Operations Center, BI developers, and SAP developers
  • Participate in peer reviews of Informatica workflows and production deployments
  • Perform data modeling, logic development, performance tuning, scheduling, and validation of data flows
  • Provide immediate incident resolution for data, performance, and integration problems.
  • Conduct incident follow-up with root cause analysis and manage incident change release and dev/acceptance reconciliation
  • Maintain and provide support for Informatica and Linux middleware, including patching, installations, shell scripting, updates, and configuration
  • Stay updated with emerging trends in data management, ETL, and data engineering
  • Availability to provide 24/7 on-call support (on rotation basis)

 

POSITION REQUIREMENTS:

  • Bachelor’s degree in Computer Science, Information Systems, or equivalent education or work experience
  • 5+ years’ experience in ETL development
  • 5+ years’ experience with SQL and scripting skills for data manipulation and transformation
  • 3+ years’ experience with big data patterns, data modeling (Star, Snowflake, Relational), NoSQL, and data engineering concepts
  • 3+ years’ experience with database systems, including Oracle or SQL Server
  • 3+ years’ experience in data pipeline design, implementation, and optimization.
  • Familiarity with cloud platforms (e.g., AWS, Azure, GCP) and their data services
  • 3 + years’ experience with data warehousing, data lakes, and data integration techniques
  • Recent experience with database systems, including Azure Synapse, Snowflake, and SAP eHana is nice to have
  • Knowledge of system integration using APIs, MQ, FTP, and other integration software is nice to have
  • Working knowledge of Linux and shell scripting, Python and R is nice to have

WHAT CPKC HAS TO OFFER:

  • Flexible and competitive benefits package
  • Employer Funded Retirement Plan
  • Employee Share Purchase Plan
  • Performance Incentive Program
  • Annual Fitness Subsidy
  • Part-time Studies Program

 

ADDITIONAL INFORMATION:

As an employer with North American presence, the possibility does exist that the location of your position may be changed based on organizational requirements.

 

Background Investigation:

The successful candidate will need to successfully complete the following clearances:       

 

  • Criminal history check
  • Reference check

 

Management Conductor Program:

Becoming a qualified conductor or locomotive engineer is the single best way for a management employee to learn the business at CPKC. You may be required to obtain a certification or to maintain your current certification/qualification as a conductor or locomotive engineer.

 

CPKC is an employment equity employer committed to the principles of employment equity and inclusion. We encourage all qualified candidates to apply including women, Black, Indigenous, People of Colour (BIPOC), members of the LGBTQ+ community, and people with disabilities. Accommodations for the job application process can be provided, as appropriate, upon request. All applicant information will be managed in accordance with the federal Personal Information Protection and Electronic Documents Act (PIPEDA).  

 

  • Req ID: 102053
  • Department: Information Services
  • Job Type: Full-Time
  • Position Type: Non-Union
  • Location: Calgary, Alberta
  • Country: Canada
  • % of Travel: 0-10%
  • # of Positions: 1
  • Job Grade: 4
  • Job Available to: Internal & External

 

 

#LI-ONSITE

#LI-GK1

 

 

Apply now »