Solvative logo

Data Engineer

Solvative

2 - 4 years

Ahmedabad

Posted:3 days ago

Job Description

Job Title:

Location:

Development Center:

Headquarters:


Experience: 2-4 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 — Azure

• 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, and 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, get tickets to all Marvel movies for the entire team, have company picnics, and more!

Skills Required

SQL Operational Excellence Python Java Data Quality Query Optimization ETL Spark Hadoop Azure Version Control GIT

Job Type

Full Time

Mock Interview

Practice Video Interview with JobPe AI

Start Python Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

coding practice

Enhance Your Python Skills

Practice Python coding challenges to boost your skills

Start Practicing Python Now
Solvative logo
Solvative

RecommendedJobs for You

Meghaz Software Solutions logo

Data Engineer

Meghaz Software Solutions

Bengaluru

Independent Recruitment Consultant (freelancer) logo

Data Engineer

Independent Recruitment Consultant (freelancer)

India

People Tech Technology logo

Data Engineer

People Tech Technology

Hyderabad

WPP logo

Chennai

Krato Solutions logo

Data Engineer

Krato Solutions

Chennai

Applied Systems logo

Data Engineer

Applied Systems

Bengaluru

HP logo

Bengaluru