Atlantic Community Bankers Bank logo
Atlantic Community Bankers Bank Verified
Banking, Financial Services

Business Intelligence Data Analyst

Camp Hill, Pennsylvania, United StatesOnsiteFull Time$80,500–$100,000 /yrPosted 3 days ago

Is this role right for you?

Upload your resume and get a skill-by-skill breakdown — see exactly where you match, where you're close, and what to highlight. Not a mystery percentage.

Get a tailored resume highlighting what this role needs.

Role summary

Atlantic Community Bankers Bank (ACBB) is seeking a Business Intelligence Data Analyst to support enterprise reporting, analytics, and data-driven decision-making. This role involves transforming complex banking, financial, operational, risk, and compliance data into actionable insights and scalable reporting solutions. Responsibilities include analyzing data, gathering requirements, building dashboards in Power BI, developing SQL queries, supporting data warehousing and ETL processes, ensuring data quality, and documenting processes. The ideal candidate has 3-5+ years of experience in BI, data analytics, or data engineering, preferably in a regulated industry like banking, with strong SQL and Power BI skills.

Description
Job Title: Business Intelligence Data Analyst
Are you a detail-oriented data professional who thrives in a structured, fast-paced, and highly regulated environment? Do you enjoy transforming complex banking and operational data into meaningful insights that support strategic decision-making, reporting, and business performance?
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.
About ACBB
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.
What You’ll Do
As a
Business Intelligence Data Analyst,
you will support enterprise reporting, analytics, and data-driven decision-making across the organization. You will partner with business stakeholders to transform complex banking, financial, operational, risk, and compliance data into actionable insights and scalable reporting solutions.
Data Analytics & Business Insights

  • 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

Data Engineering & Platform Management

  • 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

Data Quality, Governance & Compliance

  • 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

Requirements
What You’ll Bring:
Basic Qualifications/Skills

  • Experience: 3–5+ years of experience in business intelligence, data analytics, reporting, or data engineering roles, preferably within banking, financial services, or another regulated industry;
  • Education: Bachelor’s degree in Data Analytics, Information Systems, Computer Science, Business Intelligence, Finance, or a related field preferred

Technical Skills & Competencies

  • 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

Why Join Us

  • Competitive compensation package
  • Comprehensive benefits package
  • 401(K) with employer match
  • Generous Paid Time Off (PTO) policy
  • Tuition reimbursement
  • Birthday holiday and additional unique benefits
  • Employee Assistance Program
  • Flexibility with Purpose — Hybrid roles, in-office connection.
  • Performance bonus opportunities

Apply today and bring your expertise to an organization where your work truly matters. We look forward to welcoming you to our dynamic and collaborative work environment.
Pay Range:
$80,500 to $100,000 annually
Compensation Is Commensurate With Experience And Qualifications.
ACBB is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, veteran status, or any other protected characteristic.

Ready to apply?
You'll be redirected to Atlantic Community Bankers Bank's application page.

Similar roles