Data Engineer

Solvative; Ahmedabad District; Remote; INR 1,200,000 - 1,800,000; Full time

Job summary

Solvative in India is seeking a Data Engineer to design, build, and optimize scalable data pipelines using SQL and Python/Scala. You will work with cross-functional teams and directly support US-based clients.

You will own end-to-end pipelines, focus on data quality, governance, and performance, and apply best practices in CI/CD, Git, and IaC.

Qualifications

• SQL proficiency with window functions and query optimization.
• Programming in Python or Scala/Java.
• Experience with ETL/ELT tooling.
• Experience with Spark or Flink.
• Familiarity with cloud data services (AWS/GCP/Azure).
• Understanding of Parquet/Avro/ORC formats.

Responsibilities

• Design, build, and maintain robust batch and streaming data pipelines.
• Write clean, performant SQL and code in Python/Scala/Java.
• Model data with dimensional schemas and data warehouse patterns.
• Own pipelines end-to-end: monitoring, data quality, observability, lineage, cost.
• Read and analyze existing pipelines to debug and improve reliability.
• Collaborate with analysts and data scientists to deliver data products.

Skills

SQL

Python

Scala/Java

Data modeling

Data governance

CI/CD

Git

Tools

Airflow

dbt

Dagster

Luigi

Spark

Flink

Terraform

Docker

Kubernetes

AWS

GCP

Azure

Redshift

BigQuery

Snowflake

Databricks

Job description

Job Title: Data Engineer

Location: Remote (India)

Development Center: Ahmedabad, Gujarat, India

Headquarters: Dallas, USA

Experience: 2+ years

Role Summary

We are looking for a Data Engineer with strong SQL and programming skills who can design,build, and optimize scalable data pipelines and platforms — and who genuinely understands thedata they move. Beyond writing code, you should be able to read and reason about an existing codebase, identify root causes rather than symptoms, and connect engineering decisions back to what the business and the client are actually trying to achieve. You will collaborate with cross-functional teams to deliver reliable, high-quality data solutions while keeping performance, governance, and operational excellence in view.

What You’ll Do

• Design, build, and maintain robust batch and streaming data pipelines from ingestion through transformation to consumption.
• Write clean, performant SQL and code (Python or Scala/Java) that others can read, test,and extend.
• Model data thoughtfully — dimensional models, star/snowflake schemas, and the right warehouse/lake/lakehouse pattern for the problem.
• Own pipelines end-to-end: monitoring, data quality, observability, lineage, and cost.
• Read and analyze existing pipelines and code to debug issues and improve reliability and performance at scale.
• Partner with analysts, data scientists, and business stakeholders to turn ambiguous requirements into dependable data products.

Core Technical Skills

• SQL — SQL proficiency (non-negotiable): window functions, query optimization — not just basic SELECTs.
• Programming — At least one strong programming language: Python or Scala/Java.
• Pipelines — ETL/ELT tooling such as Airflow, dbt, Dagster, or Luigi.
• Distributed processing — Distributed processing with Spark or Flink (Hadoop acceptable for legacy contexts).
• Cloud — Cloud platforms (AWS, GCP, or Azure) and their data services — Redshift,BigQuery, Snowflake, or Databricks.
• Formats — File formats (Parquet, Avro, ORC) and a clear understanding of when andwhy each matters.

Engineering Fundamentals (what Separates Good From Average)

• Version control (Git) and solid CI/CD practices.
• Code quality: testing, modularity, and documentation.
• Infrastructure-as-code (Terraform) and containerization (Docker, Kubernetes).
• Working knowledge of data governance, lineage, privacy, and compliance.

Signals We Look For

• Can explain why a tool was chosen, not just that it was used.
• Evidence of handling scale — data volumes, latency requirements, cost optimization.
• Ownership of end-to-end pipelines rather than isolated, one-off scripts.
• Early leadership instincts: mentoring juniors, improving team practices, or driving a project to completion without being told to.

Watch-Outs

• Buzzword stuffing without depth — lists every tool but can’t go deep on any.
• Only coursework or certifications, with no applied projects.
• Confusing data engineering with data analysis or pure ML work.

Communication & Client-Facing Expectations

This role works directly with US-based clients and stakeholders. Strong communication is a core

Requirement, Not a Nice-to-have

• Fluent, clear written and spoken English, with the ability to explain technical concepts to both technical and non-technical audiences.
• Confident, articulate verbal communication suited to live client conversations, demos, and calls — neutral, easy-to-follow delivery that holds up across US time-zone meetings.
• Active listening: ability to draw out what a client actually needs (often unstated), ask the right clarifying questions, and translate ambiguity into a clear plan.
• Professional, composed presence on calls, with the maturity to manage expectations, disagree respectfully, and keep conversations productive without shutting them down.

Good to have

• knowledge of migrating e-commerce data
• knowledge or working experience with DataBricks.

Who Thrives Here

We care about how people work, not only what they ship. The engineers and analysts who do best at Solvative tend to share a few traits: Ownership without ego — they take end-to-end responsibility and raise the people around them rather than guarding knowledge. Curiosity and depth — they can explain why they made a choice, not just what they used. Directness balanced with empathy — honest, kind communication with teammates and clients alike. A bias toward clarity — they turn messy, ambiguous requirements into something reliable and well-documented.

Why Solvative?

• Top-of-the-line Apple laptops for increased mobility and better productivity.
• Medical insurance for all permanent employees.
• The opportunity to work with an organization that believes in investing in its employees’growth.
• An informal work environment that lets you have fun while being productive.
• Lots of fun activities: we take over a nearby restaurant every last Friday of the month, tickets to all Marvel movies for the entire team, company picnics, and more!