Jobs · Information Technology · Pennsylvania

Business Intelligence Data Analyst

Atlantic Community Bankers Bank (ACBB) · Camp Hill, PA · Today
On-siteInformation Technology$81k–$100k/yrFull-time

About the role

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.

Responsibilities

  • 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
    • Aid 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

  • 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
    • 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

Similar jobs