IAssess Consultants LLP
Website:
iassess.in
Job details:
Job Title: Data Engineer
Location City: Gurugram
Industry: Research and Advisory Services
Role Overview
We are looking for a Senior Data Engineer (7–10 years) to play a foundational role in
building Everest Group’s greenfield, Snowflake-based enterprise data platform.
This role is hands-on and ownership-driven, with a strong focus on:
Ingesting data from enterprise SaaS platforms Building scalable Snowflake ELT pipelines
Designing analytics-ready data models Owning the initial Snowflake platform foundations
in collaboration with architecture leadership The ideal candidate has deep experience
integrating CRM and marketing systems via APIs, is comfortable operating production-
grade data pipelines, and can make sound decisions around performance, cost, and
reliability.
Key Responsibilities
- SaaS Data Ingestion & Integration (Primary Focus) Design, build, and maintain
Robust Data Ingestion Pipelines From Enterprise SaaS Platforms, Including
Salesforce (CRM)
NetSuite (Finance)
Marketing and RevOps tools such as Marketo, 6sense, Gong
SharePoint (files, metadata, permissions)
Develop API-based Ingestion Frameworks Handling
Authentication and authorization
Pagination, rate limits, retries, and failures
Incremental loads, soft deletes, and historical tracking
Schema evolution and upstream source changes
- Snowflake Data Engineering & Transformation Design and implement scalable
ELT pipelines within Snowflake Write high-quality, optimized SQL for complex
transformations Build and manage data layers including raw, staged, and curated datasets
Optimize Snowflake warehouses, storage, and query performance with a strong focus on
cost efficiency
- Data Modeling & Analytics Enablement Design and maintain analytical data
Models Including
Fact and dimension tables
Star and snowflake schemas
Slowly Changing Dimensions (SCD Type 1 and Type 2) Ensure data models support
reporting, dashboards, and research analytics Partner with analytics and research teams to
deliver analytics-ready, well documented datasets
- Platform Ownership, Reliability & Governance Own end-to-end pipeline
reliability including scheduling, monitoring, alerting, and recovery Implement data quality
checks for accuracy, completeness, and freshness
Support Snowflake Platform Foundations Including
Warehouse and environment strategy (dev/test/prod)
Role-based access control (RBAC) Secure handling of sensitive HR and finance data (PII)
Troubleshoot and resolve data issues across ingestion, transformation, and consumption
layers
- Collaboration & Engineering Best Practices Collaborate closely with analytics,
research, product, and technology stakeholders to translate business needs into data
solutions Contribute to data platform architecture discussions and continuous
improvement initiatives
Maintain clear documentation for pipelines, data models, and data flows
Follow modern engineering practices including Git-based version control and CI/CD
workflows
Education And Experience
Bachelor’s or master’s degree in computer science, Information Technology, Engineering,
Mathematics, or related field.
7–10 years of hands-on experience in data engineering or similar roles
Strong hands-on expertise with Snowflake, including ingestion, transformations, and
performance optimization
Proven experience ingesting data from SaaS platforms via APIs (HR, CRM, or Marketing
systems)
Advanced SQL skills and strong understanding of relational databases and data modeling
Strong Python experience for API integration, data ingestion, and automation Experience
with cloud platforms (Azure preferred; AWS/GCP acceptable)
Experience with orchestration or transformation tools such as dbt, Azure Data Factory, or
similar
Strong problem-solving skills, ownership mindset, and attention to detail
Excellent communication skills and ability to collaborate with technical and non-
Skills: data models,snowflake,pipelines,data engineering,saas,etl,data operations,python,data engineer
Click on Apply to know more.