Systems Architect 2 - Cloud Data Engineer (Databricks)

U.S. Bank National Association; Cincinnati (OH); On-site; USD 112,000 - 131,000; Full time

Benefits offered by this job

Healthcare

Life insurance

Disability insurance

Parental leave

401(k)

Paid vacation

Paid holidays

Adoption assistance

Sick leave

Job summary

U.S. Bank is seeking a senior-level architect to lead multi-discipline architectural development. You will design scalable Databricks Lakehouse solutions, migrate Oracle workloads to cloud platforms, and mentor staff while coordinating across cloud, security, and data teams.

The role emphasizes enterprise standards, CI/CD, and high-volume data processing, with hybrid work from designated U.S. Bank locations. Strong focus on performance tuning and cross-functional collaboration.

Qualifications

• Bachelor's degree or equivalent experience.
• 7–9 years in technology architecture; or 10+ years across disciplines.

Responsibilities

• Design scalable Databricks Lakehouse architectures for enterprise workloads.
• Develop data solutions using Databricks, Python, PySpark, and Delta Lake.
• Migrate Oracle SQL/PL/SQL workloads to Databricks and cloud platforms.
• Design high-volume ETL/ELT pipelines and data ingestion.
• Optimize Databricks performance and SQL queries.
• Integrate Databricks with Oracle, AWS S3, and analytics platforms.
• Establish data architecture, CI/CD, security, and platform standards.
• Collaborate with cloud, infrastructure, database, security, and apps teams.

Skills

Databricks

Delta Lake

PySpark

Python

SQL tuning

Oracle databases

ETL/ELT pipelines

CI/CD

Distributed data processing

Data architecture

Troubleshooting

Education

Bachelor's degree or equivalent experience

Tools

Databricks Workflows

Unity Catalog

AWS S3

Oracle

Job description

At U.S. Bank, we're on a journey to do our best. Helping the customers and businesses we serve to make better and smarter financial decisions and enabling the communities we support to grow and succeed. We believe it takes all of us to bring our shared ambition to life, and each person is unique in their potential. A career with U.S. Bank gives you a wide, ever-growing range of opportunities to discover what makes you thrive at every stage of your career. Try new things, learn new skills and discover what you excel at—all from Day One.

Job Description

Provides technical direction, guidance and support for architectural development that encompasses multiple technology disciplines, platforms and applications. Facilitates creation of architectural blueprints as documentation of design and systems integration. Ensures projects are designed within approved enterprise architectural standards and are implemented successfully. Coordinates communication to management and teams regarding project development, strategy and goals. May function as a Project Leader. Provides direction and mentoring for less experienced staff.

Key Responsibilities

• Design and implement scalable Databricks Lakehouse architectures supporting enterprise data processing, analytics, and high-volume workloads.
• Develop data solutions using Databricks, Python, PySpark, Databricks SQL, and Delta Lake.
• Modernize and migrate complex Oracle SQL and PL/SQL workloads to Databricks and cloud-based data platforms.
• Design and implement high-volume ETL/ELT pipelines, data ingestion, transformation, orchestration, and integration solutions.
• Optimize Databricks performance, including SQL queries, data layouts, compute utilization, jobs, and distributed data processing.
• Integrate Databricks with Oracle databases, AWS S3, cloud object storage, enterprise applications, and analytics platforms.
• Establish reusable data architecture, engineering, CI/CD, security, and platform standards using Databricks best practices.
• Partner with cloud, infrastructure, database, security, and application teams to troubleshoot issues and deliver scalable, secure, and supportable data solutions.

Basic Qualifications

• Bachelor's degree, or equivalent experience
• Seven to nine years of experience in a specialized area of technology architectural design process, or
• Ten or more years of experience across technology disciplines

Skills & Qualifications

• Strong hands-on experience with Databricks, Databricks Lakehouse, Delta Lake, and distributed data processing.
• Advanced development skills in Python, PySpark, Databricks SQL, and SQL performance tuning.
• Strong experience with Oracle databases, SQL, and PL/SQL, including stored procedures, packages, and complex data workloads.
• Proven experience with Oracle-to-Databricks, legacy-to-cloud, or cloud data platform migrations.
• Experience designing high-volume ETL/ELT pipelines, data integration, data ingestion, and transformation solutions.
• Experience with Databricks Workflows/Lakeflow Jobs, Unity Catalog, and AWS S3/cloud object storage.
• Strong knowledge of data architecture, distributed computing, performance optimization, CI/CD, and source control.
• Strong troubleshooting, problem-solving, and cross-functional collaboration skills; experience with financial or transactional data preferred.

Location expectations

This role requires working from a U.S. Bank location three (3) or more days per week.

If there's anything we can do to accommodate a disability during any portion of the application or hiring process, please refer to our disability accommodations for applicants.

Benefits:

• Healthcare (medical, dental, vision)

• Basic term and optional term life insurance

• Short-term and long-term disability

• Pregnancy disability and parental leave

• 401(k) and employer-funded retirement plan

• Paid vacation (from two to five weeks depending on salary grade and tenure)

• Up to 11 paid holiday opportunities

• Adoption assistance

• Sick and Safe Leave accruals of one hour for every 30 worked, up to 80 hours per calendar year unless otherwise provided by law

Review our full benefits available by employment status here.

U.S. Bank is an equal opportunity employer. We consider all qualified applicants without regard to race, religion, color, sex, national origin, age, sexual orientation, gender identity, disability or veteran status, and other factors protected under applicable law.

E-Verify

U.S. Bank participates in the U.S. Department of Homeland Security E-Verify program in all facilities located in the United States and certain U.S. territories. The E-Verify program is an Internet-based employment eligibility verification system operated by the U.S. Citizenship and Immigration Services. Learn more about the E-Verify program.

The salary range reflects figures based on the primary location, which is listed first. The actual range for the role may differ based on the location of the role. In addition to salary, U.S. Bank offers a comprehensive benefits package, including incentive and recognition programs, equity stock purchase 401(k) contribution and pension (all benefits are subject to eligibility requirements). Pay Range: $111,605.00 - $131,300.00

U.S. Bank will consider qualified applicants with arrest or conviction records for employment. U.S. Bank conducts background checks consistent with applicable local laws, including the Los Angeles County Fair Chance Ordinance and the California Fair Chance Act as well as the San Francisco Fair Chance Ordinance. U.S. Bank is subject to, and conducts background checks consistent with the requirements of Section 19 of the Federal Deposit Insurance Act (FDIA). In addition, certain positions may also be subject to the requirements of FINRA, NMLS registration, Reg Z, Reg G, OFAC, the NFA, the FCPA, the Bank Secrecy Act, the SAFE Act, and/or federal guidelines applicable to an agreement, such as those related to ethics, safety, or operational procedures.

Applicants must be able to comply with U.S. Bank policies and procedures including the Code of Ethics and Business Conduct and related workplace conduct and safety policies.

Posting may be closed earlier due to high volume of applicants.