Business Intelligence Analyst

Business Intelligence Analyst Middletown, CT 06457, USA Req 1653 Wednesday, November 13, 2024 At Liberty, we are proud to integrate our Diversity, Equity, and Inclusion (DE&I) throughout all functions and areas of the Bank to maximize our impact and exceed goals. We believe deepening our DE&I strategies in the workplace and communities we serve creates a much better place to work for our teammates and a safe place where our customers are connected and supported. We take pride in promoting a socially responsible and sustainable future through initiatives and investment. SUMMARY OF THE JOB : Reporting to the SVP Data Management & Enterprise Architect the incumbent is responsible for administering data applications & execution of the banks 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: 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 incidentswith 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 & PowerBI to meet the reporting needs of end-users. Good working knowledge of SQL expressions, creation of formulas and parameters. Designs and develops stored procedures in support of standard reporting activities 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 Able to contribute the technical metadata to the metadata repository. principal accountabilities: Reporting 1. Works with business units to analyze needs and designs appropriate report specifications; provides advice and technical assistance to facilitate report resolution. Works with business units to ensure report results are accurate and meet the business units needs. Documentation 2. Responsible for documenting report specifications; ensuring reports meet template standards; Modify and test all customer documents. User Support 3. Provides excellent service to business units from all levels of the organization to bring about resolution for their requests and/or inquiries by using excellent interpersonal and communication skills (both verbal and written). MINIMUM REQUIREMENTS: Bachelors degree in information technology, Computer Technology Solutions & Efficiency and/or equivalent professional work experience 3-5 years experience supporting Banking applications, including systems configuration, troubleshooting and solutioning. Experience in creating reports, SQL expressions, creation of formulas and parameters. Tableau & PowerBI experience preferred. Excellent written and oral communications skills Ability to function independently with minimal oversight, direction and as part of a team Proficient knowledge of Microsoft Office applications Working knowledge of ERD diagram preferred. Banking experience a plus PHYSICAL REQUIREMENTS: Ability to sit for long periods of time Keyboard Dexterity General Office Equipment COMPLIANCE: Acts affirmatively in all activities under his/her control in conformance with the Banks Affirmative Action, Equal Employment Opportunity, and Fair Lending Programs to achieve the Banks 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. LI-HYBRID 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. Other details Job Family Technology Job Function Staff Pay Type Salary Apply Now Middletown, CT 06457, USA