Data Engineer

• Posted 1 day ago • Updated 1 day ago

Contract W2

Contract Corp To Corp

Contract Independent

CCS Global Tech

Fitment

Dice Job Match Score™

🔢 Crunching numbers...

Job Details

Skills

UI
Information Technology
Network
Microsoft
Tier 1
Cloud Computing
Recruiting
Training
Partnership
Communication
IT Service Management
Database
Business Rules
Data Quality
Data Deduplication
Data Dictionary
Data Mapping
Extraction
Scripting
Migration
Knowledge Transfer
Presentations
SQL
MySQL
Database Architecture
Data Modeling
Normalization
Reverse Engineering
Analytical Skill
Documentation
Extract
Transform
Load
PDF
Unstructured Data
RMS
Management
Data Structure
Oracle Linux

Summary

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 and Responsibilities:

The Data Engineer will perform technical services aligned with the following objectives / deliverables.

Perform detailed analysis of legacy MySQL/MSSQL databases to identify tables, columns, relationships, keys, constraints, and implicit business rules
Reverse-engineer or reconstruct a comprehensive data dictionary, including field definitions, data types, enumerations, and functional meaning
Identify and Propose mitigations for data quality issues
Develop comprehensive data-mapping documentation between legacy MySQL/MSSQL structures and new RMS ingestion requirements
Recommend transformation logic to address structural mismatches, normalization differences, or field consolidations. Consider the feasibility of applying records retention policy to limit scope of exported data
Write performant and accurate SELECT statements that extract, join, normalize, and structure legacy data into ingestion-ready datasets aligned with the new RMS schema
Create temporary staging tables, views, or intermediate transformation logic as needed
Incorporate data-quality checks, deduplication rules, value normalization, and field level remediation
Produce SQL extraction scripts for each RMS module
Provide documentation for each script, including purpose, dependencies, assumptions, and data transformations applied
Deliver repeatable processes/instructions to support test migrations and final cutover
Document fields that cannot be imported into the new platform due to incompatibilities. Agency staff will make determinations about criticality of data unable to be exported or imported
Legacy Data Dictionary (as reconstructed)
Data Mapping Specification (legacy new RMS)
SQL Extraction and Transformation Scripts for each data RMS module
Staging/Transformation Logic Documentation
Migration Support Reports (test migration feedback, revisions made)
Knowledge Transfer Package (demonstration, presentation of work completed, Significant findings)

Mandatory Skills:

Required Technical Expertise:
The Data Engineer must demonstrate proficiency in the following areas:
Advanced SQL with emphasis on complex SELECT statements, joins, subqueries, and transformation logic.
MySQL/MSSQL database architecture, and schema discovery.
Data modeling, normalization concepts, and reverse-engineering undocumented schema.
ETL methodology and preparing structured data for ingestion into third-party systems.
Strong analytical and documentation skills with the ability to interpret incomplete or ambiguous legacy data.
Experience with ETL processing binary large objects, PDF, and other unstructured data

Desirable Skills:

Experience with public-safety RMS, case-management, or similarly complex relational data structures

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

Dice Id: 10290999
Position Id: 2026-6735
Posted 1 day ago

Company Info

About CCS Global Tech

Headquartered in Poway, California and eight international offices, CCS Global Tech is a Certified Minority Business Enterprise (MBE) and a leading provider of enterprise solutions. We provide solutions that cover the full business spectrum from application development, data warehouse software, real time data warehousing, business analysis software, and web-based application development. Our clients span the globe and benefit from our comprehensive support capabilities.

Our tools and technical expertise have repetitively proven to reduce the time and costs associated with software and custom solution development. CCS Global Tech begins each project with quality analysis and business due diligence in order to deliver quality solutions for our clients. Our team of international talent asks critical questions that illuminate the fine details of the project scope. Once we have a clear and comprehensive view of the objectives sought, we set to work to bring your vision to life.

We have a complementary matrix of skills and talents across multiple platforms that allow us to identify, target and bridge technical gaps. Regardless of the size and scope of your business application, data warehouse initiative, or enterprise-wide project, our team supports service, technical capabilities and cost effective solutions that are unmatched by our competition. We focus on delivering state-of-the-art technology, application development, warehousing and support to our clients. With the scope and flexibility to optimize development schedules and products to fit any budget requirements, CCS Global Tech is aptly positioned to not only meet unique, strategic IT objectives of diverse organization, but also complement organizational goals.

Create job alert

Never miss an opportunity! Create an alert based on the job you applied for.