Senior Data Engineer-2979 (Remote)

<div><strong>CES</strong> has 26+ years of experience in delivering Software Product Development, Quality Engineering, and Digital Transformation Consulting Services to Global SMEs &amp; Large Enterprises. CES has been delivering services to some of the leading Fortune 500 Companies including Automotive, AgTech, Bio Science, EdTech, FinTech, Manufacturing, Online Retailers, and Investment Banks. These are long-term relationships of more than 10 years and are nurtured by not only our commitment to timely delivery of quality services but also due to our investments and innovations in their technology roadmap. As an organization, we are in an exponential growth phase with a consistent focus on continuous improvement, process-oriented culture, and a true partnership mindset with our customers. We are looking for the right qualified and committed individuals to play an exceptional role as well as to support our accelerated growth. You can learn more about us at: http://www.cesltd.com/</div><div><br></div><div><strong>About the Role:</strong><br>Design, develop, and maintain scalable data pipelines for an enterprise HCM data platform serving K-12 education clients. You will build end-to-end data solutions using modern cloud technologies, implement medallion architecture (Bronze/Silver/Gold), and ensure data quality and governance across the platform.</div><div><br><strong>Key Responsibilities:</strong><br>•<span style="white-space:pre;">&nbsp; &nbsp;&nbsp;</span>Design and implement data ingestion pipelines using CDC/CT (Change Tracking) from SQL Server sources<br>•<span style="white-space:pre;">&nbsp; &nbsp;&nbsp;</span>Build and maintain medallion architecture (Bronze → Silver → Gold) data layers in Snowflake<br>•<span style="white-space:pre;">&nbsp; &nbsp;&nbsp;</span>Develop data transformation models using tools like dbt, AWS Glue, or Snowflake native features (stored procedures, tasks)<br>•<span style="white-space:pre;">&nbsp; &nbsp;&nbsp;</span>Implement SCD Type 1 and Type 2 patterns for historical data tracking<br>•<span style="white-space:pre;">&nbsp; &nbsp;&nbsp;</span>Design and implement Row-Level Security (RLS) for multi-tenant data access<br>•<span style="white-space:pre;">&nbsp; &nbsp;&nbsp;</span>Create and optimize Snowflake objects including tables, views, streams, tasks, and stored procedures<br>•<span style="white-space:pre;">&nbsp; &nbsp;&nbsp;</span>Design data models supporting complex reporting requirements for absence management, workforce analytics, and substitute tracking<br>•<span style="white-space:pre;">&nbsp; &nbsp;&nbsp;</span>Ensure Gold layer is optimized for BI tool consumption (Power BI, Tableau, or other reporting tools)<br>•<span style="white-space:pre;">&nbsp; &nbsp;&nbsp;</span>Establish data quality checks, monitoring, and alerting mechanisms<br>•<span style="white-space:pre;">&nbsp; &nbsp;&nbsp;</span>Document technical designs, data dictionaries, and lineage documentation<br>•<span style="white-space:pre;">&nbsp; &nbsp;&nbsp;</span>Mentor junior team members and conduct code reviews<br><br><strong>Required Skills &amp; Qualifications:</strong><br>•<span style="white-space:pre;">&nbsp; &nbsp;&nbsp;</span>Snowflake: 4+ years hands-on experience with data warehousing, performance tuning, secure views, streams/tasks<br>•<span style="white-space:pre;">&nbsp; &nbsp;&nbsp;</span>SQL: Advanced SQL skills including complex joins, window functions, CTEs, and query optimization<br>•<span style="white-space:pre;">&nbsp; &nbsp;&nbsp;</span>Data Transformation: Experience with any transformation framework (dbt, AWS Glue, Snowflake stored procedures, or similar)<br>•<span style="white-space:pre;">&nbsp; &nbsp;&nbsp;</span>Data Modeling: Strong experience with dimensional modeling, star/snowflake schemas, and SCD implementations<br>•<span style="white-space:pre;">&nbsp; &nbsp;&nbsp;</span>ETL/ELT Pipelines: Experience with data pipeline design patterns, CT, and incremental loading strategies<br>•<span style="white-space:pre;">&nbsp; &nbsp;&nbsp;</span>SQL Server: Experience with SQL Server as source system including CDC and Change Tracking<br>•<span style="white-space:pre;">&nbsp; &nbsp;&nbsp;</span>Python: Proficiency in Python for data processing and automation scripts<br><br><strong>Nice to Have:</strong><br>•<span style="white-space:pre;">&nbsp; &nbsp;&nbsp;</span>CDC-based ingestion tools (Snowflake OpenFlow, Fivetran, Airbyte, AWS DMS)<br>•<span style="white-space:pre;">&nbsp; &nbsp;&nbsp;</span>SPCS (Snowpark Container Services) for containerized workloads<br>•<span style="white-space:pre;">&nbsp; &nbsp;&nbsp;</span>BI Tools: Understanding of how BI tools (Power BI, Tableau, QuickSight) consume data via<br>DirectQuery/Live Connection<br>•<span style="white-space:pre;">&nbsp; &nbsp;&nbsp;</span>Git: Version control and CI/CD pipelines for data projects<br>•<span style="white-space:pre;">&nbsp; &nbsp;&nbsp;</span>Orchestration tools (Airflow, Dagster, AWS Step Functions) for pipeline scheduling<br>•<span style="white-space:pre;">&nbsp; &nbsp;&nbsp;</span>AWS Services: S3, Glue, Lambda, PrivateLink, VPC connectivity<br>•<span style="white-space:pre;">&nbsp; &nbsp;&nbsp;</span>Snowflake certifications (SnowPro Core, SnowPro Advanced Data Engineer) preferred</div><div><br></div><div><strong>Why CES :</strong><br>Flexible working hours to create a work-life balance.<br>Opportunity to work on advanced tools and technologies.<br>Global exposure to not only collaborate with the team, but also to connect with the client portfolio and build professional relationships.<br>Highly encouraged for any innovative ideas &amp; thoughts and we support in executing the same.<br>Periodical and on-spot rewards and recognitions on your performance.<br>Provides a better platform for enhancing skills via many different L&amp;D programs.<br>Enabling and empowering atmosphere to work along.</div>