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.
- Design, automate and support sophisticated data extraction, transformation, and loading applications.
- Strong knowledge of Oracle database for batch application development within data warehouse / data lake environment.
- Perform data ingestion from heterogeneous data sources to on-premises or cloud data storage, (including and not limited to snowflake, AWS, etc.) d. 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 using DBT, ODI, Oracle PL/SQL, Oracle SQL and ShellScript.
- Experience and knowledge in developing dimensional hierarchies, design data model to support multiple Enterprise Data Management reports. Work with all stakeholders including business
- customers, vendors, and internal resources to facilitate team communication and achieve the mission.
- Creates and improves data solutions that enable smooth data delivery and oversees gathering, processing, maintaining, and analyzing enormous amounts of data.
- Experience in data quality validation.
- Knowledge/Experience in API development frameworks.
- Knowledge/Experience in Cloud native data integration technologies.