Senior Financial Data Analyst

:

Division or Field Office:

Controller Division

Department of Position: Cost Analysis & Controls Dept

Work from:

Corporate Office, Erie PA Salary Range:

$83,576.00 - $133,504.00 *

salary range is for this level and may vary based on actual level of role hired for

• This range represents a national range and the actual salary will depend on several factors including the scope and complexity of the role and the skills, education, training, credentials, location, and experience of an applicant, as well as level of role for which the successful candidate is hired. Position may be eligible for an annual bonus payment.

At Erie Insurance, you're not just part of a Fortune 500 company; you're also a valued member of a diverse and inclusive team that includes more than 6,000 employees and over 13,000 independent agencies. Our Employees work in the Home Office complex located in Erie, PA, and in our Field Offices that span 12 states and the District of Columbia. Benefits That Go Beyond The Basics

We strive to be Above all in Service® to our customers—and to our employees. That's why Erie Insurance offers you an exceptional benefits package, including:

• Premier health, prescription, dental, and vision benefits for you and your dependents. Coverage begins your first day of work.
• Low contributions to medical and prescription premiums. We currently pay up to 97% of employees' monthly premium costs.
• Pension. We are one of only 13 Fortune 500 companies to offer a traditional pension plan. Full-time employees are vested after five years of service.
• 401(k) with up to 4% contribution match. The 401(k) is offered in addition to the pension.
• Paid time off. Paid vacation, personal days, sick days, bereavement days and parental leave.
• Career development. Including a tuition reimbursement program for higher education and industry designations.

Additional benefits that include company-paid basic life insurance; short-and long-term disability insurance; orthodontic coverage for children and adults; adoption assistance; fertility and infertility coverage; well-being programs; paid volunteer hours for service to your community; and dollar-for-dollar matching of your charitable gifts each year.

Position Summary

Under minimal supervision, performs complex data and accounting functions to organize, analyze, track and report financial activities. Represents Projects & Systems team on data and finance related projects across the business and provides assistance to division staff as needed.

Duties and Responsibilities

Plays a critical role in supporting business partners by extracting data from various sources, performing exploratory data analysis, cleansing, massaging, aggregating and balancing data for use in financial accounting and reporting.

Interprets data, analyzes results and provides ongoing reports based on the customer needs, ensuring business needs are met and considering ERIE's financial reporting requirements.

Analyzes, verifies and balances all source data used in the preparation of journal entries, financial exhibits, reports, schedules and other documents in terms of accuracy, completeness and compliance with requirements. Prepares and/or reviews monthly account and system reconciliations.

Prepares various journal entries, surveys, supporting schedules and management reports, in support of financial statements for internal use and external filings in accordance with applicable accounting principles or regulations within the required deadlines.

Demonstrates analytical and research skills. Evaluates impact of business changes to accounting transactions and systems, gathers requirements, tests and implements changes to financial information or related documentation. Researches issues and implements data aggregation and reporting changes for new accounting guidance, regulations, products and company initiatives.

Creates impactful visual representations of analytic insights and concise summaries of methodology geared to audience needs. Presents selected portions to stakeholders.

Maintains strong understanding of the control environment and adheres to applicable internal controls. Prepares and maintains internal control documentation and testing in accordance with SOX/MAR. Evaluates controls for effectiveness and identifies internal control improvements as necessary.

Maintains strong working knowledge of systems and applications and process flows participating in upgrades as appropriate. Identifies process improvements and automation opportunities using data extraction and analysis tools, and coordinates testing and implementation.

Prepares workpapers for review by internal and external auditors. Communicates with internal and external associates regarding financial activities and issues.

Recommends process improvements and challenges current processes for increased efficiencies and effectiveness.

Provides training, support and guidance to division staff, as required.

Coordinates and completes special projects as required. Performs other duties as required. The first five duties listed are the functions identified as essential to the job. Essential functions are those job duties that must be performed in order for the job to be accomplished. This position description in no way states or implies that these are the only duties to be performed by the incumbent. Employees are required to follow any other job-related instruction and to perform any other duties as requested by their supervisor, or as become clear.

Competencies Customer Focus Nimble Learning Values Diversity Collaborates Cultivates Innovation Decision Quality Ensures Accountability Instills Trust Optimizes Work Processes Self-Development Qualifications

Bachelor's degree in accounting, information systems or related field required. Five years' experience in accounting or information systems required. Insurance industry experience preferred. In-depth knowledge of spreadsheet, reporting, query and/or database software required. Working knowledge of SAP preferred. The position requires the incumbent to work weekends and restrict vacation during peak periods.

Incumbents focused on projects & systems may substitute nine years of related experience in lieu of degree.

Physical Requirements Climbing/accessing heights; Never Driving; Rarely Lifting/Moving 0-20 lbs; Occasional (