What are the responsibilities and job description for the Data Analyst II position at Pekin Insurance?
Looking for more than just a job? You’ve found it.
At Pekin Insurance, you’re not a number—you’re part of something bigger. For over 100 years, we’ve built a community where people are valued, supported, and empowered to grow. Here, you’ll find a workplace where collaboration is real, ideas are welcome, and the work you do truly matters. We’re proud to help people through life’s toughest moments—and it’s our people who make that possible.
From day one, you’ll be encouraged to bring your whole self to work, take on meaningful challenges, and grow in ways that matter to you.
This is your opportunity to belong, thrive, and make a difference—right here at Pekin Insurance.
Position Overview
The Data Analyst is responsible for identifying, capturing, analyzing, and managing the company’s data, contributing to better decision-making, and planning. The Data Analyst performs data analysis, including conceptualization, modeling, and presentation of data. Additionally, the Data Analyst performs a variety of technical tasks related to capturing, managing, and analyzing data; turning information into insights to support and enable key decisions and business processes. The Data Analyst also supports information governance in conjunction with Architects and Data Stewards.
The Data Analyst works to support data science activities by analyzing information, focusing on products or business areas. The Data Analyst could apply an array of basic data science methodologies including statistics, text analytics, algorithms, and numerical optimization, along with specialties such as machine learning.
The Data Analyst participates in program increment planning, pre-and-post planning, system, and solution demos, and inspect and adapt events. The Data Analyst may also contribute to the development of the team backlog and architectural runway, management of work in process (WIP) levels, and support of program and solution Kanban.
Essential Job Functions
Education & Experience
Demonstrated knowledge of:
Pay Range
At Pekin Insurance, you’re not a number—you’re part of something bigger. For over 100 years, we’ve built a community where people are valued, supported, and empowered to grow. Here, you’ll find a workplace where collaboration is real, ideas are welcome, and the work you do truly matters. We’re proud to help people through life’s toughest moments—and it’s our people who make that possible.
From day one, you’ll be encouraged to bring your whole self to work, take on meaningful challenges, and grow in ways that matter to you.
This is your opportunity to belong, thrive, and make a difference—right here at Pekin Insurance.
Position Overview
The Data Analyst is responsible for identifying, capturing, analyzing, and managing the company’s data, contributing to better decision-making, and planning. The Data Analyst performs data analysis, including conceptualization, modeling, and presentation of data. Additionally, the Data Analyst performs a variety of technical tasks related to capturing, managing, and analyzing data; turning information into insights to support and enable key decisions and business processes. The Data Analyst also supports information governance in conjunction with Architects and Data Stewards.
The Data Analyst works to support data science activities by analyzing information, focusing on products or business areas. The Data Analyst could apply an array of basic data science methodologies including statistics, text analytics, algorithms, and numerical optimization, along with specialties such as machine learning.
The Data Analyst participates in program increment planning, pre-and-post planning, system, and solution demos, and inspect and adapt events. The Data Analyst may also contribute to the development of the team backlog and architectural runway, management of work in process (WIP) levels, and support of program and solution Kanban.
Essential Job Functions
- Works with varying teams to determine and understand how data analysis can support organizational goals and may lead planning efforts
- Gathers data to support recommendations to address problems, with appropriate contingency plans
- Develops recommendations for resolution of problems and reviews recommendations with team
- Understands and applies information and data analysis requirements
- Catalogs existing data sources
- Designs, creates and maintains relational databases and data systems of moderate to high complexity
- Works with open datasets, including populating and extracting data from internal and public open datasets
- Cleans data to discard irrelevant information
- Designs reporting dashboards to translate data to an understandable illustrative format
- Creates data visualizations and reports to present to a variety of audiences using presentation layer tools
- Collaborates to establish standards, guidelines, and procedures for data validation, analysis and presentation
- Fulfills ad hoc reporting requests
- Performs initial data exploration (binning, pivoting, summarizing and finding correlations, for example)
- Implements statistical models to identify and reveal trends, patterns, and relationships in data to provide guidance to others for decision making processes
- Actively suggests analytics opportunities and best practices
- Enables access to resident and external data sources
- Helps to streamline a better data supply chain for analytics that goes from experimentation into production
- Performs other duties as assigned
Education & Experience
- Bachelor’s degree or in Computer Science, Information Systems, Business, or other related fields. Or equivalent work experience
- Typically requires 2-5 years of experience in the desired field or may have intermediate level technical or business work experience
- Experience in an agile environment strongly preferred
- N/A
Demonstrated knowledge of:
- Business operations, systems requirements and IT processes and technologies
- Relational databases, NoSQL databases, data extraction, querying, and scripting
- How data is used within business processes and its impact on desired business process outcomes
- The security, privacy and quality requirements for critical data entities
- Perform data analysis identifying, analyzing and interpreting trends or patterns in structured and unstructured complex data sets
- Provide support for the adoption of data governance policies
- Assist in resolving the different points of view and requirements that invariably collide during cross-team and cross-organization efforts
- Use/leverage spreadsheets and databases
- Interpret trends or patterns in structured and unstructured complex data sets
- Summarize findings, draw conclusions and put together presentations for a wide variety of audiences
- Apply original thinking to produce new ideas and innovate
Pay Range
- $73,500 – $94,000 per year
- This range is based on the expected level of experience and skills for this position. Final compensation will depend on individual
- Health, Dental and Vision Insurance
- Generous 401(k) with company match
- Paid Time Off (PTO) with Paid Holidays
- Flexible/Hybrid Work Schedule
- Paid Volunteer Program
Salary : $73,500 - $94,000