BI Platform Administrator; Data Administration Manager

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 Data Ohio Portal BI initiatives.

• 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.

  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.)