Business Intelligence Data Analyst

Atlantic Community Bankers Bank
Camp Hill, United States of America
31 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Intermediate
Compensation
$ 100K

Job location

Camp Hill, United States of America

Tech stack

Microsoft Excel
Information Systems
Information Engineering
Data Governance
Data Integration
ETL
Data Transformation
Data Warehousing
Document-Oriented Databases
Microsoft Data Access Components
Microsoft Office
Microsoft SQL Server
Operational Data Store
Power BI
SQL Stored Procedures
SQL Databases
SQL Server Reporting Services
SQL Server Integration Services
Data Streaming
Data Ingestion
Azure
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