Job DescriptionU.S. Bank is seeking a proficient ETL Architect with data architecture experience to contribute toward the success of our technology initiatives. Leads and consults on the design, development, and implementation of the architecture and metadata repository for extraction, transformation, and load (ETL) solutions. Provides technical consulting to development teams during design and development for highly complex or critical projects. Identifies opportunities for new initiatives. Recommends changes to increase scalability and robustness of ETL platforms and solutions. Defines policies and best practices for ETL data manipulation functions. Evaluates new tools and techniques and makes recommendations to improve real-time and batch data access, transformation and movement across heterogeneous technologies and platforms. Determines organizational strategies for data integrity validation processes, optimizing data throughput/accessibility, restart ability, and error-handling for tools to deliver ETL solutions.
Successful applicants will exemplify US Bank's ethical principles of uncompromising integrity, respect for others, accountability for decisions and actions, and good citizenship.
Basic Qualifications-Bachelor's degree or equivalent work experience
-At least 6 years experience with design, development, automation, and support of applications to extract, transform, and load data.
-At least 9 years experience within a total information technology (IT) environment.
Preferred Skills/Experience- Demonstrated experience analyzing business products and technology to define target/future state architecture optimized for business agility, innovation, performance, resiliency, cost, security, using both Cloud Native and On-prem solutions.
- Proven track record leading cross-functional engineering teams, enforcing best practices, and aligning technical delivery with strategic architecture principles.
- Leadership experience driving technology transformation, modernization, and large-scale program delivery, preferably in the banking/finance industry supporting high-volume payments products in a multi-tenant environment.
- Proven track record in digital transformation, Data Lakehouse architecture, cloud migration (Azure/AWS), application engineering and IT program management.
- Proven leadership implementing data governance, security, and compliance controls aligned to PCI DSS, SOX, GDPR, and regulatory expectations.
- Hands-on experience with multi-zone data lake patterns (raw, cleaned/enhanced, curated/trusted, consumption), optimized storage formats, metadata-driven ingestion, and analytics-ready data models. Enables BI, reporting, customer extracts, data science, and other use cases at enterprise scale.
- Expertise in real-time and batch data ingestion architectures (Kafka/Event Hubs, Spark, Delta Lake, etc.), including leading design and management of tools/processes/services for comprehensive data ingestion and integration.
- Experience leading thedesign and implementation of enterprise data governance frameworks, including data lineage, cataloging, business glossaries, and data quality controls. Ensures end-to-end traceability from source to consumption, improving data trust, auditability, and regulatory compliance.
- Technical Skills (or similar/equivalent): AWS GLUE, IAM ROLES, LAMBDA, S3 /EFS, REDSHIFT, DMS, KAFKA/EVENT HUB, SNS, SQS, CLOUDWATCH/Event Bridge, AIRFLOW, POSTGRES/ORACLE/DB2, ETC, COLLIBRA, DATABRICKS, DELTA LAKE, PYTHON, SNOWFLAKE, SNOWPIPE / SNOWSQL, SNOWPARK, DATA MODELLING, DATA MANAGEMENT, ETL TOOLS (SPARK, ETC), POWER BI, COGNOS, TABLEAU, CI/CD PIPELINES SUPPORTING DATA LAKEHOUSE
Location expectationsThis role requires working from a U.S. Bank location three (3) or more days per week.
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.
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
Posting may be closed earlier due to high volume of applicants.