Principal Associate ETL Designer and Lead for SOX Compliance

West Creek 4 (12074), United States of America, Richmond, Virginia

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. We are succeeding because they are succeeding.

Guided by our shared values, we thrive in an environment where collaboration and openness are valued. We believe that innovation is powered by perspective and that teamwork and respect for each other lead to superior results. We elevate each other and obsess about doing the right thing. Our associates serve with humility and a deep respect for their responsibility in helping our customers achieve their goals and realize their dreams. Together, we are on a quest to change banking for good.

Principal Associate ETL Designer and Lead for SOX Compliance

In this role, you will be driving technology solutions that enable our company's Third Party Data Sharing (TPDS) program initiatives. As regulations continue to evolve in regards to the data that is disclosed with third party organizations, it is our duty to deliver a technology and data framework that ensure regulatory compliance.


  • Work with internal business groups, and provide technical consult on software and data engineering practices in the context of new TPDS initiatives
  • Implement technology solutions with agile development teams through the Software Delivery Lifecycle
  • Collaborate with other Tech platforms and partners to engineer an integrated, end-to-end view of the data flow across technology layers
  • Drive and document the Technical Design considerations required for solution delivery:
  • Fit-Gap analyses, non-functional system analyses (security, scalability, performance, reliability, recoverability, etc), system architecture / context diagrams, Source to Target
  • Mappings (STTM), Extract Transform Load (ETL) approach, etc
  • Support and / or perform the development and testing required to ensure successful implementation into Production
  • Drive current platforms towards target-state architecture, tools and technologies
  • Innovate via process improvements, enhancements and automation, with focus on
  • Continuous Improvement / Continuous Development (CI/CD)

Basic Qualifications
  • Bachelor's Degree or military experience
  • 3 or more years of experience in system analysis
  • 3 or more years of experience in delivering technology projects, involving 10 or more team members
  • 3 or more years of experience in data ETL & lineage, systems integration, or data engineering

Preferred Qualifications:
  • Amazon Web Services (AWS) Architect or Developer certification
  • 1+ years of experience in software development for Commercial Off The Shelf (COTS) software
  • 1+ years experience with SQL
  • 1+ years prior experience with Technology Sarbanes-Oxley (SOX) regulations and compliance
  • 1+ years prior experience in Spark Scala, Ab Initio, Java and / or similar coding language
  • 1+ years prior experience in Python, Perl and / or similar scripting language
  • 1+ years prior experience in Cloud-supported data formats (JSON, Parquet, Avro, etc)

At this time, Capital One will not sponsor a new applicant for employment authorization for this position.

Back to top