Analytics & Business Intelligence Developer

What You’ll Be Doing:

Under general supervision of the Business Intelligence (BI) Manager, receives direction to design & perform systems analysis, recommend application solutions &/or test & correct programs related to testing & implementation, and assist with documentation.

• Reading, writing, extracting & reporting from data sources (e.g., databases, transaction files, & real-time data streams) using software development tools (e.g., Python, SQL, Tableau, Cognos).
• Working with business personnel to identify & document system software requirements & assisting with development, implementation & monitoring IT quality assurance standards & testing.
• Defining problems & developing potential solutions for a team engaged in analysis, design, development, testing, documentation, implementation, integration, scheduling, troubleshooting, support, & maintenance of custom BI programs, scripts, & jobs (e.g., reporting, dashboards, process automation, data query, exchange, interface, & transformation) in support of BI tasks & activities (e.g., visualization, statistical analysis, machine learning, generative artificial intelligence, simulation, inference).
• Assisting in supporting user acceptance testing.

• Creating detailed test designs & plans.
• Creating & reviewing test data.
• Coordinating execution of test scripts.
• Coordinating debugging efforts & defect tracking.
• Coordinating support of user acceptance testing.
• Coordinating software implementation & deployment tasks, performing performance & load testing.

• Summarizing in writing, information on topics involving database, BI & application information in support of software development.
• Obtaining or imparting information from/to business customers & technical staff through discussions (e.g., data structures, data warehouse tools, BI techniques).
• Leading discussions & formal meetings with technical & non-technical personnel on BI software development & related topics.
• Assisting higher-level developers in the development of BI training materials & user guides.

Why Work for the State of Ohio:

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
• Free Dental, Vision and Basic Life Insurance premiums after completion of the eligibility period
• Paid time off, including vacation, personal, sick leave and 11 paid holidays per year
• Childbirth, Adoption, and Foster Care leave
• Education and Development Opportunities (Employee Development Funds, Public Service Loan Forgiveness, and more)
• Public Retirement Systems & Optional Deferred Compensation

Qualifications:

To Qualify, You Must Clearly Demonstrate:

• 48 mos. combined work experience in systems analysis, program development for computer applications, and documentation with 12 mos. experience in Business Intelligence.
• Or completion of an associate core program in computer science or information systems & 30 mos. combined work experience, including 12 mos. in Business Intelligence.
• Or completion of an undergraduate core program in computer science or information systems & 24 mos. combined work experience, including 12 mos. in Business Intelligence.

Job Skills: Software Development/Implementation, Data Analytics, Information Technology

Professional Skills: Attention to Detail, Critical Thinking, Problem Solving, Analysis

Primary Technology: Business Intelligence

Major Worker Characteristics:

• Knowledge of computer & electronics, communication tools, customer support, software development principles, SQL, Python, Tableau, Cognos, statistical analysis, data analytics, & machine learning.
• Skills in reading comprehension, speaking, service orientation, troubleshooting, and complex problem solving.
• Ability to stay abreast of current technologies in BI & software development, define problems, collect data, and prepare meaningful reports.

Supplemental Information:

EEO & ADA Statement: The State of Ohio is an Equal Employment Opportunity Employer and prohibits discrimination and harassment of applicants or employees. The Ohio Bureau of Workers' Compensation is committed to providing access and reasonable accommodation in its employment opportunities pursuant to the ADA.

BWC OCSEA Selection Rights: This position shall be filled in accordance with the provisions of the OCSEA Collective Bargaining Agreement.

Salary Information: Hourly wage is expected to be at step 1 of the pay range for new state employees. Current employees will be placed in the appropriate step based on any applicable union contract.

Transportation: Position may require travel; therefore, persons must provide their own transportation &/or operate a state-owned vehicle.

Educational Transcripts: Unofficial transcripts must be attached for educational achievements to be considered during the screening process.

Background Check: Prior to employment, the final applicant will undergo a criminal background check.