California Lottery · 7 hours ago
Senior Business Intelligence Developer
Sacramento, CA
Full-time
Hybrid
Senior LevelThe California State Lottery is a multi-billion-dollar enterprise dedicated to providing supplemental funding to California schools. They are seeking a Senior Business Intelligence Developer to design, develop, and maintain complex data models and dashboards that provide insights into lottery operations and player behavior.
Health Care
No H1B
Hiring Manager
Kathryn Ybarra
Responsibilities
Under general direction of the Information Technology Services Division (ITSD) Data Analytics & Reporting Services (DARS) Information Technology Manager l, the Information Technology Specialist ll serves as the Sr. Business Intelligence (BI) Developer supporting the California State Lottery’s (Lottery) complex Business Intelligence and Business Analytics (BIBA) platforms
The incumbent is responsible for designing, developing, implementing, maintaining and monitoring complex data models, architectures, data reports and dashboards that provide insights into lottery operations, sales, and player behavior
Creating and managing Extract, Transform, Load (ETL) processes to gather data from various sources, preparing it for analysis
Qualification
Required
Current Information Technology Specialist II exam
Strong technical proficiency with BI tools such as Tableau, Power BI, R, Cognos, OBIEE, OAS, or similar
Expertise in SQL, data modeling, performance tuning, and ability to work with large, complex data sets across multiple data sources
Ability to analyze complex data sets, interpret trends, and generate actionable insights to support decision-making processes
Proficiency in programming languages, such as DAX, Python or R, for data analysis and automation tasks
Solid understanding of database management systems, including Oracle, SQL Server, Azure Synapse or other relevant platforms
Extensive experience with ETL (Extract, Transform, Load) processes and tools (Informatica, SSIS, Talend) to manage data workflows effectively
Strong skills in data cleansing transformation logic, error handling, and performance optimization
Strong understanding of the lottery industry and its business processes, enabling effective communication with stakeholders and applicability of the industry to data sets and business requirements
Experience managing BI projects, including requirements gathering, stakeholder engagement, and project execution and coordination
Excellent interpersonal skills with the ability to communicate complex data findings to technical and non-technical stakeholders and work collaboratively in a team environment
Deep knowledge and hands-on experience designing and implementing data warehouse solutions, including dimensional modeling, star/snowflake schemas, indexing strategies, and performance optimization using platforms such as SQL Server, Snowflake, or Azure Synapse
Company
California Lottery
The California Lottery was created by a ballot measure, Proposition 37, which was approved by 58 percent of voters on Nov. 6, 1984.
Founded in 1984
501-1000 employees
Funding
Current Stage
Late StageLeadership Team
Jennifer C.
Chief Information Officer
KayLynn Weathers
Chief Enterprise Risk Officer (Acting)
Recent News
Canada NewsWire
2025-09-26
Company data provided by crunchbase