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.

Scope: DEVELOPER (Level III): Onsite Resources (Lead & Architect Level) Focus: Strategy, Complex Architecture, and Stakeholder Alignment.

Strategic Design & Governance

Architecture Mapping: Define the target Snowflake schema (Bronze/Silver/Gold) and lead the transition from Oracle's row-based PL/SQL to Snowflake's columnar SQL logic.
Security & Compliance: Onsite coordination with applications/vendors/partners and RBAC (Role-Based Access Control) in Snowflake.
dbt Project Standards: Establish global dbt macros, materialization strategies (Incremental vs. Table), and CI/CD pipeline standards

Stakeholder & Change Management

UAT Orchestration: Lead the "Inbound/Availability" validation with business users. Onsite presence is required to translate technical migration gaps into business impact.
Critical Issue Resolution: Act as the primary point of contact for "P0" migration failures or data discrepancies that block downstream reporting.
Cutover Planning: Own the "Go-Live" runbook, specifically managing the final sync from Oracle to Snowflake during the production window. 3. Lead and mange Offshore resources/deliverables

Roles/Responsibilities:

Establish and document the technical requirements for reporting software including tables, views, report design, unit test plans, and test cases.
Assist in all phases of the reporting software development cycle including requirements
gathering, analysis, design, testing, implementation, and production support.
Proficiently create and maintain complex SQL statements to generate tables and views
that will be used by PowerBI developers to drive visualizations. Develop and enhance
SQL-based tables and views as per user requirements.
Facilitate SQL design sessions and SQL code walk-throughs to ensure adherence to
development standards and best practices using dbt.
Have at least 5 years of experience as a dbt developer, with a strong focus in Snowflake.
Develop and maintain documentation on all database models, tables, guidelines,
methods, and standards to ensure consistency and clarity.
Provide recommendations for further definition of development standards and
application architecture based on industry best practices and emerging technologies.
Conduct unit testing and assist in user testing of complex SQL statements or report
modifications to ensure quality and functionality meet requirements.
Train other staff members on development processes and standards to ensure consistency
across the team
Design, implement solution using AWS for vendor inbound/outbound data transfer in
LAUSD Data lake environment.
Design, implement data lake inbound/outbound solutions using cloud technologies Five
Tran, AWS Glue, AWS (Transfer Family, Step Function, Event Bridge, lambda).
Other duties as assigned

Mandatory Skills:

Proposed candidates must have a BS/BA degree in computer science, information technology, or related field.
Years of professional experience in the requested labor categories.

Developer Level II: 5+ years of professional experience in providing services as listed in the Statement of Work (SOW).
Developer Level III: 10+ years of professional experience in providing services as listed in the Statement of Work (SOW).

Desirable Skills: N/A

Knowledge of snowflake, git, pull requests, visual studio code, and dbt is strongly recommended.

Senior Developer (Level II and Level III)

Key skills

About this role