Sr. Consultant, Analytics & BPI

ADP; Toronto; On-site; CAD 80,000 - 110,000; Full time

Job summary

A financial services technology company is looking for a Sr. Consultant in Analytics & Business Process Improvement. In this role, you will lead transformation efforts, utilizing advanced SQL and BI tools like Tableau and Power BI. Ideal candidates have 6–8 years of experience in analytics within FinTech or complex financial environments. You'll improve reporting processes and offer actionable insights, ensuring operational excellence. Competitive work environment with a focus on well-being and professional growth.

Benefits

Mental health support

Tuition reimbursement

Flexible work arrangements

Global networking opportunities

Business Resource Groups

Qualifications

• 6–8 years of experience in Analytics and BPI, particularly in FinTech or complex Financial Services.
• Expert-level SQL scripting capabilities.
• Proficiency in data visualization tools like Tableau and Power BI.
• Experience with ETL and workflow automation.

Responsibilities

• Lead process transformation initiatives focused on reporting improvement.
• Architect complex SQL scripts to manage high-volume data.
• Leverage reporting tools to enhance operational efficiency.
• Build predictive models to guide business decisions.

Skills

SQL expertise

Tableau mastery

Power BI mastery

Business process improvement experience

Communication skills

Data project leadership

Tools

Tableau

Power BI

Advanced Excel

Job description

ADP is hiring a Sr. Consultant, Analytics & Business Process Improvement (BPI)

• Are you looking to grow your career in an agile, dynamic environment with plenty of opportunities to progress?
• Do you want to continuously learn through ongoing training, development, and mentorship opportunities?
• Are you looking to be yourself in a culture that values equity, inclusion, and belonging and creates a safe space for diverse perspectives and insights?

Well, this may be the role for you. Ready to make your mark?

As a Senior Individual Contributor, you will be the bridge between complex financial data and operational excellence. Reporting to the Director of Innovation and BPI, you will lead the charge in transforming ADP’s International Money Movement reporting for Canada Payment Operations to a forward‑looking, context‑driven strategic reporting with actionable insights.

Your primary mission is two‑fold: to engineer efficiencies in the current state of operational reporting (through training, skill building, automation and process re‑design), and to look at how data can support the future‑looking pursuits of financial risk reduction, process improvement opportunities and revenue generation opportunities.

Ready to #MakeYourMark? Apply now!

What you’ll do: Responsibilities

What you can expect on a typical day:

• Process Transformation & Restructuring: Partner with Managers and Directors across business units to audit legacy reporting. You will lead the shift from "data dumps" to context‑driven analytics that align with long‑term capacity planning and forward‑looking goals.
• Technical Execution (SQL & BI): Architect and maintain complex SQL query scripts to extract high‑volume data from payroll and money movement databases. You will be the dual expert in Tableau and Power BI, selecting the right tool for the specific business need.
• Automation: Leverage key reporting tools and advanced Excel functions to eliminate manual touchpoints within the production cycle.
• Business Process Improvement: Utilize the data from reporting cycles & project‑based reporting to identify trends that support process improvement and / revenue opportunities
• Capacity & Predictive Planning: Build models that help leadership understand workforce capacity and money movement trends, allowing for proactive rather than reactive decision‑making.
• Cross‑Functional Influence: Act as a consultant to leaders within payment operations, guiding them on how to restructure their internal processes to better leverage data.

TO SUCCEED IN THIS ROLE: Requirements

• 6–8 years of professional experience in Analytics and BPI, ideally within FinTech, Payroll, or complex Financial Services.
• SQL: Expert‑level scripting; ability to handle large, complex datasets with high accuracy.
• Visualization: Mastery of both Tableau and Power BI.
• ETL: Proficiency in structuring for workflow automation.
• Consulting Background: Proven track record of working on projects that yielded measurable Business Process Improvement (BPI) results.
• Domain Knowledge: Experience or a strong interest in financial services, payments, fin‑tech, global payroll, or high‑compliance financial environments.
• Experience in leading large complex data projects but understanding how to roll up your sleeves to execute the day‑to‑day tasks as required until stability is established.
• Ability to meet stakeholders ‘where they are at’ – whether they are part of the technical teams, business or leadership.
• Strong communication skills to be able to convey complex information into relevant supporting documentation or discussion with key stakeholders in advancing projects forward.
• Flexibility to work in a highly dynamic team within a large/multi‑faceted organization.

YOU'LL LOVE WORKING HERE BECAUSE YOU CAN:

• Focus on your mental health and well‑being. We take care of one another and offer support for your well‑being… because healthy associates are happy ones.
• Join a company committed to giving back and generating a lasting, positive impact upon the communities in which we work and live.
• Knowledge to help you grow. Ongoing training and development opportunities and a tuition reimbursement program, for even the most insatiable learner.
• Innovate. Problem‑solve. Shape the future of work with people you like.
• Balance work and personal time. Flexibility to integrate work more easily in your everyday life.
• Go Global. With operations around the world, exciting new networking opportunities abound.
• Belong by joining one of ten Business Resource Groups to connect globally with networks and allies who share common interests and experiences.

What are you waiting for? Apply today!