CGS Business Solutions

Senior Data Engineer

CGS Business Solutions  •  Irvine, CA (Onsite)  •  3 months ago
Apply
AI can make mistakes so check important info. Chat history is never stored.

Job Description

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:

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

CGS Business Solutions

About CGS Business Solutions

Why Partner with CGS Business Solutions?

We don’t just find people. We cultivate potential. CGS Business Solutions has built a reputation for identifying and engaging passive talent that transforms teams, drives innovation, and supports sustainable growth.

What sets CGS apart is not just our ability to find great people, but how we do it. Our TalentFlow™ Framework is engineered to align deeply with your strategic hiring goals. We go beyond resumes and job descriptions to uncover what truly matters—values, motivations, cultural fit, and long-term potential.

Our recruiters act as strategic consultants. We bring market intelligence, talent advisory, and competitive positioning to every search. Whether you're hiring for a senior technologist, niche architect, or a future leader, we help you navigate the talent landscape with precision and perspective.

We also understand that CGS is often the very first impression a candidate has of your company—and we take that responsibility seriously. From our first outreach to the final offer stage, we uphold and protect your brand with the utmost professionalism and care. Your reputation, culture, and mission are reflected in every interaction we have on your behalf.

Clients don’t just work with us once—they partner with us for years. That’s because we treat every search like a mission-critical initiative. We bring the same level of rigor, creativity, and urgency whether we’re filling a one-off position or helping build an entire department.

And for candidates? We act as trusted career guides, ensuring every interaction with your brand is intentional, informed, and inspiring.

Let us help you build a smarter, more strategic talent pipeline—one that supports both short-term impact and long-term vision. Reach out to CGS today and discover how passive recruiting, done right, creates lasting competitive advantage.

Who is CGS? Let's just say we are a 3-letter agency fighting, helping you win The War on Talent.

Industry
IT & Software
Company Size
51-200 employees
Headquarters
San Juan Capistrano, California
Year Founded
2010
Social Media