Intern, Data Analytics Engineering - Winter 2027

Capital One; Toronto; Hybrid; CAD 39,000 - 61,000; Full time

Job summary

Capital One Canada is seeking an Intern, Data Analytics Engineering for Winter 2027 to work with cross-functional teams on building tools and data structures for analytics. The role involves transforming data in data lake and Snowflake, owning end-to-end recommendations from problem identification to deployment, and delivering robust reporting and visualizations to drive business decisions.

A quantitative degree, SQL/background, and prior internship experience are preferred; hybrid work allows

Qualifications

• Pursuing a Bachelor’s degree between September 2027 and September 2028.
• Strong programming background with quantitative discipline.
• Familiarity with SQL and data transformation tools such as dbt.

Responsibilities

• Transform data into data structures in our data lake and Snowflake data warehouse for decision making.
• Create, enhance and maintain critical data processes and reports.
• Ensure data quality, documentation, and usability as a data steward.
• Build, automate, and maintain business reporting and visualizations to deliver insights.
• Conduct investigative analysis on large and diverse datasets.

Skills

SQL

Python

Data pipelines

Snowflake

Git

Education

Bachelor’s degree

Tools

dbt

Job description

161 Bay Street (93021), Canada, Toronto, Ontario. Intern, Data Analytics Engineering - Winter 2027.

About Capital One Canada

For 30 years, we’ve been on a mission to change banking for good. We challenge the traditional bank stereotype, fostering a culture where innovation thrives and bold ideas are celebrated. You’ll be empowered to grow your career in a supportive environment where you can own and shape your journey on your own terms. You’ll redefine what’s possible by contributing to work that impacts millions of Canadians, taking ownership of your decisions and outcomes, supported by mentors who will push you to think bigger and challenge the status quo. Are you ready to redefine what’s next?

About the Team

Capital One is more than you think. We're a data-driven tech company that just happens to do credit cards. We focus on customer-first solutions, and we're united with this common goal. We have all the advantages of a startup, with the resources of a big company. Working here means you're curious, innovative spirit will be encouraged as you push boundaries and try new things, while your career is nurtured and supported. Our environment is creative and filled with teams that are passionate about the dynamic work they're doing. We're ahead of other banks in tech and we want to keep it that way.

About the Role

As a Data Analytics Engineering Intern, you will work with cross-functional teams to develop tools and data structures. As a creative problem-solver, you will be challenged to consider multiple options and select the optimal solution to meet the needs of your customers. You will own the recommendation and resolution to an existing business problem and will be involved end to end, from problem identification to solution deployment.

Your Responsibilities

• Transform data into data structures in our data lake and Snowflake data warehouse that are leveraged for business decision making.
• Create, enhance and maintain critical data processes.
• Act as a steward for our data: ensuring it is high quality, trustworthy, well documented, and easy to use.
• Build, automate, and maintain critical business reporting and visualizations that helps deliver insights.
• Perform investigative analysis on large/diverse dataset.

Basic Qualifications

• Will obtain a Bachelor’s degree or higher between September 2027 and September 2028.

Preferred Qualifications

• Pursuing a Bachelor's degree in Mathematics, Computer Science, Engineering, or another quantitative discipline with a strong programming background.
• Familiarity with SQL and/or data transformation tools such as dbt.
• Python experience would also be an asset.
• Experience building and maintaining data pipelines.
• Ability to shape and develop requirements into practical solutions.
• Ability to clearly explain technical terms to a non-technical audience.
• Experience in a Unix/Linux environment, with Git, AWS, or APIs.
• Excellent verbal and written communication skills.
• Previous intern experience.

Working at Capital One

Here you’ll uncover personal strengths, explore new interests and make an impact that matters. The work you’ll find here will keep you inspired and guide you in your career journey. Take ownership of your own potential: As you begin your career, you’ll define your own path by gaining exposure across the business, learning new skills, and having access to tools and mentorship to understand your potential. Find your rhythm: We believe trust fosters the flexibility and autonomy required to balance personal needs with a focus on high performance. We support a hybrid model – with 3 days in the office per week – that gives room for both collaboration and personal commitments. A supportive community from day one: Through our robust onboarding program, orientation sessions, buddy program for new hires and early career development programs, you’ll get foundational training while building connections with your peers and leaders – cultivating a supportive community you can lean on for support and guidance. You’ll find that Capital One is committed to helping you thrive and evolve every step of the way.

Salary

The expected salary range for this position is $28.21 per hour to $43.59 per hour.

Artificial Intelligence

Weembrace the responsible use of artificial intelligence (AI) to enhance the candidate experience and streamline our recruitment processes. However, no hiring decisions are made using AI as every hiring decision is made by our hiring managers, business interviewers, and recruitment professionals. Our teams are equipped with training that empowers them to use AI responsibly.

Diversity and Inclusion

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.

Miscellaneous

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). At Capital One, we’re building a leading information-based technology company. Still founder‑led by Chairman and Chief Executive Officer Richard Fairbank, Capital One is on a mission to help our customers succeed by bringing ingenuity, simplicity, and humanity to banking. We measure our efforts by the success our customers enjoy and the advocacy they exhibit.