Principal Platform Data Architect; Snowflake​/ETL; Hybrid

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:

Our nationwide manufacturing customer is seeking a FULL TIME Principal Data Platform Architect who will be responsible for defining and executing the company’s enterprise data platform strategy and roadmap. This role will architect a modern Snowflake-based lakehouse environment, enable scalable self-service BI, drive integration across enterprise systems and data domains, and establish the data foundation needed to support machine learning and AI initiatives.

• Develop and maintain the overall architectural vision for data, integration, analytics, and AI platforms.
• Align data platform capabilities with evolving business priorities, including growth, operational efficiency, compliance, and innovation.
• Establish enterprise architecture principles, standards, best practices, and governance frameworks.

• Design and oversee logical data models across bronze, silver, and gold layers within a medallion architecture.
• Establish standards for data quality, lineage, security, and accessibility across structured and semi-structured data.
• Drive performance optimization, cost efficiency, scalability, and multi-tenant architecture across the platform.

• Define scalable integration patterns using API-led, event-driven, and batch-based approaches.
• Establish consistent standards for error handling, monitoring, logging, and metadata management.
• Ensure seamless interoperability across enterprise applications, data platforms, data warehouses, and operational systems.

• Architect governed semantic layers and reusable datasets to support enterprise analytics and reporting.
• Establish governance and standards distinguishing certified, trusted analytics from exploratory and ad hoc reporting.
• Develop frameworks supporting data catalogs, data dictionaries, business definitions, and end-user documentation.

• Ensure data architecture and pipelines are designed to support ML feature engineering, model development, and training.
• Partner with data science and engineering teams to establish scalable MLOps standards and best practices.
• Enable the reuse of trusted enterprise data assets across predictive analytics and generative AI use cases.

Location:

Hybrid in Irvine, CA (3 days onsite each week)

• Bachelor’s degree in Computer Science, Information Systems, Data Engineering, or a related field required.
• Master’s degree in Computer Science, Information Management, or a Business/Technology discipline preferred.

• 10+ years of experience in data architecture, data engineering, or enterprise data platforms.
• 5+ years in a senior or lead architecture role responsible for platform strategy, standards, and governance at an enterprise level.
• Proven experience designing and supporting cloud-based data platforms, preferably Snowflake, including lakehouse and medallion architectures.
• Hands-on experience with ELT/ETL technologies, data modeling, and metadata management, including dbt, Fivetran, or comparable solutions.
• Strong experience designing enterprise integration solutions using API-led, event-driven, and batch…