Senior Data Engineer Snowflake / ETL (Onsite)

CGS Business Solutions provided pay range

This range is provided by CGS Business Solutions. Your actual pay will be based on your skills and experience talk with your recruiter to learn more.

Base pay range

$130,000.00 / yr - $175,000.00 / yr

Direct message the job poster from CGS Business Solutions

Summary

CGS is hiring for a Senior Data Engineer to serve as a core member of the Platform team. This is a high?impact role responsible for advancing our foundational data infrastructure.

Your primary mission will be to build key components of our Policy Journal the central source of truth for all policy, commission, and client accounting data. Youll work closely with the Lead Data Engineer and business stakeholders to translate complex requirements into scalable data models and reliable pipelines that power analytics and operational decision?making for agents, managers, and leadership.

This role blends greenfield engineering, strategic modernization, and a strong focus on delivering trusted, high?quality data products.

Overview

• Build the Policy Journal Design and implement the master data architecture unifying policy, commission, and accounting data from sources like IVANS and Applied EPIC to create the platforms gold record.
• Ensure Data Reliability Define and implement data quality checks, monitoring, and alerting to guarantee accuracy, consistency, and timeliness across pipelines while contributing to best practices in governance.
• Build the Analytics Foundation Enhance and scale our analytics stack (Snowflake, dbt, Airflow), transforming raw data into clean, performant dimensional models for BI and operational insights.
• Modernize Legacy ETL Refactor our existing Java + SQL (PostgreSQL) ETL system diagnose duplication and performance issues, rewrite critical components in Python, and migrate orchestration to Airflow.
• Implement Data Quality Frameworks Develop automated testing and validation frameworks aligned with our QA strategy to ensure accuracy, completeness, and integrity across pipelines.
• Collaborate on Architecture & Design Partner with product and business stakeholders to deeply understand requirements and design scalable, maintainable data solutions.

Ideal Experience

Seniority level

Mid?Senior level

Employment type

Full?time

Job function

Information Technology

Industries

IT Services and IT Consulting

Referrals increase your chances of interviewing at CGS Business Solutions by 2x

Get notified about new Data Engineer jobs in Beverly Hills, CA .

CGS Business Solutions is an INC 5000 company and is honored to be selected as one of the Best IT Recruitment Firms in California.

#J-18808-Ljbffr