Under the general direction of the Data, Information, & Analytics Services Supervisor (Information Technology Supervisor II) the Information Technology Specialist I serves as a Data Developer Architect of the Lottery’s complex Business Intelligence (BI) and Data Analytics platforms. The incumbent performs design, development, testing, operation, and maintenance of BI, Data Analytics, reporting and software systems. The incumbent has practical knowledge of Business Intelligence, Business Analytics, Data Warehousing, Data Engineering, and Reporting systems. The incumbent has experience developing such systems with SQL, OLAP/SSAS, SSIS, Azure Synapse Analytics, dedicated SQL pools, data lakes, Databricks, Snowflake, Python, DAX, MDX, ETL/ELT, data pipelines, Power BI or equivalent technologies. Duties encompass researching, designing, documenting, developing, and troubleshooting systems performing data: ingestion, storage, processing, transformation, modeling, integration, quality, governance, and visualization. The incumbent must possess exceptional analytical skills to assimilate and clearly understand Lottery data warehouse architecture and design along with its value to the organization. The incumbent must possess excellent communication skills to provide effective, concise, and factual presentations of the architecture, surrounding technology, data, and information requirements to ITSD staff and business stakeholders. 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 encompass Software Engineering and Systems Engineering domains, however work may be assigned in other domains as needed.
This position requires a current IT Specialist I exam. If you need to take the exam or if your score has expired, click here to gain list eligibility.
This position is headquartered at the Sacramento HQ 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.
You will find additional information about the job in the Duty Statement.