Data Analytics Specialist

The CalSTRS Enterprise IT Solutions and Innovation Division is seeking a motivated individual to work as an Information Technology Specialist I on the Data Services & Reporting Team.

The Enterprise IT Solutions and Innovation Division provides solutions development and related support services aimed at delivering and optimizing the CalSTRS enterprise-wide, technology-based solutions to the business. This division works in collaboration with the Project Management, Infrastructure and Operations, Enterprise IT Governance and CalSTRS business areas in the delivery of quality solutions that meet or exceed the business needs of CalSTRS. This division manages and provides oversight to Solution Services, START Solutions Development and Web Solutions Development Units.

Under direction of the Data Services & Reporting Supervisor, the Information Technology Specialist I (ITS I) will act as the Data Analytics Specialist and perform various data analytics design and development, production support, troubleshooting, and other hands-on data delivery tasks.

The Data Analytics Specialist develops solutions to implement business intelligence use cases to engage, collaborate, and deliver data analytic assignments and production support to add business value to users and members. The incumbent will develop business intelligence and data warehouse solutions by leveraging cloud managed services for deployment to the CalSTRS Analytic Platform., Interested individuals must submit a Statement of Qualifications (SOQ) in addition to the standard state application (form STD 678). Your SOQ will be considered the first interview for this position. If your qualifications are competitive, you will be invited to an interview. When completing the SOQ, please include all relevant experience, education, and training, as applicable, and explain all answers thoroughly. Your SOQ should not exceed two pages, single-spaced, 12-point font and address the following questions:

1. Explain your experience performing advanced analytics and developing enterprise BI solutions as described in the duty statement.

2. Describe your background with data architecture, ETL processes, and SQL optimization.

Exam

This position requires a current Information Technology Specialist I examination. If you need to take the examination or if your score has expired,click here (https://calcareers.ca.gov/CalHrPublic/Exams/ExamBulletin.aspx?ExamControlId=1750) to gain list eligibility.

CalSTRS Personal Trading Program

Investment Branch employees are required to participate in the CalSTRS Personal Trading Program which allows CalSTRS to monitor employees' personal trading transactions in order to reduce risks associated with insider trading, front running, and misusing material non-public information. Upon accepting a position within the Investment Branch, you will be required to disclose your personal broker account information and be required to utilize a personal broker from a designated list as provided by CalSTRS.

Background Investigation

Prior to employment with CalSTRS, a background investigation (BI) will be conducted. The BI consists of a Personal History Statement and fingerprinting through the Department of Justice. The BI will check criminal and civil records and, if applicable, verify education and check driving records.

CalSTRS Disclosure Requirements

This position may be subject to disclosure and disqualification requirements concerning economic conflict of interest in government work, including the Conflict of Interest Code (https://www.calstrs.com/files/7e818a3e7/ConflictofInterestCode.pdf) that applies to CalSTRS team members and the Political Reform Act (https://www.fppc.ca.gov/the-law/the-political-reform-act.html) , which require disclosure of certain investment information and use of a designated trading platform for securities transactions, as well as filing a Statement of Economic Interest (Form 700) (http://www.fppc.ca.gov/Form700.html) .

Incompatible Activities

This position is subject to the provisions of Government Code Section 19990 (https://leginfo.legislature.ca.gov/faces/codes_displaySection.xhtml?lawCode=GOV§ionNum=19990.) . Upon accepting a position at CalSTRS, you will also be required to comply with the CalSTRS Incompatible Activities Policy by ensuring that outside work or activities are compatible and align with your professional activities or workplace obligations.

Application Instructions

Completed applications and all required documents must be received or postmarked by the Final Filing Date in order to be considered. Dates printed on Mobile Bar Codes, such as the Quick Response (QR) Codes available at the USPS, are not considered Postmark dates for the purpose of determining timely filing of an application.

Final Filing Date:7/2/2026

Who May Apply

Individuals who are currently in the classification, eligible for lateral transfer, eligible for reinstatement, have list or LEAP eligibility, are in the process of obtaining list eligibility, or have SROA and/or Surplus eligibility (please attach your letter, if available). SROA and Surplus candidates are given priority; therefore, individuals with other eligibility may be considered in the event no SROA or Surplus candidates apply., Please direct requests for Reasonable Accommodations to the interview scheduler at the time the interview is being scheduled. You may direct any additional questions regarding Reasonable Accommodations or Equal Employment Opportunity for this position(s) to the Department's EEO Office.

• Ability to communicate analytical concepts to diverse audiences

• Strong documentation and technical writing skills

• Experience collaborating in cross functional enterprise teams

• Strong organizational and time management skills

• Experience with Power BI or Tableau

• Experience with ETL, and Database Development Date Modeling and Warehousing

• Experience with Azure, AWS, and Google Cloud, This position is not eligible for visa sponsorship. Applicants must be authorized to work in the US without the need for visa sponsorship by the start date of employment with CalSTRS.

Every 12 months, based on performance evaluation, employees may receive a 5% salary increase until they reach the maximum salary for the position.

In July 2025, the State of California implemented the Personal Leave Program 2025. This program reduces employees' monthly base pay in exchange for paid leave credits. This position is subject to PLP 2025 and will have a monthly base pay reduction of 3% in exchange for 5 hours of leave credits for the duration of the program. The salary ranges shown on this job posting do not reflect the reduced amounts., CalSTRS offers a hybrid approach including in-office and remote work solutions based on business needs., CalSTRS offers a competitive pay schedule and a work-life-balance for all itsemployees. The State of California provides comprehensive benefits packages determined by the employee's bargaining unit and conditions of employment. Some benefits include:

• Alternative work schedules

• Flexible work hours

• Remote work options

• Medical benefits, including health, dental and vision insurance

• Paid holidays and a defined benefit retirement program

CalSTRS is the largest educator-only pension fund in the world, providing retirement, disability and survivor benefits to California's more than 1 million public school educators and their families. Named as one of the best places to work in money management ten times by Pensions & Investments magazine, we are a world-class financial services institution with a commitment to sustainability and wellness. Our two U.S. Green Building LEED Platinum-certified headquarters buildings in West Sacramento, California, feature sustainable construction, abundant natural lighting, an organic garden, sustainable beekeeping and ergonomic functionally designed workspaces. We offer a variety of on-site amenities to our team members, including two full-service cafés, two free fitness centers, a bicycle rental library and a child care center with a covered playground. Team members enjoy walks along the Sacramento River and nearby seasonal farmers markets. In addition to our state-of-the-art amenities, we offer thriving wellness and sustainability programs, an award-winning employee recognition program, and ongoing training, learning and development opportunities. We offer competitive benefits, flexible work hours and hybrid work options. We are committed to creating a workplace where our team members thrive. If you're looking for a rewarding career and are interested in becoming part of a diverse and inclusive workforce where talent, expertise and wellness are valued, we encourage you to find out more about our many career options at **CalSTRS.com/Careers** **.**