Business Intelligence Analyst I

Position Summary

Responsible for collecting, analyzing, and interpreting large datasets to identify trends, patterns, and opportunities for improvement. This role plays a crucial role in transforming data into actionable insights that drive strategic business decisions. The ideal candidate will have expertise in data visualization and reporting to help stakeholders understand complex information and make informed decisions.

Qualifications

• Bachelor’s degree in a related field or equivalent work experience (required).
• Graduate degree in a related or supporting field (preferred).
• Minimum two (2) years' experience in Data Analytics and reporting in banking or a similar industry.
• Proven experience developing reports in a business intelligence tool (Cognos and Power BI preferred).
• Experience working with large datasets and relational databases.
• Excellent written and verbal communication skills for presenting data findings and recommendations to executive management.

Core Competencies

• Career Development: Proactively prepares and participates in monthly coaching sessions, seeks advancement into challenging roles, sets and meets clear, measurable goals.
• Communicates Effectively: Communicates clearly and concisely with all employees and clients, writes, speaks, and listens to disseminate and receive information accurately, seeks to understand others’ viewpoints, and keeps others informed in a timely manner.
• Focuses on the Client: Anticipates and identifies internal and external client needs, takes action to meet or exceed expectations, and plans and organizes work to meet deadlines.
• Judgment: Demonstrates sound reasoning, balances action with analysis, incorporates strategic thinking, solves complex problems, probes beyond symptoms, and learns from mistakes.
• Teamwork: Enhances department and organizational development, holds self and others accountable, builds strong working relationships, voices opinions constructively, breaks down silos, and fosters a collaborative environment built on trust and respect.

Essential Duties

• Gather and analyze data from various sources to support business objectives.
• Provide reporting on operational performance and translate analytics into actionable presentations.
• Develop and maintain dashboards, reports, and visualizations to communicate insights effectively.
• Collaborate with cross‑functional teams to understand their data needs and provide analytical support.
• Identify key performance indicators (KPIs) and track performance against targets.
• Conduct ad‑hoc analysis to answer specific business questions and provide recommendations.
• Thoroughly understand all bank systems and reports to avoid conflicting data or redundancy.
• Ensure data accuracy and integrity by performing regular data validation and quality checks.
• Regularly review existing reporting to confirm accuracy, adequacy, and necessity.
• Stay up‑to‑date with industry trends and best practices in business intelligence and data analytics.
• Abide by laws, policies, and procedures that promote a harassment‑free, non‑discriminatory workplace and support risk management, safety, and regulatory compliance.
• Perform supportive tasks that may be altered or redesigned depending on individual circumstances.

Physical Requirements

The role requires regular sitting, using hands, reaching, talking, and hearing; frequent standing and walking; occasional lifting or moving of up to ten pounds; and the ability to reach destinations within the Orrstown footprint. Reasonable accommodations may be made for individuals with disabilities.

Work Environment

Work is performed in an office setting with little to moderate exposure to noise, heat, dust, or other adverse factors. Extended hours may be required as needed. The noise level is usually quiet.