Job Description:
The Los Angeles Unified School District seeks qualified proposers to provide data analysis and visualization services on behalf of the Information Technology Services. The Contractor shall provide resources with the technical skills and personal leadership to perform all related services. Resource must have at least three (3) years of experience analyzing data and developing reports and dashboards using Power BI data visualization
Requirements:
- Minimum of seven (7) years of demonstrated experience.
- Experience as a BI Developer for a school district, with a specialty in Oracle BI applications.
- Knowledge of RPD metadata i.e. customized analytics repository, designing physical layer, developing BMM and presentation layers, setting up LDAP Authentication and developing dynamic and interactive dashboards.
- Experience managing ETL and writing and deploying code for the LAUSD applications MyData, MyTeam, Central Office, CASE, Unified Enrollment Project, SchoolMint, or Student Survey. Experience with the Oracle products OBIEE, OBIA, or Oracle BI Publisher.
- Experience and knowledge in developing dimensional hierarchies, design data model to support multiple Enterprise Data Management reports.
Responsibilities:
- Develop Oracle SQL queries and PL/SQL packages for the Unified Enrollment School Mint tool.
- Analyze, troubleshoots, and identifies Oracle SQL and PL/SQL code bugs on Oracle database 12c or higher for the Unified Enrollment project.
- Analyze, troubleshoots, and identifies OBIEE report bugs for for MyData, MyTeam, Central Office, CASE
- Develop new reports and dashboards for MyData, MyTeam, Central Office, CASE projects using OBIEE 12c.
- Enhance existing reports and dashboards using OBIEE 12c or higher for MyData, MyTeam, Central Office, CASE
- Manage the OBIEE Web Catalog for MyData, MyTeam, Central Office, CASE
- Training and/or knowledge transfer
- Other duties as assigned.