JC-– Data Analytics Developer California State Lottery win

The California State Lottery is looking to fill the exciting role of a Data Analytics Developer!

If this opportunity would be a good fit for you, we encourage you to apply today and join our winning team!

People are drawn to the California State Lottery because we:

• We have a worthy mission that we’re sure you’ll take pride in too.
• Are an energetic, creative, and talented team
• Value diversity and inclusion in the workplace
• Empower team members to bring their knowledge, expertise, and innovation
• Recognize individual and team contributions
• Support the importance of work-life balance
• Invest in the professional development of our team members
• Are dedicated to preserving our environment by lowering our carbon footprint

The California Lottery is a multi-billion-dollar enterprise headquartered in Sacramento. It is one of the few state agencies that is a revenue generator, not accepting taxpayer dollars from the state’s general fund. Our mission is to provide supplemental funding to California schools while simultaneously supporting local communities. Ninety-five cents of every dollar spent by players goes back to local communities in the form of contributions to public schools and colleges, prizes and retailer compensation.

In fiscal year 2023-24, the California Lottery provided over $2 billion in supplemental funding for California public schools, bringing the total contributions to more than $46 billion since we began in 1985. Lottery products are sold at more than 23,000 retail locations throughout the state. Product offerings include an average of 52 fun and entertaining Scratchers games and several draw games such as Powerball, Mega Millions, and Super Lotto Plus and daily games such as Fantasy 5 and Hot Spot.

Under direction of the Information Technology Services Division (ITSD), Data Analytics & Reporting Services (DARS), Information Technology (IT) Manager I, the IT Specialist I serves as a Data Analytics Developer of the California State Lottery’s (Lottery) complex Business Intelligence (BI) and Data Analytics platforms. The incumbent designs, develops, tests, operates, and maintains the BI, Data Analytics, reporting and software systems. Duties encompass researching, designing, documenting, developing, and troubleshooting systems performing data ingestion, storage, processing, transformation, modeling, integration, quality, governance, and visualization.

Responsibilities include participation in defining and maintaining standards, processes, and procedures for the business intelligence and analytics applications and systems. The duties in this position are focused on the Software Engineering, Systems Engineering, and Business Technology Management domains; however, work may be assigned in other domains as needed.

Schedule:

This position supports the Lottery during normal business hours from 8:00 a.m. to 5:00 p.m. unless approved by the unit manager. Weekend, long and/or irregular work hours, after-hours work, and holiday work may be required.

Travel:

Statewide overnight travel may be required.

Other:

This position may be required to carry a Lottery issued cell phone. This position may be required to be reachable outside of normal business hours.

• Experience designing, developing, testing, and maintaining various BI and Data Analytics data processing functions such as: ETL/ELT, pipelines, data cleansing, data migration, data integration and transformations, data loading to warehouses/data lakes/data marts using: T-SQL, Python, MDX, DAX, Azure Data Factory, Azure Synapse Pipelines, SSIS, dedicated SQL pools, SQL Server, and equivalent tools.
• Experience designing, implementing, and maintaining various data models, database designs, data warehouse designs, data lakes, tabular cubes and equivalent data structures and architectures for Business Intelligence (BI) and Data Analytics systems.
• Experience analyzing requirements, designing, and building reports, dashboards, and visualizations in BI and Data Analytics systems using Power BI, SSRS, R, Rstudio, Posit and Posit Connect and equivalent technologies.
• Experience designing, implementing, and…