Senior Data Solution Engineer

Job Posting: Senior Data Solution EngineerState Teachers' Retirement SystemJC-509210 Senior Data Solution EngineerINFORMATION TECHNOLOGY SPECIALIST II$8,625.00 - $11,557.00 per MonthNew to State candidates will be hired into the minimum salary of the classification or minimum of alternate range when applicable.Final Filing Date: 3/11/2026Job Description and DutiesThe 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.The ideal candidate will possess the following skills: 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. 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.Does this opportunity seem right for you? If so, see the Application Instructions section below and apply now.You will find additional information about the job in the Duty Statement (.Working ConditionsCalSTRS offers a hybrid approach including in-office and remote work solutions based on business needs.All staff of CalSTRS are employees of the State of California and subject to California employment taxes and withholdings. Upon appointment, staff are required to provide a current California address to CalSTRS Human Resources to be used as a remote work location.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.Minimum RequirementsYou will find the Minimum Requirements in the Class Specification. INFORMATION TECHNOLOGY SPECIALIST II (Additional Documents Job Application Package Checklist (Duty Statement Position DetailsJob Code #:JC-509210Position #(s):815-626-1414-907Working Title:Senior Data Solution EngineerClassification:INFORMATION TECHNOLOGY SPECIALIST II$8,625.00 - $11,557.00 ANew to State candidates will be hired into the minimum salary of the classification or minimum of alternate range when applicable.# of Positions:1Work Location:Yolo CountyTelework:HybridJob Type:Permanent, Full TimeDepartment InformationCalSTRS: Securing the financial future and sustaining the trust of California’s educatorsCalSTRS 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 .Special RequirementsStatement of Qualifications:(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.ExamThis position requires a current Information Technology Specialist II Exam. If you need to take the exam or if your score has expired,click here (to gain list eligibility.Background InvestigationPrior 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 RequirementsThis position may be subject to disclosure and disqualification requirements concerning economic conflict of interest in government work, including the Conflict of Interest Code (that applies to CalSTRS team members and the Political Reform Act (, 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) (.Application InstructionsCompleted 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:3/11/2026Who May ApplyIndividuals 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.Applications will be screened and only the most qualified applicants will be selected to move forward in the selection process.Applicants must meet the Minimum Qualifications stated in the Classification Specification(s).How To ApplyComplete Application Packages (including your Examination/Employment Application (STD 678) and applicable or required documents) must be submitted to apply for this Job Posting. Application Packages may be submitted electronically through your CalCareer Account at When submitting your application in hard copy, a completed copy of the Application Package listing must be included. If you choose to not apply electronically, a hard copy application package may be submitted through an alternative method listed below:Address for Mailing Application PackagesYou may submit your application and any applicable or required documents to:State Teachers' Retirement SystemN/AAttn:RecruitmentP.O. Box 15275, MS 31Sacramento,CA95851-0275Address for Drop-Off Application PackagesYou may drop off your application and any applicable or required documents at:State Teachers' Retirement SystemN/ACalSTRS, Attn: Recruitment100 Waterfront PlaceWest Sacramento,CA9560508:00 AM-05:00 PMRequired Application Package DocumentsThe following items are required to be submitted with your application. Applicants who do not submit the required items timely may not be considered for this job: Current version of the State Examination/Employment Application STD Form 678 (when not applying electronically), or the Electronic State Employment Application through your Applicant Account at All Experience and Education relating to the Minimum Qualifications listed on the Classification Specification should be included to demonstrate how you meet the Minimum Qualifications for the position. Resume is required and must be included. Statement of Qualifications -A Statement of Qualifications is required. Please see the Special Requirements section of the job posting for detailed instructions. Applicants requiring reasonable accommodations for the hiring interview process must request the necessary accommodations if scheduled for a hiring interview. The request should be made at the time of contact to schedule the interview. Questions regarding reasonable accommodations may be directed to the EEO contact listed on this job posting.BenefitsCalSTRS 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 More than four weeks of vacation/sick leave for leaders More than three weeks of vacation/sick leave for staff Health insurance in retirement Employee Assistance Program Loan forgiveness under the federal Public Service Loan Forgiveness Program (For the latest information on the benefits offered by the state of California, explore theHealth Benefits Summary provided by CalHR (.Contact InformationThe Human Resources Contact is available to answer questions regarding the position or application process.Human Resources Contact:Recruitment(916) 414-4900Please 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.EEO Contact:EEO Officer(916) 414-4933California Relay Service: 1-800-735-2929 (TTY), 1-800-735-2922 (Voice) TTY is a Telecommunications Device for the Deaf, and is reachable only from phones equipped with a TTY Device.Additional Application Instructions Electronic applications through your CalCareer account are highly recommended. If you are unable to apply electronically through your CalCareer account, please mail or drop off a hard copy of your application packet. Please provide the following information on your application:815-626-1414-907, RPA:0459, JC-509210 If education is being used to meet the minimum qualifications, please submit a copy of your transcripts/degree. Training and development (T&D) assignments may be considered for this position. If you are applying as a T&D, please indicate this in the eligibility section of your application. Candidate may be selected by application packet review only. Multiple positions may be filled from this recruitment. Submission of an incomplete STD 678 may result in disqualification. Additional Salary InformationAll 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.Equal Opportunity EmployerThe State of California is an equal opportunity employer to all, regardless of age, ancestry, color, disability (mental and physical), exercising the right to family care and medical leave, gender, gender expression, gender identity, genetic information, marital status, medical condition, military or veteran status, national origin, political affiliation, race, religious creed, sex (includes pregnancy, childbirth, breastfeeding and related medical conditions), and sexual orientation.It is an objective of the State of California to achieve a drug-free work place. Any applicant for state employment will be expected to behave in accordance with this objective because the use of illegal drugs is inconsistent with the law of the State, the rules governing Civil Service, and the special trust placed in public servants.

Created: 2026-03-04