Systems Architect 2 - Cloud Data Engineer (Databricks)

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.

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.

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

Requirements

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

Conditions

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

• Our approach to benefits and total rewards considers our team members’ whole selves and what may be needed to thrive in and outside work. That's why our benefits are designed to help you and your family boost your health, protect your financial security and give you peace of mind. Our benefits include the following:
• 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 .