Strsoh
Business Intelligence Analyst 2, Investment Services
Strsoh, Columbus, Ohio, United States, 43224
Business Intelligence Analyst 2, Investment Services page is loaded
Business Intelligence Analyst 2, Investment Services
Apply locations Columbus, Ohio time type Full time posted on Posted 4 Days Ago job requisition id JR100531
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 Ohios educators, STRS Ohio is one of the nations 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: Bachelors 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. About STRS Ohio
STRS Ohio associates are highly talented, customer service-oriented professionals. Interested in current or future opportunities with STRS Ohio? Create an account and complete the online application. We are an equal opportunity employer employment selection and related decisions are made without regard to sex, race, age, disability, religion, national origin, color or any other protected class. Rsums and applications are retained on file for consideration for at least six months from the date of receipt. STRS Ohio is one of the nations leading retirement systems, serving about 500,000 active, inactive and retired Ohio public educators. Operating under the guidelines of Chapter 3307 of the Ohio Revised Code as enacted by the Ohio General Assembly, STRS Ohio is legally separate from and fiscally independent of state and local governments. Click here to learn more about STRS Ohios mission and vision, history, assets and funding, workplace culture and investment in Ohio. #J-18808-Ljbffr
Apply locations Columbus, Ohio time type Full time posted on Posted 4 Days Ago job requisition id JR100531
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 Ohios educators, STRS Ohio is one of the nations 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: Bachelors 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. About STRS Ohio
STRS Ohio associates are highly talented, customer service-oriented professionals. Interested in current or future opportunities with STRS Ohio? Create an account and complete the online application. We are an equal opportunity employer employment selection and related decisions are made without regard to sex, race, age, disability, religion, national origin, color or any other protected class. Rsums and applications are retained on file for consideration for at least six months from the date of receipt. STRS Ohio is one of the nations leading retirement systems, serving about 500,000 active, inactive and retired Ohio public educators. Operating under the guidelines of Chapter 3307 of the Ohio Revised Code as enacted by the Ohio General Assembly, STRS Ohio is legally separate from and fiscally independent of state and local governments. Click here to learn more about STRS Ohios mission and vision, history, assets and funding, workplace culture and investment in Ohio. #J-18808-Ljbffr