Data Engineer III

Data Engineer III Job Locations US-IL-Joliet | US-IL-Chicago | US-IN-Evansville | US-MN-Eden Prairie | US-IL-Tinley Park | US-IL-Joliet | US-WI-Milwaukee 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 III 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 environment. We are not currently sponsoring H-1 and we are not providing OPT for this role. We require to come to one of our offices in either Chicago (it's close to O'Hare airport), Tinley Park IL, Joliet IL, Eden Prairie MN, 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. Experience with scripting tools such as Python is required Experience with Azure Databricks for an enterprise Data Lake is required. 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. 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 our Company's strategy and success. In return we offer competitive compensation with our salary, bonus program, exceptional BC/BS medical, Delta dental all effective day 1, Headspace mental health support and vision insurance, 401k Company "match" dollar for dollar (100%) of the first 5% contributed into the Plan which is 100% vested right away, continuing education support and a unique opportunity with a growing, client-focused and collegial company. Old National is proud to be an equal opportunity employer focused on fostering an inclusive workplace and committed to hiring a workforce comprised of diverse backgrounds, cultures and thinking styles. As such, all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, protected veteran status, status as a qualified individual with disability, sexual orientation, gender identity or any other characteristic protected by law. We do not accept resumes from external staffing agencies or independent recruiters for any of our openings unless we have an agreement signed by the Director of Talent Acquisition, to fill a specific position Our culture is firmly rooted in our core values. We are optimistic. We are collaborative. We are inclusive. We are agile. We are ethical. We are Old National Bank. Join our team Need help finding the right job? We can recommend jobs specifically for you Click here to get started. If you're qualified for a position but need additional help with the application because of a disability, please email HRservicesoldnational.com (This email will respond to accommodation requests only.)