Commercial Products & Services Division Department of Position: Commercial Products Data Dept Work from: Westport Office in Millcreek, PA Salary Range: $109,074.00-$174,235.00*
salary range is for thislevel 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.
Please Note: We are only considering US workers for this position. We are unable to offer this position to individuals who will require current or future immigration sponsorship for employment.
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
Plans and manages data and analytics projects of high complexity and confidentiality. Leads critical initiatives to ensure results contribute business value and align with strategy. Integrates predictive modeling, scenario testing, cost-benefit and other analytic results in the development of business solutions. Provides data-driven insights and strategic counsel to business leaders.
This position is based in-person out of our Westport Office in Erie, PA (Millcreek).
As a Data & Analytics Manager in our Commercial Products Data Department, your duties and responsibilities will include (but not be limited to) the following. Prior professional experience highly preferred in:
Strategic Data Management
Develop and execute the data strategy aligned with Commercial Products business goals, ensuring efficient datausage, storage, and integration.
Actas the liaison among the data engineering team, business stakeholders, enterprise dataand IT teams to translate business needs into technical solutions.
Innovation and Scalability
Identify opportunities for leveraging emerging technologies (e.g., cloud, AI, ML) to improve scalability and performance of data solutions, develop insights, and add value for the business.
Data Architectureand Pipeline Development
Oversee the design, implementation, and optimization of contemporary data architectures from data lake to warehouse, robust dimensional data models in star and snowflake schemas, as well as supporting ETL/ELT pipelines and workflows to ensure data availability and quality using tools available in AWS, Informatica, Snowflake, or related.
Analytics Enablement
Drive the development of analytics tools, dashboards, and predictive models to support decision making and operational efficiencies using tools like QLIK.
Develop analytics and insights for commercial insurance products and service teams.
Data Product Lifecycle Management
Guide product owners in an agile development environment managing the definition and lifecycle of data products, from ideation to deployment, ensuring alignment with business priorities.
Duties and Responsibilities
Manages overall operations of designated area of authority. Interviews, hires, trains and directs personnel. Prepares and conducts performance assessments, coordinates discipline and oversees Employee development as required.
Oversees objectives, plans and scope for section projects including expenses, tasks, deliverables, resources, assignments and dependencies. Consults on change management impacts. Ensures coordination with business area and Centers of Excellence to schedule, prioritize and delegate tasks as required.
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.
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.
Maintains current knowledge of data analysis tools and trends. Identifies gaps in current services, proposes solutions and implements changes as appropriate.
Applies knowledge of programming languages and software tools to analyze the financial implications of business decisions and identify approaches to resolve business problems. Monitors and reports on progress and results as requested.
Builds and maintains effective working relationships with internal and external business partners.
Oversees in-depth research and analysis related to assigned projects and issues. Provides research recommendations and interprets relevant data.
Thefirst 4dutieslisted are the functions identified as essential to the job. Essential functions are those job duties that must be performedin order forthe 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
Collaborates (Leader)
Self-development (Leader)
Customer Focus (Leader)
Instills Trust (Leader)
Persuades (Leader)
Decision Quality (Leader)
Drives vision and purpose (Leader)
Nimble Learning (Leader)
Cultivates Innovation (Leader)
Develops Talent (Leader)
Plans and Aligns (Leader)
Values Diversity (Leader)
Ensures Accountability (Leader)
Optimizes Work Processes (Leader)
Qualifications
Minimum Educational Requirements
Bachelor's degree in marketing, market research, statistics or business-related field. Advanced degree preferred.Seven years of experience in data analysis, statistics, strategic planning, financial analysis, business analysis or related field, required, or;
Associate degree in marketing, market research, statistics or business-related field and nine years of experience in data analysis, statistics, strategic planning, financial analysis, business analysis or related field, required, or;
High school diploma or GED with eleven years of experience in data analysis, statistics, strategic planning, financial analysis, business analysis or related field, required.
Additional Experience
Experience in one or more areas of business operations required.
Supervisory experience preferred.
Project management experience preferred.
An understanding of analysis and research required.
Experience with dataset, programming, querying and reporting design required.
Advanced knowledge of SAS (or comparable programming language) required.
Knowledge of statistical and financial analysis and quantitative techniques preferred.
Proficiency with word processing, spreadsheet, database and presentation software required.
Proficiency with research specific, statistical report writing software preferred.
Physical Requirements
Climbing/accessing heights; Rarely
Driving; Occasional (<20>
Lifting/Moving 0-20 lbs; Occasional (<20>
Lifting/Moving 20-50 lbs; Occasional (<20>
Ability to move over 50 lbs using lifting aide equipment; Rarely
Pushing/Pulling/moving objects, equipment with wheels; Rarely