CGS Business Solutions
Senior Data Engineer – Snowflake / ETL (Onsite)
CGS Business Solutions, Beverly Hills, California, United States, 90211
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. You’ll 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 platform’s “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
5+ years of experience building and operating production‑grade data pipelines.
Expert‑level proficiency in
Python
and
SQL .
Hands‑on experience with the modern data stack —
Snowflake/Redshift ,
Airflow ,
dbt , etc.
Strong understanding of
AWS data services
(S3, Glue, Lambda, RDS).
Experience working with
insurance or insurtech data
(policies, commissions, claims, etc.).
Proven ability to design
robust data models
(e.g., dimensional modeling) for analytics.
Pragmatic problem‑solver capable of analyzing and refactoring
complex legacy systems
(ability to read Java/Hibernate is a strong plus — but no new Java coding required).
Excellent communicator comfortable working with both technical and non‑technical stakeholders.
Direct experience with Agency Management Systems (Applied EPIC, Nowcerts, EZLynx, etc.)
Familiarity with carrier data formats (Accord XML, IVANS AL3)
Experience with BI tools (Tableau, Looker, Power BI)
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
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. You’ll 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 platform’s “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
5+ years of experience building and operating production‑grade data pipelines.
Expert‑level proficiency in
Python
and
SQL .
Hands‑on experience with the modern data stack —
Snowflake/Redshift ,
Airflow ,
dbt , etc.
Strong understanding of
AWS data services
(S3, Glue, Lambda, RDS).
Experience working with
insurance or insurtech data
(policies, commissions, claims, etc.).
Proven ability to design
robust data models
(e.g., dimensional modeling) for analytics.
Pragmatic problem‑solver capable of analyzing and refactoring
complex legacy systems
(ability to read Java/Hibernate is a strong plus — but no new Java coding required).
Excellent communicator comfortable working with both technical and non‑technical stakeholders.
Direct experience with Agency Management Systems (Applied EPIC, Nowcerts, EZLynx, etc.)
Familiarity with carrier data formats (Accord XML, IVANS AL3)
Experience with BI tools (Tableau, Looker, Power BI)
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