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:

Develop SQL using DBT within a Snowflake environment.
Code locally within a docker container using Visual Studio Code, and deploy updates via GIT/Azure DevOps.
Integrate with CI/CD pipelines and author comprehensive descriptions for all pull requests.
Define and map dbt sources, implementing source freshness rules.
Leverage dbt macros effectively to modularize and reuse complex logic across models.
Design fact and dimension tables using a star schema optimized for Power BI.
Implement standard and custom dbt tests, including macros, to ensure data resiliency and catch anomalies.
Schedule tasks and validate incremental materialization logic to optimize compute costs.
Generate and maintain comprehensive documentation, ensuring column level descriptions exist for all production models.
Optimize and performance-tune models by leveraging Snowflake clustering and dbt pre/post-hooks.

Mandatory Skills:

3 years of experience as a QA
3 years of experience with testing automation using Selenium
Resource must work onsite at LAUSD central office
Experience with school district-level data
Good understanding of SQL
Experience in cloud-native application QA such as Power BI, Snowflake, and DBT
Strong analytics skills with the ability to analyze complex data and identify trends and patterns.
Experience with Azure DevOps
Expert knowledge on automation testing tools such as Selenium to automate testing on various aspects of an application.

Desirable Skills: N/A

Quality Assurance (QA)

Key skills

About this role