Business Intelligence Data Analyst

Atlantic Community Bankers Bank•Camp Hill, PA

4h•$80,500 - $100,000•Hybrid

About The Position

We are seeking a Business Intelligence Data Analyst to play a key role in supporting enterprise reporting, analytics, and data-driven decision-making across our organization. Embark on an exciting journey with Atlantic Community Bankers Bank (ACBB), where we're shaping the future of community banking! At ACBB, our people are at the heart of everything we do. We take pride in offering dynamic correspondent services, including loan participations, Fed Funds transactions, compliance services, settlement solutions, and more—all without competing with our customer banks. Join our passionate team, where employees are trusted, supported, and encouraged to grow, and help us deliver innovative solutions to community banks and financial institutions nationwide.

Requirements

3–5+ years of experience in business intelligence, data analytics, reporting, or data engineering roles, preferably within banking, financial services, or another regulated industry
Bachelor’s degree in Data Analytics, Information Systems, Computer Science, Business Intelligence, Finance, or a related field preferred
Experience with Microsoft SQL Server, SSIS, SSRS, or Azure data tools and familiarity with banking, financial, risk, or compliance data structures preferred
Exposure to data modeling and business intelligence best practices preferred
Strong proficiency in SQL, including query development, stored procedures, and data transformation
Experience building dashboards and visualizations using Power BI
Knowledge of Microsoft-based data platforms, data warehousing concepts, and ETL processes
Understanding of data governance, reporting controls, and data quality best practices
Ability to analyze complex datasets and communicate findings clearly to technical and non-technical audiences
Strong attention to detail with excellent problem-solving and analytical skills
Experience supporting regulatory, operational, or audit reporting within a banking or financial environment preferred
Ability to manage multiple priorities and work independently in a fast-paced environment
Proficiency in Microsoft Office Suite, particularly Excel
Strong written and verbal communication skills

Responsibilities

Analyze banking, financial, and operational data to identify trends, risks, and business opportunities
Partner with business stakeholders to gather reporting requirements, define KPIs, and translate business needs into analytical solutions
Build and enhance dashboards, scorecards, and executive reports using Power BI
Deliver timely, accurate, and meaningful insights to support strategic and operational decision-making
Develop, maintain, and optimize SQL queries, views, and stored procedures to support reporting and analytics
Support data ingestion, transformation, and orchestration workflows using Microsoft data platforms and related services
Contribute to the design, build, and support of Microsoft-based data warehouse solutions and reporting layers
Assist with documenting and maintaining reporting architecture, data flows, and technical processes
Validate data accuracy and reconcile datasets across systems to ensure reporting integrity
Document data definitions, transformation logic, warehouse structures, business rules, and reporting processes
Support regulatory, audit, and risk-reporting needs common to banking environments
Identify opportunities for process improvement and recommend scalable, data-driven solutions
Promote strong data governance, standardization, and compliance practices across reporting environments