Lead Developer Security Clearance
Job in
West Sacramento, Yolo County, California, 95605, USA
Listed on 2026-08-25
Listing for:
22nd Century Technologies, Inc.
Full Time
position Listed on 2026-08-25
Job specializations:
-
IT/Tech
Data Engineering, Data Analyst, AI Engineer (Applied/Software)
Job Description & How to Apply Below
BACKGROUND The CalSTRS Technology Services (TS) Branch supports approximately 1,700 employees and contractors at the headquarters and seven Member Service Centers (MSC) throughout the State of California. The CalSTRS Technology Services (TS) Branch delivers technology products, services, and business solutions which support all information technology systems throughout the organization including implementation of enterprise projects. TS programs and projects utilize the System Development Life Cycle (SDLC) methodology and Agile Development guidelines.
The goal of this engagement is to construct a team of technical resources, with all the necessary skillsets collectively, for maintaining and advancing CalSTRS' IDW platform with GenBI/ AI/ML capabilities, as well as designing/building additional GenBI solutions or use cases that will be deployed onto the IDW platform. Minimum Technical Qualifications
* At least ten (10) years of experience in data/BI engineering or analytics.
* At least five (5) years of experience in leading a team (at least 3 members) to implement enterprise-level BI and/or large data warehouse solutions.
* At least five (5) years of experience working with AI/ML or GenAI technologies.
* At least two (2) proven deliveries of production-grade BI or data products (dashboards, data models, APIs).
* At least two (2) years of experience with ETL/ELT pipelines, data warehousing platforms such as Snowflake, Amazon Redshift, and orchestration tools (Airflow, dbt, etc.).
* At least two (2) years of experience using OpenAI APIs or similar LLM platforms, building natural language to SQL/query systems, designing prompt strategies for business insights and analytics, and prompt engineering to guide the platform's system behavior.
* At least two (2) years of experience in SQL (advanced joins, window functions, performance tuning), data modeling (star/snowflake schemas, semantic layers), and hands-on experience with at least one major BI tool such as Power BI, Tableau, Looker.
* At least two (2) years of experience leading a team of analysts and developers, as well as collaborating with stakeholders, to Client, document, and implement requirements and stakeholder requests for data warehouse or business intelligence projects. Desirable Technical Qualifications
* Holding technical certifications in the areas of:
* AWS certifications
* Snowflake certifications
* BI certifications (Power BI, Tableau)
* AI/ML or GenAI-related coursework or credentials
* Have 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 the diploma/degree.
* The proposed onsite project person will be able to adhere to the hybrid working model by working on-site 2 to 3 business days per week at CalSTRS Headquarters, West Sacramento, CA. (no points) Description of Services The Tech-Team will be primarily managed by and work directly with the CalSTRS Investment Data Solutions division daily. Collectively, this Tech-Team is expected to provide full-stack development coverage, as well as the ongoing support to maintenance and operations (M&O) of the IDW and use cases deployed on it.
The scope of key responsibilities and activities include but is not limited to the following:
Full-Stack Development with GenBI/GenAI and AI/ML, and Ongoing M&O
* Effectively apply User Interface (UI)/ User Experience (UX) design principles for designing and building analytics dashboards with technologies such as Chainlit, Streamlit, and React.
* Create interactive reporting and storytelling based on data visualization best practices, and human centered design.
* Leverage Out-of-Box (OOB) services/functions/APIs (e.g., calling SNOWFLAKE.CORTEX functions via SQL or configuring AWS Bedrock Knowledge Bases) to accelerate the design and implementation of use cases.
* Build automated tests to ensure the platform's Text-to-SQL engine isn't hallucinating incorrect numbers.
* Perform continuous prompt engineering to guide and finetune the platform's system behavior.
* Execute statistical analysis, predictive analytics, optimization;…
To View & Apply for jobs on this site that accept applications from your location or country, tap the button below to make a Search.
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
Search for further Jobs Here:
×