Senior Data Engineer – Snowflake

CGS Business Solutions is committed to helping you, as an esteemed IT Professional, find the next right step in your career. We match professionals like you to rewarding consulting or full-time opportunities in your area of expertise. We are currently seeking Technical Professionals who are searching for challenging and rewarding jobs for the following opportunity:

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.

Huge Plus

• 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)

About CGS Business Solutions: CGS specializes in IT business solutions, staffing and consulting services. With a strong focus in IT Applications, Network Infrastructure, Information Security, and Engineering. CGS is an INC 5000 company and is honored to be selected as one of the Best IT Recruitment Firms in California. After five consecutive Fastest Growing Company titles, CGS continues to break into new markets across the USA. Companies are counting on CGS to attract and help retain these resource pools in order to gain a competitive advantage the rapidly changing business environments.