Systems Architect 2 - Cloud Data Engineer (Databricks)

US Bank; Cincinnati (OH); On-site; USD 125,000 - 170,000; Full time

Benefits offered by this job

Healthcare (medical, dental, vision)

401(k) plan

Paid vacation

Sick and Safe Leave

Paid holidays

Parental leave

Adoption assistance

Job summary

U.S. Bank is seeking an experienced architect to lead the design of scalable Databricks Lakehouse architectures. You will migrate Oracle SQL workloads to cloud data platforms, build high-volume ETL/ELT pipelines, and optimize performance across distributed data processing environments.

The role requires strong Python/PySpark skills, Delta Lake expertise, and collaboration with cloud, security, and application teams to deliver secure, scalable data solutions.

Qualifications

• Bachelor's degree or equivalent experience in a technical field.
• 7–9 years in technology architectural design, or 10+ years across disciplines.
• Proven hands-on Databricks and SQL/PLSQL expertise.

Responsibilities

• Design and implement scalable Databricks Lakehouse architectures.
• Develop data solutions using Databricks, Python, PySpark, and Delta Lake.
• Migrate Oracle SQL/PLSQL workloads to cloud-based data platforms.
• Design and implement high-volume ETL/ELT pipelines and data ingestion.
• Optimize Databricks performance, including SQL queries and compute utilization.
• Integrate Databricks with Oracle, AWS S3, and analytics platforms.
• Establish reusable data architecture and CI/CD standards.
• Collaborate with cross-functional teams to deliver scalable data solutions.

Skills

Databricks Lakehouse

Python

PySpark

SQL performance tuning

Orac le databases

ETL/ELT pipelines

CI/CD

Cloud data platforms

Education

Bachelor's degree or equivalent experience

Tools

Databricks

Delta Lake

Oracle SQL

AWS S3

Git

SQL tooling

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.

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

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 sys