Data Engineer

Overview

Full Time

Skills

UI
Network
Microsoft
Tier 1
Recruiting
Training
Partnership
Data Integration
Amazon Web Services
Python
Query Optimization
Performance Tuning
Computer Science
Information Technology
Soft Skills
Analytical Skill
Conflict Resolution
Problem Solving
Communication
Data Engineering
Data Modeling
Cloud Computing
Health Care
Management
Data Quality
SQL
Scripting
Stored Procedures
Microsoft SQL Server
Modeling
Snow Flake Schema
Business Intelligence
Data Warehouse
Reporting
Analytics
Collaboration
Requirements Elicitation
Specification Gathering
Storage
Optimization
Extract
Transform
Load
Root Cause Analysis

Job Details

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.

Position Overview:

We are looking for an experienced Data Engineer with a strong foundation in data engineering best practices and experience with modern data warehousing and ETL platforms. The ideal candidate will have at least 5 years of hands-on experience, preferably with Snowflake, SQL Server, AWS, and Matillion ETL, to build, optimize, and maintain data pipelines and data integration solutions. This role involves working closely with cross-functional teams to support data-driven initiatives across the organization.

SKILLS:

Matillion, Snowflake, SQL, AWS Cloud

Required Qualifications:

  • Experience: At least 5 years of experience in data engineering, with proficiency in Snowflake, SQL Server, AWS and ETL tools (preferably Matillion).

  • Technical Skills: Strong SQL and Python skills with experience in query optimization and performance tuning.

  • Education: Bachelor's degree in Computer Science, Information Technology, or a related field.

  • Soft Skills: Strong analytical, problem-solving, and communication skills.

  • Data Engineering Skills: Experience in building, maintaining, and optimizing data pipelines and ETL processes.

  • Data Modeling: Knowledge of data warehousing concepts and hands-on experience in data modeling, particularly within Snowflake.

Preferred Qualifications:

  • Additional Tools and Platforms: Experience with additional ETL tools, data transformation methods, or cloud platforms is a plus.

  • Healthcare and PBM: PBM-specific knowledge and experience with transforming various healthcare data is a plus, but not required.

Key Responsibilities: Data Pipeline Development and Maintenance:

  • Design, develop, and maintain scalable and high-performance ETL pipelines using Matillion ETL to ingest, transform, and load data into Snowflake.

  • Integrate and manage data from various sources, ensuring data quality, reliability, and performance.

  • Optimize SQL queries, scripts, and stored procedures in Snowflake and SQL Server to improve efficiency and reduce processing time.

Data Warehousing and Modeling:

  • Develop and implement data models within Snowflake to support business intelligence and analytics requirements.

  • Collaborate with data architects and analysts to design and enhance data warehouse schemas and ensure alignment with reporting and analytics needs.

Collaboration and Requirements Gathering:

  • Work with business stakeholders to understand data requirements and translate them into technical specifications.

  • Support data architects and analysts by guiding data ingestion, storage, and retrieval methods.

Platform Monitoring and Optimization:

  • Monitor data pipeline and ETL performance, identifying bottlenecks and making necessary adjustments to ensure optimal system performance.

  • Perform troubleshooting and root cause analysis to resolve data issues and prevent future occurrences.

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.

About CCS Global Tech