Description
The Role
We're looking for a Business Systems Analyst / Data Engineer to combine strong business analysis expertise with hands-on data engineering capabilities. In this role, you'll work with stakeholders to understand business and data requirements while designing and delivering enterprise data, reporting, and analytics solutions using modern cloud technologies.
You'll collaborate with cross-functional teams throughout the project lifecycle, helping transform complex business requirements into scalable, high-quality data solutions that drive informed decision-making.
What You'll Do
- Partner with business stakeholders to gather, analyse, and document business, functional, and data requirements for enterprise reporting and analytics solutions.
- Design, develop, and maintain scalable data pipelines using AWS data services and Snowflake, integrating data from multiple enterprise source systems.
- Perform data profiling, validation, reconciliation, and quality assurance activities to ensure data accuracy, integrity, and consistency across reporting and analytics platforms.
- Produce source-to-target mappings, data models, technical specifications, and support system integration testing, user acceptance testing, and production deployments.
- Collaborate within Agile delivery teams, working closely with solution architects, developers, and QA professionals while contributing to continuous improvement initiatives.
What We're Looking For
- Proven experience (5+ years) as a Business Systems Analyst, Data Engineer, or in a hybrid Data BSA/Data Engineering role with strong business and technical analysis skills.
- Demonstrated experience building and supporting data pipelines using AWS data services and Snowflake.
- Advanced SQL expertise with hands-on experience developing ETL/ELT pipelines, data modelling, data warehousing, and enterprise data reporting solutions.
- Excellent analytical, communication, stakeholder management, and problem-solving skills with experience working in Agile delivery environments.
- A collaborative mindset with the ability to translate business requirements into scalable, reliable data and reporting solutions.
Bonus Points For
- Experience with Tableau for enterprise reporting and data visualisation.
- Experience delivering enterprise reporting and analytics solutions within large, complex organisations.
- Knowledge of modern cloud-based data architectures and data engineering best practices.
- Experience working across cross-functional business and technology teams.
- Financial services industry consulting experience.
Why Join Capco
- Deliver high-impact technology solutions for Tier 1 financial institutions.
- Work in a collaborative, flat, and entrepreneurial consulting culture.
- Access continuous learning, training, and industry certifications.
- Be part of a team shaping the future of digital financial services.
- Help shape the future of digital transformation across Financial Services & Energy.
Benefits
- Comprehensive Benefits Coverage – 100% company-paid health, life, and disability insurance effective from Day 1 of employment.
- Retirement Savings Program – RRSP with the option of receiving a matching employer contribution.
- Virtual Health Care, Employee & Family Assistance Program (EFAP), and enhanced parental leave benefits available from Day 1.
- Wellness support including fitness reimbursement and a company-sponsored gift to celebrate the arrival of a new child.
- Business Coach from Day 1 with personalized one-on-one coaching to accelerate your professional growth.
Inclusion at Capco
We're committed to making our recruitment process accessible and straightforward for everyone. If you need any adjustments at any stage, just let us know—we'll be happy to help. We value each person's unique perspective and contribution. At Capco, we believe that being yourself is your greatest strength. Our #BeYourselfAtWork culture encourages individuality and collaboration—a mindset that shapes how we work with clients and each other every day.
Use of Artificial Intelligence in Talent Acquisition
At Capco, we use artificial intelligence (AI) tools to support and enhance several parts of talent acquisition. This includes using AI-enabled features within LinkedIn to help source potential candidates, speeding up routine recruitment communications such as emails and creating compelling and brand-aligned job postings that accurately reflect role requirements, and AI-scheduling applications to improve the efficiency of interview coordination.
AI is used as a support tool only. All hiring decisions are made by talent acquisition and hiring teams.
Why This Role Is Open
We are currently hiring for this role due to an existing or newly created vacancy within our organization. This position is open as part of our ongoing business needs, and we are actively reviewing applications to fill this role with a qualified candidate who can make an immediate impact.
Pay Transparency
The salary range for this position is listed below. Additionally, this position may also be eligible to receive an annual discretionary/variable bonus payment.
Capco is committed to providing fair and equitable compensation to our people. Our compensation policies and salary ranges are designed to allow our people to progress through the salary range as they demonstrate strong performance and develop in their role over time. The base pay offered to selected candidates will be within the salary range and the placement will vary based upon a variety of factors, including, but not limited to job-related knowledge, skills, experience and internal equity.
Similar jobs
Shape strategy. Lead transformation. Turn complex financial services challenges into meaningful outcomes. The Role Financial institutions are navigating rapid change driven by evolving customer expectations, emerging tec…
Shape strategy. Lead transformation. Turn complex financial services challenges into meaningful outcomes. The Role Financial institutions are navigating rapid change driven by evolving customer expectations, emerging tec…
The Role Capco is looking for an experienced Data Architect with deep expertise across data flows, data integration, data sources, and enterprise data architecture. You’ll work with clients to understand how data moves a…
Capco is looking for a Consultant, Data Validation to join our Technology & Engineering practice in Toronto. This is an exciting opportunity for an analytical professional who enjoys solving complex data challenges,…
Location: Toronto (Hybrid) | Practice Area: Banking & Payments | Type: Permanent Help financial services organizations turn complex transformation challenges into practical, lasting change. The Role As a Consultant w…
Senior Business Analyst - SaaS & Income Processing Application (Hybrid Toronto) The Role Capco is seeking a Business Analyst. What You'll Do Capco is seeking a tenacious & proactive Corporate Actions Business Ana…
Build and deliver complex enterprise software solutions for financial services clients. The Role As a Senior Software Engineer at Capco, you’ll design, develop, modify, maintain, and support complex web-based products an…
Accelerate modern data platform delivery by building secure, automated, and scalable DevOps solutions. Join Capco to help transform enterprise data and analytics through cloud-native engineering and continuous delivery.…
Build and deliver complex enterprise software solutions for financial services clients. The Role As a Senior Software Engineer at Capco, you’ll design, develop, modify, maintain, and support complex web-based products an…
The Role We are seeking an experienced Technology Controls & Cyber Security leader to join our Technology & Engineering practice in Toronto. In this role, you will partner with senior stakeholders to strengthen s…
Build secure, scalable backend solutions that protect the world's leading financial institutions. The Role Capco is seeking a Security Engineering Developer to design, develop, and enhance enterprise authentication capab…
Help shape practical technology solutions for the evolving insurance industry. The Role As a Consultant, you will work with clients and delivery teams to support the implementation, integration and ongoing evolution of i…
As a Technology Crisis Management Lead, you will play a key role in strengthening our clients' operational resilience by leading and supporting responses to high-impact technology incidents. Working alongside technology,…
Senior Implementation Engineer - SaaS & Income Processing Application (Hybrid Toronto) The Role What You'll Do Capco is seeking a tenacious & proactive Corporate Actions Implementation engineers our growing team…
The Role Capco is seeking a Senior Full Stack Engineer with strong .NET and React experience to join our Technology & Engineering practice in Toronto. In this role, you will help design, develop, and maintain modern…
Shape the future of banking by modernizing enterprise platforms and building cloud-native solutions that deliver real business impact. The Role We're looking for a Staff Java Engineer who combines deep technical expertis…
Capco is seeking a DevOps/DevSecOps Engineer to join our Technology & Engineering practice in Toronto. This role is ideal for someone with a strong DevOps/DevSecOps background who enjoys designing automation solution…
Drive smarter staffing decisions that empower people and enable business performance. The RoleAs a Senior Resource Specialist, you will play a key role in delivering effective, transparent, and data-driven resourcing acr…
Shape the future of secure customer identity and digital trust for leading financial services organizations. The Role We are seeking a Customer Identity Solutions Architect with deep Customer Identity and Access Manageme…
Lead the future of insider risk management by delivering strategic controls that protect our clients, strengthen governance, and enable secure transformation across financial services. The Role As a Senior Program Manage…
Lead the future of insider risk management by delivering strategic controls that protect our clients, strengthen governance, and enable secure transformation across financial services. The Role As a Project Manager withi…
Shape the future of insurance through business and technology transformation. The Role The insurance industry is undergoing rapid change, shaped by new technologies, emerging competitors, evolving regulations, and innova…
Bilingual Talent Acquisition Partner Shape the future of how we attract the brightest minds in consulting and technology. The Role At Capco, our people are at the heart of everything we do. As a Talent Acquisition Partne…
Lead enterprise-scale identity transformation while enabling secure, compliant, and agile delivery across complex financial services environments. The Role Capco is seeking an experienced Lead Project Manager / Release T…
The Role We are supporting a leading capital markets client through a critical market infrastructure transformation initiative focused on expanding the Canadian Fixed Income ecosystem and onboarding key market participan…
Lead legacy modernization and support critical mainframe database environments The RoleAs a Lead Database Administrator - Supra, you will lead the legacy modernization team, focusing on the management and optimization of…
Shape the future of secure digital identity for leading financial services organisations. The Role We are looking for a CIAM Capability Lead to define and evolve Customer Identity and Access Management (CIAM) capabilitie…
The Role We are seeking an experienced AI Enablement Developer to build and enhance AI-powered capabilities within financial services. You’ll bring strong software engineering expertise, with a particular focus on Python…
Lead complex risk assessment design initiatives, bringing together project management discipline, consulting expertise, and effective process and methodology design. The Role As a Project Manager, Risk Assessment Design…
Drive critical change initiatives that help secure the future of banking technology. The Role Capco is seeking an experienced Change Manager to support a major banking client on strategic encryption and cryptography init…