Senior Data Solution Engineer

The CalSTRS** Enterprise IT Solutions & Innovation Division is seeking an experienced individual to work as **a Senior Data Solution Engineer on the Data Solutions Services 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 oversights to Data Solution Services, Web Solution Development, Solution Services, START Solutions Development, and System and Production Services.

Under the general direction of the Manager of Data Solution Services (IT Manager I), the Information Technology Specialist II, in collaboration with Business Intelligence & Data Analytics team, operates as the Senior Data Solution Engineer. This position is pivotal for the administration and operation of databases and data warehouses. The incumbent performs a wide variety of tasks requiring innovative problem-solving where guidance is not readily available, such as data transformation, designing and developing data warehousing solutions, executing data science tasks, developing cloud applications, implementing DevOps practices, and integrating systems within the CalSTRS cloud ecosystem. The incumbent will collaborate closely with architects, business analysts, developers, testers, infrastructure engineers, and other IT personnel to ensure seamless operation and innovation., (SOQ) is REQUIRED and MUST be submitted with your application to be considered for this position. The SOQ serves as documentation of each applicant's ability to present information clearly and concisely in writing. Each question must be numbered and addressed in the same order as the questions below. The SOQ must be typed, no more than two pages in length, and 12-point Arial font.

1. Describe your experience designing, building, and administering a data warehouse using SQL Server, Oracle, Amazon Redshift, or Snowflake. Include key design decisions, security measures, and measurable outcomes (e.g., performance improvements, cost optimization).

2. Describe a project where you designed, built, and operated a cloud ETL pipeline across Dev/Testing/Prod involving SQL Server, Amazon Redshift or Snowflake, and Power BI. Include the tools and services used, security/IAM integration, and measurable results.

3. Please describe your experience administering databases or data warehouse systems, including after hours work and frequency you have performed for database deployment, database upgrades or security patches. In your response, please also list any database or data warehouse related certifications you possess or are currently pursuing.

Exam

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

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) .

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:6/4/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.

• 5+ years of experience in data warehouse design, development, and administration, managing environments such as SQL Server, Amazon Redshift, or Snowflake.

• Expert in performance tuning, backup and recovery, disaster recovery planning, and security measures (data masking, row-level security, encryption).

• 4+ years of experience in cloud architecture and ETL development, designing and deploying solutions on AWS/Azure clouds.

• Advanced skills in implementing ETL/ELT pipelines (AWS Glue, Azure Data Factory) and managing CI/CD pipelines and DevOps practices.

• 3+ years of experience in data analytics, writing and optimizing SQL queries, building dashboards with Power BI, and using Python (pandas, NumPy, scikit-learn) for data preprocessing, feature engineering, and predictive modeling.

• 1+ years of experience in AI/ML and prompt engineering, working with large language models (LLMs), designing prompts, integrating AI/ML solutions into data pipelines, and applying responsible AI practices (bias monitoring, ethical compliance).

• 3+ years of experience in technical leadership and problem-solving, leading complex projects, mentoring technical team members, translating business requirements into scalable technical solutions, and communicating effectively with stakeholders., 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, All civil service positions have salary ranges with minimum and maximum pay rates. Typically, employees who are new to civil service are appointed at the minimum rate of the salary range for the position. Special provisions for appointments above the minimum exist to meet special recruitment needs and to accommodate employees who transfer into a position from another civil service position and are already receiving salaries above the minimum.

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** **.**