Internal Controls Data Analyst

Division or Field Office:

Law Division

Department of Position: Special Investigations Dept 

Work from:

Home Office, Erie PA  Salary Range:

$61,892.00 - $98,865.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

Works closely with the Internal Controls Consultant and business areas to assess information needs, designs research studies, manages data projects, analyzes results, and presents key findings to support internal business fraud mitigation strategies. Plans and manages data and fraud analytics projects of moderate to high complexity in business areas to test resilience of internal fraud risk controls and identify exposures.

 

• The successful candidate will work from the Home Office, Erie PA.
• The Hiring Manager will also consider candidates for Senior Internal Controls Data Analyst.  Level of position offered will be based upon the depth and breadth of selected candidate’s experience and qualifications.    

Duties and Responsibilities

• Works with business areas to analyze business data and data relationships to develop and generate testing, data analysis, and analytics reporting to evaluate the adequacy of internal fraud controls.
• Utilizes quantitative analysis and statistical methods to develop fraud risk analytics, reporting, data development and analytics support to provide strategic insights to optimize internal fraud controls.
• Analyzes trends and interrogates performance of internal fraud mitigation initiatives. Creates ad hoc data analyses from multiple internal and external data sources to evaluate effectiveness of internal controls.
• Mines and performs data analysis from multiple sources using high-level analytical tools often using complex joins across multiple datasets and validates data by reconciling source or system of records; understands, documents and explains variances and interpret results; pinpoint trends, correlations and patterns in data.
• Develops metrics to measure quality and effectiveness of exiting controls. Works with subject matter experts to create data analysis and insight resulting in recommendations for residual fraud risk controls and mitigation.
• Provides concise data reports and data visualizations. Creates and maintains databases and data sets and triage data related issues, and articulates results of data analysis to support residual fraud risk remediation.
• Trains less experienced data analyst within the section and conducts special research studies as directed.

 

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 evident.

Capabilities

• Self-Development
• Collaborates
• Cultivates Innovation
• Instills Trust
• Decision Quality
• Values Diversity
• Nimble Learning
• Customer Focus
• Optimizes Work Processes
• Ensures Accountability
• Information Management Skills
• Job-Specific Knowledge
• Using Tables And Graphs

Qualifications

Minimum Educational and Experience Requirements 

• Bachelor's degree with three years of experience in research, analysis, strategic planning, financial analysis, information systems or related field; or
• Associate degree and five years of experience in research, analysis, strategic planning, financial analysis, information systems or related field; or
• High school diploma or GED with seven years of experience in research, analysis, strategic planning, financial analysis, information systems or related field

 

Additional Experience

• An understanding of analysis and research required.
• Experience with dataset querying and reporting required.
• Proficiency with word processing, spreadsheet, database, presentation, and flow-charting software required.
• Proficiency at performing data analysis and reporting using business intelligence tools required.
• Experience with SQL and/or SAS is preferred.
• Experience with software and programs such as ACL or other related data analytics programs preferred.
• Knowledge of statistical and financial analysis and quantitative techniques preferred.
• Project management experience preferred.
• Experience analyzing and reviewing business data to identify performance indicators pertaining to operations, risk, finance, compliance, or process controls.
• Insurance industry experience preferred.

Physical Requirements

• Climbing/accessing heights; Rarely
• Driving; Rarely
• Lifting/Moving 0-20 lbs; Occasional (<20%)
• Lifting/Moving 20-50 lbs; Occasional (<20%)
• Ability to move over 50 lbs using lifting aide equipment; Occasional (<20%)
• Manual Keying/Data Entry/inputting information/computer use; Often (20-50%)
• Pushing/Pulling/moving objects, equipment with wheels; Occasional (<20%)