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