This job has closed.

Ohio BWC (official) · 2 weeks ago

BI Platform Administrator (Data Administration Manager 1) - 20067153

Columbus, OH

Full-time

Onsite

Entry, Mid Level

$39.22/hr - $55.99/hr

2+ years exp

Ohio BWC is a state agency that promotes workplace safety and provides insurance for workplace injuries. The BI Platform Administrator will work under the Business Intelligence Manager to develop and enforce data administration policies, maintain data sources, and collaborate with technical staff and business stakeholders to optimize data performance and ensure compliance with security protocols.

Employee BenefitsInsuranceTraining

Comp. & Benefits

Responsibilities

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

Qualification

SnowflakeTableauCognosSQLData AdministrationContinuous ImprovementCommunicationAttention to Detail

Required

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

Company

Ohio BWC (official)

BWC helps thousands of injured workers and their employers each year by providing support, resources, and services to ensure workplace safety and recovery.

Founded in 1912

Columbus, Ohio, USA

1001-5000 employees