Senior BI Developer (Software Development Specialist 3)- 20083383

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

What You'll Be Doing:

Receives general direction from the Business Intelligence Manager & possesses a thorough technical working knowledge to assure requirements are defined & approved, performing code reviews & ensuring BWC's application development standards are met.

• Serving as a senior technical resource for team engaged in analysis, design, development, testing, documentation, implementation, integration, scheduling, troubleshooting, support & maintenance of custom business intelligence programs, scripts, & jobs (e.g. reporting, dashboards, process automation, data query, exchange, interface, & transformation) in support of business intelligence tasks & activities (e.g. visualization, statistical analysis, machine learning, simulation, inference).
• Reading, writing, extracting & reporting from data sources (e.g. databases, transaction files, & real time data streams) using software development tools (e.g. SQL, Tableau, Cognos, Python).
• Participating in code reviews.
• Leading testing efforts (e.g. create detailed test designs & test plans, create & review test data, coordinate execution of test scripts, coordinate debugging efforts & defect tracking, coordinate support of user acceptance testing, coordinate software implementation & deployment tasks, performs performance & load testing).
• Managing & monitoring BI applications to ensure optimal performance, security, & updates.
• Collaborating with business area personnel to assure requirements are thoroughly defined & approved.
• Performing impact analyses to identify interdependencies.
• Assisting with design reviews & workload requirements estimation.
• Obtaining or imparting information from/to business customers & technical staff through discussions (e.g. data structures, data warehouse tools, business intelligence techniques).

For more information about this position, please click here.

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
• Free Dental, Vision and Basic Life Insurance premiums after completion of eligibility period
• Paid time off, including vacation, personal, sick leave and 11 paid holidays per year
• Childbirth, Adoption, and Foster Care leave
• Education and Development Opportunities (Employee Development Funds, Public Service Loan Forgiveness, and more)
• Public Retirement Systems ( such as OPERS, STRS, SERS, and HPRS ) & Optional Deferred Compensation ( Ohio Deferred Compensation )

*Benefits eligibility is dependent on a number of factors. The Agency Contact listed above will be able to provide specific benefits information for this position.

Qualifications

To Qualify, You Must Clearly Demonstrate:

Required Experience and/or Education

• 60 mos. combined work experience in any combination of the following: assuring requirements are defined and approved, performing code reviews and ensuring application development standards are met including 12 mos. work experience in the Business Intelligence and Data Analytics as specified by the agency position description & job posting.
• Or completion of associate core program in computer science or information systems AND 42 mos. combined work experience in any combination of the following: assuring requirements are defined and approved, performing code reviews and ensuring application development standards are met including 12 mos. work experience in Business Intelligence and Data Analytics as specified by the agency position description & job posting.
• Or completion of undergraduate core program in computer science or information systems AND 36 mos. combined work experience in any combination of the following: assuring requirements are defined and approved, performing code reviews and ensuring application development standards are met including 12 mos. work experience in Business Intelligence and Data Analytics as specified by the agency 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 (Business Intelligence and Data Analytics) 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 Skills: Software Development/Implementation, Data Analytics, Data Visualization
  
  Professional Skills: Critical Thinking, Attention to Detail, Interpreting Data, Problem Solving, Analyzation
  
  Primary Technology: Business Intelligence and Data Analytics

Major Worker Characteristics:

Knowledge of computer & electronics, oral & written communication tools & techniques, customer support & personal service, state & Ohio Bureau of Workers' Compensation (BWC) policy, procedures & applicable laws*, vision, mission & goals of BWC*, software development principles & methods for design, development, testing & implementation of new or modified software, SQL,Tableau, Cognos, Snowflake, Python, Streamlit, statistical analysis, mathematical principles relative to business intelligence, data analytics, & machine learning, IT principles, methods, & practices, standard software validation tools, technical writing & documentation practices, team leadership, requirements analysis principles & methods, interrelationships of multiple IT specialties; IT lifecycle concepts, statistical analysis, employee development, Snowflake, data modeling, cloud development & implementation environments.

Skill for reading comprehension, effective communication, service orientation, troubleshooting, critical thinking, complex problem solving, lead work, programming software analysis & evaluation, judgment & decision making, assuring quality, & identifying & specifying business requirements.

Ability to stay abreast of current technologies in business intelligence & software development, deal with problems involving several variables in familiar context, define problems, collect data, establish facts & draw valid conclusions, use proper research methods in gathering data, prepare meaningful, accurate & concise reports, use statistical analysis.

(*) Developed after employment.