Senior Business, Data and Software Analyst

California Lottery; Sacramento (CA); Hybrid; USD 96,000 - 129,000; Full time

Benefits offered by this job

Onsite restaurant

Free gym

Electric car charging stations

Free parking

Job summary

The California Lottery is seeking a Senior Business, Data and Software Analyst to lead data analytics and reporting initiatives within the IT Services Division. You will oversee daily business and technical activities and collaborate with stakeholders to deliver critical insights and solutions.

The position offers a hybrid work arrangement in Sacramento County and requires expertise in BI tools, SQL, Azure and cloud data analytics in a fast-paced environment.

Qualifications

• Experience with Business Intelligence and Data Analytics tools and practices.
• Experience with SQL, Azure, Synapse, Python and Power BI.
• Ability to communicate clearly with technical and non-technical stakeholders.
• Experience leading data analytics on a BI or cloud-based project.
• Ability to work independently or in a team with minimal supervision.

Responsibilities

• Lead data analytics and reporting initiatives for Lottery's IT projects.
• Provide leadership for daily business and technical activities.
• Collaborate with stakeholders to define requirements and deliverables.
• Support training and development assignments.

Skills

Communication

Data analytics

BI tools

SQL

Azure

Synapse

Python

Power BI

SharePoint

SSMS

ServiceNow

Tools

SQL

Azure

Synapse

Python

Power BI

Visual Studio

SharePoint

SSMS

ServiceNow

Job description

Job Description And Duties

Under general direction of the Information Technology Services Division (ITSD), Data Analytics & Reporting Services Information Technology (IT) Manager I, the Senior Business, Data and Software Analyst, is responsible for providing leadership and direction for daily California State Lottery (Lottery) business and technical activities. The duties for this position are focused in the Software Engineering and IT Project Management domains; however, work may be assigned in other domains as needed.

People Are Drawn To The Lottery Because We:

• 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

May consider a Training & Development assignment.

All Experience and Education relating to the Minimum Qualifications listed on the Classification Specification should be included to clearly demonstrate how you meet the Minimum Qualifications for the position on your State Application (STD Form 678). The application should also clearly demonstrate the candidate’s ability to meet the Desirable Qualifications identified in this job advertisement. The Classification Specification is located on this Job Announcement Posting under "Minimum Requirements."

Effective July 1, 2025, specific Bargaining Units and associated Excluded State employees are subject to a salary reduction between 2% - 4.62% in exchange for hours for Personal Leave hours each month. For more details, please click here to visit the California Department of Human Resources (CalHR) website.

The Lottery is less than 30 minutes from all that Downtown Sacramento has to offer. Amenities include an onsite restaurant, free gym, close to the light rail station, electric car charging stations, and free parking!! Apply today to join a dynamic organization that is not only passionate about its mission, but also its people!!

You will find additional information about the job in the Duty Statement.

Working Conditions

The Senior Business, Data and Software Analyst will work in a fast-paced environment, with competing priorities, and critical deliverables.

• Schedule: This position supports the Lottery during normal work hours from 8:00 a.m. to 5:00 p.m. unless otherwise approved by the unit manager. Weekends, long and/or irregular 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.

Minimum Requirements

You will find the Minimum Requirements in the Class Specification.

• INFORMATION TECHNOLOGY SPECIALIST II

Additional Documents

• Job Application Package Checklist
• Duty Statement

Position Details

Job Code #: JC-533647

Position #(s): 358-516-1414-002

Working Title: Senior Business, Data and Software Analyst

Classification: INFORMATION TECHNOLOGY SPECIALIST II

$8,625.00 - $11,557.00 A

New to State candidates will be hired into the minimum salary of the classification or minimum of alternate range when applicable.

# of Positions: 1

Work Location: Sacramento County

Telework: Hybrid

Job Type: Permanent, Full Time

Department Information

The California Lottery is a multi-billion-dollar enterprise headquartered in Sacramento. It is one of the few state organizations that is a revenue generator, not accepting taxpayer dollars from the state’s general fund. Our mission is to provide supplemental funding for California’s public schools and colleges. We are passionate about creating a better tomorrow - one child at a time. The mix of talented people within our workplace reflects the rich diversity inherent within the State of California. We celebrate the contributions of each individual and strive to create a work environment that is inclusive, collaborative, and welcoming. We believe in California For All.

In fiscal year 2024-25, the California Lottery generated sales of more than $9.2 billion with approximately $1.9 billion earned for California public schools. Lottery products are sold at more than 23,000 retail locations throughout the state, from independent neighborhood shops to convenience stores, liquor stores to supermarkets, and more. Retail product offerings include an average of 52 fun and entertaining Scratchers® games and several draw games, including jackpot games such as Powerball®, Mega Millions®, and SuperLotto Plus® and daily games such as Fantasy 5 and Hot Spot®.

Department Website: http://www.calottery.com

Special Requirements

• The California State Lottery Act provides that no person may be hired as an employee of the Commission if that person has been convicted of a felony or any gambling related offense.
• The position requires a Background Investigation be cleared prior to being hired.
• If you are basing your eligibility on education, (http://www.calhr.ca.gov/state-hr-professionals/pages/job-descriptions.aspx), provide your transcripts and/or diploma. Applicants with foreign transcripts must provide a transcript evaluation that indicates the number of units to which the foreign course work is equivalent. Transcripts and evaluations may be unofficial; official transcripts will be required upon appointment. Please redact birthdates and social security numbers.

Who May Apply

Individuals who are currently in the classification, eligible for lateral transfer, eligible for reinstatement, have list or LEAP eligibility, are in the process of obtaining list eligibility, or have SROA and/or Surplus eligibility (please attach your letter, if available). SROA and Surplus candidates are given priority; therefore, individuals with other eligibility may be considered in the event no SROA or Surplus candidates apply.

Desirable Qualifications

• Excellent written and verbal communication skills, experience facilitating meetings, briefings and presentations to all levels of the organization as well as strong interpersonal and customer service skills with the ability to adjust to changing priorities and quickly respond to urgent matters.
• Expert knowledge of Data Analyst methodologies, principles, and practices including planning, requirements analysis, statements of work, and risk management.
• Experience performing critical analysis of complex business problems, data extraction, troubleshooting data anomalies, and presenting findings to key stakeholders and technical staff.
• Experience with Business Intelligence & Data Analytics tools, SQL, Azure, Synapse, Python, Power BI, Visual Studio, Vizio, SharePoint, SQL Server Management Studio, ServiceNow.
• Experience in the development and implementation of policies, procedures, standards, and processes.
• Experience as a lead data analyst on a Business Intelligence or Cloud-based application development team that utilized Microsoft or similar application development products.
• Ability to convey and explain complex problems and solutions to a technical and non-technical audience.
• Experience with establishing and maintaining collaborative relationships.
• Ability to multi-task, prioritize and work independently or as a member of a team with minimum supervision.
• Ability to work independently as a high-level technical specialist and conduct business activities in a professional manner.

Benefits

Benefit information can be found on the CalHR website and the CalPERS website.

Contact Information

The Human Resources Contact is available to answer questions regarding the position or application process.

Human Resources Contact

Human Resources, JC 533647

[phone]

[e-mail]

EEO Contact

Equal Employment Opportunity Office

[phone]

[e-mail]

California Relay Service: 1-800-735-2929 (TTY), 1-800-735-2922 (Voice) TTY is a Telecommunications Device for the Deaf, and is reachable only from phones equipped with a TTY Device.

Statement Of Qualifications

A Statement of Qualifications (SOQ) is a narrative discussion of how your education, training, experience, knowledge, skills, and abilities meet the minimum qualifications for this position. The SOQ serves as a document of the candidate's ability to present information clearly and concisely in writing and should be typed, no more than 2 pages in length, and in 10-point font or above. Resumes and Cover Letters do not take the place of the SOQ. The SOQ should specifically address each of the questions in the order they are presented. Applicants who fail to submit the SOQ or who do not follow the instructions of the SOQ will not be considered.

• Describe how your background, experience, education, and/or training with Business Intelligence and Data Analytics qualifies you for this position.
• Provide an example of your data analysis skills that describes your ability to model, collect, clean, visualize, analyze and interpret information from various sources to develop clear, well-defined documentation such as, but not limited to: requirements gathering, root cause analysis, process/procedural documentation, etc. What did you analyze and what steps did you take to analyze, test, and present your findings?
• Describe your knowledge and/or experience with On-Prem and Cloud data warehouse environments.

Position Location

Headquarters

700 North 10th Street

Sacramento, CA 95811

Equal Opportunity Employer

The State of California is an equal opportunity employer to all, regardless of age, ancestry, color, disability (mental and physical), exercising the right to family care and medical leave, gender, gender expression, gender identity, genetic information, marital status, medical condition, military or veteran status, national origin, political affiliation, race, religious creed, sex (includes pregnancy, childbirth, breastfeeding and related medical conditions), and sexual orientation.

It is an objective of the State of California to achieve a drug-free work place. Any applicant for state employment will be expected to behave in accordance with this objective because the use of illegal drugs is inconsistent with the law of the State, the rules governing Civil Service, and the special trust placed in public servants.