Data Engineer III

at Old National Bank in ChicagoChicago, Illinois, United States

Job Description

Data Engineer III
Job Locations

US-IL-Joliet | US-IL-Chicago | US-IN-Evansville | US-MN-Eden Prairie

Category/Function 
Information Technology  

Position Type 
Regular Full-Time  

Requisition ID 
2024-14823  

Workplace Type 
On Site
Overview

Old National Bank has been serving clients and communities since 1834. With $53 billion in total assets, we are a regional powerhouse deeply rooted in the communities we serve. As a trusted partner, we thrive on helping our clients achieve their goals and dreams, and we are committed to social responsibility and investing in our communities through volunteering and charitable giving.
Our team members are our greatest asset, and we continually invest in their growth and development. We offer a variety of Impact Network Groups led by team members who are passionate about driving engagement, creating awareness of diverse backgrounds and experiences, and building inclusion across the organization.
We are currently seeking a Data Engineer responsible for the development and implementation of technical solutions. This role leverages technical expertise in database applications, ETL processes, and automation in support of internal and external customers' data exchange and integration needs. Help move our bank to a modern data platform, including the integration work for our Salesforce platform and our digital banking platform. We are an in-office work enviornment.
We are not currently sponsoring H-1 for this role. We require coming to our office in either our Chicago office near Rosemont IL, Eden Prairie MN, Joliet IL, Evansville IN or Milwaukee Wisconsin.
Key Competencies for Position
Ability to work independently and be able to collaborate and guide other team members.
Critical thinking and problem-solving skills to ensure the right-sized solution is developed for the task at hand.
Technical passion to move the bank towards modern data platform principles.
Skills and Qualifications:
Over 5 years of experience data engineering experience, including developing ETL/ELT.
We prefer 3 years of experience with SSIS/Azure Data Factory, and some knowledge of Python.
Expertise in building scalable data products and platforms focused on metadata driven approaches towards ingestion and transformation.
Experience working with stakeholders on gathering requirements and translating to data solutions with a focus on developing repeatable patterns.
Experience in orchestration tools or job schedulers, building dependency and event driven approaches towards loading and moving data.
Experience with scripting tools such as Python and/or C#.
Experience with Azure Databricks for an enterprise Data Lake.
Very good working experience of T-SQL. Proficiency in complex stored procedures, User Defined Functions (UDF), and query optimization.
Knowledge of CDC and experience preserving historical data in a variety of patterns from different source systems.
Excellent written and oral communication, including experience presenting designs and solutions to senior leadership.
Experience working in an Agile environment, leveraging Azure DevOps or JIRA for work management.
Exposure to code repositories such as Azure DevOps, Git, etc.
Working knowledge of analytical and data visualization technology such as Power BI
Working knowledge of cloud-based data architectures using the Azure stack, Databricks, and/or Snowflake
Position may require the need to travel to other branch or meeting locations.
Duties/Responsibilities
Design, development, and maintenance (enhancements and maintenance) of ETL/ELT processes.
Design and development of repeatable frameworks and functions to be leveraged by other data engineers within the bank.
Focus on Operational Excellence- ensuring we are monitoring, validating, and communicating the health and status of our data products.
Collaborate with Enterprise Architecture, Info Security and Data Governance organizations.
Confer with relevant team members where necessary. Study systems flow, data usage, and work processes.
Deliver functional data products that have been thoroughly tested.
Follow the development team's SDLC process. Accurately estimate time required to complete projects and tasks.
Meet mutually agreed upon deadlines for completion of modules throughout the program development.
Work closely with the existing DBAs to design, model, develop, and maintain existing and new database objects required for all business solutions.
We continually seek highly motivated and talented individuals. Our people are critical to the Bank's strategy and success. In return we offer competitive compensation with our salary, structured bonus program, exceptional medical, dental, vision insurance, 5% company contribution on 401K, continuing education and a unique opportunity with a growing, client-focused and collegial company.
Old National is proud to be an equal... For full info follow application link.

EOE/Minorities/Females/Vet/Disability