Business Intelligence Data Analyst

Atlantic Community Bankers Bank
Camp Hill, PA, United States
about 2 months ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Experienced
Experience required
3 years minimum
Compensation
$80,500.0 - $100,000.0
Working hours
Regular working hours
Job source

Tech stack

Microsoft Excel Information Systems Information Engineering Data Governance Data Integration Extract Transform Load (ETL) Data Transformation Data Warehousing Document-Oriented Databases Microsoft Data Access Components Microsoft Office Microsoft SQL Server
+12 more
Operational Data Store Power BI SQL Stored Procedures SQL Databases SQL Server Reporting Services SQL Server Integration Services Data Streaming Data Ingestion Azure Data Factory Information Technology Data Analytics Data Management

Job description

  • 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

Do you have experience in Data Integration (Data management)?, Do you have a Bachelor’s degree?, 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?, * 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

Benefits & conditions

Pulled from the full job description

  • Tuition reimbursement
  • 401(k) matching
  • Paid time off
  • Employee assistance program, * 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.

About the company

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.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on indeed.com

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

2:39 min

Navigating strict environments for enterprise banking

Lea Fragner · LIVE

1:32 min

Structuring platforms for new services and data analytics

Nevelina Aleksandrova · LIVE

1:14 min

Evolution of distributed SQL database architectures

Wei Hu Wei Hu · WWC 2024

1:24 min

Moving the semantic layer upstream to avoid vendor lock-in

Piotr Menclewicz Piotr Menclewicz · Europe 2026 Virtual

2:44 min

Integrating data analytics into the talent acquisition function

Kobi Kobi +1 · WWC 2025

3:03 min

Career evolution in data engineering and AI platforms

Maria Apazoglou · Coffee With Developers

Videos

See all

Related articles

See all