Join CPKC, North America’s first transnational railroad connecting U.S., Canada, and Mexico, where your career drives progress and safety is paramount. We connect communities, fuel economic growth, and provide meaningful work in a culture that values diversity, accountability, and pride. With opportunities for training, development, and advancement, you’re not just building a career—you’re part of something bigger. Together, we move goods, connect people, and create lasting change. Your future starts here.
PURPOSE OF THE POSITION:
We are growing our in-house SAP Centre of Excellence (CoE). Our leadership team is focused on creating an environment where internal talent is nurtured and developed to their full potential. If you are an SAP champion who thrives in a fast-paced environment, we invite you to be a part of our transformation journey to SAP S/4HANA Rise Cloud. With over 150 SAP professionals, we are one of North America’s largest SAP hubs offering you the opportunity to drive excellence and build a culture of innovation.
CPKC is hiring an experienced SAP BW-ABAP Developer for a 12-month fixed-term contract. This role is open to candidates based in Calgary or Kansas City. The successful candidate will participate in developing business intelligence solutions that collect, analyze, and present information to the business, and subsequently develop solutions to address business requirements.
POSITION ACCOUNTABILITIES:
- Develop, enhance, and maintain code in ABAP, SAP BW, SAP BW/4HANA, SAP HANA, and SAP Datasphere
- Responsible for successful delivery of functional and technical components of Business Intelligence reporting solutions using SAP BW, SAP BW/4HANA, ABAP, SAP Datasphere, SAP Analytics Cloud, and AI-enabled analytics capabilities
- Develop and enhance data sources for BI extractors in SAP ERP
- Build dashboards, stories, and analytical reports using SAP Analytics Cloud
- Utilize SAP Analytics Cloud features such as smart insights, predictive forecasting, and automated analytics where applicable
- Responsible for root cause analysis and resolution of production issues
- Assess business requirements and processes and provide recommendations on optimal solutions that best serve business needs
- Identify opportunities to apply AI, predictive analytics, automation, and advanced data analysis to improve BI reporting and business insights
- Maintain records and documentation for system development, enhancements, revisions, and support activities
- Perform ABAP development and performance analysis, testing, issue analysis, triage, debugging, job scheduling, execution, monitoring, and issue resolution
- Provide on-call support for BW, HANA, BO, Datasphere, and SAC applications on a weekly rotation basis
- Provide end-user support and training
- Collaborate with business users, functional teams, data engineers, and analytics teams to deliver scalable BI solutions
- Support integration of SAP and non-SAP data sources for reporting, dashboarding, and advanced analytics use cases
POSITION REQUIREMENTS:
- 5+ years of experience in SAP Business Warehouse, including BW versions 7.x and higher, and BW/4HANA
- 3+ years of experience in ABAP programming
- 2+ years of experience in SAP Datasphere and SAP Analytics Cloud
- Strong experience in BW-ABAP coding, Function Modules, BW custom extractors, routines, transformations, ABAP CDS Views, ABAP Object-Oriented Programming, and debugging
- Strong experience in building dashboards, stories, and reports using SAP Analytics Cloud
- University degree in Computer Science, Information Systems, or equivalent Business Intelligence technical experience
- Expertise developing ABAP Data Dictionary objects, BADIs, enhancements, user exits, and custom developments
- Good understanding of in-memory columnar database functionality, especially SAP HANA.
- Experience with SAP HANA modeling, Calculation Views, SQLScript, and performance optimization is preferred
- Strong analytical, problem-solving, troubleshooting, and debugging skills.
Nice to have:
- Experience using AI-enabled or advanced analytics features in reporting platforms, including smart insights, predictive forecasting, anomaly detection, or automated analytics
- Understanding of Artificial Intelligence, Machine Learning, predictive analytics, and how these capabilities can be applied to BI reporting and business decision-making
- Familiarity with SAP Business AI, SAP Analytics Cloud Smart Predict, SAP AI Core, SAP AI Launchpad, or similar AI/ML tools is a plus
- Experience with Python, SQL, or data science tools for analytics, automation, or model integration is preferred
WHAT CPKC HAS TO OFFER:
- Flexible and competitive benefits package
- Competitive company pension plan
- Employee Share Purchase Plan
- Performance Incentive Program
- Annual Fitness Subsidy
- Part-time Studies Program
PRE-EMPLOYMENT REQUIREMENTS:
Background Investigation
- Criminal history check
- Education verification
- Professional references
BECOMING A RAILROADER:
As an employee with a North American presence, the possibility does exist that the location of your position may be changed based on organizational requirements.
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.
CULTURE OF INCLUSION:
For our U.S. applicants, CPKC is an equal opportunity/affirmative action employer, inclusive of protected veterans and individuals with disabilities. For Canadian applicants 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 Color (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: 106052
- Department: Information Services & Network Service Centre (NSC)
- Job Type: Fixed Term
- Position Type: Non-Union
- Location: Calgary, Alberta
- Country: Canada
- % of Travel: 0-10%
- # of Positions: 1
- Job Grade: 5
- Job Available to: Internal & External
#LI-ONSITE
#LI-JA1