Business Intelligence Analyst

SUMMARY: The Business Intelligence Analyst will be responsible for all aspects of data analysis, from meeting with stakeholders to define and gather requirements through the delivery of insightful and actionable analytics. The analyst is tasked with building/reporting of KPIs, dashboards, scorecards, statistical models, and ad hoc analytics to ensure that business processes are conducted in a controlled and efficient manner. Extraction, cleansing, and transformation of data are all necessary functions to aid the analyst in the maintenance of established reporting as well as in the creation of ad hoc analysis and special projects as requested by department managers within the Bank Operations Division.

ESSENTIAL DUTIES AND RESPONSIBILITIES include the following. Other duties and special projects may be assigned.

• Production of dashboards, KPIs, scorecards, executive decks, and exception tracking reports on a routine basis. Must be quick at understanding various critical business processes and must be able to interpret data related to these processes to make decisions and root out data integrity issues.
• Determine and create optimal graphical display for critical measures, producing graphics and dashboard formats to accurately and professionally convey process performance.
• Develop streamlined and automated approaches for gathering and delivering data, thereby reducing manual business processes where possible.
• Development of models to predict future volume and capacity needs.
• Structuring of data to support drill down analyses on process performance.
• Analyze reporting requirements, extract and interpret data, and ultimately provide recommendations to management.
• Participate in project teams and provide guidance on relevant metrics to support production needs.
• Lead special projects as assigned, working closely with IT to develop data structures when needed for reporting.
• Work with subject matter experts to discover, define, assess, and document business needs and requirements.
• Must possess the ability to clearly document reporting logic and processes for auditability.
• Adheres to and complies with applicable, federal and state laws, regulations and guidance, including those related to anti-money laundering (i.e. Bank Secrecy Act, US PATRIOT Act, etc.).
• Adheres to Bank policies and procedures and completes required training.
• Identifies and reports suspicious activity.

EDUCATION

Bachelor's Degree in Business Administration or related analytical field (ie Management Information Systems, Engineering, Math/Statistics, or Computer Science) required

EXPERIENCE

• 1-2+ years in an analytical capacity in conjunction with the development/maintenance of a reporting library required
• 1-2+ years working closely with IT to develop robust reporting data structures within a data warehouse required
• 1-2+ years writing complex SQL queries (eg, CTEs, correlated subqueries, complex aggregations) required
• 1-2+ years developing reports from a leading business intelligence platform such as SSRS, Business Objects, or OBIEE required
• Experience with visual dashboarding tool (Tableau is preferred but Qlik, Microstrategy, ThoughtSpot, PowerBI or similar tool will be considered)
• 2+ years of experience programming in Python or R required preferred
• Intermediate level of experience in Microsoft Excel required
• Banking and/or financial services industry experience is a plus preferred
• Experience reporting in a cloud environment is a plus, especially Amazon Web Services (AWS) preferred