OfferDrill.

Jobs › Capital One

Principal Data Analyst - BIN/IIN Management (Open)

Capital One · Riverwoods, IL · Full time

Posted Oct 2, 2026 · We last checked this listing on Oct 6, 2026

Apply at Capital One

Likely interview questions for this role

Written from this job description, not a generic list. Each one notes what the interviewer is really checking.

About your past

Tell me about a self-service data tool or dashboard you built that people actually used.

What they are checking: Whether they can build well-managed data products, not just one-off queries.

Tell me about a time you had to learn a new technology quickly to finish a project.

What they are checking: Whether they can pick up open source and cloud tools fast, which the role calls out.

How would you explain a data quality problem to a business leader who just wants the number?

What they are checking: Whether they can communicate data limits clearly without losing the partner's trust.

What would you do

A business partner asks for a dashboard but can't say what decision it will support. How do you handle it?

What they are checking: Whether they consult and clarify the real need before building, as the posting describes.

You find that two systems disagree on which issuer owns a BIN range. What do you do?

What they are checking: Whether they can trace the source of truth and fix the process, not just patch the number.

About the work

Explain what a BIN or IIN is and why managing those ranges accurately matters to a payment network.

What they are checking: Whether they understand the domain well enough to see how a bad BIN record breaks routing and acceptance.

How would you find overlapping or conflicting BIN ranges in a large table using SQL?

What they are checking: Whether they have hands-on SQL skill with ranges and self-joins, the core of BIN data quality work.

The industry moved from six-digit to eight-digit BINs. What data problems would you expect that to create?

What they are checking: Whether they can anticipate migration issues like mixed lengths and duplicate mappings across systems.

How do you make sure the data you publish is correct before others rely on it?

What they are checking: Whether they have real validation habits, since others will make decisions from their work.

What makes a data solution well-managed in a bank, in your view?

What they are checking: Whether they think about ownership, documentation, lineage and controls along with the code.

Practice this interview out loud.

Offer builds a real interview for this exact role at Capital One from your resume and this job description, asks the questions one at a time, and tells you what landed. The first one is free.

Practice this out loud

The full job description

As published by Capital One.

Principal Data Analyst - BIN/IIN Management (Open) Job Description At Capital One, data is at the center of everything we do. When we launched as a startup we disrupted the credit card industry by individually personalizing every credit card offer using statistical modeling and the relational database, cutting edge technology in 1988! Fast-forward a few years, and this little innovation and our passion for data has skyrocketed us to a Fortune 200 company and a leader in the world of data-driven decision-making. As a Data Analyst at Capital One you will leverage analytic and technical skills to innovate, build, and maintain well-managed data solutions and capabilities to tackle business problems. On any given day you will be challenged on three types of work – Innovation, Business Intelligence and Data Management: Innovation • Use Open Source/Digital technologies to mine complex, voluminous, and different varieties of data sources and platforms • Build well-managed data solutions, tools, and capabilities to enable self-service frameworks for data consumers • Demonstrate ability to explore and quickly grasp new technologies to progress varied initiatives Business Intelligence • Partner with the business to provide consultancy and translate the business needs to design and develop tools, techniques, metrics, and dashboards for insights and data visualization • Drive analysis that provides meaningful insights on business strategies Data Management • Drive an understanding and adherence to the principles of data quality management including metadata, lineage, and business definitions • Work collaboratively with appropriate Tech teams to manage security mechanisms and data access governance • Build and execute tools to monitor and report on data quality Our ideal candidate will have: • Degree specialized in a Science, Technology, Engineering, Mathematics discipline • Scripting experience in (Python, R, Spark, and SQL) • Strong desire and experience with data in various forms (data warehouses/SQL, unstructured data) • Experience utilizing and developing within AWS services Basic Qualifications • Currently has, or is in the process of obtaining a Bachelor’s Degree in quantitative field (Statistics, Economics, Operations Research, Analytics, Mathematics, Computer Science or a related quantitative field) plus at least 5 years of experience performing data analytics, or currently has, or is in the process of obtaining a Master’s Degree plus at least 3 years performing data analytics with an expectation that required degree will be obtained on or before the scheduled start date. • At least 3 years of experience working with at least one scripting language • At least 3 years of experience utilizing a business intelligence visualization tool • At least 3 years of experience in querying, analyzing and working with data languages and platforms Preferred Qualifications: • Master’s Degree in a Science, Technology, Engineering, Mathematics discipline • At least 4 years of experience coding in Python, R, Spark, or SQL • At least 4 years of experience working within process management and improvement methodologies – Agile, Lean, Six Sigma, etc. • At least 2 years of experience utilizing and developing within AWS services • At least 2 years of experience delivering Data Governance and Data Quality Management concepts and practices within the financial services industry Capital One will consider sponsoring a new qualified applicant for employment authorization for this position. The minimum and maximum full-time annual salaries for this role are listed below, by location. Please note that this salary information is solely for candidates hired to perform work within one of these locations, and refers to the amount Capital One is willing to pay at the time of this posting. Salaries for part-time roles will be prorated based upon the agreed upon number of hours to be regularly worked. McLean, VA: $131,300 - $149,800 for Principal Data Analyst Richmond, VA: $119,400 - $136,200 for Principal Data Analyst Riverwoods, IL: $119,400 - $136,200 for Principal Data Analyst Chicago, IL: $119,400 - $136,200 for Principal Data Analyst Candidates hired to work in other locations will be subject to the pay range associated with that location, and the actual annualized salary amount offered to any candidate at the time of hire will be reflected solely in the candidate’s offer letter. This role is also eligible to earn performance based incentive compensation, which may include cash bonus(es) and/or long term incentives (LTI). Incentives could be discretionary or non discretionary depending on the plan. Capital One offers a comprehensive, competitive, and inclusive set of health, financial and other benefits that support your total well-being. Learn more at the Capital One Careers website . Eligibility varies based on full or part-time status, exempt or non-exempt status, and management level. This role is expected to accept applications for a minimum of 5 business days. No agencies please. Capital One is an equal opportunity employer (EOE, including disability/vet) committed to non-discrimination in compliance with applicable federal, state, and local laws. Capital One promotes a drug-free workplace. Capital One will consider for employment qualified applicants with a criminal history in a manner consistent with the requirements of applicable laws regarding criminal background inquiries, including, to the extent applicable, Article 23-A of the New York Correction Law; San Francisco, California Police Code Article 49, Sections 4901-4920; New York City’s Fair Chance Act; Philadelphia’s Fair Criminal Records Screening Act; and other applicable federal, state, and local laws and regulations regarding criminal background inquiries. 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 RecruitingAccommodation@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.com 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).

Apply at Capital One