What are the responsibilities and job description for the Senior Business Intelligence Developer position at Jobright.ai?
Verified Job On Employer Career Site
Job Summary:
The California State Lottery is a multi-billion-dollar enterprise dedicated to providing supplemental funding to California schools while supporting local communities. They are seeking a Senior Business Intelligence Developer responsible for designing, developing, and maintaining complex data models and dashboards that provide insights into lottery operations and player behavior.
Responsibilities:
• Designing, developing, implementing, maintaining and monitoring complex data models, architectures, data reports and dashboards that provide insights into lottery operations, sales, and player behavior.
• Creating and managing Extract, Transform, Load (ETL) processes to gather data from various sources, preparing it for analysis.
• Focusing on the cloud migration, integration, and maintenance of the BIBA platform, applications, data warehouses, and related components.
Qualifications:
Required:
• Current Information Technology Specialist II exam.
• Strong technical proficiency with BI tools such as Tableau, Power BI, R, Cognos, OBIEE, OAS, or similar.
• Expertise in SQL, data modeling, performance tuning.
• Ability to work with large, complex data sets across multiple data sources.
• Ability to analyze complex data sets, interpret trends, and generate actionable insights to support decision-making processes.
• Proficiency in programming languages, such as DAX, Python or R, for data analysis and automation tasks.
• Solid understanding of database management systems, including Oracle, SQL Server, Azure Synapse or other relevant platforms.
• Extensive experience with ETL (Extract, Transform, Load) processes and tools (Informatica, SSIS, Talend).
• Strong skills in data cleansing transformation logic, error handling, and performance optimization.
• Strong understanding of the lottery industry and its business processes.
• Experience managing BI projects, including requirements gathering, stakeholder engagement, and project execution and coordination.
• Excellent interpersonal skills with the ability to communicate complex data findings to technical and non-technical stakeholders.
• Deep knowledge and hands-on experience designing and implementing data warehouse solutions, including dimensional modeling, star/snowflake schemas, indexing strategies, and performance optimization using platforms such as SQL Server, Snowflake, or Azure Synapse.
Company:
The California Lottery was created by a ballot measure, Proposition 37, which was approved by 58 percent of voters on Nov. 6, 1984. Founded in 1984, the company is headquartered in Sacramento, California, USA, with a team of 501-1000 employees. The company is currently Late Stage.
