Hybrid BI Data Analyst - Power BI, SQL, Data Warehousing

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

Job summary

COCC is seeking a Business Intelligence Data Analyst to support reporting, analytics, and data-driven decision making across banking, financial, operational, risk, and compliance functions. You will transform complex information into insightful reports, dashboards, and scalable analytics solutions.

The role involves partnering with stakeholders, developing Power BI dashboards, and optimizing SQL queries within a Microsoft-based data environment.

Qualifications

• Bachelor’s degree in Data Analytics, IS, CS, Statistics, or related field.
• Strong analytical, technical, and communication skills.
• Experience with SQL, Power BI, Excel, and MS analytics tools.

Responsibilities

• Analyze banking, financial, and operational data to identify trends, risks, and opportunities.
• Partner with business stakeholders to gather reporting requirements and define KPIs.
• Develop dashboards, scorecards, and executive reporting solutions using Power BI.
• Develop, maintain, and optimize SQL queries, views, and stored procedures.
• Support data ingestion, transformation, and orchestration workflows using Microsoft data platforms.
• Contribute to the development and support of a Microsoft based data warehouse and analytics environment.
• Validate data accuracy and support enterprise data quality initiatives.
• Document data definitions, business rules, reporting processes, and transformation logic.
• Support regulatory, audit, and risk reporting requirements with reliable data assets.
• Identify process improvement opportunities and recommend scalable reporting solutions

Skills

SQL

Power BI

Analytical thinking

Communication

Data governance

KPI development

Education

Bachelor’s degree in Data Analytics or related field

Tools

SQL

Power BI

Excel

Microsoft Fabric

Azure

Job description

COCC is seeking a Business Intelligence Data Analyst to support reporting, analytics, and data-driven decision making across banking, financial, operational, risk, and compliance functions. You will transform complex information into insightful reports, dashboards, and scalable analytics solutions.

The role involves partnering with stakeholders, developing Power BI dashboards, and optimizing SQL queries within a Microsoft-based data environment.