Business Intelligence Developer

We are looking for an experienced Business Intelligence (BI) Developer with detailed knowledge
and experience of functional and technical design and development in Business Intelligence and
Data Warehouse (BI&DW) tools, and Machine Learning/Artificial Intelligence (ML/AI)
frameworks, standards, processes, and architectures to work within the BI&DW Project team of
Technology Service Branch.

Required Qualifications
1. At least 1 year of hands-on experience in using Generative AI to successfully deliver data
analytics solutions.
2. At least 5 years of hands-on experience of designing and developing data analytics, and
Business Intelligence dashboards with Microsoft (MS) Power BI.
3. At least 5 years of experience of creating Structural Query Language (SQL) queries,
optimizing SQL query performance, and modifying SQL elements such as procedure, functions,
and views with a solid understanding of database principles.
4. At least 3 years of experience of developing data solutions with Snowflake or Amazon Web
Services (AWS) Redshift data warehouses.

Desirable Technical Qualifications:

1. Bachelor s degree or equivalent experience in Computer Science, Information Technology, or
similar field of study.
2. At least five years of experience with Agile methodologies and Software Development Life
Cycle.
3. At least five years of experience with MS Power BI Data Analysis Expressions (DAX) to
create queries, measures, and data models.
4. At least 3 years of experience in State agency or Financials or Investment portfolios or other
regulated industry highly preferred.
5. Ability to use business knowledge and expertise to build analytical data models and reports
that can serve business users.
6. The proposed project person will be able to adhere to the hybrid working model by working
on-site 2-3 days per week at West Sacramento, CA.