The Role
Designs and operates scalable Snowflake data platforms, including ingestion pipelines, CDC, ELT, dimensional and medallion models, warehouse administration, security, cost governance, Trino analytics, data quality, observability, and lineage. Partners with engineering, product, BI, and business stakeholders to deliver reliable reporting datasets while supporting PII protection, DPDP compliance, and RBI audit requirements.
Summary Generated by Built In
Key Responsibilities
Data Ingestion & Pipeline Engineering
• Design and build reliable, scalable data pipelines ingesting from PostgreSQL, MySQL, MongoDB, Apache Kafka, and AWS SQS into Snowflake.
• Implement CDC (Change Data Capture) patterns for near-real-time ingestion from transactional Aurora (PostgreSQL and MySQL) databases.
• Build and maintain ELT pipelines using Python and dbt, ensuring data quality, lineage, and observability at every stage.
• Handle schema evolution gracefully across heterogeneous source systems without breaking downstream consumers.
Data Modelling & Warehouse Design
• Design dimensional models, data vault structures, or medallion architecture layers (bronze/silver/gold) in Snowflake suited to SarvaGram's lending, collections, and field operations domains.
• Own the Snowflake warehouse — clustering keys, micro-partition strategy, materialized views, dynamic tables, and cost governance.
• Define and enforce data modelling standards, naming conventions, and documentation practices across all datasets.
Snowflake Administration
• Manage Snowflake account administration — user and role management, RBAC configuration, resource monitors, and virtual warehouse sizing.
• Monitor and govern Snowflake credit consumption — identify expensive queries, configure auto-suspend/auto-resume policies, and right-size virtual warehouses for different workload types.
• Maintain Snowflake security posture — network policies, data masking policies, row access policies, and column-level security for PII fields.
• Manage Snowflake storage — database, schema, and table lifecycle policies, time travel configuration, and Fail-safe awareness.
• Drive Snowflake feature adoption (e.g. dynamic tables, Snowpark) and stay current with platform capabilities relevant to SarvaGram's data stack.
Analytics Layer & Trino
• Maintain and optimise the Trino query layer over Snowflake and other data stores, ensuring performant and cost-efficient analytical queries.
• Collaborate with product and business teams to design semantic layers, aggregated marts, and self-serve datasets for reporting and dashboards.
• Partner with the analytics/BI function to ensure Grafana, Metabase, or equivalent dashboards are backed by well-structured, tested data models.
Data Quality & Observability
• Implement data quality checks, anomaly detection, and freshness SLAs across all critical datasets.
• Build alerting and monitoring for pipeline failures, schema drift, and data volume anomalies.
• Maintain data cataloguing and lineage documentation so that any dataset consumed by product or business is traceable to its source.
Cross-functional Collaboration
• Work closely with backend engineers to understand source system schemas, event structures, and data contracts as new product features are built.
• Translate analytical and reporting requirements from product managers and business stakeholders into well-scoped data engineering deliverables.
• Participate in data governance discussions, especially around PII handling, DPDP compliance, and RBI audit data requirements.
Requirements
Requirements
Must-Have
• 3 to 5 years of hands-on data engineering experience.
• SnowPro Core Certification
• Demonstrable production experience with Snowflake not just familiarity.
• Hands-on Snowflake administration experience — RBAC, resource monitors, virtual warehouse management, and credit governance.
• Working knowledge of Snowflake security features — data masking policies, row access policies, and network policies.
• Strong experience building ELT/ETL pipelines from relational (PostgreSQL, MySQL) and NoSQL (MongoDB) sources.
• Hands-on experience consuming from event streaming systems — Kafka and/or AWS SQS — into a data warehouse.
• Proficiency in Python for data pipeline development and orchestration.
• Experience with Apache Airflow for pipeline orchestration and scheduling.
• Strong understanding of data warehouse design — star schema, dimensional modelling, or medallion/data vault approaches.
• Experience with dbt (data build tool) for transformation, testing, and documentation.
• Advanced SQL skills — window functions, CTEs, query optimisation, execution plan analysis.
• Ability to work directly with non-technical stakeholders — product managers, business analysts, and operations teams — and translate their requirements into data engineering deliverables.
• Strong documentation skills — data dictionaries, pipeline runbooks, model documentation.
Good to Have
• SnowPro Advanced certification (Data Engineer or Architect track).
• Experience with CDC tools such as Debezium or AWS DMS.
• Experience with Trino as a distributed query engine.
• Familiarity with data quality frameworks — Great Expectations, Soda, or dbt tests.
• Exposure to data cataloguing tools — Apache Atlas, Amundsen, or Collibra.
• Understanding of PII masking, data anonymisation, and compliance obligations under DPDP Act and RBI data guidelines.
• Experience in fintech, lending, insurance, or any regulated financial domain.
• Hands-on with AWS services — S3, Lambda, SQS — in a data engineering context.
• Basic familiarity with infrastructure-as-code (Terraform) for data infrastructure.
Who You Are
• A data platform owner who takes pride in reliability, model quality, and data that stakeholders can trust.
• Someone who can sit in a business review and understand what the numbers need to say, then go build the pipeline that produces them correctly.
• Comfortable working across engineering, product, and business — translating between technical constraints and analytical requirements.
• Someone who treats documentation and data contracts as first-class engineering deliverables, not afterthoughts.
• Curious about the fintech and rural finance domain — motivated by the idea that well-engineered data directly influences credit decisions for underserved households.
Preferred Qualification
• Bachelor's or Master's in Computer Science, Engineering, Statistics, or a related quantitative field.
Benefits
Benefits
SarvaGram is on a mission to revolutionize financial services for millions in rural India. We're building the nation's first data-driven platform that combines cutting-edge technology with a human touch to unlock financial possibilities for underserved households.
This is your chance to be at the forefront of innovation. Join us and:
• Shape the future of FinTech: We're not just building a product, we're creating a new category. Be a part of defining the future of financial inclusion for rural India.
• Embrace a high-growth, high-impact environment: This is a non-linear growth opportunity. Build a platform used by millions and witness the network effect drive massive scale.
• Tackle real-world challenges: Apply your skills to solve critical problems and directly empower rural communities.
• Craft solutions that touch lives: Develop innovative products used by diverse household members, each with unique needs.
Skills Required
- 3 to 5 years of hands-on data engineering experience
- SnowPro Core Certification
- Production experience with Snowflake
- Hands-on Snowflake administration experience, including RBAC, resource monitors, virtual warehouse management, and credit governance
- Working knowledge of Snowflake data masking policies, row access policies, and network policies
- Experience building ELT/ETL pipelines from PostgreSQL, MySQL, and MongoDB sources
- Experience consuming Kafka and/or AWS SQS event streams into a data warehouse
- Proficiency in Python for data pipeline development and orchestration
- Experience with Apache Airflow for pipeline orchestration and scheduling
- Understanding of star schema, dimensional modeling, medallion, or data vault warehouse design
- Experience with dbt for transformation, testing, and documentation
- Advanced SQL skills, including window functions, CTEs, query optimization, and execution plan analysis
- Ability to work with product managers, business analysts, and operations teams and translate requirements into data engineering deliverables
- Strong documentation skills, including data dictionaries, pipeline runbooks, and model documentation
- SnowPro Advanced certification in the Data Engineer or Architect track
- Experience with CDC tools such as Debezium or AWS DMS
- Experience with Trino as a distributed query engine
- Familiarity with Great Expectations, Soda, or dbt tests
- Exposure to Apache Atlas, Amundsen, or Collibra
- Understanding of PII masking, data anonymization, DPDP Act, and RBI data guidelines
- Experience in fintech, lending, insurance, or another regulated financial domain
- Hands-on AWS experience with S3, Lambda, and SQS in a data engineering context
- Basic familiarity with Terraform for data infrastructure
- Bachelor's or Master's degree in Computer Science, Engineering, Statistics, or a related quantitative field
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
SarvaGram is India's 1st rural household-centric platform for financial services, risk mitigant & productivity enhancement Farm tools. We provide Loan & Insurance services, currently in the states of Maharashtra, Gujarat, Rajasthan, Karnataka & Telangana. We offer Farm loan, Business loan, Home loan, Consumer durable loan, Personal loan, Gold loan. One-stop-shop for all types of credit needs. Our Insurance partners are HDFC Life, Bajaj Allianz and HDFC ERGO. Farm Mechanization services are provided through our franchisee partners SarvaMitra who is local to your village and has implements for all seasons on pay per use basis. Website http://www.sarvagram.com
