HYBRID- Business Analytics Intelligence Consultant (Information Technology Consultant 3)

Ohio Department of Insurance • Columbus, OH, United States • $200k - $250k / year • 1m ago

About Us

The Ohio Department of Insurance (ODI) was established in 1872 as an agency charged with overseeing insurance regulations, enforcing statutes mandating consumer protections, educating consumers, and fostering the stability of insurance markets in Ohio.

Today, the mission of the Ohio Department of Insurance is to provide consumer protection through education and fair but vigilant regulation while promoting a stable and competitive environment for insurers.

Please visit our website Department of Insurance and also find us on LinkedIn.

Office Of Information Technology Mission Statement

The mission of Office of Information Technology and Security is to support the Ohio Department of Insurance, through technology and innovation, to adhere to regulatory compliance and to serve consumers and constituents alike, with the objective to improve awareness, protection and advocacy.

We are looking for a motivated Information Technology Consultant 3 to join our team at the Ohio Department of Insurance. We are searching for an innovative individual with database support experience and a desire to implement new data analysis tools and techniques to help our department make data-driven decisions.

What You'll Do

Your Key Responsibilities include but are not limited to the following:

Design and implement business intelligence dashboards and user interfaces
Support SQL Server Database and Analysis Server
Manipulate data utilizing SQL
Design and implement processes for efficient transfer of data, monitor data transfer processes, and resolve data conflicts & inappropriate use of data
Identify meaningful business insights out of queried data and prepare summary findings
Build relationships and communicate regularly with business units
Provide consultation, analysis and advise to OITS management relating to data warehouse and analytic initiatives, including business exploration, production refinement, data science/machine learning, and advanced prototyping of data and information systems in the INS environment.
Work with OITS senior management and other staff, as well as business areas, to provide expert advice and guidance in order to support our complex data environment and help staff in resolving difficult or complex issues

What’s In It For You

Unless required by legislation or union contract, the final candidate can expect to be paid at the lowest step in the pay range (step 1). As an Information Technology Consultant 3, you will receive a raise after six (6) months and yearly step increases until you reach the top level of the pay range. There may also be possible cost of living adjustments (COLA) and longevity supplements begin after five (5) years of state service. This position is designated as telework eligible. The agency has a hybrid work model (i.e., working in the office and working from home on a schedule based on operational need). As such, successful candidates must have and maintain internet at their remote location during normal working hours. In addition, employees must reside in Ohio and within a reasonable distance from the Department location to respond to workplace reporting requirements.

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!

Minimum Qualifications

Completion of undergraduate core program coursework in information technology, electrical engineering or telecommunications; 5 years experience in information systems analysis, design & operations; 18 months experience in project/program management; 2 courses or 6 months experience in budgeting.