Certification PgM Data Engineer

작업 내용

Summary

We are looking for long term support for carrier certification database maintenance. This includes the support from the design of the database and table schema to report generation to end users.

Responsibility also includes daily bug fix and enhancements on dashboards.

Service:

1. Apply SQL and JavaScript experience to daily operation.

2. Maintain current tables.

3. Create and maintain multiple F1 tables using different data sources including but not limited to Google Spreadsheets and BigQuery connector.

4. Design and optimize database structure.

5. Scale up current database structures to support running with multiple programs and data sources.

6. Use Looker studio (Google Data visualization tool) to create reports.

7. Setup process to monitor workflow running status.

8. Document changes and requirements.

Deliverables:

1. Database solution definition, schema design, and documentation.

2. F1 tables for each program for carriers (including new product launches and in-market)

3. PLX workflow and scripts with monitoring and alerts (initial and maintenance)

4. Reports generated in PLX Dashboard and Looker Studio (Google Data visualization tool)

5. Dashboard report bug fixes and enhancements.moting the laboratory’s work.

*F1 is distributed relational database

**PLX is a suite of applications and services for data analysis