Benefits:

Optional Retirement plan

Accrued PTO

Diamond Technology is a Technical Services company. We have client who is a large local public organization with an opening for the following position:

JOB TITLE: Snowflake Analytics Engineer NUMBER OF OPENINGS: 1 DESIRED START DATE: Late June 2026 LOCATION: San Francisco: On Site DURATION: 1 year 40 hours a week. HOURLY RATE: $100ph

MINIMUM QUALIFICATIONS

Experience with the following: Provide at least 4 examples within the past 5 years which demonstrate 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

Project Summary The Department is seeking a highly qualified professional services Contractor who will provide technical support on a variety of tasks and projects to support the development of data infrastructure on an as needed, as assigned basis. The primary role of the Contractor will be to perform the following tasks, including, but not limited to:

1. App Development
2. Data migration
3. Build dbt/Snowflake data objects
4. Build AWS and Snowflake testing infrastructure
5. CI/CD Infrastructure design

C. Scope of Work The following is a description of the tasks required to complete the assignment.

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.

2. 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.

3. Task 3: Build dbt/Snowflake data objects: As needed and as authorized, Contractor will translate and migrate legacy data models in Department 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: A. Contribute to (in part or in whole) dashboard and query migration from legacy systems. B. Contribute to writing dbt data objects and models.

4. 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: A. Develope test suites for internal DHR hiring systems. B. Execute test suites against internal technical systems and produced documented results.

5. 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.