Systems Architect 2 - Cloud Data Engineer (Databricks)

U.S. Bank•Cincinnati, OH

2d•Hybrid

About The Position

The Systems Architect provides technical direction, guidance, and support for architectural development across multiple technology disciplines, platforms, and applications. The role facilitates the creation of architectural blueprints documenting system design and integration, ensures projects align with approved enterprise architecture standards and are implemented successfully, and coordinates communication about project development, strategy, and goals. The position may function as a project leader and provides direction and mentoring to less experienced staff. In this role, you will design and implement scalable Databricks Lakehouse architectures for enterprise data processing, analytics, and high-volume workloads. You will develop data solutions using Databricks, Python, PySpark, Databricks SQL, and Delta Lake; modernize and migrate Oracle SQL and PL/SQL workloads to Databricks and cloud data platforms; and design and optimize high-volume ETL/ELT pipelines. You will integrate Databricks with Oracle databases, AWS S3, cloud object storage, enterprise applications, and analytics platforms, while establishing reusable architecture, engineering, CI/CD, security, and platform standards. The role partners with cloud, infrastructure, database, security, and application teams to troubleshoot and deliver scalable, secure, and supportable data solutions. The role requires working from a U.S. Bank location three or more days per week.

Requirements

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.
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 or 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.
Ability to work from a U.S. Bank location three or more days per week.

Nice To Haves

Experience with financial or transactional data.

Responsibilities

Provide technical direction, guidance, and support for architectural development across technology disciplines, platforms, and applications.
Facilitate creation of architectural blueprints documenting design and systems integration.
Ensure projects follow approved enterprise architectural standards and are implemented successfully.
Coordinate communication to management and teams regarding project development, strategy, and goals.
Design and implement scalable Databricks Lakehouse architectures for 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.
May function as a project leader and provide direction and mentoring to less experienced staff.

Benefits

Healthcare, including medical, dental, and 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 hours worked, up to 80 hours per calendar year unless otherwise provided by law.
Incentive and recognition programs.
Equity stock purchase.
Pension.