BI Developer Services Level III

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:

• Design, automate and support sophisticated data extraction, transformation, and loading applications.
• Strong knowledge of Oracle database for batch application development within data warehouse / data lake environment.
• Perform data ingestion from heterogeneous data sources to on-premises or cloud data storage, (including and not limited to snowflake, AWS, etc.)
• Creates and improves data solutions that enable smooth data delivery and is in charge of gathering, processing, maintaining, and analyzing enormous amounts of data.
• Data lake migration experience from on prem systems to cloud platform

1. Minimum of 10+ years of demonstrated experience in the services listed below:

2. Design, automate and support sophisticated data extraction, transformation, and loading applications.

3. Strong knowledge of Oracle database for batch application development within data warehouse / data lake environment.

4. Perform data ingestion from heterogeneous data sources to on-premises or cloud data storage, (including and not limited to snowflake, AWS, etc.)

5. Experience managing ETL using DBT, ODI, Oracle PL/SQL, Oracle SQL and ShellScript.

6. Experience and knowledge in developing dimensional hierarchies, design data model to support multiple Enterprise Data Management reports. Work with all stakeholders including business customers, vendors, and internal resources to facilitate team communication and achieve the mission.

7. Creates and improves data solutions that enable smooth data delivery and is in charge of gathering, processing, maintaining, and analyzing enormous amounts of data.

8. Experience in data quality validation.

9. Knowledge/Experience in API development frameworks.

10. Knowledge/Expierience in Cloud native data integration technologies

11. Data lake migration experience from on prem systems to cloud platform

12. Previous Experience working on LAUSD Data Lake systems

13. Min 3 years' experience in building incremental models/handling raw data layers and building DBT models for LAUSD Vendors/Application

14. Proficiency in dbt (Data Build Tool) development, including macros, hooks, and incremental models. Experience converting complex Oracle stored procedures into modular dbt models.

15. Ability to write DBT tests for data quality and manage security on DBT models.

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.