Lead Data Engineer (Python, AWS, SQL, GenAI) (Enterprise Platforms Technology)

Capital One; Chicago (IL); On-site; USD 179,000 - 205,000; Full time

Benefits offered by this job

Performance-based incentives

Job summary

Capital One is seeking a Lead Data Engineer to drive data engineering efforts across the Enterprise Platforms Technology organization. You will lead a team of developers, collaborate with Agile teams, and build scalable data pipelines using Python, SQL, and cloud data warehousing services.

The role emphasizes data modeling, governance, and using emerging technologies like GenAI. You will mentor engineers, contribute to platform improvements, and deliver robust cloud-based solutions for millions

Qualifications

• Bachelor's Degree required.
• At least 4 years of application development experience.
• At least 2 years of big data technologies experience.
• At least 1 year of cloud computing experience (AWS, Azure, GCP).
• Experience with Python, SQL, Spark, ETL tools, and cloud data warehousing.

Responsibilities

• Collaborate with Agile teams to design and deliver technical data solutions.
• Lead a team of developers in data movement, distributed computing, and full-stack systems.
• Utilize Python, SQL, Snowflake/Databricks for data warehousing and analytics.
• Optimize data design for end-user and downstream consumers.
• Mentor engineers and share knowledge of new technologies.

Skills

Python

SQL

Spark

ETL tools

AWS Glue

Big data

Cloud computing

NoSQL

Education

Bachelor's Degree

Tools

Snowflake

Databricks

Hadoop

Redshift

Kafka

MongoDB

MySQL

Job description

Lead Data Engineer (Python, AWS, SQL, GenAI) (Enterprise Platforms Technology)

Do you love building and pioneering in the technology space? Do you enjoy solving complex business problems in a fast-paced, collaborative, inclusive, and iterative delivery environment? At Capital One, you'll be part of a big group of makers, breakers, doers and disruptors, who solve real problems and meet real customer needs. We are seeking Sr. Data Engineers who are passionate about data, data modeling, data quality, governance and permissible use and building data pipelines with emerging technologies. As a Capital One Lead Data Engineer, you’ll have the opportunity to be on the forefront of driving a major transformation within Capital One.

Team

The Marketing and Messaging team is responsible for delivering hyper-personalized messages and experiences that will delight the customer, attract prospects and drive increasing business value. The team builds scalable platforms that deliver omnichannel messages in owned and paid Adtech channels.

What You’ll Do

• Collaborate with and across Agile teams to design, develop, test, implement, and support technical solutions using data movement tools and technologies.


• Work, as a lead developer, with a team of developers with deep experience in data movement, distributed computing, and full stack systems.


• Utilize programming languages like Python, SQL and Open Source RDBMS and NoSQL databases and Cloud based data warehousing services such as Snowflake, Databricks.


• Optimize information system for end-user and downstream application consumers by using sound data design practices.


• Share your passion for staying on top of tech trends, experimenting with and learning new technologies, participating in internal & external technology communities, and mentoring other members of the engineering community.


• Collaborate with digital product managers, and deliver robust cloud-based solutions that drive powerful experiences to help millions of Americans achieve financial empowerment.


• Perform unit tests and conduct reviews with other team members to make sure your code is rigorously designed, elegantly coded, and effectively tuned for performance.

Basic Qualifications

• Bachelor's Degree


• At least 4 years of experience in application development (Internship experience does not apply)


• At least 2 years of experience in big data technologies


• At least 1 year experience with cloud computing (AWS, Microsoft Azure, Google Cloud)

Preferred Qualifications

• 7+ years of experience in application development including Python, SQL, Spark, ETL tools, AWS Glue


• 4+ years of experience with a public cloud (AWS, Microsoft Azure, Google Cloud)


• 4+ years of experience with Distributed data/computing tools (MapReduce, Hadoop, Hive, EMR, Kafka, Spark, or MySQL)


• 4+ years of experience working on real-time data and streaming applications


• 4+ years of experience with NoSQL implementation (Mongo, Cassandra)


• 4+ years of data warehousing experience (Redshift or Snowflake)


• 4+ years of experience with UNIX/Linux including basic commands and shell scripting


• 4+ years of experience with data modeling for data warehousing


• 2+ years of experience with Agile engineering practices


• 1+ years of experience leveraging AI-assisted coding tools (Claude Code, GitHub Copilot) to accelerate the software delivery

Location & Salary

• Chicago, IL: $179,400 - $204,700 for Lead Data Engineer


• McLean, VA: $197,300 - $225,100 for Lead Data Engineer


• Candidate 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.

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.

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.