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: 1Job Grade: 4

　　Job Available to: Internal & External

　　#LI-ONSITE

　　#LI-GK1