LAUSD 202422 | BI Developer Services - Kaygen Inc.

KAYGEN is an emerging leader in providing top talent for technology based staffing services. We specialize in providing high-volume contingent staffing, direct hire staffing and project based solutions to companies worldwide ranging from startups to Fortune 500 and Managed Service Providers (MSP) across a wide variety of industries.
for BI Developer, provide fully burden hourly rate for
- Fully burden hourly rate for onsite deployment.
- Fully burden hourly rate for offsite deployment.

Provide a minimum of three (3) references closely related to services as listed in the statement of work including Project Size, Project Scope, Period of Performance, and Contact Information


Job Title: BI Developer
Period of Performance: Upon execution of work order through 6/30/2024
Location: LAUSD Administrative Headquarters 333 S. Beaudry Avenue, Los Angeles, CA 90017

Minimum Qualifications: Proposers shall meet each of the minimum qualification requirements at the time of proposal submittal
" Minimum of seven (7) years of demonstrated experience in the services listed in the Statement of Work

Submittal Requirements
" Minimum Qualifications: Provide a cover letter addressing, in detail and explicitly, how the firm meets the Minimum Qualifications
" Experience and Qualifications: Provide resume(s) with a detailed summary of work experience as listed in Appendix A MSA Work Order Statement of Work. The District reserves the right to request additional resumes should those submitted be deemed unacceptable for this project
" Experience and Qualifications: Provide a minimum of three (3) references closely related to services as listed in the statement of work.
" Number of Resources: The proposed work order will require one (1) resource. Provide your best available resource meeting the requirements. Do not provide more than one (1) submittal for this request.

MSA WORK ORDER STATEMENT OF WORK
A. GENERAL: The Los Angeles Unified School District seeks qualified proposers to provide a BI Developer for the Information Technology Division. LAUSD intends to use the results of this solicitation process to award a work order to the responsive and responsible proposer. The proposed work order will require one (1) resource.
B. REQUIREMENTS:
a. Experience as a BI Developer for a school district, with a specialty in Oracle BI applications
b. 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.
c. Experience managing ETL, and writing and deploying code for the LAUSD applications MyData, MyTeam, Central Office, CASE, Unified Enrollment Project, SchoolMint, or Student Survey.
d. Experience with the Oracle products OBIEE, OBIA, or Oracle BI Publisher.
e. Experience and knowledge in developing dimensional hierarchies, design data model to support multiple Enterprise Data Management reports.
C. DELIVERABLES
The proposed resource shall perform the following duties, including but not limited to: shall be provided at the request of the District. Specific duties will include the following:
a. Develop Oracle SQL queries and PL/SQL packages for the Unified Enrollment School Mint tool.
b. Analyze, troubleshoots, and identifies Oracle SQL and PL/SQL code bugs on Oracle database 12c or higher for the Unified Enrollment project
c. Analyze, troubleshoots, and identifies OBIEE report bugs for for MyData, MyTeam, Central Office, CASE
d. Develop new reports and dashboards for MyData, MyTeam, Central Office, CASE projects using OBIEE 12c
e. Enhance existing reports and dashboards using OBIEE 12c or higher for MyData, MyTeam, Central Office, CASE
f. Manage the OBIEE Web Catalog for MyData, MyTeam, Central Office, CASE
g. Training and/or knowledge transfer
h. Other duties as assigned