Principal Integration Engineer - Trade Data Warehouse

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.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 QualificationsBachelor's degree, or equivalent work experienceTen or more years of relevant experiencePreferred SkillsExperience 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, FlinkExperience 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 KnowledgeDeep understanding of Reference Data and Security Master conceptsDeep understanding of Transactional Trade dataUnderstanding 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 ModelingWorking 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 SkillsetBuild 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 practicesGeneral 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.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 insuranceShort-term and long-term disabilityPregnancy disability and parental leave401(k) and employer-funded retirement planPaid vacation (from two to five weeks depending on salary grade and tenure)Up to 11 paid holiday opportunitiesAdoption assistanceSick and Safe Leave accruals of one hour for every 30 worked, up to 80 hours per calendar year unless otherwise provided by lawReview 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-VerifyU.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 the E-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 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.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.SummaryLocation: Chicago, IL; Charlotte, NC; New York, NYType: Full time