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.
Skills Required
- Proven experience (5+ years) as a DevOps Engineer supporting Azure cloud environments and enterprise data platforms.
- Designing and maintaining Azure DevOps CI/CD pipelines, release management, and environment configuration.
- Infrastructure as Code using Bicep or ARM Templates.
- PowerShell and/or Python scripting experience.
- Experience with Git version control.
- Azure security, identity management, and secrets management using Azure Key Vault.
- Experience working in Agile delivery environments; strong analytical, communication, and collaboration skills.
- Experience with Microsoft Fabric, Azure Data Factory, Azure Synapse Analytics, Azure Databricks, and Power BI Deployment Pipelines.
- Experience implementing Azure Monitor, Log Analytics, and Application Insights for monitoring and operational support.
- Knowledge of Microsoft Entra ID, cloud governance, and enterprise security best practices.
- Experience supporting enterprise-scale cloud migration, data platform modernization, or analytics transformation initiatives.
- Financial services consulting or regulated industry experience.
What the Team is Saying
What We Do
Capco, a Wipro company, is a global management and technology consultancy specializing in driving transformation in the energy and financial services industries. Capco operates at the intersection of business and technology by combining innovative thinking with unrivalled industry knowledge to fast-track digital initiatives for banking and payments, capital markets, wealth and asset management, insurance, and the energy sector. Capco’s cutting edge ingenuity is brought to life through its award-winning Be Yourself At Work culture and diverse talent. TRUSTED ADVISORS - Our collaborative and entrepreneurial approach position us as trusted long-term partners to our clients. DEEP EXPERTISE - Clients look to us for clear guidance, proven expertise, and the support they need to set their companies up for success. DISRUPTIVE SOLUTIONS- We do not provide off -the-shelf answers to clients’ challenges. Instead, we work in close collaboration to understand the issues, and craft disruptive, bespoke solutions. ACCOUNTABILITY AND OWNERSHIP - We recognize every client has distinct needs and expectations, and we take ownership and accountability for the solutions we design, build, and deliver.
Why Work With Us
We support and encourage an inclusive culture, entrepreneurial outlook and independent thinking. Capco is not about organizational charts and rigid hierarchies – we want all employees to feel that Capco is their firm to own and run. We believe diversity powers innovation. Be Yourself At Work (#BYAW) is an integral and underlying part of our culture
Gallery
Capco Offices
Hybrid Workspace
Employees engage in a combination of remote and on-site work.
