Snowflake, dbt, and AWS Professional Services Contractor

Roles/Responsibilities:

1. Task 1: Streamlit App Development

As needed and as authorized Contractor shall develop Streamlit applications over various Snowflake datasets. Many of these will be CRUD spreadsheet-style user experiences directly on top of datasets while others will be more nuanced applications with conditional logic complex views and more advanced functionality.

Task 1 Deliverable: Write code and develop technical configuration to various Streamlit Apps.

1. Task 2: Merit Bridge -> Snowflake Migration

As needed and as authorized Contractor shall rebuild Merit Bridge schemas in dbt/Snowflake refactoring AWS database connection code to point to Snowflake migrating the data.

Task 2 Deliverable:

Document and write database schemas and definitions.

1. Task 3: Build dbt/Snowflake data objects

As needed and as authorized Contractor will translate and migrate legacy data models in DHR Snowflake in UDP Snowflake. Refactor current Position Management Dashboard SQL and PowerBI queries into dbt-standardized data objects. Build dbt objects based on SME-developed schemas queries and data models.

Task 3 Deliverables:

1. Contribute to (in part or in whole) dashboard and query migration from legacy systems.
2. Contribute to writing dbt data objects and models.

1. Task 4: Build AWS and Snowflake testing infrastructure

As needed and as authorized Contractor will build unit and integration tests for Python codebase spanning AWS Services (Lambda RDS DynamoDB) and Snowflake to integrate within CI/CD infrastructure.

Task 4 Deliverables:

1. Develope test suites for internal DHR hiring systems.
2. Execute test suites against internal technical systems and produced documented results.

1. Task 5: Consult on CI/CD Infrastructure design

As needed and as authorized Contractor will provide recommendations and input on CI/CD Infrastructure design.

Task 5 Deliverable: Produce documented best-practices recommendations and/or guidelines about infrastructure development and design.

Mandatory Skills:

1. MQ1 Provide at least one prior project which involves each of the following:

1. Leveraging AWS Python Lambdas to integrate data across systems
2. dbt/Snowflake data modeling
3. Data processing and optimizing over large (not hyper-large) datasets
4. Unit and integration testing
5. CI/CD and/or infrastructure as code

1. MQ2 Contractor must be available to be on-site when needed.

Desirable Skills: N/A