INFORMATION TECHNOLOGY SPECIALIST II

at  CA State Lottery

Under the general Direction of the Information Technology Manager I in the Data, Information & Analytics Services (DIAS) unit, the Information Technology Specialist II serves as a lead back-end & Data Analytics developer supporting the Lottery’s most complex Business Intelligence (BI) and Business Analytics (BIBA) platforms. The incumbent is responsible for the design, development, operation, and maintenance of BI, reporting and software systems. The technical aspects of this position include cloud migration tasks, integration, and maintenance of the BIBA platform, applications, data warehouses, and related components. Duties encompass the research, design, documentation, development, configuration, testing, implementation, and management of data processing functions including defining, extracting, transforming, loading, and archiving data; analysis of business information, standards development, analytical data models, and conceptual database designs; developing database strategies, structures, systems monitoring, performance, capacity, and planning for expansion. The back-end developer will be responsible for developing, managing, and maintaining BIBA data lakes, cubes, data pipelines and security by utilizing Synapse, R, SQL Server Integration Services (SSIS), Databricks, the Snowflake model, Online Analytical Processing (OLAP) and other related technologies. The duties for this position are focused on the Software Engineering and Systems Engineering domains. Work may be assigned in other domains as needed.
This position requires a current IT 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 at the Sacramento HQ and is eligible for either a remote-based or office-based telework schedule. Employees must be able to report to their assigned headquarters office as needed. Travel expense to and from the assigned headquarters are the responsibility of the employee. Eligibility for telework requires employee residence 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?

BENEFITS SUMMARY

Contact Information
The Human Resources Contact is available to answer questions regarding the position or application process.
Department Website: http://www.calottery.com

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.