Job Description

Ready to take the next step in your career? Maybe you\xe2\x80\x99re looking for advancement opportunities, a better work-life balance, or just something new and exciting. At Pekin Insurance, we strive to go Beyond the expected\xc2\xae in everything we do. Position Objective The Data Analyst is responsible for identifying, capturing, analyzing, and managing the company\xe2\x80\x99s 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 can 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
• Gathers data to support recommendations to address problems
• Develops recommendations for resolution of problems for review by other team members
• Understands and applies information and data analysis requirements
• Catalogs existing data sources
• Designs, creates and maintains relational databases and data systems of low to moderate complexity
• Works with open datasets, including populating and extracting data from internal and public open datasets
• Cleans data to discard irrelevant information
• Assists in designing reporting dashboards to translate data to an understandable illustrative format
• Assists in creating data visualizations and reports to present to a variety of audiences using presentation layer tools
• May support the establishment of standards, guidelines, and procedures for data validation, analysis and presentation
• Fulfills ad hoc reporting requests
• Assists with initial data exploration (binning, pivoting, summarizing and finding correlations, for example)
• Analyzes and interprets results using standard tools and techniques
• Suggests analytics opportunities and best practices
• Performs other duties as assigned

Education & Experience Required

• Bachelor\xe2\x80\x99s degree or in Computer Science, Information Systems, Business, or another related field. Or equivalent work experience
• Typically requires 0-2 years of experience in the desired field or may have entry level technical or business work experience, including internships

Preferred or Specialized

• Experience in an agile environment strongly preferred

Certifications & Licenses

• N/A

Knowledge, Skills & Abilities Basic 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

Basic ability to:

• 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