Hybrid BI Data Analyst: Power BI, SQL & Finance Analytics

COCC; Camp Hill (Cumberland County); Hybrid; USD 80,000 - 109,000; Full time

Job summary

COCC in Camp Hill, PA is seeking a Business Intelligence Data Analyst to support reporting, analytics, and data-driven decision making across banking, operational, risk, and compliance functions.

You will transform complex information into meaningful insights, build dashboards and scalable analytical solutions, and collaborate with stakeholders to define KPIs and reporting requirements. This hybrid role offers competitive compensation and growth opportunities.

Qualifications

• Bachelor’s degree or equivalent education/training.
• 3–5 years of experience in data analytics/BI reporting or related role.
• Proficiency with SQL, Power BI, Excel, and MS analytics tools.
• Knowledge of data warehousing concepts, data quality, governance, and KPI development.
• Ability to gather requirements and communicate with stakeholders.

Responsibilities

• Analyze banking, financial, and operational data to identify trends, risks, and opportunities.
• Develop dashboards, scorecards, and executive reports using Power BI.
• Create and optimize SQL queries, views, and stored procedures.
• Support data ingestion, transformation, and orchestration using Microsoft data platforms.
• Contribute to a Microsoft-based data warehouse and analytics environment.
• Validate data accuracy and support data quality initiatives.
• Document data definitions, business rules, and reporting processes.
• Support regulatory, audit, and risk reporting with reliable data assets.
• Identify opportunities to improve reporting processes and scalability.

Skills

SQL

Power BI

Data governance

KPI development

Stakeholder communication

Data quality

Education

Bachelor’s degree in Data Analytics/Information Systems/Computer Science/Statistics or equivalent

Tools

Microsoft Fabric

Azure Data Services

Microsoft data platforms

Job description

COCC in Camp Hill, PA is seeking a Business Intelligence Data Analyst to support reporting, analytics, and data-driven decision making across banking, operational, risk, and compliance functions.

You will transform complex information into meaningful insights, build dashboards and scalable analytical solutions, and collaborate with stakeholders to define KPIs and reporting requirements. This hybrid role offers competitive compensation and growth opportunities.