California State Teachers' Retirement System

Buyer seeks a Senior BI Engineer with detailed knowledge of BI and Data Warehouse implementation. The contractor will implement AI-powered business intelligence solutions and optimize existing BI systems. The role combines expertise in business intelligence, data architecture, and ETL processes. The contractor will incorporate AI capabilities into the Data Analytics Platform using machine learning and advanced analytics techniques.

• 3/31/2025 - Written Question Submittal Due Date
• 4/10/2025 - Proposal Due Date

• Hold a current Information Technology California Multiple Award Schedule agreement
• Ten years Power BI experience with complex DAX and dashboard development
• Ten years experience writing complex SQL queries and designing data models
• Five years programming experience in Python, Java, or R
• Three years experience in Amazon Redshift or Snowflake
• Two years experience with LLMs, Auto-ML tools, or NLP

• Design AI-driven BI platforms integrating data from multiple sources
• Develop BI dashboards with AI-powered features like conversational BI
• Implement data architecture supporting AI/ML capabilities
• Integrate structured and unstructured data for unified architecture
• Develop ETL pipelines and data integration processes
• Incorporate AI-powered BI into CalSTRS's Data Analytics Platform
• Implement data quality assurance practices for accuracy and consistency
• Enforce security protocols for BI and data warehouse systems
• Establish data governance frameworks and standards
• Leverage machine learning algorithms for real-time decision support
• Design AI-enhanced data models for large-scale Data Warehouse systems
• Develop augmented analytics and anomaly detection capabilities
• Integrate streaming data solutions for AI model decision-making
• Create documentation for data architecture and ETL processes
• Transfer knowledge through job-aids and training materials
• Work with architects to develop data strategies and standards
• Analyze requirements with SMEs to create data dictionaries
• Perform analysis and design for data testing/migration
• Develop automated data analysis solutions
• Monitor and audit data access logs and system performance