Systems Architect 2 Cloud Data Engineer (Databricks)
Cincinnati, OH - USA
Job Summary
At U.S. Bank were 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 atall 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.
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
- Bachelors 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 theres anything we can do to accommodate a disability during any portion of the application or hiring process please refer to ourdisability 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. Thats 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.
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 theE-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 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: $111605.00 - $131300.00U.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.
Required Experience:
Staff IC
About Company
Experience personalized banking services for your unique needs with U.S. Bank - Checking, credit cards, home loans & convenient online banking. Member FDIC.