Business Intelligence Analyst Senior

At Liberty, we strive to maximize our impact and exceed goals by investing in our teammates to deepen our relationships in the workplace and communities we serve. We take pride in promoting a socially responsible and sustainable future through initiatives and investment.

SUMMARY OF THE JOB:

Reporting to the Business Intelligence Senior Analyst the incumbent is responsible for administering applications, risk assessments, application security and preparing and tracking all the bank’s business reporting needs. Ensures that reports are written from the appropriate application and are written to meet the needs of multiple business units with a goal of minimizing the duplication of data.

ESSENTIAL FUNCTIONS:

• Acts as department lead for large scale bank-wide reporting projects/initiatives.
• Provides guidance and assistance, as needed, to the business analysts.
• Demonstrates good leadership skills and acts as a role model to others within the department.
• Gather and analyze data, performs research, uses diagnostic tools and runs tests to resolve problems quickly and accurately.
• Responsible for in-depth troubleshooting; determining the appropriate course of action to resolve incidents with minimal business disruption and determining the root cause of the problems with reporting applications.
• Participates in technical training programs and self-directed learning to help in the support of the business units with reporting applications.
• Works with the end-user in developing, designing, writing and implement effective and sustainable relational database reports and data file outputs that will meet the needs of the bank.
• Analyzes report requests to ensure the true business objective of the report specifications are met by applying banking knowledge and interviewing of requestor to provide advice and technical assistance to facilitate report request.
• Maintains standard reports, templates and queries from which a customized report can be developed. Reports should be consistent in look and feel, be auditable, and reviewed annually on need, content and access as it relates to application security and compliance.
• Able to develop complex, accurate, flexible reports using bank approved reporting tools such as Crystal Reports, Tableau etc. to meet the reporting needs of end-users.
• Good working knowledge of SQL expressions, creation of formulas and parameters.
• Deliver accurate results to ensure an accurate business decision can be made.
• Designs and develops stored procedures in support of standard reporting activities
• Automates the generation of reports using scheduling application.
• Able to manage data analysis and data integration of disparate systems.
• Able to build extensible data acquisition and integration solutions to meet the functional and non-functional requirements of the business.
• Able to implement processes and logic to extract, transform, and distribute data across one or more data stores from a wide variety of sources.
• Documents all report generation, data processing and data management procedures in support of required disclosure and cross-training activities.
• Maintains all security levels, report groups, report folders and users of the applications.
• Collaborate with other team members to identify any potential design gaps or discrepancies and work towards correcting them as well as the validation of reports.
• Able to work within time and budget constraints at times meeting demanding delivery dates
• Familiarity with Integration tools like Mulesoft, Akana, Boomi or SoftwareAG preferred.
• Able to create, design and develop data models.
• Able to contribute the technical metadata to the metadata repository.
• Working knowledge of ERD diagram preferred.
  
  

Minimum knowledge/skills:

• Bachelor’s degree in Data Analytics, Computer Science or other related field or equivalent work experience.
• Banking experience preferred.
• Three years’ experience creating reports, SQL expressions, creation of formulas and parameters.
• Experience in Crystal Reports and Tableau preferred.
• Excellent written and oral communications skills
• Ability to function independently with minimal oversight, direction and as part of a team
• Strong sense of project ownership
• Knowledge in applicable report writing tools
• Proficient knowledge of Microsoft Office applications
• Experience with data extraction and scripting or equivalent professional work experience.
• Ability to multitask
  
  

PHYSICAL REQUIREMENTS:

• General Office Equipment
• Keyboard Dexterity
• Prolonged Sitting
  
  

COMPLIANCE:

Acts affirmatively in all activities under his/her control in conformance with the Bank’s Affirmative Action, Equal Employment Opportunity, and Fair Lending Programs to achieve the Bank’s goals and objectives. The Bank shall provide equal employment opportunity to all qualified persons, and continue to recruit, hire, train and evaluate persons in all jobs without regard to race, color, religion, sex, national origin, or veteran status.

Liberty Bank is an Equal Opportunity employer. It is the policy of Liberty Bank to provide equal employment opportunities to all qualified applicants without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, protected veteran or disabled status, or genetic information.