Data Engineer

Job Title: Data Engineer Location: Remote Headquarters: Dallas, USA Development Center: Ahmedabad Job Summary: We are seeking a Data Engineer with strong SQL and programming skills (Python/Scala/Java) to design, build, and optimize scalable data pipelines and data platforms. The ideal candidate has experience with ETL/ELT frameworks, distributed processing technologies such as Spark, and cloud-based data services. You will collaborate with cross-functional teams to deliver reliable, high-quality data solutions while ensuring performance, governance, and operational excellence. Experience: 2 years Core technical skills SQL proficiency (non-negotiable; look for window functions, query optimization, not just basic SELECTs) At least one strong programming language (Python or Scala/Java) Data pipeline/ETL-ELT tools (Airflow, dbt, Dagster, Luigi) Distributed processing frameworks (Spark, Flink, sometimes Hadoop for legacy) Cloud platforms (AWS, GCP, or Azure) and their data services (Redshift, BigQuery, Snowflake, Databricks) Data modeling & architecture Understanding of dimensional modeling, normalization, star/snowflake schemas Experience with both batch and streaming architectures Knowledge of data warehousing vs. data lake vs. lakehouse concepts Familiarity with file formats (Parquet, Avro, ORC) and why they matter Engineering fundamentals (separates good from average) Version control (Git), CI/CD practices Code quality: testing, modularity, documentation Infrastructure-as-code (Terraform) and containerization (Docker, Kubernetes) Understanding of data quality, observability, and monitoring Signals of depth vs. surface knowledge Can they explain why they chose a tool, not just that they used it? Evidence of handling scale (data volumes, latency requirements, cost optimization) Ownership of end-to-end pipelines vs. only writing isolated scripts Awareness of data governance, lineage, and privacy/compliance Soft signals Collaboration with analysts, data scientists, and business stakeholders Ability to translate ambiguous requirements into reliable pipelines Communication clarity in how they describe past work Watch-outs Buzzword stuffing without depth (lists every tool but can’t go deep on any) Only coursework/certifications with no applied projects Confusing data engineering with data analysis or pure ML work Why Solvative? Top-of-the-line Apple laptops for increased mobility and better productivity. Medical insurance for all permanent employees. The opportunity of working with an organization that believes in investing in employees’ growth. An informal work environment that enables you to have fun while being productive. Lots and lots of fun activities: we take over one of the nearby restaurants every last Friday of the month, tickets to all Marvel movies for the entire team, company picnics, and more!