Senior Associate, Data Analyst at Capital One - CA Canada

Capital One - CA; Canada; Hybrid; CAD 70,000 - 90,000; Full time

Job summary

A financial services firm is seeking a Senior Associate, Data Analyst to join their Canada team. The role involves building automated reporting, SQL-based data manipulation, and creating data visualizations. Candidates should have a Bachelor's degree, strong SQL skills, and experience with data analysis tools. The company offers a flexible hybrid work model and a commitment to diversity and inclusion.

Benefits

Health and fitness center discounts

Comprehensive benefits program

Training and professional development programs

Qualifications

• At least 2 years of experience with SQL.
• At least 1 year of experience with Unix or equivalent.
• Experience working with AWS (EC2, S3, Lambda, RDS, etc.).
• Experience in open source programming languages for large scale data analysis (Python or equivalent).
• At least 3 years’ experience with SQL.

Responsibilities

• Build, automate, and maintain critical business reporting using cutting-edge tools.
• Write SQL to clean, transform, investigate, and augment large, complex database tables.
• Design and implement rich data visualizations.
• Ensure data and intent integrity by automating data quality verification.
• Identify process improvements and deliver on them.

Skills

Curiosity

Data extraction

Creativity

Collaboration

Proactiveness

Education

Bachelor's Degree

Tools

SQL

GitHub

AWS

Python

Matplotlib

Tableau

Job description

Job Description

161 Bay Street (93021), Canada, Toronto,Toronto, Ontario,

Senior Associate, Data Analyst job at Capital One Canada.

Our Capital One DA Team.

Data is at the center of everything we do. It started in 1988, when we launched as a startup with the goal of using data to deliver personalized credit card products. Fast-forward a few years — we’re a Fortune 200 company and a leader in the world of data-driven decision-making.

As a Data Analyst on our team, you’ll be curious enough to ask questions and brave enough to blurt out a cool idea. You approach problems with creativity, and you love exploring new ways of doing things. But most importantly, you enjoy collaborating, and you’re always willing to share your knowledge with your peers — because you know that’s how the best ideas are made.

Working with us

How do we do things at Capital One Canada? We listen — to our people, and to our customers. We change with the times and have adopted a flexible hybrid model. A flexible hybrid working model is one that creates the opportunity to match the work that we do to the environment that best supports that work. Associates working in the hybrid model are expected to come into the office 3 days a week across Tuesdays and Thursdays, reserving Mondays and Fridays as company-wide virtual days. As was true before the pandemic, expectations of being in the office will be balanced with personal life flexibility.

At Capital One we’re committed to diversity, inclusion and belonging. We strive to build a culture where diverse perspectives are valued, innovative ideas are encouraged and inclusive behaviours are embedded in everything we do to positively impact associates. Strive to build a culture where diverse perspectives are valued, innovative ideas are encouraged and to help challenge the status quo and create the best outcomes for everyone.

We’re focused on helping associates live well—physically, financially and emotionally. When you join us, we support you and those who are most important to you, offering full coverage for spouses, domestic partners, and dependents. We’ve designed our benefits program to be flexible, comprehensive and consistent across our organization. From health and fitness center discounts, to training and professional development programs—and much more—you’ll discover that Capital One is committed to helping you live your best life.

Here are some examples of projects that you may work on as a Senior Data Analyst:

• Build, automate, and maintain critical business reporting using cutting-edge tools.
• Write SQL to clean, transform, investigate, and augment large, complex database tables
• Work closely with business partners to make sure our business strategy is as data driven as possible
• Design and implement rich data visualizations to communicate complex ideas to customers or company leaders
• Ensure data and intent integrity by automating data quality verification
• Support and consult with the business to propagate data management best practices
• Create and maintain well-managed critical data processes to meet regulatory requirements.
• Identify process improvements and deliver on them.
• Perform ad hoc analytics on large/diverse datasets.

We want you to be one of us if you are:

• Curious: You ask why, you explore, and you’re not afraid to blurt out your disruptive idea. You know SQL and are constantly exploring new open source tools, and hitting up stack overflow on a regular basis.
• A Wrangler: You know how to programmatically extract data from a database or an API, bring it through a transformation or two, and convert into a human-readable form (Matplotlib, QuickSight, Tableau, etc.).
• Creative: Big, undefined problems and petabytes of data don’t frighten you. You’re used to working with abstract data, and you love discovering new narratives in unmined territories.
• Proactive: You will want to share your knowledge with your peers and contribute back to inner/open source projects which you might consume.
• Collaborative: You’re able to work with teammates with diverse skill sets and explain your work to less technical audiences.

Basic Qualifications:

• Bachelor's Degree
• At least 2 years of experience with SQL
• At least 1 year of experience with Unix or equivalent
• At least 1 year of experience with version control systems like GitHub.

Preferred Qualifications:

• Master's Degree
• Experience working with AWS (EC2, S3, Lambda, RDS, etc.)
• Experience working with advanced Git Workflows (Pull Requests, Code Reviews, Issues, and Branching)
• At least 1 year of experience in open source programming languages for large scale data analysis (Python or equivalent)
• At least 3 years’ experience with SQL

Capital One Canada is an equal opportunity employer committed to fostering a diverse and inclusive work environment. We consider all qualified applicants and will meet the needs of those requiring reasonable accommodations.

If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation, please contact Capital One Recruiting at 1-800-304-9102 or via email at [e-mail]. All information you provide will be kept confidential and will be used only to the extent required to provide needed reasonable accommodations.

For technical support or questions about Capital One's recruiting process, please send an email to [e-mail]

Capital One does not provide, endorse nor guarantee and is not liable for third-party products, services, educational tools or other information available through this site.

Capital One Financial is made up of several different entities. Please note that any position posted in Canada is for Capital One Canada, any position posted in the United Kingdom is for Capital One Europe and any position posted in the Philippines is for Capital One Philippines Service Corp. (COPSSC).