• Camp Hill, PA
    6 days ago

    Job Description

    CLASSIFICATION: Non-exempt

    REPORTS TO: Data Analyst Manager

    DATE: September 16, 2026

    JOB DESCRIPTION

    Summary/Objective

    Responsible for developing, maintaining, and delivering accurate, timely, and actionable reporting and analytics in support of all departments and divisions of the Bank. This position uses IBM Cognos, SQL, Python, and related data tools to extract, validate, analyze, and present information that supports business performance, operational efficiency, regulatory awareness, and management decision-making across the organization.

    Essential Functions

    Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

    • Design, develop, maintain, and enhance recurring and ad hoc reports, dashboards, data extracts, and analytical deliverables using IBM Cognos, SQL, Python, and other approved reporting tools.
    • Partner with business units across all departments and divisions of the Bank to understand reporting requirements, translate business needs into data solutions, and provide reliable reporting support.
    • Write, optimize, and validate SQL queries to retrieve, join, and analyze data from enterprise data sources, data marts, and operational systems.
    • Use Python, where appropriate, to automate data preparation, validation, analysis, reconciliation, and reporting processes.
    • Develop and maintain IBM Cognos reports and packages, ensuring reports are accurate, efficient, well-documented, and aligned with business requirements.
    • Validate data outputs for accuracy, completeness, consistency, and reasonableness; identify data quality issues and work with data owners, subject matter experts, and technology partners to resolve concerns.
    • Prepare clear, concise reporting summaries and analyses that help management and business partners identify trends, monitor key metrics, and make informed decisions.
    • Maintain reporting documentation, including report specifications, data definitions, source-to-report mapping, business rules, assumptions, and production schedules.
    • Support regulatory, audit, compliance, finance, retail, commercial, operations, risk, and executive reporting needs as assigned.

    Other Duties

    • Performs other duties as assigned.

    Skills/Abilities

    • Strong analytical, problem-solving, and critical-thinking skills with the ability to translate business questions into accurate reporting solutions.
    • Works with general direction from the Data Analyst Manager and exercises sound judgment in prioritizing reporting requests, validating results, and escalating issues when appropriate.
    • Proficiency with IBM Cognos report development, SQL querying, relational databases, data validation, and Python-based analysis or automation. Familiarity with banking data, financial reporting, business intelligence concepts, and data governance practices is preferred.
    • Demonstrates informal leadership by promoting reporting standards, sharing data knowledge, and helping business partners use information effectively; this role does not have direct staff management responsibilities.
    • Communicates technical information clearly to non-technical audiences and prepares reporting explanations, summaries, and recommendations appropriate for business users, managers, and senior leaders.
    • Maintains the confidentiality, integrity, and appropriate use of customer, employee, financial, operational, and proprietary Bank data.
    • Builds effective working relationships with stakeholders across all departments and divisions of the Bank, including business lines, operations, finance, risk, compliance, technology, and executive support functions.

    Supervisory Responsibility

    This position does not have supervisory responsibilities and does not manage any staff.

    Work Environment

    This job operates in an office setting, the opportunity to telework is not available. This role routinely uses standard office equipment such as computers, phones, photocopiers, filing cabinets and fax machines. Office environment with job duties conducted via telephone, face to face meetings, and on the computer.

    Physical Demands

    This position requires manual dexterity, the ability to lift files and open cabinets. This position requires bending, stooping, or standing, as necessary.

    Travel

    Limited local travel may be required for this position.

    Education and Experience

    • Bachelor's degree in Data Analytics, Information Systems, Computer Science, Finance, Accounting, Business Administration, or a related field required; equivalent combination of education and relevant experience may be considered.
    • Two or more years of experience in data reporting, business intelligence, data analysis, financial services, or a related analytical role preferred.
    • Experience developing reports or dashboards in IBM Cognos or a comparable business intelligence platform preferred.

    Equal Employment Opportunity/M/F/disability/protected veteran status.

    Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities, and activities may change at any time with or without notice.

    Numbers & Facts

    LocationCamp Hill, PA

    Skills

    • Accountingunmatched
    • Analysis Skillsunmatched
    • Automationunmatched
    • Banking Operationsunmatched
    • Banking Servicesunmatched
    • Business Administrationunmatched
    • Business Bankingunmatched
    • Business Intelligenceunmatched
    • Business Operationsunmatched
    • Business Skillsunmatched
    • Business Supportunmatched
    • Communication Skillsunmatched
    • Computer Scienceunmatched
    • Data Analysisunmatched
    • Data Martunmatched
    • Data Qualityunmatched
    • Environmental Workunmatched
    • Establish Prioritiesunmatched
    • Executive Assistant Skills unmatched
    • Financeunmatched
    • Financial Complianceunmatched
    • Financial Operationsunmatched
    • Financial Reportingunmatched
    • Financial Servicesunmatched
    • IBM Cognosunmatched
    • Identify Issuesunmatched
    • Information Technology & Information Systemsunmatched
    • Leadershipunmatched
    • Metricsunmatched
    • People Managementunmatched
    • Physical Demandsunmatched
    • Problem Solving Skillsunmatched
    • Python Programming/Scripting Languageunmatched
    • Reconciliationunmatched
    • Regulationsunmatched
    • Relational Databases (RDBMS)unmatched
    • Reporting Dashboardsunmatched
    • Reporting Skillsunmatched
    • Retailunmatched
    • Riskunmatched
    • SQL (Structured Query Language)unmatched
    • Technical Supportunmatched
    • Time Managementunmatched
    • Trend Analysisunmatched
    • Work From Homeunmatched

    Be found by employers

    5,500+ employers search our resume database daily. Add yours to get found by recruiters looking for candidates like you.

    Level up your application

    Professional resume templates

    Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.

    Free resume templates

    Free resume builder

    Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.

    Free resume builder