Sr Data Engineer, Python + Spark (Data Federation skillset - Data Lakehouse - Eg: Starburst) - Chennai
As a Senior Data Engineer, you will be responsible for breaking down data silos. This role focuses on building a unified, high-performance data layer using Data Federation techniques. You won't just move data; you will architect a Data Lakehouse environment where disparate sources feel like a single, cohesive database for our analytics and AI teams.
### Core Responsibilities- Data Federation Architecture: Design and implement federated query layers (e.g., Starburst/Trino) to allow high-speed analytics across distributed data sources without unnecessary data movement.
- ETL/ELT Pipeline Development: Build scalable, distributed data processing pipelines using Python and Apache Spark (PySpark).
- Lakehouse Implementation: Manage and optimize modern table formats like Delta Lake, Apache Iceberg, or Hudi to bring ACID transactions to our data lake.
- Performance Tuning: Optimize Spark jobs and SQL queries across the federation layer to minimize latency and manage compute costs.
- Governance & Security: Implement fine-grained access control and data masking within the federation engine to ensure data privacy across all connected platforms.
- Python & Spark: 5+ years of experience with Python and deep expertise in Apache Spark tuning (partitioning, shuffling, caching).
- Data Federation Tools: Hands-on experience with Starburst Enterprise, Trino (Presto), or Dremio.
- Lakehouse Ecosystem: Proven track record working with Delta Lake or Iceberg architectures.
- Cloud Platforms: Extensive experience with AWS (EMR, S3, Glue), Azure (Databricks, ADLS), or GCP.
- SQL Mastery: Expert-level SQL skills for complex analytical queries and query plan analysis.
- Data Modeling: Proficiency in designing Star/Snowflake schemas and understanding "Medallion Architecture" (Bronze, Silver, Gold layers).
- Experience with Infrastructure as Code (IaC) like Terraform or Pulumi.
- Familiarity with dbt (data build tool) for modeling within the federation layer.
- Knowledge of Kubernetes (K8s) for deploying and scaling Spark/Trino clusters.
-
Background in Data Mesh or Data Fabric methodologies.
Compensation, Benefits and DurationMinimum Compensation: USD
Maximum Compensation: USD
Compensation is based on actual experience and qualifications of the candidate. The above is a reasonable and a good faith estimate for the role.
Medical, vision, and dental benefits, 401k retirement plan, variable pay/incentives, paid time off, and paid holidays are available for full time employees.
This position is not available for independent contractors
No applications will be considered if received more than 120 days after the date of this post
Skills Required
- 5+ years experience with Python
- Deep expertise in Apache Spark tuning (partitioning, shuffling, caching)
- Hands-on experience with Data Federation tools (Starburst, Trino/Presto, or Dremio)
- Proven experience with Lakehouse table formats (Delta Lake or Apache Iceberg or Hudi)
- Extensive experience with cloud platforms (AWS EMR/S3/Glue, Azure Databricks/ADLS, or GCP)
- Expert-level SQL skills for complex analytical queries and query plan analysis
- Proficiency in data modeling (Star/Snowflake schemas) and Medallion Architecture
- Experience building scalable ETL/ELT pipelines using Python and Spark
- Experience implementing governance, fine-grained access control and data masking
- Experience with Infrastructure as Code (Terraform or Pulumi)
- Familiarity with dbt for modeling
- Knowledge of Kubernetes for deploying/scaling Spark/Trino clusters
- Background in Data Mesh or Data Fabric methodologies
What We Do
Photon.com has emerged as one of the world’s largest and fastest-growing Digital Agencies. We work with 40% of the Fortune 100 on their Digital initiatives and are known for our ability to integrate Strategy Consulting, Creative Design, and Technology at scale. Please visit www.photon.com to learn more about us, how we work, and our customer case studies. Digital Transformation Starts Here.









