Business Intelligence Data Analyst at Atlantic Community Bankers Bank

Camp Hill, Pennsylvania, United States -

Full Time

Start Date

Immediate

Expiry Date

09 Sep, 26

Salary

100000.0

Posted On

11 Jun, 26

Experience

2 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Power BI, SQL, Data Modeling, ETL Processes, Data Warehousing, SSIS, SSRS, Microsoft SQL Server, Azure Data Tools, Data Governance, Data Analytics, Financial Reporting

Industry

Banking

Description

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 HR 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.

Responsibilities

The role involves transforming complex banking and operational data into actionable insights and scalable reporting solutions using Power BI. It also requires developing and optimizing SQL queries and supporting Microsoft-based data warehouse solutions.