Snowflake, dbt, and AWS Professional Services Contractor

Dice is the leading career destination for tech experts at every stage of their careers. Our client, CCS Global Tech, is seeking the following. Apply via Dice today!CCS Global Tech is a rapidly growing Information Technology company with a diverse portfolio of technology products and services and a large network of industry partnerships. With over 22 years of being a successful business with a global talent pool and presence, CCS is a certified Microsoft Gold Partner and specializes in delivering expert Microsoft based solutions for technical and business needs. We have been recognized by Inc. 500 Magazine as one of the fastest growing small companies in the Unites States.we are a Tier 1 vendor for the City and County of San Francisco for Cloud Services, Staffing Services and Training Services. For this multi-year opportunity with a diverse set of needs to address, we are currently focusing on establishing partnerships with individuals as well as companies who can help us enhance our overall service portfolio, cut lead times, and ultimately help us deliver successfully. We currently hold sizable Government accounts in the San Francisco bay area including City and County of San Francisco, San Mateo County, and Santa Clara County.We take great pride in our global reach and local influence. Your experience alongside our highly skilled and talented internal team who guide you along the way, offers key insights into what helps you stand out in a competitive job market.If you are a partner company, please submit resumes with contact information of your own W2 Consultants only. Submitted consultants are expected to have excellent communication skills.Roles/Responsibilities: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.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.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:Contribute to (in part or in whole) dashboard and query migration from legacy systems. Contribute to writing dbt data objects and models. 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:Develope test suites for internal DHR hiring systems. Execute test suites against internal technical systems and produced documented results. 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:MQ1 Provide at least one prior project which involves each of the following: Leveraging AWS Python Lambdas to integrate data across systems dbt/Snowflake data modeling Data processing and optimizing over large (not hyper-large) datasets Unit and integration testing CI/CD and/or infrastructure as codeMQ2 Contractor must be available to be on-site when needed.Desirable Skills: N/A