ETL Analytics Specialist (Database Administration Specialist 1)- 20067121

A Little About Us: With roughly 1,600 employees in 11 offices across Ohio, BWC is the state agency that cares for Ohio workers by promoting a culture of safety at work and at home and ensuring quality medical and pharmacy care is provided to injured workers.

For Ohio employers, we provide insurance policies to cover workplace injuries and safety and wellness services to prevent injuries.

Our Culture: BWC is a dynamic organization that offers career opportunities across many different disciplines. BWC employees strive to maintain an inclusive workplace. We begin by being an equal opportunity employer. Employees can participate in and lead employee resource groups, participate in online forums discussing society’s impact on our services and workplace, and learn about how different perspectives can improve leadership skills.

Our Vision:To transform BWC into an agile organization driven by customer success.

Our Mission:To deliver consistently excellent experiences for each BWC customer every day.

Our Core Values:One Agency, Personal Connection, Innovative Leadership, Relentless Excellence.

BWC is currently operating under a hybrid schedule that can incorporate both teleworking and in-office hours. Employees may be required to report to the office when requested by management &/or for their initial job training.

What You’ll Be Doing: As an ETL Analytics Specialist (Database Administration Specialist 1) you will be providing tier I database support to BWC employees or other IT staff and assisting with data modeling & conducting performance tuning & configuration.

Data Modeling:

  • Assisting with data model design.
  • Implementing physical data models.
  • Assisting with tuning single RBMS system on a single platform.

Data migrations, business process monitoring:

  • Designing & implementing processes for efficient transfer of data.
  • Monitoring data transfer processes.
  • Resolving data conflicts & inappropriate use of data.
  • Providing ETL & data warehouse support.
  • Transferring data to data warehouse, building tables & loading scripts.
  • Writing platform specific code for data migrations.

High Availability:

  • Monitoring cluster parameters for high performance.
  • Resolving problems & issues.

Database Support:

  • Advising & consulting users on accessing various databases & to resolve data conflicts & inappropriate use of data.
  • Promotes system security & awareness by adhering to BWC’s & State of Ohio IT security policy(s) & standards.

Performance Tuning & Configuration:

  • Providing performance tuning for query language statements.
  • Interpreting query plans.
  • Providing monitoring by using vendor supplied & third-party utilities.

For more information about this position, please click here.

What’s in it for you: 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

  • Quality, affordable, and competitive medical benefits are offered through the available Ohio Med plans.

Dental, Vision and Basic Life Insurance

  • Dental, vision, and basic life insurance premiums are free after completed eligibility period . Length of eligibility period is dependent on union representation.

Time Away From Work and Work/Life Balance

  • Paid time off, including vacation, personal, and sick leave.
  • 11 paid holidays per year
  • Childbirth/Adoption leave

Employee Development Funds

  • The State of Ohio offers a variety of educational and professional development funding that varies based on whether you are a union-exempt employee or a union-represented employee.

Ohio Public Employees Retirement System

  • OPERS is the retirement system for State of Ohio employees. The employee contributes 10% of their salary towards their retirement. The employer contributes an amount equal to 14% of the employee’s salary. Visit the OPERS website for more information.

Deferred Compensation

  • The Ohio Deferred Compensation program is a 457(b) voluntary retirement savings plan. Visit the Ohio Deferred Compensation website for more information.

EEO & ADA Statement: The State of Ohio is an Equal Employment Opportunity Employer and prohibits discrimination and harassment of applicants or employees due to protected classes as defined in applicable federal law, state law, and any effective executive order.

The Ohio Bureau of Workers’ Compensation is committed to providing access and reasonable accommodation in its employment opportunities pursuant to the Americans with Disabilities Act and other applicable laws. To request a reasonable accommodation due to disability, please contact ADA Coordinator Kathleen Bourke at 614-644-7811 or by email to: e e odept@bwc.ohio.gov

Qualifications
To Qualify, You Must Clearly Demonstrate:Required Experience and/or Education

  • Completion of undergraduate core program in computer science or information systems AND 12 mos. combined work experience in any combination of the following: database administration providing Tier I support to information system users and/or IT staff, assisting with data modeling and conducting performance tuning and configuration including 12 mos. work experience in the primary technology specified by the agency in the position description & job posting.
  • Or completion of associate core program in computer science or information systems AND 18 mos. combined work experience in any combination of the following: database administration providing Tier I support to information system users and/or IT staff, assisting with data modeling and conducting performance tuning and configuration including 12 mos. work experience in the primary technology specified by the agency in the position description & job posting.
  • Or 36 mos. combined work experience in any combination of the following: database administration providing Tier I support to information system users and/or IT staff, assisting with data modeling and conducting performance tuning and configuration including 12 mos. work experience in the primary technology specified by the agency in the position description & job posting.
  • Or equivalent of minimum class qualifications for employment noted above.

    Note: The official position description on file with the designated agency is to reflect the required, primary technology directly relating to the duties of the position. Only those applicants possessing the experience in the required, primary technology listed in the position description & job posting are to be considered for any vacancies posted. The job posting must list the required technology commensurate with the position in question.

Job Category
Administration and Office
Job Type
Full Time/Permanent
Salary
USD 30.55 - 44.82 per hour
Country
United States
City
Columbus
Career Level
unspecified
Company
Ohio Department of Aging
JOB SOURCE
https://dasstateoh.taleo.net/careersection/oh_ext/jobdetail.ftl?job=2300079O