Business intelligence analyst serp_jobs.h1.location_city

Position Information

The California State University, Office of the Chancellor, is seeking a Business Intelligence Dashboard Developer to design, develop, and maintain reporting and dashboard solutions that modernize legacy processes and advance data analytics capabilities. The position manages dashboard and report development, validation, and maintenance, as well as user and role-based reporting and auditing to ensure compliance and accuracy.

The incumbent works closely with the Data Analytics manager and developers, BIDO data engineers, database administrators, server administrators, application data stewards, and application end-users to reimagine and transition legacy reporting processes into cloud-based solutions, including the creation of advanced datasets and dashboards using Athena, Snowflake, and QuickSight. The incumbent applies strong knowledge of data manipulation, integration, and transformation to improve reporting workflows and optimize data usability.

In addition, the position supports metadata management in the CSU Data Lake by organizing, integrating, and maintaining metadata to enhance accessibility, consistency, and compliance with governance policies. The developer collaborates with stakeholders to understand reporting needs, develops customized solutions, and contributes to project planning and tracking, establishing standards and practices that ensure high-quality, scalable analytics solutions.

This is a highly collaborative role that requires balancing independent development with close coordination among developers, managers, and service stakeholders.

This position is approved for telecommuting (two days telecommuting, three days in office (in-person)) with onsite work at the main headquarters located in Long Beach, California.

Responsibilities

Under the general direction of the Manager of Data Analytics , the Business Intelligence Dashboard Developer will perform duties as outlined below :

The Business Intelligence Dashboard Developer applies advanced knowledge of enterprise resource planning systems (esp. PeopleSoft), database productivity tools, data modeling concepts, structured and semi-structured data design, data integration, programming within security frameworks, distributed processing, and modern data lake / lakehouse workflows. The incumbent independently designs, develops, and maintains reporting and dashboard solutions while ensuring data quality, governance, and scalability across CSU systems.

Specific duties include :

Maintaining, updating, and evolving legacy applications and reporting through :

• Complex BI development duties (combination of QuickSight, Athena, database, and user-provided sources).
• Advanced backend dataset development and deployment using Athena CTEs and Databricks to Snowflake workflows.
• Active participation in agile software development and continuously improving development practices.
• Designing, documenting, developing, validating, and maintaining dashboards and reports using modern, cloud based BI Platforms (esp. Amazon QuickSight, Athena, Databricks and Snowflake).
• Performing advanced quality assurance and validation of applications, dashboards, and reports to ensure accuracy, performance, and compliance.
• Building, organizing, and maintaining report libraries and catalogs using version control systems (e.g. GIT).

Consulting with business owners, end-users, and business process specialists to gather, analyze, and document business requirements, users’ needs, objectives, and desired features, including :

User account auditing and maintenance by :

Metadata management in the CSU Data Lake :

Other duties as assigned, including :

Qualifications

This position requires :

Preferred Qualifications