Lead Data Warehouse & GenAI Solutions Architect

V Group Inc.

West Sacramento (CA)

Hybrid

USD 120,000 - 180,000

Full time

2 days ago

Be an early applicant

Get more replies from employers

Send a job-specific resume in minutes.

Job summary

CalSTRS is seeking a Lead Developer to modernize and enhance its Investment Data Warehouse (IDW) platform while driving GenBI, AI/ML, and Generative AI initiatives. The role leads enterprise data warehousing initiatives, AI-powered analytics, semantic models, and cloud-based data engineering on AWS/Snowflake.

You will steer technical design reviews, CI/CD, and governance, collaborating with stakeholders across analytics, architecture, and IT teams.

Qualifications

At least 10 years of experience in data/BI engineering or analytics.
At least 5 years leading a team (3+ members) to implement enterprise BI or large data warehouse solutions.
At least 5 years experience working with AI/ML or GenAI technologies.
At least 2 proven deliveries of production-grade BI or data products (dashboards, data models, APIs).
At least 2 years with ETL/ELT pipelines, data warehousing platforms such as Snowflake, Redshift, and orchestration tools (Airflow, dbt, etc.).
At least 2 years of experience using OpenAI APIs or similar LLM platforms, building NL-to-SQL/query systems, and prompt engineering.
At least 2 years of experience in SQL (advanced joins, window functions), data modeling (star/snowflake), and hands-on with Power BI, Tableau, Looker
At least 2 years leading a team of analysts and developers, and collaborating with stakeholders.

Responsibilities

Lead development and enhancement of the Investment Data Warehouse platform.
Design and implement GenBI, AI/ML, and Generative AI use cases.
Develop natural language-to-SQL and AI-assisted analytics solutions.
Design semantic models and dimensional data models.
Develop dashboards and reporting solutions using BI platforms.
Implement prompt engineering strategies and optimize AI model behavior.
Collaborate closely with business stakeholders, data analysts, architects, and technical teams.
Lead technical design reviews, code reviews, and best-practice adoption.
Support CI/CD, monitoring, logging, and cloud infrastructure automation.
Provide knowledge transfer to CalSTRS staff and technical teams.
Ensure compliance with AI governance, security, and data privacy standards.