Data Analyst, Sr

Overview

Old National Bank has been serving clients and communities since 1834. With over $70 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.

Old National is currently seeking to fill the position of Data Analyst. We're building a class-leading data team that works to solve complex business challenges and provide insights to improve our business and customer experience. We are looking for an innovative senior data analytics developer who has a knack for seeing solutions in sprawling data sets across a variety of retail bank systems and products.

The incumbent should have a flair for building highly usable and consistent business user experiences, and the business mindset to perform detailed analysis to produce genuine business insights that will find and fuel strategic opportunities.

You will work directly with line of business leaders - including Line of Business Chief Product, Information and Financial Officers - to assess and interpret their reporting needs. You will identify and design reporting solutions based on their requirements. You will use various data query and visualization tools (SQL, Python, Power BI, SAS, etc.) to access multiple data sources and design insightful products for our business partners.

You will work with various teams, each with unique backgrounds and perspectives, to develop solutions that will have a real impact for the bank and for our customers.

The annual salary range for this position is $60,000 - $121,300. The base salary indicated for this position reflects the compensation range applicable to all levels of the role across the United States. Actual salary offers within this range may vary based on a number of factors, including the specific responsibilities of the position, the candidate's relevant skills and professional experience, educational qualifications, and geographic location.

• Deliver on large data projects by leading planning, execution and completion of projects through peer leadership, cross-functional team collaboration and consensus building with functional and senior stakeholders and implementing logical solutions.
• Build, develop and maintain data models, dashboards, reports, data automation systems, and performance metrics support that support key business decisions
• Proactively evaluate data & data technology trends to guide business partners on emerging opportunities.
• Ensure data accuracy, quality and consistent reporting by designing and creating optimal analytics code with data controls defined as defined within the policy, procedure, and standards
• Tasks and deliverables are often time-sensitive and require a proactive approach to ensure deadlines are consistently met

• Create consistent dashboards, reporting, and analytics experiences for business users
• Elicit and understand business requirements from stakeholders; transform into the BI context and design a data model to transform raw data into meaningful insights
• Convert business requirements into technical specifications and implement them through reports that support decision-making
• Perform DAX queries and functions in Power BI

• Partner with business users to derive requirements, identify data sources, wrangle data and/or transform data via SQL and/or SAS to produce file extracts for use within PowerBI Dashboards or distribution to other systems
• Partner closely with data engineering and data movement teams on ETL processes and to develop and enhance databases/schemas/tables and implement data solutions to move data from and to other internal and external systems and vendors
• Drive efforts on ad hoc, time-sensitive exploratory data analysis and/or qualitative analysis to provide insights on trends, client behaviors, system troubleshooting or non-recurring reporting needs.
• Creating customized diagrams and user-defined calculations as needed
• Design, develop and deploy business intelligence solutions with SQL queries for best results, filters, and graphs to better understand your data at all levels for performance improvements and suggestions

• Bachelor's degree in related field; advanced coursework/training related to computer science, management information systems, and mathematics/statistics, Master's degree preferred
• Exceptional analytic ability and problem-solving skills
• 6-10 years' experience in banking and finance with a thorough knowledge of the retail bank business line
• Demonstrated ability in data retrieval from multiple databases and systems
• 5+ years' experience in developing analytics reports and dashboards, preferably PowerBI
• 5+ years' experience working with and creating data extracts
• 5+ years'…