Business Process Analyst, Process Automation

Connor, Clark & Lunn group; Vancouver; Hybrid; CAD 80,000 - 105,000; Full time

Benefits offered by this job

Hybrid work

Competitive compensation

Retirement savings support

Wellness credits

Enhanced parental leave

Health benefits

Job summary

Connor, Clark & Lunn Financial Group seeks a Business Process Analyst, Process Automation to join our Investment Resource Group. You will partner with business SMEs to identify automation opportunities and translate needs into clear requirements and plans.

You will design, develop, and implement automation using Python, Microsoft Fabric, Power BI, Power Platform, Excel, and VBA, collaborating across global teams to deliver scalable, well-governed solutions with rigorous testing.

Qualifications

• Undergraduate degree in Computer Science, Engineering, Mathematics, or Business Administration.
• Experience in investment operations or financial services with focus on processes and controls.
• Ability to translate business needs into clear requirements and practical solutions.
• Strong analytical and problem-solving capabilities for efficiency and controls.
• Experience with requirements discovery, process mapping, and future-state design.
• Hands-on development with Python, Power BI, Excel, Power Platform; VBA is a plus.

Responsibilities

• Partner with business SMEs to identify automation opportunities and understand current-state processes.
• Translate objectives into defined requirements, scope, and implementation plans.
• Analyze processes, data flows, and dependencies; define scope and future-state processes.
• Design, develop, and implement automation using Python, Fabric, Power BI, and Power Platform.
• Collaborate with business users and technical teams through design, testing, and deployment.
• Define testing and validation approaches, including edge cases and controls.
• Document requirements, process flows, and solution designs in a structured manner.
• Support automation solutions by investigating production issues and resolutions.
• Champion governance and scalable development practices.
• Gather feedback and promote adoption and continuous improvement.
• Educate users on automation capabilities and best practices.
• Build relationships across global teams to standardize automation approaches.

Skills

Requirements discovery

Process analysis

Stakeholder collaboration

Analytical thinking

Automation knowledge

Excel advanced

Data analysis

Education

Bachelor's degree in Computer Science

Engineering

Mathematics

Business Administration

Tools

Python

Microsoft Fabric

Power BI

Power Platform

Excel

Power Query

VBA

Job description

Interested in joining one of Canada's top-performing asset managers? We are looking for a Business Process Analyst, Process Automation for an existing vacancy within the Investment Resource Group (IRG). The Investment Resource Group is a diverse and dynamic team whose varied talents and experiences enable us to deliver accurate, timely, and efficient global investment operations while supporting the sustainable growth of CC&L Financial Group and its affiliates. We are committed to providing strong infrastructure and services and creating winning conditions for our clients, affiliates, and employees. As we continue to expand our automation capabilities, we are seeking an entrepreneurial and process-oriented individual who is passionate about process innovation and continuous improvement. Reporting to the Manager, Process Automation, the Business Process Analyst will play a central role in transforming the Investment Resource Group through automation by partnering with business subject-matter experts and technology teams to improve efficiency, strengthen controls, reduce operational risk, and deliver scalable and supportable solutions for manual, repetitive, and operationally intensive processes.What You Will DoPartner with business subject-matter experts across the Investment Resource Group to understand current-state processes and identify, assess, and prioritize automation and process-improvement opportunities.Translate business objectives and operational challenges into clearly defined requirements, scope, solution approaches, and implementation plans, considering business value, feasibility, risk, dependencies, timelines, and resource requirements.Analyze current-state processes, business rules, controls, data flows, and upstream and downstream dependencies; define the appropriate scope; and translate findings into improved and re-engineered future-state processes and user stories to support automation solution development.Design, develop, and implement automation solutions using technologies such as Microsoft Fabric, Power Automate, Power Apps, Power BI, Microsoft Copilot, and Python, through hands-on development and/or in partnership with technical teams, depending on the candidate's capabilities, experience, and technical skill set.Collaborate with business users and technical teams throughout design, development, testing, and implementation, using presentations, documentation, and process diagrams as appropriate to maintain alignment and ensure solutions are robust, efficient, scalable, and aligned with business requirements.Define and execute appropriate testing and validation approaches that cover both expected and non-standard scenarios, including exceptions, edge cases, reconciliations, controls, downstream impacts, and production readiness.Document business requirements, process flows using process diagrams, solution designs, controls, testing outcomes, and implemented solutions in a structured and consistent manner.Support existing and newly implemented automation solutions by investigating production issues, identifying root causes, and coordinating or implementing appropriate resolutions.Champion the Automation Factory framework and ensure solutions are developed, tested, deployed, and supported in a controlled, sustainable, and well-governed manner.Gather stakeholder feedback and identify opportunities to improve automation solutions, development practices, governance frameworks, and the overall user experience.Educate business users on automation capabilities, appropriate use cases, and best practices to support adoption and help identify new opportunities.Build strong relationships with business, Information Systems, Operational Risk, and other key stakeholders, and collaborate across global teams to promote standardized and scalable approaches to automation.What You BringAn undergraduate degree in Computer Science, Engineering, Mathematics, Business Administration, or a related field.Experience within investment operations, trade support, or a comparable financial-services environment, with a strong understanding of operational processes, business logic, and control requirements.Ability to quickly learn complex investment and operational processes, identify critical dependencies, risks, and gaps, and translate business needs into clear requirements and practical solutions.Proven capability in requirements discovery, process analysis, process mapping, and future-state process design, with the confidence to challenge assumptions, think beyond existing processes, and navigate ambiguity.Strong analytical and problem-solving capabilities, with the ability to collect and analyze information, exercise sound judgement, define appropriate solution scope, and recommend solutions that enhance efficiency, controls, and decision-making.Strong understanding of software-development methodologies and the end-to-end solution lifecycle, including planning, design, development, testing, implementation, production support, and change management.Ability to define the appropriate solution scope, translate business requirements into reliable technical logic, and design scalable, maintainable, and well-controlled solutions, including recognizing when requirements are better addressed through broader technology capabilities or by other technology teams rather than through automation alone.Strong testing, debugging, documentation, and production-support disciplines, with attention to exceptions, edge cases, controls, reliability, and long-term operational sustainability.Understanding of workflow automation, APIs, structured data, and data architecture, including data ingestion, transformation, modelling, and reporting, is considered a strong asset.Hands-on development experience with technologies such as Python, Microsoft Fabric, Power BI, Power Platform, Excel, Power Query, and VBA is considered a strong asset.Strong proficiency in Microsoft Excel, including the use of formulas and functions.Strong written and verbal communication skills, with the ability to articulate complex issues concisely, synthesize detailed information into clear discussion and decision points, and support communication through effective presentations and visual materials where appropriate.A proactive, self-starting, and results-oriented approach, with the initiative to identify and address gaps, remove obstacles, and drive work forward independently in fast-paced, evolving environments that require a high degree of autonomy and sound judgment.A flexible and adaptable mindset, with the ability to coordinate across multiple stakeholders, navigate differing perspectives and priorities, build alignment, and drive execution through a range of approaches with persistence, resourcefulness, and resilience.A strong growth mindset, with curiosity, openness to new ideas and approaches, and a demonstrated commitment to continuously developing business, investment-process, automation, and technology capabilities.The salary range for this position is $80,000-$105,000. The salary range provided reflects the base salary range for this position as required by legislation. In addition, there is an annual performance bonus which contributes to the total compensation for this position. Further questions may be directed to the HR team during the interview process.#LI-HYBRID #LI-JB1What We OfferAt Connor, Clark & Lunn Financial Group, we're \"invested in our greatest asset, you\". Our shared goals reflect what matters most to our people:Your community: we foster belonging through collaboration, inclusion and flexibility. Enjoy social events, volunteering and a strong commitment to corporate social responsibility. Our flexible work practices are designed to support work-life balance and provide employees with flexibility in where and how they workYour growth: we prioritize your development with meaningful work, continuous learning budgets, paid study days and support for professional designations.Recognizing you: your contributions are rewarded with competitive total compensation, retirement savings support, wellness credits, enhanced parental leave, and comprehensive health benefits.For a closer look at how you can build your career with us, we invite you to explore cclgroup.com.We are committed to providing an inclusive, accessible recruitment and selection process. We welcome and encourage applications from people with disabilities. Accommodations are available on request for candidates taking part in all aspects of the recruitment and selection process. Please contact [e-mail] if you require accommodation.AI may be used to support certain stages of our screening & recruitment process. These tools support, but do not replace, human judgment and decision-making.