DATA ENGINEER
Maxima Apparel •Gurugram, India • Full-time
ROLE OVERVIEW
Shift: Monday–Friday, 6:30 PM – 3:30 AM IST (New York aligned)
Experience: 2–4 years
Location: Gurugram, India (On-site)
Reports To: Sr. Data Manager, Analytics & BI / Director of Data & BI
Maxima Apparel's data infrastructure is growing fast — and it needs careful, skilled hands. We're transitioning to a modern analytics stack: PostgreSQL as our operational backbone, ClickHouse for real-time query performance, and Cube.js as our semantic layer. At the same time, we're rebuilding our entire ERP on Odoo — a Python-based platform running on PostgreSQL — which will become the central system of record across the organization. As our Data Engineer, you'll work with the Sr. Data Manager and Director of Data & BI to maintain and evolve the analytics infrastructure, and partner with the Associate Director of Development leading the Odoo build to own the data layer that connects the ERP to your reporting stack — building Cube.js data models, writing Python scripts to extract and ingest ERP and API data, and helping optimize the databases that everything else depends on.
WHAT YOU'LL DO
Database Performance & Configuration
- Support the Sr. Data Manager in monitoring, tuning, and configuring the central PostgreSQL database.
- Identify and resolve query performance issues; recommend indexing and configuration improvements.
- Maintain and document database schemas, relationships, and access patterns.
- Develop and maintain ClickHouse tables, schemas, and materialized views for real-time analytics performance.
Semantic Layer & Data Modeling
- Build and maintain data models in Cube.js: define cubes, measures, dimensions, joins, and pre-aggregations.
- Collaborate with the BI & Reporting analyst to ensure models are accurate, well-documented, and performant.
- Provide hands-on support for Power BI reporting and dashboard maintenance as needed.
- Evolve the semantic layer as new data sources and business requirements emerge.
Data Pipelines & Integrations
- Develop Python-based scripts to extract and ingest data from Odoo's PostgreSQL database and external APIs into ClickHouse and the analytics layer.
- Design and maintain ETL/ELT pipelines that bring new data sources reliably into the platform.
- Evaluate and integrate new data source types as the business portfolio expands.
- Collaborate with the Odoo ERP implementation team to map, extract, and model ERP data for downstream analytics and reporting.
- Maintain clear documentation for all pipelines, ingestion schedules, and source-to-target mappings.
REQUIRED SKILLS
- Advanced SQL — PostgreSQL required (query optimization, performance tuning, indexing, schema design)
- PostgreSQL administration and monitoring (connection pooling, autovacuum, replication basics).
- Python — REST API integration, ETL scripting, automation
- ClickHouse or other columnar/OLAP databases
- Cube.js or semantic layer modeling experience
- ETL/ELT pipeline design and maintenance
- REST API integration and data ingestion
- Systems thinking with an eye for reliability and maintainability
PREFERRED SKILLS
- ClickHouse schema design and performance optimization.
- Familiarity with Power BI — understanding how downstream BI tools consume data models.
- Odoo experience — understanding the ORM, data model, XML-RPC/JSON-RPC APIs, or custom module development.
- ERP data integration — extracting and modeling operational data (orders, inventory, finance) for analytics.
- Data warehouse design patterns (star/snowflake schemas, slowly changing dimensions).
WHY MAXIMA APPAREL
- Get in at the inflection point — help shape the data architecture as we migrate to a modern analytics stack and rebuild the company's ERP on Odoo.
- Work directly alongside a Sr. Data Manager with 15+ years of experience, hands-on and invested in the team.
- Gain rare full-stack data exposure — from raw API ingestion to semantic modeling to BI delivery.
- A lean team where your decisions have real impact on the systems the whole business runs on.
- Continuous learning: ClickHouse, Cube.js, Odoo, and modern data engineering are central to this role.
