Business Data Analyst

Penn Community Bank; Bensalem Township (Bucks County); Hybrid; USD 70,000 - 95,000; Full time

Job summary

Penn Community Bank in Bucks County seeks a data analyst to collect, validate, and interpret production data from multiple sources (DNA, Salesforce, Encompass) and publish actionable insights for management.

You will build dashboards, ensure data integrity, support users, and collaborate with teams to improve processes while maintaining data security and compliance.

Qualifications

• Bachelor's degree or 3-5 years of banking experience or an equivalent combination.
• Experience with Encompass and Salesforce is preferred.
• Strong analytical and data interpretation abilities.

Responsibilities

• Collect, analyze, and interpret production data from multiple sources and publish insights.
• Develop and maintain dashboards to track KPIs and trends.
• Ensure data validation and integrity across platforms and systems.
• Collaborate with cross-functional teams to identify process improvements.
• Provide day-to-day user support and develop workflows.
• Maintain Salesforce/Encompass user profiles and security settings.
• Support campaigns and manage data transmissions with vendors.

Skills

Advanced analytical knowledge of data

Strong analytical skills

Strong attention to detail

Time management/prioritization

Customer focus

Math and computer skills

Reading financial statements/regulat.

Writing routine reports

Public speaking before groups

Microsoft Office proficiency

Education

Bachelor's degree in related field

3-5 years banking experience

Encompass experience

Salesforce experience

Tools

Encompass

Salesforce

Job description

Job description:

Essential Functions

The following is a list of essential functions, which may be subject to change at any time and without advance notice. Management may assign new duties, reassign existing duties, or eliminate a function.

• Collect, analyze, and interpret production related data from various sources (DNA, Salesforce, Encompass, etc.), and publish insights and findings.
• Perform data validation and ensure data integrity and accuracy across multiple platforms.
• Develop and maintain Dashboards and other reporting tools (Encompass/Salesforce) to track trends, patterns, and key performance indicators (KPIs).
• Proactively communicate and collaborate with cross-functional teams to identify efficiencies and process improvements.
• Maintain Salesforce/Encompass user profiles, permissions, and security settings.
• Provide "day to day" support to users, including managing FAQ, troubleshooting, and workflow development.
• Act as liaison to Learning & Development, offering subject matter expertise of new and existing functionality, to assist in curriculum development.
• Conduct routine testing and execute quality assurance procedures (QA) of data systems.
• With sales leaders: Create, manage, and monitor sales campaigns, ensuring leads and opportunities are distributed as required, with timely disposition.
• Oversee data transmissions to other entities, vendors, and investors (FNMA, etc.) while ensuring data security protocols are honored

Compliance

• Comply with all applicable regulations and Bank policies regarding employment and employment law.
• Participate in annual compliance and other job-related training.
• Comply with applicable bank regulations, Bank policies and procedures.
• Comply with Bank's internal privacy and ethics standards.

Relationships and Contacts

Internal: Reports to Salesforce & Data Administration Manager; Frequent communication with Team Members and Stakeholders in various areas and levels throughout the Bank.

External: Occasional contact with current and prospective customers as well as the banks third party vendors.

Education and Experience

• Bachelor's degree in a related field from a four-year college or university; or 3-5 years banking experience; or equivalent combination of education and experience.
• Minimum of 3 years' experience in retail banking, preferably in either consumer loan originations, sales, or consumer loan product management.
• Encompass experience preferred.
• Salesforce experience preferred.

Skills and Competencies

• Advanced analytical knowledge of data.
• Strong analytical skills.
• Strong attention to detail.
• Self-motivated and proficient in time management/prioritization skills.
• Strong internal/external customer focus and bottom-line orientation.
• Strong math and computer skills.
• Ability to read and interpret documents such as financial statements, compliance regulations, and policy/procedure manuals.
• Ability to write routine reports and correspondence.
• Ability to speak effectively before groups of customers, Team Members, or Directors.
• Proficient in Microsoft Office

Working Conditions

Traditional office environment with ability to work remotely on a hybrid basis; the office maintains five day a week operation (Monday - Friday) with operational hours of 8:00am - 5:00pm.

Physical Demands

Penn Community promotes an equal opportunity workplace, which includes reasonable accommodations of otherwise qualified disabled applicants and employees. Please contact Human Resources with questions regarding the physical demands of this position.

• Lifting/carrying up to 10 lbs.
• Manual dexterity for computer work
• Speaking, hearing, and vision are required to perform essential functions

Penn community Bank is an equal opportunity employer.