Data Analyst

DATA ANALYST (Hybrid/Remote Eligible)

About Us:

As Ohio's Secretary of State, Frank LaRose is doing his part to deliver a thriving democracy and a prosperous economy for all Ohioans. In his role as the state's chief elections officer, he is working to ensure that Ohio's elections are both secure and accessible. And, as the first stop for new businesses in the Buckeye State, he is assisting entrepreneurs as they receive articles of incorporation for a new business.

What You'll Do:

The Data Analyst is responsible for researching and identifying complex business problems and opportunities, collaborating with stakeholders to define priorities and risks, and extracting and validating data from multiple sources.

Research and Problem Identification

• Researches and identifies complex business problems and opportunities

• Collaborates with business subject matter experts, IT staff, and agency leaders to define priorities, resources, and risks

Performance Metrics and Data Extraction

• Identifies relevant performance metrics

• Extracts data from multiple sources and systems

• Identifies and catalogs appropriate data sources (e.g., agency data files, shared data lake, purchased databases)

• Accesses databases and other source systems

• Coordinates with business subject matter experts and IT staff to ensure the validity and completeness of data models and transformations

Statistical Analysis and Visualization

• Applies statistical analysis and visualization techniques to identify data trends and relationships

• Utilizes analytics techniques (e.g., regression, correlation, cluster analysis, classification, data quality, data mining, machine learning, data visualization) to discover, confirm, and document associations, predictive models, and algorithms

Business Solutions and Insights

• Recommends actionable business solutions and insights impacting agency goals and objectives

• Applies analytical results to address practical business problems and opportunities in a format accessible to non-technical staff and stakeholders

• Provides guidance to business leaders regarding the interpretation and applicability of findings in a business context (e.g., program effectiveness, resource allocation, utilization patterns, fraud detection)

• Presents summary findings and recommendations to agency leaders

• Operationalizes analytics processes

Collaboration and Deployment

• Collaborates with IT staff to select deployment methods

• Establishes measurement and reporting of performance metrics

• Identifies and documents best practices

• Trains peers and business staff in the use of analytics tools and techniques

• Remains current with relevant innovations and industry direction

Protocol Development and Survey Administration

• Assists the Senior Data Analyst in developing protocols for responding to internal and external data requests

• Creates and administers surveys for data collection from external parties

Data Review and Standardization

• Improves and standardizes data review processes

• Collaborates with the Senior Data Analyst on List Maintenance projects

Process Enhancement

• Works with the Senior Data Analyst and Elections Assistant to review and enhance internal processes associated with the Statewide Voter Registration Database

Process Improvement Collaboration

• Collaborates with the Senior Data Analyst, Elections Division staff, and IT Division staff to identify opportunities for process improvement

What's in it for you:

At the State of Ohio, we take care of the team that cares for Ohioans. We provide a variety of quality, competitive benefits to eligible full-time and part-time employees. For a list of all the State of Ohio Benefits, visit our Total Rewards website! Our benefits package includes:

Medical Coverage

• Quality, affordable, and competitive medical benefits are offered through the available Ohio Med plans.

Dental, Vision and Basic Life Insurance

• Dental, vision, and basic life insurance premiums are free after completed eligibility period. Length of eligibility period is dependent on union representation.

Time Away From Work and Work/Life Balance

• Paid time off, including vacation, personal, and sick leave

• 12 paid holidays per year

• Childbirth/Adoption leave

Employee Development Funds

• The State of Ohio offers a variety of educational and professional development funding that varies based on whether you are a union-exempt employee or a union-represented employee.

Ohio Public Employees Retirement System

• OPERS is the retirement system for State of Ohio employees. The employee contributes 10% of their salary towards their retirement. The employer contributes an amount equal to 14% of the employee's salary. Visit the OPERS website for more information.

Deferred Compensation

• The Ohio Deferred Compensation program is a 457(b) voluntary retirement savings plan. Visit the Ohio Deferred Compensation website for more information.

Education and Experience

Required

• Bachelor's degree in a relevant field such as Data Science, Statistics, Computer Science, or a related field

• Minimum of 18 months experience with data analytics, statistical analysis, and data visualization software

• Proficiency in writing and executing SQL queries

Preferred

• Experience with business intelligence (BI) and data visualization tools (e.g., Tableau, PowerBI, Cognos)

• Proficiency in coding and reporting languages such as Python or R

• Previous experience in a similar role or industry

• Certifications in relevant software or methodologies (e.g., SAS, SPSS certification)

Knowledge

• Data analytics, statistical analysis, and data visualization software

• Agency policies and procedures

• Customer relations management

• Meeting management techniques

Skills

• Use of personal computers and associated hardware/software

• Writing and executing SQL queries

• Data analysis software

• Statistical analysis software (e.g., SAS, SPSS)

• Business intelligence (BI) and data visualization tools (e.g., Tableau, PowerBI, Cognos)

• Coding and reporting (e.g., Python, R)

Abilities

• Deal with many variables and determine recommended courses of action

• Develop complex reports and position papers

• Gather, collate, and classify information about data, people, or things

• Cooperate with co-workers on group projects

• Write and execute SQL to access and query data tables

• Acquire data from multiple sources

• Work with structured and unstructured data

• Use statistical analysis

• Use proper research methods in gathering data

Technology

• Personal computer, Microsoft Office 365 - Word, Excel, PowerPoint, Outlook

• Azure Synapse/Data Factory, Power BI Desktop and Server, Power Apps, Power Automate, Power Query

• T-SQL, Python, DAX