Job ID 203 - Software Consultant (Data Engineer)

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.

AI-first engineering at energytec.ai

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 enginee