Data Analyst

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.

 

We continually seek highly motivated and talented individuals as our people are critical to our success. In return, we offer competitive compensation with our salary and incentive program, in addition to medical, dental, and vision insurance.  401K, continuing education opportunities and an employee assistance program are also included in our benefit suite. Old National also offers 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 offer a unique opportunity to join a growing, community and client-focused company that is firmly rooted in its core values.

Responsibilities

We have an ambitious Community Bank Data Office and 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 data analytics developer who has a knack for seeing solutions in sprawling data sets across loan and deposit products, a flair for building 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 lines of business peers and leaders 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. 

 

Salary Range

           The salary range for this position is $51,700 - $101,500 per year. Final compensation will be determined by location, skills, experience, qualifications and the career level at which the position is filled.

 

 

Key Accountabilities

Fulfill core data analytics developer accountabilities:

• Building and maintaining dashboards, reports, and data models.
• Proactively evaluate data & trends to guide business partners on emerging opportunities
• Ensure data accuracy 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

Develop and implement Power BI Reports:

• Creates a consistent dashboard, reporting, and analytics experience for the business users
• Understand business requirements of 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

Develop data extracts & ad-hoc reporting:

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

Qualifications and Education Requirements

• Bachelor’s degree is required
• Thorough knowledge of the retail bank business line
• 5+ years’ experience in banking and finance
• 5+ years’ experience programming skills with querying languages: SQL, SAS, R, Python, etc.
• 3-5 years’ experience in developing analytics reports and dashboards, preferably PowerBI