Data & Analytics Specialist II

Position Summary

Affirms information needs, designs studies, manages projects, analyzes results, and presents key findings to support business leaders. Manages data and analytics projects of moderate complexity and impact to the business.

Duties and Responsibilities

• Models and develops data warehouse programs of moderate complexity ensuring business needs are met, including understanding ERIE's demographics and potential opportunities.
• Analyzes metrics and supports audit of source data.
• Applies knowledge of programming languages and software tools to prepare ad hoc and recurring reports.
• Analyzes the financial implications of business decisions and identifies approaches to resolve business problems.
• Maintains and reports on progress and results as requested.
• Serves as a liaison to internal and external suppliers of data and insights.
• Develops, communicates, and enforces standards for proper documentation and organization of electronic files, data, and deliverables.
• Trains less experienced specialists within the section.
• Conducts special research studies as directed.

Qualifications

• Minimum educational and experience requirements: Bachelor's degree with two years' experience in research, analysis, strategic planning, financial analysis, information systems or related field; or Associate degree and four years’ experience; or High school diploma or GED with six years’ experience.
• Additional experience: Insurance industry experience preferred. An understanding of analysis and research required. Experience with dataset, programming, querying, and reporting design required. Advanced knowledge of SAS, SQL, SPSS, Python, R, or other related data analysis programs required. Experience developing, maintaining, and monitoring enterprise data governance policies and standards preferred. Knowledge of statistical and financial analysis and quantitative techniques preferred. Project management experience preferred. Proficiency with word processing, spreadsheet, database, presentation, and flow-charting software required. Proficiency with research-specific, statistical report writing software preferred.

Physical Requirements

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