Job DescriptionWe are seeking an experienced Data Modeler, Designer, and Warehouse Engineer to lead data workstreams for a large-scale technology integration and transformation program within our Capital Markets and
Electronic Trading organization. The candidate is a seasoned data engineering leader with strong technical, influential, and strategic abilities to help drive the success of the Electronic Trading Data Strategy.
The ideal candidate will bring deep expertise in data and cloud technologies and lead a high-performing team of data engineers and architects responsible for the technical design, architecture, and engineering of data backends and warehouses for large, distributed trading systems.
Additionally, the team will be responsible for building ETL workflows that move pre-and-post trade data between various back-office systems for settlement, market and counterparty risk analysis, and finance general ledger.
What does it take to succeed in this role? You love working with data at high throughput and low latency. You are comfortable rolling up your sleeves and diving into the details while also able to articulate strategy and design (both high and low-level) to appropriate audience. You possess a unique blend of technical proficiency, superior leadership and communication skills, and a visionary approach to data platforms evolution and transformation. You foster a culture of innovation and high-performance.
Basic Qualifications- Bachelor's degree, or equivalent work experience
- Ten or more years of relevant experience
Preferred Skills- Experience in building large-scale data backends and warehouses for electronic trading platforms in trading desks for equities, fixed income, or derivative instruments.
- Strong skillset with SQL and able to model and design a RDMS for low latency, high throughput electronic trading backends.
- Advanced understanding of data warehouse, data lake, data lakehouse, and medallion architecture.
- Proficiency with respect to cloud concepts such as RBAC, cloud blueprints and IaC tools such as terraform.
- Experience implementing and working with cloud data platform solutions such as Amazon Redshift, Snowflake, Data Bricks.
- Experience in Data Processing technologies such as Spark, Flink
- Experience implementing self-service business intelligence solutions using tools such as Tableau and Power BI.
- Knowledge of data science, machine learning, and natural language processing concepts, with experience shaping data to support those needs.
- Understanding of Gen AI concepts and their applicability to pertinent use cases across various domains preferably electronic trading.
- Data Security and Privacy: Understanding of data security principles, encryption techniques, and privacy regulations (e.g., GDPR, CCPA) to ensure data compliance.
Capital Markets Domain Knowledge- Deep understanding of Reference Data and Security Master concepts
- Deep understanding of Transactional Trade data
- Understanding of electronic trading market structure across one or more asset classes, such as fixed income, equities, equity options, commodities, or FX.
- Experience in Securities Data Modeling
- Working knowledge of market data, including aggregated and consolidated data, as well as montage books.
- Experience managing time series data.
- Understanding of post-trade feed flows, including settlement calculations.
Technical Skillset- Build and run processes for the data backends using such technologies as public cloud infrastructure on AWS, Kafka, Message Queues, in-memory data grids like Coherence or Hazelcast, and databases (Postgres, SQL Server).
- Strong experience working with SQL and databases engines/warehouses such as PostgreSQL, SQL Server, Snowflake, Redshift, and Databricks.
- Experience building ETL with SSIS on SQL Server and/or ETL on PostgreSQL with Python/Pandas.
- Experience with stream processing pipelines using Kafka and Spark on Databricks, Snowflake, and Redshift; or experience with Stream processing using RabbitMQ streams to PostgreSQL output sink.
- Proficiency in Linux scripting, troubleshooting, and host tuning.
- Exposure to third-generation programming languages such as Java, .NET, and Python.
- Strong proclivity for test automation and DevOps practices
- General understanding of application frameworks like Spring (Java), Django (Python); package managers like Mavan (Java), npm (JavaScript) and nuget (.Net)
- Practical experience with Docker and Kubernetes.
This 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: $143,905.00 - $169,300.00
Posting may be closed earlier due to high volume of applicants. 
