Data Analyst Ii Jobs

Ready to take the next step in your career? Maybe you’re 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® in everything we do.

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

• Catalogs existing data sources
• Works with varying teams to determine and understand how data analysis can support organizational goals and may lead planning efforts
• Designs reporting dashboards to translate data to an understandable illustrative format
• Cleans data to discard irrelevant information
• Enables access to resident and external data sources
• Designs, creates and maintains relational databases and data systems of moderate to high complexity
• Fulfills ad hoc reporting requests
• Actively suggests analytics opportunities and best practices
• Develops recommendations for resolution of problems and reviews recommendations with team
• Gathers data to support recommendations to address problems, with appropriate contingency plans
• Performs other duties as assigned
• Implements statistical models to identify and reveal trends, patterns, and relationships in data to provide guidance to others for decision making processes
• Creates data visualizations and reports to present to a variety of audiences using presentation layer tools
• Performs initial data exploration (binning, pivoting, summarizing and finding correlations, for example)
• Helps to streamline a better data supply chain for analytics that goes from experimentation into production
• Understands and applies information and data analysis requirements
• Works with open datasets, including populating and extracting data from internal and public open datasets
• Collaborates to establish standards, guidelines, and procedures for data validation, analysis and presentation

Education & Experience

Required

• Typically requires 2-5 years of experience in the desired field or may have intermediate level technical or business work experience
• Bachelor’s degree or in Computer Science, Information Systems, Business, or other related fields. Or equivalent work experience

Preferred or Specialized

• Experience in an agile environment strongly preferred

Certifications & Licenses

• N/A

Knowledge, Skills & Abilities

Demonstrated knowledge of:

• Relational databases, NoSQL databases, data extraction, querying, and scripting
• Business operations, systems requirements and IT processes and technologies
• The security, privacy and quality requirements for critical data entities
• How data is used within business processes and its impact on desired business process outcomes

Demonstrated ability to:

• Use/leverage spreadsheets and databases
• Perform data analysis identifying, analyzing and interpreting 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
• Assist in resolving the different points of view and requirements that invariably collide during cross-team and cross-organization efforts
• Interpret trends or patterns in structured and unstructured complex data sets
• Provide support for the adoption of data governance policies

Skills

• Scrum Master
• Agile Team Member