Consultant, Automation & Analytics

CIBC • Toronto, ON

1d • Hybrid

About The Position

The Operations, Transformation and Automation team is responsible for building and supporting instrumentation, analytics, automation, reporting, and capacity management capabilities. The team is committed to streamlining processes through simplification and automation to improve operations and better serve partners and clients. The Consultant, Automation & Analytics develops solutions using self-serve tools such as Power Apps, Power Automate, VBA, Alteryx, Azure DevOps, and Tableau to address business problems. This role assists in resolving routine and non-routine operational problems by investigating, analyzing, and providing recommendations on compliance issues, policy changes, operational controls, risk assessment, and control activities. The Consultant provides technical leadership to develop precise steps and processing logic across all platforms, ensuring designed specifications meet business needs. Additionally, the role offers comprehensive senior-level technical consulting to other senior management and technical teams, and consults with senior management on a wide spectrum of existing and emerging infrastructure technologies. The role translates user requirements into process and data requirements and develops solutions with far-reaching impact, often making technology selection decisions when business requirements are not completely defined. The successful candidate will demonstrate a strong understanding of business analytics and possess an automation mindset, requiring adaptability and the ability to think outside-the-box in a fast-paced environment with changing requirements.

Requirements

• 3-5+ years experience in designing, developing, implementing and supporting applications with expertise in most of the following: No/Low Code Tools (VBA, Alteryx, Power Automate, Power App), Analytics Software (Tableau, Power BI), Databases (SAS, Oracle, SQL Server), Cloud (Azure, AWS), ETL (Informatica, SSIS), and Tools (Tools: source control/issue management: Git, TFS, JIRA, Azure DevOps, Selenium).
• Embrace and champion change.
• Be passionate about being on top of technology trends.
• Continuously evolve your thinking and the way you work in order to deliver your best.
• Know that relationships and networks are essential to success.
• Inspire outcomes by making yourself heard.
• Be digitally savvy.
• Seek out innovative solutions and embrace evolving technologies.
• Easily adapt to new tools and trends.
• Have a degree/diploma: Bachelor’s degree or equivalent in Computer Science or Technical discipline.
• Values matter to you.
• Bring your real self to work and live our values - trust, teamwork, and accountability.

Nice To Haves

• MBA or Master degree with specialization on Advanced Analytics, ML or AI is considered a plus.
• PMP and Lean Six Sigma certification are good to have.

Responsibilities

• Develop solutions leveraging self-serve tools such as Power Apps, Power Automate, VBA, Alteryx, Azure DevOps & Tableau to address business problems.
• Assist in the resolution of routine and non-routine operational problems or issues by investigating, analyzing and providing an informed and independent opinion or recommendation on compliance issues, changes to policies, adequacy of operational controls, risk assessment, and control activities.
• Provide technical leadership to develop precise steps and processing logic across all platforms, ensuring the designed specifications achieve business needs.
• Provide consultation for senior management on a wide spectrum of existing and emerging infrastructure technologies, translating user requirements to process and data requirements and developing solutions for the business with far-reaching impact.
• Make technology selection decisions that are often made in situations where business requirements are not completely defined.
• Perform and coordinate complex solution design activities.
• Understand the business requirements and translate them into system and application design that is aligned with our technology roadmap.
• Design and document the technical functionality, infrastructure, interfaces and integrations.
• Lead the design of cost-effective and innovative solutions to meet both business objectives and the goal of operational efficiency.
• Contribute to technology roadmaps that are aligned with the bank’s vision, strategy, and business objectives.
• Lead multiple complex technology solutions while maintaining consistency across the platform, adopting best practices and pushing forward continuous improvements.
• Act as the solution lead and interface with the project teams by driving and moderating design review sessions to walk stakeholders through and ensure that the overall design aligns with business requirements as well as architectural directions.
• Support and mentor junior designers and developers through knowledge sharing, collaboration and effective problem solving.

Benefits

• competitive salary
• incentive pay
• banking benefits
• a benefits program
• defined benefit pension plan
• an employee share purchase plan
• a vacation offering
• wellbeing support
• MomentMakers, our social, points-based recognition program.
• Purpose Day; a paid day off dedicated for you to use to invest in your growth and development.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level