Senior Data Engineer

At CGS Business Solutions, we’re dedicated to helping skilled IT and business professionals take the next meaningful step in their careers. Whether you're exploring project-based consulting roles or seeking a long-term position, we connect you with opportunities that align with your expertise, your goals, and your growth trajectory.

Backed by deep industry insight and our proven TalentFlow™ Framework, we ensure every role we present is thoughtfully matched to your skills, passions, and career ambitions. If you're ready for a role that challenges you and moves your career forward, we’re currently partnering with leading organizations to fill the following opportunity:

Position Summary:

The Senior Data Engineer will be part of a team designing and implementing our modern data platform to support enterprise-wide analytics, integration, and AI/ML initiatives. Together, the team will build a scalable enterprise data warehouse, enable modern visualization tools, and advance self-service analytics capabilities for business users.

Major Duties and Responsibilities:

• Data Engineering & Pipeline Development – Design, build, and maintain scalable data pipelines and workflows in Snowflake, leveraging dbt for modular transformations and Fivetran for automated ingestion.
• Enterprise Data Warehouse & Modeling – Architect and optimize the enterprise data warehouse, applying best practices in data modeling, performance tuning, and scalability to support enterprise-wide analytics.

Education and Experience:

Required:

• Bachelor’s degree in Computer Science, Data Engineering, Information Systems, or a related technical field.
• 5+ years of professional experience in data engineering or related roles.
• Proven expertise with Snowflake for data pipelines, development, and optimization.
• Strong experience with dbt for modular transformations and Fivetran for automated ingestion.
• Hands-on experience with AWS cloud services (especially S3) for data integration and storage.

Preferred:

• Master’s degree in a related field.
• Experience with real-time/streaming technologies (e.g., Kafka, Kinesis, Flink).
• Knowledge of data security, compliance, and access control best practices.

Knowledge and Skills:

• Snowflake (Expert) – deep expertise in data pipelines, query optimization, and enterprise-scale implementation.
• dbt (Advanced) – strong ability to design modular, reusable transformations and maintain version-controlled models.
• Fivetran (Advanced) – hands-on skill in managing ingestion pipelines and troubleshooting data connectors.
• Data Warehousing & Data Modeling (Advanced) – proficiency in dimensional modeling, star/snowflake schemas, and performance tuning.
• AWS Cloud (Intermediate) – working knowledge of S3 for storage and integration; familiarity with broader AWS data services a plus.

About CGS Business Solutions

CGS Business Solutions is a nationally recognized leader in IT staffing and consulting, delivering top-tier talent across Applications, Cloud & Infrastructure, Cybersecurity, Data & AI, and Engineering. As a multi-year INC 5000 winner and one of California’s Best IT Recruitment Firms, we’re known for combining boutique-level service with enterprise-grade results.

We’re also proud to be named one of the Orange County Business Journal’s Fastest Growing Companies, earning the distinction for five consecutive years as we continue to expand into new markets across the U.S. Companies trust CGS to attract, engage, and retain elite technology talent—giving them the advantage they need to lead with confidence in a rapidly evolving digital landscape