Job Description161 Bay Street (93021), Canada, Toronto,Toronto, Ontario,Manager, Underwriting & Valuations Strategy AnalystManager, Underwriting & Valuations Strategy AnalystAbout Capital One Canada.For 30 years, we’ve been on a mission to change banking for good and build relationships by making credit accessible, simple, intuitive and rewarding. We want to help Canadians succeed with credit, because we believe in people — in our customers, in our associates, and in talent like you!Yes, we’re a credit card company, but we’re more than that too. With your help, we’ll build the next generation of banking in Canada based on customer-focused values, compelling products and great engineering. Our Strategy & Analytics Roles are like management consulting, but better. From day one, you’ll have the opportunity to work on solving complex problems, using data-driven decision making to enhance the overall business strategy, while still maintaining work/life balance. At Capital One, we love to give our Strategy Analyst Managers the opportunity to rotate to roles across various teams, so while this role is within the Credit Modeling team, we will consider your application for multiple Strategy & Analytics teams as well as offer you the opportunity to rotate to new teams throughout your time at Capital One. This is part of our winning formula for creating great future leaders and as such, this role is well suited to high performers looking for growth opportunities.About the TeamThe Underwriting & Valuations team consists of Strategy Analysts and Data Scientists who come together to build our models and policies which lead to our underwriting outcomes. This team collaborates with our best in class Credit Risk Management group to create robust analysis and implement credit based strategies. About the RoleIn this role, you will be the lead analyst responsible for determining the optimal underwriting strategy for your area of the business. You will perform complex analysis using model outputs and latest insights to determine and propose the winning strategy. You will present your recommendation and gain buy in from leadership. You will function as the lead analyst among a group of analysts, responsible for the teams’ most complex problems and guiding junior analysts across the team. From a technical perspective, you’ll have access to various coding and visualization tools. You’ll work with SQL to query data, use spreadsheets and Python-based notebooks to organize it, and Slides to present it, along with other modern analytics tools, such as Tableau and Quicksight. This role will eventually evolve into a people leadership role, and you will join the Capital One Leads program, which focuses on developing people leadership skills to lead high-performing teams.
Your Responsibilities: You will be the lead analyst in one of the areas of underwriting and valuations, such as new applications or credit limit increases. You will have oversight of the most complex pieces of analysis in the area, including completing the analysis yourself and guiding the junior analysts on the team. You will create and present the recommendations to senior leadership and gain buy-in to proceed with strategies, which you will then implement, monitor and continue to improve as you see your strategy evolve. As the lead of your area, you will determine the strategic roadmap of the team and collaborate across the underwriting and valuations team to lead the change.You will use technical analytical skills (such as SQL and Python) to complete the analysis.
Basic Qualifications:At least 5 years of experience, with an established history of leveraging analytical skills to effectively influence strategic decisions A bachelor’s degree or higherExperience working in a team environment, with a strong ability to collaborate effectively with othersExperience in coding (e.g. Complete SQL scripts, Python notebooks) and presenting analytical information through slides and memosPreferred Qualifications:Experience in underwriting and valuations with a basic understanding of credit card or other loan based underwritingWorking at Capital One.Enjoy a hybrid work environment, with 3 days in the office. Build a comfortable workspace with our one-time, Work From Home allowance and enjoy our head office located conveniently across the street from Union Station.Live well—physically, financially and emotionally. Receive support for you and those who are most important to you, with full coverage for spouses, domestic partners, and dependents. With up to $3000 in mental health coverage and up to $5000 in tuition subsidies per year—and much more—you’ll discover that Capital One is committed to helping you live your best life.We may use your information for automated decision making. We may, for certain purposes, render a decision based exclusively on automated processing of your personal information as a part of the candidate screening process.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 ARCanada@capitalone.com. 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 Careers@capitalone.comCapital 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).
Job Description161 Bay Street (93021), Canada, Toronto,Toronto, Ontario,Senior Associate, Underwriting & Valuations Strategy AnalystAbout Capital One Canada.For 30 years, we’ve been on a mission to change banking for good and build relationships by making credit accessible, simple, intuitive and rewarding. We want to help Canadians succeed with credit, because we believe in people — in our customers, in our associates, and in talent like you!At Capital One we’re laser focused on growth, and our Strategy Analysts are integral to moving us forward. You’ll combine deep data analytics with strategic decisioning to solve problems that actually move the needle. From day one you’ll have high ownership over your work and outcomes, seeing projects through from end to end. You’ll start in Underwriting & Strategy, and have the ability to rotate across the business to explore, learn new skills and ultimately carve your own career trajectory. This role is a masterclass in business leadership designed for those who are energized by what’s possible and who challenge themselves and their peers to think bigger, as we collectively work towards our global mission. About the TeamThe Underwriting & Valuations team consists of Strategy Analysts and Data Scientists who come together to build our models and policies which lead to our underwriting outcomes. This team collaborates with our best in class Credit Risk Management group to create robust analysis and implement credit based strategies. About the RoleIn this role, you will get deep into the data, iterating on decision scenarios until you find the outcome that best aligns with your strategy. You will complete deep analysis and prepare robust presentations to gain approval and buy in from leadership. This role also provides the opportunity to work with product and strategy teams to implement the changes, understand customer behaviour and continue to iterate on your implemented strategy. From a technical perspective, you’ll have access to various coding and visualization tools. You’ll work with SQL to query data, use spreadsheets and Python-based notebooks to organize it, and Slides to present it, along with other modern analytics tools, such as Tableau and Quicksight. To continue your learning, you’ll also join the Canada Analyst Development Program (CADP), which takes place over your first year with us. The program provides comprehensive foundational training not only in credit underwriting but also across various other key areas, including marketing, fraud prevention, risk management, customer lifecycle, etc. to equip you with the skills and knowledge to make meaningful contributions to cross-functional projects.
Your Responsibilities: You will be responsible for one of the areas of underwriting and valuations, such as new applications or credit limit increases. You will deep dive into the performance of existing strategies, with access to a vast amount of data which you will analyze to create recommendations to determine how we extend credit.You will build the case to bring strategies to market and work with product and technology teams to implement them. With our in-house technology, you get to see your work through to delivery in real time. As the owner of the strategy, you can then evaluate performance and continue to adjust and improve your strategy as needed.As the expert of your area, you will influence the strategic roadmap of the team and collaborate across the underwriting and valuations team to drive change.You will use technical analytical skills (such as SQL and Python) to complete the analysis.
Basic Qualifications:2-5 years of experience, with an established history of leveraging analytical skills to effectively influence strategic decisions A bachelor’s degree or higherExperience working in a team environment, with a strong ability to collaborate effectively with othersExperience in coding (e.g. Complete SQL scripts, Python notebooks) and data visualization (e.g. Tableau, QuickSight).Preferred Qualifications:Experience in underwriting and valuations with a basic understanding of credit card or other loan based underwritingWorking at Capital One.Enjoy a hybrid work environment, with 3 days in the office. Build a comfortable workspace with our one-time, Work From Home allowance and enjoy our head office located conveniently across the street from Union Station. Live well—physically, financially and emotionally. Receive support for you and those who are most important to you, with full coverage for spouses, domestic partners, and dependents. With up to $3000 in mental health coverage and up to $5000 in tuition subsidies per year—and much more—you’ll discover that Capital One is committed to helping you live your best life. At Capital One Canada, paying our employees fairly is fundamental to our core values of Excellence and Do the Right Thing. We are committed to being intentional and fair in how we set pay across our organization.The salary range for this position is $112,300 to $128,100 per annum, depending on experience and qualifications.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 ARCanada@capitalone.com. 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 Careers@capitalone.comCapital 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).
Job Description161 Bay Street (93021), Canada, Toronto,Toronto, Ontario,Senior Associate, Product Strategy AnalystAbout Capital One CanadaFor 30 years, we’ve been on a mission to change banking for good and build relationships by making credit accessible, simple, intuitive and rewarding. We want to help Canadians succeed with credit, because we believe in people — in our customers, in our associates, and in talent like you!At Capital One we’re laser focused on growth, and our Strategy Analysts are integral to moving us forward. You’ll combine deep data analytics with strategic decisioning to solve problems that actually move the needle. From day one you’ll have high ownership over your work and outcomes, seeing projects through from end to end. You’ll start in Product Strategy, and have the ability to rotate across the business to explore, learn new skills and ultimately carve your own career trajectory. This role is a masterclass in business leadership designed for those who are energized by what’s possible and who challenge themselves and their peers to think bigger, as we collectively work towards our global mission.About the TeamThe Product Strategy team is a very cross-functional team that brings together Strategy Analysts with experts across the business to design our customer products and strategies. This team collaborates with our credit teams, marketing teams and product teams to analyse prospective and current customer behaviours to implement market leading product strategies.
About the RoleIn this role, you will dive into a wide range of data and insights to propose the next product strategy. You’ll design product tests to find the best new product offerings. You’ll conduct market and customer research, and couple these insights with internal data modeling to propose new solutions for our customers. From a technical perspective, you’ll have access to various coding and visualization tools. You’ll work with SQL to query data, use spreadsheets and Python-based notebooks to organize it, and Slides to present it, along with other modern analytics tools, such as Tableau and Quicksight. To continue your learning, you’ll also join the Canada Analyst Development Program (CADP), which takes place over your first year with us. The program provides comprehensive foundational training not only in product strategy but also across various other key areas, including underwriting, fraud prevention, risk management, customer lifecycle, etc. to equip you with the skills and knowledge to make meaningful contributions to cross-functional projects. Your Responsibilities: You will be responsible for one of the products, diving deep into current performance, analysing marketing insights and proposing the strategies to continue to grow the product. You will build the case to bring strategies to market and work with product and technology teams to implement them. With our in-house technology, you get to see your work through to delivery in real time. As the owner of the strategy, you can then evaluate performance and continue to adjust and improve your strategy as needed.As the expert of your area, you will influence the strategic roadmap of the team and collaborate across the product strategy team to drive change to our customer experiences.You will use technical analytical skills (such as SQL and Python) to complete the analysis - don’t worry if you don’t know this now, we will help you learn.
Basic Qualifications:2-5 years of experience, with an established history of leveraging analytical skills to effectively influence strategic decisions A bachelor’s degree or higherExperience working in a team environment, with a strong ability to collaborate effectively with others
Preferred Qualifications:Experience in product strategy or digital marketing with a basic understanding of credit card or other loan based underwritingExperience in coding (e.g. Complete SQL scripts, Python notebooks) and data visualization (e.g. Tableau, QuickSight). If you know how to build models or write code, that’s awesome. If not, we will help you learn it.Working at Capital OneEnjoy a hybrid work environment, with 3 days in the office. Build a comfortable workspace with our one-time, Work From Home allowance and enjoy our head office located conveniently across the street from Union Station. Live well—physically, financially and emotionally. Receive support for you and those who are most important to you, with full coverage for spouses, domestic partners, and dependents. With up to $3000 in mental health coverage and up to $5000 in tuition subsidies per year—and much more—you’ll discover that Capital One is committed to helping you live your best life. At Capital One Canada, paying our employees fairly is fundamental to our core values of Excellence and Do the Right Thing. We are committed to being intentional and fair in how we set pay across our organization.The salary range for this position is $112,300 to $128,100 per annum, depending on experience and qualifications.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 ARCanada@capitalone.com. 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 Careers@capitalone.comCapital 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).
Job Description161 Bay Street (93021), Canada, Toronto,Toronto, Ontario,Senior Associate, Fraud Strategy AnalystAbout Capital One Canada.For 30 years, we’ve been on a mission to change banking for good and build relationships by making credit accessible, simple, intuitive and rewarding. We want to help Canadians succeed with credit, because we believe in people — in our customers, in our associates, and in talent like you!At Capital One we’re laser focused on growth, and our Strategy Analysts are integral to moving us forward. You’ll combine deep data analytics with strategic decisioning to solve problems that actually move the needle. From day one you’ll have high ownership over your work and outcomes, seeing projects through from end to end. You’ll start in Product Strategy, and have the ability to rotate across the business to explore, learn new skills and ultimately carve your own career trajectory. This role is a masterclass in business leadership designed for those who are energized by what’s possible and who challenge themselves and their peers to think bigger, as we collectively work towards our global mission. About the TeamThe Fraud team consists of Strategy Analysts, Data Scientists, Process Managers and Product Managers who come together to prevent and detect fraud. We leverage in-house and/or third-party vendor models, data insights and home-grown technology solutions to protect our customers from fraud and deliver reassuring customer experiences when fraud does happen. About the RoleIn this role, you will develop defenses and policies to mitigate fraud losses while balancing the impact on the customer experience and lifecycle journey. You will perform deep dives into data, investigate emerging fraud trends, and implement strategies to prevent fraudulent behaviour. Additionally, this role provides the opportunity to work on and lead diverse projects, including new product launches, feature enhancements, and authentication tool rollouts, all while contributing to a safe and secure experience for our customers. From a technical perspective, you’ll have access to various coding and visualization tools. You’ll work with SQL to query data, use spreadsheets and Python-based notebooks to organize it, and Slides to present it, along with other modern analytics tools, such as Tableau and Quicksight. To continue your learning, you’ll also join the Canada Analyst Development Program (CADP), which takes place over your first year with us. The program provides comprehensive foundational training not only in fraud prevention but also across various other key areas, including marketing, credit underwriting, risk management, customer lifecycle, etc. to equip you with the skills and knowledge to make meaningful contributions to cross-functional projects. Your Responsibilities: You will be responsible for one of the areas of credit card fraud, such as transaction fraud or fraud applications. You will deep dive into the performance of existing strategies, with access to a vast amount of data which you will analyze to create recommendations to identify and stop emerging fraud trends.You will build the case to bring strategies to market and work with product and technology teams to implement them. With our in-house technology, you get to see your work through to delivery in real time. As the owner of the strategy, you can then evaluate performance and continue to adjust and improve your strategy as needed.As the expert of your area, you will influence the strategic roadmap of the team and collaborate across the fraud team to drive change to our overall fraud experiences.You will use technical analytical skills (such as SQL and Python) to complete the analysis - don’t worry if you don’t know this now, we will help you learn.
Basic Qualifications:2-5 years of experience, with an established history of leveraging analytical skills to effectively influence strategic decisions A bachelor’s degree or higherExperience working in a team environment, with a strong ability to collaborate effectively with others
Preferred Qualifications:Experience in fraud strategy analytics with a basic understanding of credit card or other financial fraudExperience in coding (e.g. Complete SQL scripts, Python notebooks) and data visualization (e.g. Tableau, QuickSight). If you know how to build models or write code, that’s awesome. If not, we will help you learn it.Working at Capital One.Enjoy a hybrid work environment, with 3 days in the office. Build a comfortable workspace with our one-time, Work From Home allowance and enjoy our head office located conveniently across the street from Union Station. Live well—physically, financially and emotionally. Receive support for you and those who are most important to you, with full coverage for spouses, domestic partners, and dependents. With up to $3000 in mental health coverage and up to $5000 in tuition subsidies per year—and much more—you’ll discover that Capital One is committed to helping you live your best life. At Capital One Canada, paying our employees fairly is fundamental to our core values of Excellence and Do the Right Thing. We are committed to being intentional and fair in how we set pay across our organization.The salary range for this position is $112,300 to $128,100 per annum, depending on experience and qualifications.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 ARCanada@capitalone.com. 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 Careers@capitalone.comCapital 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).
Job Description161 Bay Street (93021), Canada, Toronto,Toronto, Ontario,Senior Associate, Strategy AnalystAbout Capital One CanadaFor 30 years, we’ve been on a mission to change banking for good and build relationships by making credit accessible, simple, intuitive and rewarding. We want to help Canadians succeed with credit, because we believe in people — in our customers, in our associates, and in talent like you!At Capital One we’re laser focused on growth, and our Strategy Analysts are integral to moving us forward. You’ll combine deep data analytics with strategic decisioning to solve problems that actually move the needle. From day one you’ll have high ownership over your work and outcomes, seeing projects through from end to end. You’ll start in Product Strategy, and have the ability to rotate across the business to explore, learn new skills and ultimately carve your own career trajectory. This role is a masterclass in business leadership designed for those who are energized by what’s possible and who challenge themselves and their peers to think bigger, as we collectively work towards our global mission.About the RoleAs a Strategy Analyst, you’ll develop and apply analytical rigour, problem solving skills and critical thinking from day one. Embedded within a cross-functional team, you’ll bring your strategies to life from conception and analytical business case building to in-market delivery, measuring their impact through testing and monitoring, and ultimately being accountable for both customer and financial outcomes. You’ll spend time gathering and visualizing data, storytelling through presentations, collaborating with experts in areas like legal and technology, and influencing senior leadership on critical decisions.From a technical perspective, you’ll have access to various coding and visualization tools. You’ll work with SQL to query data, use spreadsheets and Python-based notebooks to organize it, and Slides to present it, along with other modern analytics tools, such as Tableau and Quicksight. To continue your learning, you’ll also join the Canada Analyst Development Program (CADP), which takes place over your first year with us. The program provides comprehensive foundational training not only in product strategy but also across various other key areas, including underwriting, fraud prevention, risk management, customer lifecycle, etc. to equip you with the skills and knowledge to make meaningful contributions to cross-functional projects. Your Responsibilities: Perform modeling/analytics to assist and lead new product and pricing strategies for various lending products.Develop direct-to-consumer marketing strategies and initiatives to support business growth objectives.Help build targeted insights to inform the design and development of new customer experiences, as well as breakthrough technology and concepts designed to deliver on new go to market strategies.Support and lead step-change improvements in credit performance by connecting drivers of future consumer credit trends to historical behaviour, creating risk models, and testing hypotheses using rigorous monitoring and analysis.
Basic Qualifications:2-5 years of experience, with an established history of leveraging analytical skills to effectively influence strategic decisions A bachelor’s degree or higherExperience working in a team environment, with a strong ability to collaborate effectively with others
Preferred Qualifications:Experience in coding (e.g. Complete SQL scripts, Python notebooks) and data visualization (e.g. Tableau, QuickSight). If you know how to build models or write code, that’s awesome. If not, we will help you learn it.Experience in analytical problem-solving.Working at Capital OneEnjoy a hybrid work environment, with 3 days in the office. Build a comfortable workspace with our one-time, Work From Home allowance and enjoy our head office located conveniently across the street from Union Station. Live well—physically, financially and emotionally. Receive support for you and those who are most important to you, with full coverage for spouses, domestic partners, and dependents. With up to $3000 in mental health coverage and up to $5000 in tuition subsidies per year—and much more—you’ll discover that Capital One is committed to helping you live your best life. At Capital One Canada, paying our employees fairly is fundamental to our core values of Excellence and Do the Right Thing. We are committed to being intentional and fair in how we set pay across our organization.The salary range for this position is $112,300 to $128,100 per annum, depending on experience and qualifications.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 ARCanada@capitalone.com. 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 Careers@capitalone.comCapital 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).
Job Description161 Bay Street (93021), Canada, Toronto,Toronto, Ontario,Senior Associate, Data AnalystAbout Capital One CanadaFor 30 years, we’ve been on a mission to change banking for good and build relationships by making credit accessible, simple, intuitive and rewarding. We want to help Canadians succeed with credit, because we believe in people — in our customers, in our associates and in talent like you!About the TeamData is at the centre of everything we do at Capital One. Your role as a Data Analyst on the team will heavily leverage your deep expertise in SQL. You will be a creative data wrangler, comfortable with extracting, transforming and analyzing large, complex datasets to uncover new narratives. This requires more than just the ability to write complex, performant queries; you must also possess a thorough understanding of database structures, query optimization techniques and best practices for data governance. Ultimately, you will be a proactive collaborator, skilled at articulating complex ideas through data visualization tools like QuickSight, Tableau or Matplotlib and eagerly sharing your knowledge across diverse teams.
About the RoleIn this role, you will serve as a vital partner to the business, influencing strategy and execution across key areas like fraud prevention, credit risk or marketing. This role requires a blend of advanced technical analysis skills and strong business acumen to tackle complex challenges and deliver groundbreaking solutions. You will be responsible for translating technical insights into clear, concise and actionable strategic recommendations. Success in this position involves working effectively with both technical and non-technical stakeholders to implement strategies and innovative solutions that enhance performance, mitigate risk and drive profitable growth.Your Responsibilities:Strategic Stakeholder Partnership & Business Recommendations: Engage directly with senior stakeholders (e.g., line-of-business leads, product owners, risk management) to deeply understand business goals, challenges and decision needs. Partner with them to prioritize initiatives and refine strategies. Drive business strategy by proactively identifying, quantifying risks and translating complex analysis into compelling, concise recommendations that guide critical roadmap and decision-making processes.Actionable Insight and Executive Storytelling: Draw clear business conclusions and present comprehensive insights that explain "what happened," "why it happened," "what it means" and "what we recommend doing next" (including risk mitigation or growth levers). Design and deploy rich data visualizations and craft crisp, executive-ready narratives and dashboards to empower senior leadership to make high-stakes decisions efficiently.End-to-End Data Analysis and Execution: Lead the full data analysis lifecycle, translating complex business problems into defined specifications and final implemented solutions.Data Preparation & Transformation: Apply expert-level SQL skills to efficiently transform raw data into clean, accessible datasets for yourself and other analysts.Governance, Reporting and Automation: Build, automate and maintain critical business reporting and controls for processes and proactively identify and deliver process improvements for efficiency.
Basic Qualifications:At least 2 years of professional experience with SQL (e.g., Snowflake, MySQL, SQL Server, PostgreSQL, Microsoft SQL Server, Oracle, etc.).Proficient in SQL for data extraction, wrangling and advanced analytics including Joins, Window Functions, CTEs, Aggregations and performance trending across large enterprise data environments.
Preferred Qualifications:Bachelor's or Master's Degree in a quantitative field such as Data Analytics, Data Science, Computer Science, Engineering, Mathematics, Statistics, Economics, Finance or a related discipline.At least 1 year of professional experience using dbt (data build tool) for data transformation, modeling and maintaining a production-ready data warehouse.At least 1 year of experience applying strong analytical and mathematical skills to solve complex business problems.Effective stakeholder management experience with strong skills in communication, negotiation, strategic thinking, influence and technical abilities is highly desirable.Proficient in data analysis within a cloud environment, including experience with open-source programming (e.g., Python), advanced SQL for large datasets (e.g. Snowflake), version control (e.g. Git/GitHub) and cloud services (e.g. AWS).Experience with Linux or equivalent is preferred.Working at Capital One.Enjoy a hybrid work environment, with 3 days in the office. Build a comfortable workspace with our one-time, Work From Home allowance and enjoy our head office located conveniently across the street from Union Station.Live well—physically, financially and emotionally. Receive support for you and those who are most important to you, with full coverage for spouses, domestic partners, and dependents. With up to $3000 in mental health coverage and up to $5000 in tuition subsidies per year—and much more—you’ll discover that Capital One is committed to helping you live your best life.We may use your information for automated decision making. We may, for certain purposes, render a decision based exclusively on automated processing of your personal information as a part of the candidate screening process.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 ARCanada@capitalone.com. 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 Careers@capitalone.comCapital 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).
