Lead Data Engineer

Join to apply for the Lead Data Engineer role at U.S. Bank 2 days ago Be among the first 25 applicants 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: Data Integration and Management 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. Database Design and Optimization 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. Data Quality and Governance 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). Collaboration with Stakeholders 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. Automation and Optimization 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. Reporting and Analytics Support 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. Security and Compliance 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. Troubleshooting and Support Troubleshoot issues related to data pipelines, databases, and data integrity. Provide support for resolving data-related issues in financial applications or reporting systems. Database Manager Responsibilities Manages the design, development, maintenance, upkeep, safety, and integrity of databases. Conducts audits and initiates preventative and corrective actions. Manages the coordination and facilitates the design implementation and control of data management concepts and techniques. Approves and maintains database analyses and development policies, standards, and procedures. Analyzes short and long term requirements for Database Administrator to meet current and future business needs. Allocates appropriate database resources to ensure that projects are completed within committed time and budget and are integrated with other database systems. Works with software and hardware vendors to analyze, recommend, and purchase Database tools, products, and services. 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 Working experience in : 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 Application delivery process IT environment The role offers a hybrid/flexible schedule, which means there's an in-office expectation of 3 or more days per week and the flexibility to work outside the office location for the other days. 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 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. 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 the E-Verify program. Pay Range: $119,765.00 - $140,900.00 U.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. Seniority level Mid-Senior level Employment type Full-time Job function Information Technology Industries Banking #J-18808-Ljbffr U.S. Bank