BI Platform Administrator (Data Administration Manager 1)

Schedule: Full-time

BWC’s core hours of operation are Monday-Friday from 8:00am to 5:00pm, however, daily start/end times may vary based on operational need across BWC departments. Most positions perform work on-site at one of BWC’s seven offices across the state. BWC offers flex-time work schedules that allow an employee to start the day as early as 7:00am or as late as 8:30am. Flex-time schedules are based on operational need and require supervisor approval.

What You'll Be Doing:

Under general supervision of the Business Intelligence (BI) Manager, works with Enterprise Analytics team to develop, publish, & enforce policies & procedures regarding data administration, develop standards for new & existing data definition, determine software to maintain data administration standards & assist in design & development of databases.

Developing & maintaining data sources in Snowflake, Tableau, Cognos, etc. to meet business requirements.

Collaborating with technical staff & business stakeholders via meetings & electronic communication methods to gather & translate requirements into technical specifications for data products (e.g. Tableau data sources, Snowflake tables & views, Cognos framework packages)

Monitoring & optimizing the performance of Tableau data sources through Tableau Server administration capabilities & Snowflake tables/views through query monitoring to ensure efficient data retrieval & processing.

Coordinating with Enterprise Analytics staff & business Subject Matter Experts (SMEs) to conduct annual audits of data sources & other BI products (e.g. Tableau workbooks, Cognos reports, etc.) to identify & resolve data discrepancies & outdated items.

Documenting data source structures, processes, & maintenance procedures for future reference & training efforts.

Coordinating with Enterprise Analytics staff and business SMEs to annually review & update security protocols and data permissions to safeguard sensitive data (e.g. HR data, PII, CPI) & maintain compliance with regulatory standards.

Working in conjunction with Enterprise Analytics staff & business SMEs to establish & maintain new & existing data definitions.

Acting as BWC liaison for State of Ohio DataOhio Portal BI initiatives.

To Qualify, You Must Clearly Demonstrate:

Required Experience and/or Education

Completion of undergraduate core program in business or public administration or data processing/computer science/information systems technology AND 2 yrs. exp. or 2 yrs. trg. in which included responsibility for developing standards for new & existing data definition, product evaluation, recommending software selection, design & development of data bases to include security measures/controls & how data is to be accumulated maintained, archived & removed from system.

Or equivalent of Minimum Class Qualifications for Employment noted above.

MAJOR WORKER CHARACTERISTICS:

Knowledge of: Ohio Bureau of Workers Compensation (BWC), Division, departmental & section policies & standard operating procedures*; computer science; business &/or public administration, data processing, engineering or comparable field which included coursework in logic-based mathematics, database concepts, basic data processing concepts & high-level language computer programming (e.g. SQL, Python), data security industry standards in data administration; computer systems analysis & design; computer hardware systems; planning*; project management.

Skill in: Operation of personal computer & peripheral equipment; BI tools (e.g. Tableau, Cognos); Microsoft Office products; BWC Web*; BWC software & systems (e.g. Snowflake)

Ability to: design & develop business plan (i.e., short & long term); deal with problems/issues involving several variables within familiar context; communicate verbally & in writing on technical & non-technical matters; gather, collate & classify information about data, people or things; prepare & maintain accurate & concise reports & records. Developed after employment.