Data & Analytics Consultant

Position Summary

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

Please note that we are only considering US workers for this position, and we are unable to offer this position to individuals who will require current or future immigration sponsorship for employment.

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

• There are two (2) positions available.
• These positions will be based in-person out of our corporate office in Erie, PA.
• Hiring team will consider candidates for Data & Analytics Specialist II, Senior Data & Analytics Specialist, or Data & Analytics Consultant.  Level of role offered will be based on depth and breadth of candidate's experience and qualifications.
• Incumbent will support data analytics and operational reporting for Finance areas, such as Accounts Payable, Accounts Receivable, Billing, Collections, and Sourcing & Vendor Management by:
  • Working with key stakeholders to recommend and implement solutions using data and programming language(s).
  • Developing and designing data models, datasets, Qlik dashboards.
  • Maintaining SharePoint sites and workflows.
  • Supporting the maintenance of SAS datasets.

We are looking for a diverse pool of candidates with the skillsets below:

• Problem solving skills
• Verbal and written communication skills
• Accuracy and attention to detail
• Strong mathematical skills
• Adept at writing queries, creating reports and making presentations
• Knowledge of data visualizations software (Tableau, QLIK)
• Knowledge of coding languages (SQL, R, SAS or Python)

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 re-occurring reports. Analyzes the financial implications of business decisions and identifies approaches to resolve business problems. Monitors and reports on progress and results as requested.
• Leads 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.
• Analyzes 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.

The first two 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

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 in research, analysis, strategic planning, financial analysis, information systems or related field; or
• High school diploma or GED with twelve years of experience in research, analysis, strategic planning, financial analysis, information systems or related field.

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