Lead Data Engineer

U.S. Bank; Irvine (CA); On-site; USD 119,765 - 140,900; Full time

Benefits offered by this job

Healthcare (medical, dental, vision)

401(k) and employer-funded retirement plan

Paid vacation

Paid holidays

Adoption assistance

Job summary

A leading financial institution is seeking a Lead Data Engineer in Irvine, CA. This role involves developing data pipelines, integrating diverse data sources, and ensuring data integrity and compliance. Ideal candidates will have at least 7 years of experience in data management, strong programming skills, and familiarity with data warehousing technologies. Competitive salary range of $119,765.00 - $140,900.00 offered along with comprehensive benefits including healthcare and 401(k).

Qualifications

• Minimum of 7 years of experience in data management and administration.
• Strong experience with On-Prem and Cloud data warehouse solutions.
• Familiarity with data movement tools.

Responsibilities

• Develop and maintain data pipelines to process financial data.
• Integrate structured and unstructured data from multiple systems.
• Ensure data quality and compliance with regulations.

Skills

Data management and administration

Python programming

SQL proficiency

Scala programming

Education

Bachelor's degree or equivalent work experience

Tools

Snowflake

Amazon Redshift

Apache Kafka

Airflow

ETL frameworks

AWS

Azure

Google Cloud

Job description

Join to apply for the Lead Data Engineer role at U.S. Bank.

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 Description

Responsible for working on big data compilation projects that gather and integrate voluminous enterprise data, performs validation and analysis, and develops and implements dataset performance optimization guidelines. This role is crucial in maintaining and improving dataset integrity, ensuring regulatory compliance, and improving operational efficiency.

Essential Functions

• Develop and maintain data pipelines to ingest, process, and store financial data from various sources (internal and external).
• Integrate structured and unstructured data from multiple systems such as accounting software, trading platforms, financial databases, and market feeds.
• Build and optimize relational and non-relational databases (e.g., SQL, NoSQL) to store financial data.
• Ensure efficient querying and retrieval of financial data to support reporting and analytics.
• Implement data quality checks to ensure data accuracy, consistency, and completeness.
• Establish and enforce data governance policies to ensure compliance with financial regulations and standards (e.g., GDPR, SOX).
• Work with data scientists, financial analysts, and business intelligence teams to understand data needs and ensure data is accessible and usable for analysis.
• Collaborate with software engineers and IT teams to ensure seamless integration with other business systems.
• Automate repetitive data processing tasks to improve operational efficiency.
• Continuously monitor and improve the performance of data pipelines and systems to handle large volumes of financial data.
• Provide financial data to support the generation of reports, dashboards, and other visualizations.
• Work with finance teams to ensure the data is structured for effective analysis and decision‑making.
• Ensure that all financial data is stored securely, adhering to relevant security and privacy standards.
• Monitor and implement appropriate access controls to sensitive financial information.
• Troubleshoot issues related to data pipelines, databases, and data integrity.
• Provide support for resolving data‑related issues in financial applications or reporting systems.

Basic Qualifications

• Bachelor's degree or equivalent work experience.
• At least 7 years experience with tools, facilities and techniques for managing and administering data.
• Proficiency in programming languages like Python, SQL, or Scala.

Preferred Skills / Experience

• Application development tools.
• Information management.
• Data warehousing.
• Data movement tools.
• Strong experience with On-Prem and Cloud data warehouse solutions (e.g., Snowflake, Amazon Redshift, RDS, Oracle, MS SQL).
• Familiarity with data pipeline tools (e.g., Apache Kafka, Airflow, ETL frameworks); knowledge of cloud technologies (e.g., AWS, Azure, Google Cloud).
• Relational databases.
• Dataset architecture and design – best practices.

Extensive Experience In

• Application delivery process.
• IT environment.

Benefits

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

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.

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.

Pay Range: $119,765.00 - $140,900.00.

Posting may be closed earlier due to high volume of applicants.