Data Analyst Consultant (Hybrid – Toronto)

Data Analyst Consultant (Hybrid – Toronto)

Capco – The Future. Now.

Capco is a distinctly and positively different place to work. Much more than consultants, we are active participants in the global financial services industry. Our passionate business and technology professionals enjoy a unique environment where they are actively encouraged to apply intellect, innovation, experience and teamwork. We are dedicated to fully supporting our world class clients as they respond to challenges and opportunities in: Banking, Capital Markets, Finance Risk & Compliance, Insurance, and Wealth and Investment Management. Experience Capco for yourself at capco.com

Let’s Talk About You

You want to Own Your Career. You’re serious about rising as far and as fast as your work and achievements can take you. And you’re ready to write the next chapter of your career story: a challenging and rewarding role as a Capco Data Analyst Consultant.  

Let’s Get Down To Business

Capco is looking for talented, innovative and creative people to join our emerging data analytics team to work on a number of projects and applications.

Responsibilities

• Test and validate data sources, transformations, and calculations within technology risk dashboards.
• Troubleshoot issues related to data accuracy, dashboard performance, and user experience.
• Identify and document data lineage from source system to data model
• Work with data owners, domain owners and product owners to ensure data being provided aligns to reporting requirements.
• Conduct data analysis to highlight and report data inconsistencies, allowing users to review and provide feedback
• Determine the data mapping required to join multiple data sets together across multiple sources
• Lead and work closely with all stakeholders creating a strong culture of transparency and collaboration
• Develop and maintain SQL queries, scripts, and stored procedures to support dashboard development and data analysis.
• Document processes, data sources, and technical solutions for knowledge sharing and future reference.

Must Haves  

• Five (5) or more experience working as a Data Analyst
• Proficiency in SQL for data querying, manipulation, and analysis.
• Strong analytical skills with the ability to analyse complex data sets and identify lineage.
• Knowledge of data modelling concepts and database design principles.
• Experience in troubleshooting data-related issues and optimizing dashboard performance.
• Excellent communication skills to collaborate with cross-functional teams and explain technical concepts to non-technical stakeholders.
• Manage stakeholder expectations and ensure that robust communication and escalation mechanisms are in place across project

Technical capabilities

• Ability to write SQL queries for data querying, manipulation, and analysis
• Experience using Tableau
• Data analysis, data profiling, data cleansing, and data quality assessment.
• Understanding of relational databases, data warehouses, and ETL processes.

Nice to Haves

We are also looking for individuals who demonstrate the following traits:

• Familiarity with technology risk management in financial services.
• Certifications in SQL, Tableau, or related data analytics disciplines.
• Understanding of data governance principles and best practices.
• Experience working with Agile methodology tools – Jira and Confluence.
• Analyzing results of technology Key Risk Indicators.

Professional experience is important. But it’s paramount you share our belief in disruptive innovation that puts clients ahead in a tough market. From day one, your key skill will be to perceive new and better ways of doing things to give your clients an unfair advantage.

Now Take the Next Step 

If you’re looking forward to progressing your career with us, then we’re looking forward to receiving your application.

Capco is well known for its thought leadership and client-centric model that distinguishes it from other consulting firms. Capco’s strong technology and digital knowledge base, it’s global experience of the Financial Service enables us to deliver projects from strategy through to delivery. We are committed to providing new areas of expertise from which our clients will greatly benefit. We have:

• Access to industry-focused talent globally
• Ability to leverage best-of-breed, innovative products and solutions for complex architecture and large-scale transformation
• Extended global geographic market reach
• Ability to capitalize on our client footprint and deep domain expertise within financial services

For more information about Capco, visit www.Capco.com.

Capco is an equal opportunity employer. We evaluate qualified applicants without regard to race, color, religion, sex, sexual orientation, gender identity, marital status, genetic information, national origin, disability, veteran status, and other protected characteristics.