Technical Business Solution Analyst

at  CN

At CN, everyday brings new and exciting challenges. You can expect an interesting environment where you’re part of making sure our business is running optimally and safely―helping keep the economy on track. We provide the kind of paid training and opportunities that long-term careers are built on and we recognize hard workers who strive to make a difference. You will be able to thrive in our close-knit, safety-focused culture working together as ONE TEAM. The careers we offer are meaningful because the work we do matters. Join us!
Job Summary
The Project Officer is responsible for designing and developing solutions that leverage technologies such as Microsoft Access, Structured Query Language (SQL), Visual Basic for Applications (VBA), and Robotics Process Automation (RPA) to quickly generate both financial returns and productivity gains for Accounting in an agile manner. The role requires specialized technical expertise and ability to learn new and advanced technologies to deliver and support innovative solutions in order to meet internal objectives.
Main Responsibilities

Agile Development Projects

• Analyze current business challenges, identify and assess the best technology solutions to address the challenges and drive business value
• Design and develop new solutions or enhance existing ones by using Microsoft Access, SQL, and RPA
• Coordinate with business users to ensure solutions improve processes, data integrity, and overall controls while successfully meeting business needs
• Perform quality assurance and user acceptance by testing new, existing and enhanced systems

Accounting Systems Support

• Coordinate and perform user support for new, existing and modified systems while minimizing system down time
• Work with business partners and I&T to investigate, document, and resolve system issues
• Ensure that problems are logged, communicated to solution owners and prioritized by considering business partner constraints and business process criticality
• Identify recurring problems, propose corrective solutions, and ensure their migration to production environments
• Coordinate with I&T and assist in system and platform technical migration while ensuring minimal business disruption

Reporting and Analytics

• Develop reporting solutions to monitor various business streams (e.g. monthly billing amounts, revenue recapture, billing amount by stream, Account Payables (AP) data audits) aimed to provide visibility to senior leadership
• Integrate large data sets from numerous data sources and draw insights required to build complex analytics models
• Perform data analytics, document business users’ requirements, write functional and technical specifications
• Design conceptual and logical data models complying with corporate business intelligence standards
• Implement databases, data collection systems, or data analytics in order to optimize integrity and efficiency

Working Conditions
The role has standard working conditions in an office environment with a normal workweek from Monday to Friday.
Requirements

Experience

• Minimum 5 years of experience in a business or technology optimization role

o Experience in end-to-end development of complex Microsoft Access solutions

Education/Certification/Designation

• Bachelor’s Degree in Accounting, Finance, or Computer Science

Competencies

• Shares timely information within and across functions to get things done effectively
• Collaborates with others
• Applies analytical thinking to make recommendations that pursue sustainable performance
• Inspires others with impactful communications and adapts to the audience
• Knows technology and business systems and stays current with industry trends to elevate expertise and work
• Ability to learn and support RPA solutions by using Blue Prism
• Fluently bilingual both written and verbal (English, French)

Technical Skills/Knowledge

• Knowledge of Microsoft Office (Word, Excel, PowerPoint, and Access)
• Knowledge of Business Objects, Systems, Applications and Procedures (SAP) Business Warehouse, Power BI, Risk Management System (RMS), Service Reliability System (SRS), Electronic Data Interchange (EDI), eBill, and GetPaid
• Knowledge of SQL, SQL Server Integration Services (SSIS), and VBA

About CN
CN is a world-class transportation leader and trade-enabler. Essential to the economy, to the customers, and to the communities it serves, CN safely transports more than 300 million tons of natural resources, manufactured products, and finished goods throughout North America every year. As the only railroad connecting Canada’s Eastern and Western coasts with the Southern tip of the U.S. through a 19,500 mile rail network, CN and its affiliates have been contributing to community prosperity and sustainable trade since 1919. CN is committed to programs supporting social responsibility and environmental stewardship. At CN, we work as ONE TEAM, focused on safety, sustainability and our customers, providing operational and supply chain excellence to deliver results.
At CN, we are dedicated to building North America’s safest, most inclusive and sustainable railroad, which includes reflecting the communities in which we operate. Research shows that candidates from underrepresented groups often don’t apply unless they feel they fit the job posting at 100%. Even if you don’t see yourself in every job requirement listed in a posting, we still encourage you to apply. If you require an accommodation for the recruitment process (including alternate formats of materials, accessible meeting rooms or other accommodations), please reach out to our team at cnrecruitment@cn.ca.
As an equal employment opportunity employer, all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, protected veteran status, and other protected status as required by applicable law. We thank all applicants for their interest, however, only candidates under consideration will be contacted. Please monitor your email on a regular basis, as communication is primarily made through email

Please refer the Job description for details