Data & Analytics Consultant

Position Summary

Affairs information needs, designs studies, manages projects, analyzes results, and presents key findings to support business leaders in developing short- and long-term plans. Manages data and analytics projects of high complexity and impact to the business.

Duties and Responsibilities

• Creates models and develops data warehouse programs of high 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. Monitors and reports on progress and results as requested.
• Ledges and identifies short- and long-range data and analytics objectives related to targeted business objectives. Measures the effectiveness of the data and analytics strategies in driving performance improvement.
• Leads the planning, development, modeling, implementation, and reporting of all related data.
• Analyses current landscape and trends to assist in planning. Recommends changes to business strategies and tactics as appropriate.
• Creates files that include topics related to the industry, competitors, products, service innovations and trends. Works with others, including management, to develop, communicate, and enforce standards for proper documentation and organization of electronic files and data deliverables.
• Develops partnerships across the organization to define and implement experimental research designs and quantitative techniques using analytical tools. Serves as liaison to internal and external suppliers of customer and Agent data, and competitor insights. Serves as key contact with research suppliers.
• Maintains current knowledge of data analysis tools and trends. Identifies gaps in current services, proposes solutions, and implements changes as appropriate. Identifies process improvements.
• Mentors less experienced staff.
• Conducts special research studies as directed.

Capabilities

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

Qualifications

• Minimum Educational and Experience Requirements: Bachelor's degree with eight years of experience in research, analysis, strategic planning, financial analysis, information systems or related field; or Associate degree and ten years of experience; or High school diploma or GED with twelve years of 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