Overview
Skills
Job Details
Below is the requirement.
Minimum Technical Qualifications
1. At least ten (10) years of hands-on experience with Power BI to write complex DAX
calculations, develop interactive dashboards, and implement best practices for data
visualization.
2. At least ten (10) years of experience in writing complex SQL queries, SQL performance
turning, creating E-R diagrams, and designing efficient data models for large-scale Data
Warehouse systems.
3. At least five (5) years of programming experience in Python, Java, or R for data
processing, automation, and working with large datasets.
4. At least three (3) years of experience in Amazon Redshift or Snowflake for scalable BI
solutions
5. At least two (2) year hands-on experience with LLMs (GPT, Claude, Gemini), Auto-ML
tools, or NLP for generative AI use cases, predictive analysis, or data forecasting.
Desirable Technical Qualifications
It is desirable for the proposed project person to have the following listed experience,
knowledge, skills and abilities as evidenced by Attachment II, Proposed Project Person Skill
Summary Sheet and resume:
1. Hands-on experience of providing enterprise level data architecture and/or data modeling
services at a public sector entity such as local, State or Federal agency.
2. Hands-on experience in developing ETL pipelines with AWS ETL tools such as AWS
Glue, AWS Step functions, and AWS Crawlers.
3. AWS professional certifications. CalSTRS may request a copy of the certifications.
4. A bachelor s degree in computer science, computer engineering, or related fields from an
accredited or government-sanctioned college/university. CalSTRS may request a copy of
degree.
5. The proposed project person will be able to adhere to the hybrid working model by
working on-site 2-3 days per week at CalSTRS Headquarters, West Sacramento, CA. If
no, provide a short explanation. (no points)