CES · 9 hours ago
Principal Data Engineer-2980 (Remote)
United States
Full-time
Remote
Lead/Staff
10+ years expCES is a company with over 26 years of experience in delivering software product development and digital transformation consulting services. They are seeking a highly experienced Principal Data Engineer to lead the architecture, design, and implementation of a scalable enterprise HCM data platform for K-12 education clients, guiding the end-to-end data engineering strategy and collaborating with various teams.
Cyber SecurityInformation Technology
Responsibilities
Define the technical vision, data architecture roadmap, and engineering standards for the enterprise data platform
Lead design decisions for ingestion frameworks, medallion architecture, orchestration patterns, and data modeling approaches
Provide hands-on technical leadership in Snowflake, SQL, Python, and ETL/ELT frameworks
Perform deep technical reviews of pipelines, SQL logic, dbt models, Snowflake objects, and code quality
Architect, design, and oversee implementation of scalable data ingestion pipelines using CDC/CT from SQL Server and other sources
Drive the buildout of Bronze → Silver → Gold layers with Snowflake best practices
Implement enterprise-grade standards for SCD Type 1 and Type 2, incremental loads, and data versioning
Architect and optimize Snowflake objects (secure views, streams, tasks, stored procedures, warehouses, clustering strategies)
Ensure the Gold layer is optimized for downstream analytics—Power BI, Tableau, QuickSight, and operational reporting
Establish and enforce data governance standards including lineage, documentation, retention, and metadata management
Implement Row-Level Security (RLS) and multi-tenant data access patterns at scale
Establish automated data quality frameworks with validation rules, alerts, and monitoring dashboards
Define audit, observability, and compliance frameworks across all data layers
Work closely with Product, Architecture, BI, and Engineering teams to translate business requirements into scalable data models
Collaborate with cloud engineering teams to optimize Snowflake performance, cost, and environment strategy
Drive performance tuning strategies at SQL, Snowflake, and pipeline orchestration layers
Mentor Senior/Junior Data Engineers and uplift the team’s technical capabilities
Conduct technical training sessions, architecture walkthroughs, and code reviews
Guide team on adopting modern tools (dbt, Snowpark, Airflow, etc.)
Qualification
Required
10+ years of hands-on data engineering experience
Demonstrated experience in architecting and scaling data platforms for enterprise clients
Strong leadership, mentoring, and cross-functional collaboration experience
Experience in fast-paced Agile teams delivering business-critical analytics platforms
Snowflake Expertise (Must Have)
5+ years hands-on Snowflake experience with strong expertise in: Warehousing, micro-partitioning, clustering, cost optimization Streams & Tasks automation Secure views, masking policies, RLS implementation, Query performance tuning
Advanced SQL proficiency (joins, window functions, CTEs, recursion, optimization)
Strong experience implementing medallion architecture at scale
Expertise in SCD Types 1 & 2, incremental loads, CDC, CT patterns
Strong Python skills for automation, data processing, validations, and API integrations
Expert-level understanding of data modeling: Dimensional modeling, Star/Snowflake schemas, Multi-tenant models, Performance-oriented semantic models
Strong understanding of SQL Server source systems, including CDC and Change Tracking
Preferred
Experience with ingestion tools: Snowflake OpenFlow, Fivetran, Airbyte, AWS DMS
Exposure to Snowpark, Snowpark Container Services (SPCS), or Python UDFs/UDAFs
Familiarity with BI consumption patterns (Power BI, Tableau, QuickSight)
CI/CD and Git-based workflow experience for data projects
Orchestration experience with Airflow, Dagster, Prefect, or AWS Step Functions
AWS ecosystem experience: S3, Glue, Lambda, PrivateLink, IAM, VPC networking
SnowPro Advanced – Data Engineer (preferred)
Benefits
Flexible working hours to create a work-life balance.
Opportunity to work on advanced tools and technologies.
Global exposure to not only collaborate with the team, but also to connect with the client portfolio and build professional relationships.
Highly encouraged for any innovative ideas & thoughts and we support in executing the same.
Periodical and on-spot rewards and recognitions on your performance.
Provides a better platform for enhancing skills via many different L&D programs.
Enabling and empowering atmosphere to work along.
Company
CES
CES is an information technology and business process management company.
1001-5000 employees
H1B Sponsorship
CES has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (14)
2024 (10)
2023 (7)
2022 (13)
2021 (11)
2020 (15)
Funding
Current Stage
Late StageLeadership Team
Raju Vedala
Chief Executive Officer
Recent News
shropshirestar.com
2025-09-20
The Hollywood Reporter
2025-05-17
shropshirestar.com
2025-04-30
Company data provided by crunchbase