Business Intelligence Analyst 1

State Teachers Retirement System of Ohio•Columbus, OH

3d•Onsite

About The Position

STRS Ohio, STRS The State Teachers Retirement System of Ohio (STRS Ohio) is seeking a Business Intelligence Analyst 1, Investment Services to join the Information Technology Services/Data & Digital Solutions team. Established in 1920 and serving Ohio’s educators, STRS Ohio is one of the nation’s largest retirement systems, serving over 500,000 active, inactive, and retired public-school teachers, and university faculty members, managing approximately $96.9 billion as of June 30, 2024, in assets and paying more than $7 billion in benefits annually. STRS Ohio provides a competitive pay, and a comprehensive benefits package including on-site parking, educational assistance, subsidized medical insurance, fully paid dental and life insurance, vacation and sick leave, retirement benefits and on-site fitness center. At STRS Ohio, you can experience rewarding work in a professional, business casual work environment. We welcome, celebrate, and promote respect for everyone. We are continually seeking bright and talented individuals to join our team. Compensation: $83,835-$100,602 Work Schedule: 8:00am-5:00pm Monday through Friday (Onsite) General Summary: Under the direction of the manager, Business Intelligence (BI), design, develop, enhance, implement and provide support for business intelligence solutions, with primary focus on enterprise BI platforms, data visualization tools and low-code/no-code platform technologies.

Requirements

High school diploma or equivalent and three to five years programming experience required.
Ability to interpret and understand normalized and de-normalized databases, as well as operational data warehouses required.
Basic knowledge of AI/ML concepts and their potential applications in business intelligence.

Nice To Haves

Bachelor’s degree in computer science preferred.
One year of relevant IT-related experience preferred, specifically focused on structured query language (SQL) preferred.
Experience with one or more of the following technologies: relational database systems; enterprise BI platforms; low-code/no-code platforms; data visualization tools; R; Python; basic knowledge of AI/ML concepts required.

Responsibilities

Develop Extract, Transform, Load (ETL) / Extract, Load, Transform (ELT) packages, queries, and low-code platform solutions based on information provided by other team members.
Work closely with the manager and other team members to ensure data conforms to current structures and is compatible with future technical architecture direction.
Develop BI solutions using enterprise platforms, including data visualization tools, low-code applications, workflow automation, and reporting services.
Participate in requirements gathering, documentation, testing and production implementation of new and existing ETL processes and data solutions.
Develop queries against normalized and dimensional models to answer complex business questions or data issues.
Assist in exploring and implementing emerging technologies including Artificial Intelligence (AI) and Machine Learning (ML) capabilities.