Business Intelligence Analyst 2, Investment Services

STRS Ohio, STRS

The State Teachers Retirement System of Ohio (STRS Ohio) is seeking a Business Intelligence Analyst 2, Investment Services to join the EX/ITS Investment Services team.

Established in 1920 and serving Ohio’s educators, STRS Ohio is one of the nation’s premier retirement systems, serving over 500,000 active, inactive, and retired public-school teachers, and university faculty members, managing approximately $90.1 billion 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: 

$96,411 - $115,693

Work Schedule:

8:00am-5:00pm Monday through Friday (Onsite)

General Summary:

Under the direction of the supervisor, Business Systems Analysis, design, develop, enhance, implement and   provide support for business intelligence solutions, with primary focus on user delivery and consumption of data.

Summary of Responsibilities:

• Work closely with users and business support teams to define requirements for business intelligence (BI) solutions. Add to and enhance standards as appropriate.

• Build new data flows and models based on high-level requirements.

• Develop BI solutions using Microsoft technologies, including PowerBI, SSAS and SSRS.

• Develop and monitor daily and intra-day ETL (Extract, Transform, Load) jobs and resolve production issues.

• Develop queries against normalized and dimensional models to answer complex business questions or data issues.

The above list of duties in intended to describe the general nature and level of work performed by persons assigned to this classification. It is not to be construed as an exhaustive list of duties performed by the persons so classified, nor is it intended to limit or modify the right of any supervisor to assign, direct and control the work of associates under supervision.

Summary of Qualifications:

• Bachelor’s degree required.

• Three to five years programming experience preferred.

• Three to five years of relevant IT-related experience preferred, specifically focused on data analysis.

• Understanding of relevant areas of accounting and investments industry preferred.

• Experience with the following is preferred:

  • Microsoft database technologies

  • Microsoft BI stack

  • R

  • Python

  • Matlab

• Strong ability to interpret and understand normalized and de-normalized databases, as well as operational data warehouses.

• Excellent work record of attendance, punctuality and the ability to maintain a flexible work schedule to meet business needs. Occasional evening, weekend and non-regular work hours may be required.

Equal Employment Opportunity Employer Statement

State Teachers Retirement System of Ohio (STRS) is an Equal Employment Opportunity Employer and prohibits discrimination and harassment of applicants or employees on the basis of race, color, religion, gender, gender identity or expression, national origin (ancestry), military status, disability, age, genetic information, sexual orientation, or caregiver status, in making employment-related decisions about an individual.

ADA Statement

STRS Ohio is committed to ensuring access, inclusion, and reasonable accommodations across all its services, activities, programs, and employment opportunities in accordance with the Americans with Disabilities Act (ADA) and other applicable laws.