CES · 5 days ago
Senior Data Engineer-2979 (Remote)
United States
Full-time
Remote
Mid, Senior Level
4+ years expCES has over 26 years of experience in delivering Software Product Development and Digital Transformation Consulting Services. They are seeking a Senior Data Engineer to design, develop, and maintain scalable data pipelines for an enterprise HCM data platform serving K-12 education clients, focusing on data quality and governance.
Cyber SecurityInformation Technology
Responsibilities
Design and implement data ingestion pipelines using CDC/CT (Change Tracking) from SQL Server sources
Build and maintain medallion architecture (Bronze → Silver → Gold) data layers in Snowflake
Develop data transformation models using tools like dbt, AWS Glue, or Snowflake native features (stored procedures, tasks)
Implement SCD Type 1 and Type 2 patterns for historical data tracking
Design and implement Row-Level Security (RLS) for multi-tenant data access
Create and optimize Snowflake objects including tables, views, streams, tasks, and stored procedures
Design data models supporting complex reporting requirements for absence management, workforce analytics, and substitute tracking
Ensure Gold layer is optimized for BI tool consumption (Power BI, Tableau, or other reporting tools)
Establish data quality checks, monitoring, and alerting mechanisms
Document technical designs, data dictionaries, and lineage documentation
Mentor junior team members and conduct code reviews
Qualification
Required
Snowflake: 4+ years hands-on experience with data warehousing, performance tuning, secure views, streams/tasks
SQL: Advanced SQL skills including complex joins, window functions, CTEs, and query optimization
Data Transformation: Experience with any transformation framework (dbt, AWS Glue, Snowflake stored procedures, or similar)
Data Modeling: Strong experience with dimensional modeling, star/snowflake schemas, and SCD implementations
ETL/ELT Pipelines: Experience with data pipeline design patterns, CT, and incremental loading strategies
SQL Server: Experience with SQL Server as source system including CDC and Change Tracking
Python: Proficiency in Python for data processing and automation scripts
Preferred
CDC-based ingestion tools (Snowflake OpenFlow, Fivetran, Airbyte, AWS DMS)
SPCS (Snowpark Container Services) for containerized workloads
BI Tools: Understanding of how BI tools (Power BI, Tableau, QuickSight) consume data via DirectQuery/Live Connection
Git: Version control and CI/CD pipelines for data projects
Orchestration tools (Airflow, Dagster, AWS Step Functions) for pipeline scheduling
AWS Services: S3, Glue, Lambda, PrivateLink, VPC connectivity
Snowflake certifications (SnowPro Core, 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