Job ID 203 - Software Consultant (Data Engineer)

energytec.ai; Hyderabad; On-site; INR 2,800,000 - 4,200,000; Full time

Benefits offered by this job

Growth academy and internal career机会

Five extra days of paid leave every ye

Volunteer day each year

Parental leave above legal

Job summary

energytec.ai (eTEC) in Hyderabad is seeking a Software Consultant - Data Engineer to design and deliver scalable data engineering solutions for our product platform. You will apply an AI-first mindset to accelerate delivery, improve quality, and strengthen platform resilience.

Responsibilities include ETL/ELT pipelines, SQL optimization, AWS data services, and CI/CD with Terraform. You will work in a hybrid setup with cross-functional teams to build secure, scalable data solutions.

Qualifications

• 5+ years of hands-on data engineering experience with production ETL/ELT pipelines.
• Strong Python programming with Pandas for data manipulation.
• Advanced SQL with PostgreSQL and Trino; dimensional modeling experience.
• Experience building cloud data infra on AWS (S3, Glue, Athena).
• Infrastructure as code with Terraform.
• Experience in Agile delivery within teams.

Responsibilities

• Design, develop, and operate ETL/ELT pipelines using Python (Pandas).
• Write performant SQL for PostgreSQL and Trino; maintain dimensional models.
• Architect and manage AWS data solutions (S3, Glue, Athena).
• Build IaC with Terraform and CI/CD pipelines on AWS.
• Embed security and governance in the SDLC.
• Collaborate with cross-functional teams to translate requirements into components and dashboards.

Skills

Python

Pandas

PostgreSQL

Trino

Terraform

AWS

S3

Glue

Athena

Agile

Tools

Terraform

AWS

S3

Glue

Athena

Superset

Job description

Job ID 203 - Software Consultant (Data Engineer)

We exist to make it better.

We’re a new generation software company based in Hyderabad, helping to scale digital businesses to disrupt global utility retail markets. We provide technology development, customer experience and process optimisation services to support our award‑winning utility retailers in New Zealand and Australia.

It’s an exciting time where traditional utilities need to innovate. Consumers expect companies to do good for their employees, customers, local communities, and for the future of the planet (all while offering seamless user experience that’s great value). Our strategy recognises that the exceptional technology we create makes us one of the best consumer facing businesses in our industry.

Our Culture: The “Real” Deal

We don’t just build software; we build careers through our Employee Value Proposition (EVP):

• Real Growth: Learning is integral to delivery. We provide clear pathways and role‑based upskilling and certifications.
• Real Care: energytec elevate (e²): 3 hours of protected in-work learning time each week to enable sustainable high performance, continuous development, and long‑term career growth; we value sustainable impact over burnout.
• Real Impact: Turn your learning into a legacy. Work with Practice Champions to strengthen our platform architecture and reduce dependencies.

Job Description

Software Consultant - Data Engineer

About the Role

We are looking for a Software Consultant - Data Engineer to contribute to the development and delivery of scalable, secure, and reliable data engineering and software solutions for our product platform.

At energytec.ai (eTEC), we build with an AI‑first mindset, operating as a human‑led, agent‑operated organization where engineers own outcomes and use AI responsibly to accelerate delivery, improve quality, and strengthen platform resilience.

• Apply AI across the entire software development lifecycle (SDLC), utilizing it for design assistance, coding, test generation, security checks, documentation, incident summarization, and runbook automation.
• Guardrails & Governance: You will maintain non‑negotiable guardrails for code reviews, security and privacy controls, and governance, while measuring impact through SLOs, DORA metrics, and cost/performance outcomes.
• Knowledge Sharing: You will actively share knowledge and standardize prompts, playbooks, and reusable automation to multiply overall team effectiveness.

Responsibilities

• Data Pipeline Engineering: Design, develop, and operate ETL/ELT pipelines using Python (Pandas) to meet strict SLOs for freshness, latency, and completeness.
• Data Modeling & SQL Optimization: Write performant SQL for PostgreSQL and Trino, while implementing and maintaining dimensional models and curated datasets.
• Cloud Architecture & Optimization: Architect and manage AWS data solutions (S3, Glue, Athena), optimizing for scalability, resiliency, performance, and cost.
• Infrastructure as Code & CI/CD: Build infrastructure as code with Terraform and implement automated CI/CD pipelines on AWS for testing, security scans, and deployment.
• Security & Vulnerability Management: Embed a security‑first mindset in the SDLC using least‑privilege IAM, secure coding, secrets management, and encryption.
• Collaboration & Analytics Support: Collaborate with cross‑functional product, analytics, and engineering teams to translate business requirements into maintainable components and self‑service Superset dashboards.

Minimum Qualifications

• Core Experience: 5+ years of hands‑on data engineering experience building and operating production‑grade ETL/ELT pipelines.
• Language Proficiency: Strong programming proficiency in Python, with deep, proven experience using the Pandas library for data manipulation.
• Advanced Database Skills: Advanced SQL development capabilities utilizing PostgreSQL and Trino, alongside practical experience in dimensional modeling.
• AWS Data Services: Proven experience implementing cloud data infrastructure using core AWS services, specifically S3, Glue, and Athena.
• Infrastructure Tools: Hands‑on experience writing, versioning, and managing cloud infrastructure as code (IaC) using Terraform.
• Agile Delivery: Track record of working effectively within Agile teams to consistently ship high‑quality deliverables every sprint.

Preferred Qualifications

• Advanced AWS Ecosystem Knowledge: Extended exposure to broader AWS services including Lambda, Secrets Manager, RDS, DynamoDB, Lake Formation, DMS, and API Gateway.
• AI‑Assisted Development: Experience leveraging AI‑powered tools in coding, testing, deployment, and monitoring to maximize development efficiency and delivery speed.
• Modern Visualization Tools: Familiarity with creating and maintaining visualizations and dashboards in Superset or similar business intelligence tools.
• DevSecOps Integration: Experience integrating automated security checks and vulnerability remediation directly into active CI/CD pipelines.
• Business Acumen: Demonstrated strength in bridging the gap between complex business requirements and scalable, well‑designed technical components.
• Communication & Collaboration: Excellent written and verbal communication skills with a proven ability to manage stakeholders and align with cross‑functional teams.

Work Mode: Hybrid (1 day WFH, 4 days WFO)

Notice Period: Looking for candidates who can join within 30 days.

Benefits

• Growth academy and internal career opportunities - we grow our people while we grow our company
• Five extra days of paid leave every year to do the things that matter to you
• A paid volunteer day every year to give back to your community
• Parental leave that’s above and beyond legal requirements