Business Intelligence Analyst I

Orrstown Bank; Harrisburg (Dauphin County); On-site; USD 65,000 - 85,000; Full time

Job summary

Orrstown Bank in Harrisburg, PA seeks a Business Intelligence Analyst I to transform data into actionable insights for strategic decisions. You will collect and analyze large datasets, develop dashboards, and present findings to executives.

The role emphasizes data visualization, reporting proficiency, and strong communication. Collaboration with cross-functional teams and ongoing BI improvements are expected.

Qualifications

• Bachelor’s degree in related field or equivalent work experience is required.
• Minimum two years' data analytics and reporting experience in banking or similar industry.
• Experience developing reports in Cognos and Power BI.
• Experience with large datasets and relational databases.
• Excellent written and verbal communication to present data findings to executive management.

Responsibilities

• Gather and analyze data from various sources to support business objectives.
• Provide reporting on operational performance and translate analytics into presentations.
• Develop and maintain dashboards, reports, and visualizations to communicate insights.
• Collaborate with cross-functional teams to understand data needs and provide analytical support.
• Identify KPIs and track performance against targets.
• Conduct ad-hoc analysis and provide recommendations.
• Ensure data accuracy and integrity through validation and quality checks.
• Stay up-to-date with BI trends and best practices in data analytics.

Skills

Data analysis

Data visualization

Reporting

SQL

Communication

Education

Bachelor's degree in related field

Graduate degree preferred

Tools

Cognos

Power BI

Job description

If you are unable to complete this application due to a disability, contact this employer to ask for an accommodation or an alternative application process.

Business Intelligence Analyst I

Regular - Full time Professional Harrisburg, PA, US

2 days ago Requisition ID: 2913

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 will help stakeholders understand complex information and make informed decisions.

Qualifications:

A bachelor’s degree in related field and/or equivalent work experience is required. Graduate degree in a related or supporting field is preferred.

A minimum of 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 to efficiently present data findings and recommendations to executive management.

Core Competencies:

Career Development: Proactively prepares and actively participates in ongoing, candid, constructive monthly Coaching sessions with supervisor. Seeks advancement into challenging and developmental roles and assignments. Sets and meets clear, measurable goals.

Communicates Effectively: Demonstrates the ability to effectively communicate with all employees and clients, regardless of level. Communicates clearly, concisely, with candor and confidence. Writes, speaks and listens to disseminate and receive information effectively and accurately. Seeks to understand the viewpoints of others. Keeps others informed in a timely manner.

Focuses on the Client: Anticipates and identifies internal and external client needs. Takes action to meet and, where possible, exceed client expectations. Plans and organizes work effectively to facilitate responsiveness to client and meet deadlines.

Judgment: Demonstrates sound reasoning and well-balanced thinking. Balances the need for action with the need for analysis. Incorporates strategic thinking skills into practice by examining facts. Shows an ability to problem solve complex issues. Probes beyond symptoms to determine the underlying cause. Learns from and accepts responsibility from mistakes.

Teamwork: Demonstrates the ability to enhance the department and Orrstown Banks development through participation. Holds self and others accountable for exceeding departmental and corporate goals. Develops strong working relationships throughout the organization. Appropriately voices opinions, even if they are contrary to the consensus of the team. Initiates and develops positive working relationships with others in a way that builds bridges across boundaries and breaks down silos. Relates to others in an open and accepting manner that creates trust, respect and a collaborative environment.

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 all 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 the current laws and organizational policies and procedures designed and implemented to promote an environment that is free of sexual harassment and other forms of illegal discriminatory behavior in the workplace, support risk management practices and overall safety and soundness and the Bank’s compliance with all regulatory requirements. Ensure that the department and all personnel adhere to the same; perform tasks that are supportive in nature to the essential functions of the job which may be altered or redesigned depending on individual circumstances.

Physical Requirements:

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

While performing the duties of this job, the employee is regularly required to sit, use hands to finger, handle or feel, reach with hands and arms, and talk or hear. The employee is frequently required to stand and walk. The employee may occasionally lift and/or move up to ten pounds. Ability to reach destinations within the Orrstown footprint always is required.Ability to work and report to the employer’s physical work location(s).

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