Data Analyst 1

State of Ohio; Kentucky; Hybrid; USD 52,000 - 76,000; Full time

Benefits offered by this job

Hybrid work environment

Flexible work schedule

CPA/certification reimbursement

Medical benefits

Retirement planning

Work/Life balance

Job summary

Auditor Of State is looking for a Data Analyst 1 to join the Data and IT Audit (DITA) team. You will collect, prepare, analyze, and interpret financial, operational, and compliance-related data used in audit engagements.

This role emphasizes strong analytical skills and an interest in accounting, auditing, data analysis, and using technology to support audit procedures. The position offers a hybrid work environment, flexible schedules, and opportunities for professional certification

Qualifications

• Requires a bachelor’s degree in a relevant field or equivalent experience.
• Experience in data analytics, accounting, or auditing is beneficial.
• Interest in using technology to support audit procedures.

Responsibilities

• Assist higher-level data analysts in audit data analytics projects.
• Collect data from financial systems and prepare data for analysis.
• Prepare narratives describing data preparation methods.
• Assist in delivering data tests and audit procedures.
• Examine and interpret data to help automate audit tests.
• Execute data scripts and queries and analyze financial data.
• Review data results to ensure proper compliance with procedures.
• Document work showing evidence of scope, timing, and findings.

Skills

Analytical thinking

Attention to detail

Collaboration

Problem solving

Time management

Education

Baccalaureate degree in data analytics, MIS, CS, accounting, finance, or related discipline

Tools

Python

SQL

Data visualization tools

Job description

The Auditor of State’s Office (AOS) is looking for a Data Analyst 1 to join the Data and IT Audit (DITA) team. Data Analysts provide support to financial audit regions by collecting, preparing, analyzing, and interpreting financial, operational, and compliance-related data used in audit engagements. AOS staff work with public entities, including state agencies, counties, townships, school districts, municipalities, and other organizations receiving public funds. We are looking for individuals with strong analytical skills and an interest in accounting, auditing, data analysis, and using technology to support audit procedures. Experience or education involving data analysis, accounting, auditing, data preparation, or related fields is beneficial.

What You'll Do

• Assist higher-level data analysts in performing audit data analytics projects and activities in accordance with generally accepted government auditing standards.
• Collect and gather data from financial systems and prepare the data and documentation necessary for the execution of data analysis in conducting audits.
• Prepare documentation for data work, including narratives describing data preparation methods and tools used.
• Assist in the delivery of data and data tests of specific accounts and records.
• Assist in the preparation of audit procedures and schedules.
• Examine and interpret financial, operational, and compliance-related data to help automate audit tests.
• Execute data scripts and queries and analyze financial data.
• Review completed data results with the Data Analytics Manager or designated team leader to determine proper compliance with audit procedures and techniques adopted by the Auditor of State.
• Prepare audit work that clearly provides evidence of the nature, timing, and extent of the work performed and supports the results of the audit as presented in reports and other forms of audit communications.
• Perform other duties as assigned.

Why work for the Auditor of State?

Benefits

• Hybrid work environment
• Four- or Five-Day Flexible Work Schedule
• Merit-Based Internal Promotion Structure
• CPA and Professional Certification Reimbursement Program
• Medical Benefits (Dental and Vision)
• Retirement Planning
• Work/Life Balance

Educational And Capability Requirements

Baccalaureate degree from an accredited college or university in data analytics, management information systems, computer science, accounting, finance, or a related discipline.

Or-

Five years of experience in data analytics or a related field.

Preferred Qualifications / Desired Experience

The following knowledge, skills, and experience are preferred but are not required:

• Demonstrated aptitude and interest in learning new programming languages, development frameworks, data tools, and technologies, or
• Experience using Python or another programming or scripting language for data analysis, automation, data preparation, or application development.
• Experience using SQL or other tools to query, transform, analyze, and validate structured data.
• Experience with or interest in developing web-based applications, internal business applications, dashboards, APIs, or other technology solutions.
• Familiarity with software development concepts, source control, testing, documentation, or deployment practices.
• Knowledge of local government accounting, financial reporting, or financial management systems, including systems used by counties, municipalities, townships, school districts, or other public entities.
• Knowledge of state government accounting, financial reporting, enterprise resource planning, or other statewide financial and administrative systems.

Desired Characteristics

You are analytical, detail-oriented, and able to work effectively with financial, operational, and compliance-related data. You have an interest in using data and technology to support audit procedures and objectives, communicate information clearly, collaborate effectively with Data Analytics Managers and audit staff, and apply sound judgment and objectivity when performing assigned duties. Experience or education involving accounting, auditing, data analysis, or related areas is beneficial, as is familiarity with data preparation methods, audit procedures, financial data, and data scripts or queries.

The AOS is an Equal Opportunity Employer.

It is the policy of the AOS to prohibit discrimination and harassment of applicants and employees, due to race, color, religion, sex (including sexual harassment), sexual orientation, gender identity or expression, genetic information, national origin, ancestry, disability, age (40 years or older), veteran status or military status, status as a parent during pregnancy and immediately after the birth of a child, status as a nursing mother, status as a parent of a young child, or status as a foster parent. Discrimination, harassment, and/or retaliation will not be tolerated.

Organization

Auditor Of State

Primary Location

United States of America-OHIO

Compensation

Commensurate w/ Experience

Schedule

Full-time

Classified Indicator

Classified

Union

Exempt from Union

Professional Skills

Analyzation, Attention to Detail, Collaboration, Problem Solving, Time Management

Primary Technology

Data Integration Tools

Agency Overview

With a statewide staff of more than 800 auditors and other professionals, the Auditor of State's office is responsible for auditing all public offices in Ohio, (nearly 6,000 entities). This includes cities, counties, villages, townships and schools.