Business Intelligence Architect

Job Description and Duties Under the general direction of the Information Technology Services Division (ITSD), Data Analytics & Reporting Services (DARS) Information Technology (IT) Manager I, the Business Intelligence Architect is responsible for designing, directing, and implementing changes to the California State Lottery’s (Lottery) Business Intelligence Business Analytics (BIBA) platform, including systems such as Sales Wizard, Performance Wizard, 2nd Chance, Microsoft Azure, and other third-party platforms. The Business Intelligence Architect will support core organizational functions, assure integrity, availability, and meet security needs of transporting and storing data. The Business Intelligence Architect must possess strong team leadership skills, excellent written and verbal communication skills. The duties for this position are focused on the Software Engineering and System Engineering domains; however, work may be assigned in other domains as needed. This position requires a current Information Technology Specialist II exam. If you need to take the exam or if your score has expired, click here to gain list eligibility. This position is headquartered in Sacramento and is eligible for a hybrid telework schedule. Employees must be able to report to their assigned headquarters office as assigned. Travel expense to and from the assigned headquarters are the responsibility of the employee. Eligibility for telework requires the employee to reside in California per California Government Code Section 14200 which states: “telecommuting means the partial or total substitution of computers or telecommunication technologies, or both, for the commute to work by employees residing in California. When choosing a state organization to work for, there are a lot of options. Why choose the California State Lottery?

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." It is highly recommended that you apply online using your CalCareers account. It is not necessary to return the contact letter if you applied electronically. Please ensure to monitor your email and/or CalCareers account for communication associated with your application submission. 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 Business Intelligence Architect will work in a fast-paced environment, with competing priorities, and critical deliverables. a. Schedule: This position supports the Lottery during normal business 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. b. Travel: Statewide overnight travel may be required. c. 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 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. Desirable Qualifications In addition to evaluating each candidate's relative ability, as demonstrated by quality and breadth of experience, the following factors will provide the basis for competitively evaluating each candidate:
• Experience designing and implementing scalable data architectures, including data lakes, data warehouses, and real-time data pipelines using tools such as Azure Synapse Analytics, Azure, Azure Data Factory, Azure Analysis Services, Azure Data Lake, Power BI and Power BI Symantec Models and equivalent technologies.
• Strong experience with Business Intelligence platforms such as Power BI Symantec Data Models, Asure Synapse Analytics, OLAP/SSAS, and reporting tools, including the ability to develop complex dashboards and data visualizations.
• Ability to build and manage robust ETL/ELT pipelines using Azure Syapse Piplines, SSIS, Python, and SQL to support data ingestion, transformation, and integration across multiple systems.
• Ability to analyze complex data systems, identify inefficiencies, and propose innovative solutions that align with business goals and improve operational efficiency.
• Familiarity with data governance frameworks, metadata management, and data quality assurance practices to ensure integrity and compliance across enterprise data assets.
• Excellent written and verbal communication skills to convey technical concepts clearly to both technical and non-technical stakeholders, and to collaborate effectively across IT and business units.
• Experience with cloud-native data services and architecture patterns, particularly within Microsoft Azure and Power BI Symantec Data Model environments.
• Initiative in researching emerging technologies, proposing enhancements, and contributing to the evolution of enterprise data strategies and standards.

Benefits

Benefit information can be found on the CalHR website and the CalPERS website. 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.

1. Describe the depth and breadth of knowledge, skills, experience, and other attributes that make you the perfect candidate for the Business Intelligence Architect position.
2. Describe your experience implementing data governance and security frameworks within a business intelligence environment.
3. Provide an example of a BI modernization initiative where you served as a technical lead or architect. Position Location Headquarters 700 North 10th Street Sacramento, CA 95811