The primary role will be to perform the following tasks, including, but not limited to:
- Build dbt/Snowflake data objects.
- Build AWS and Snowflake testing infrastructure.
- CI/CD infrastructure design.
Task 1:
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.
Write code and develop technical configuration to various Streamlit Apps
Task 2: Merit Bridge -> Snowflake Migration
As needed and as authorized, shall rebuild Merit Bridge schemas in dbt/Snowflake, refactoring AWS database connection code to point to Snowflake, migrating the data.
Document and write database schemas and definitions.
Task 3: Build dbt/Snowflake data objects
As needed and as authorized, 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 4: Build AWS and Snowflake testing infrastructure
As needed and as authorized, will build unit and integration tests for Python codebase spanning AWS Services (Lambda, RDS, DynamoDB) and Snowflake to integrate within CI/CD infrastructure.
Task 5: Consult on CI/CD Infrastructure design
As needed and as authorized, will provide recommendations and input on CI/CD Infrastructure design.
Job Type: Part-time
Pay: $40.00 - $60.00 per hour
Expected hours: 20 – 40 per week
Work Location: Remote
