Data Engineer

Data Engineer - Maxima Apparel - Gurugram, India

Maxima Apparel is seeking a skilled Data Engineer with 2-4 years of experience to join our growing team in Gurugram, India. This is a full-time, on-site position aligned with a Monday-Friday, 6:30 PM – 3:30 AM IST shift, working in tandem with New York hours. You will report to the Sr. Data Manager, Analytics & BI or the Director of Data & BI.

Our data infrastructure is rapidly evolving. We are transitioning to a modern analytics stack featuring PostgreSQL as our operational backbone, ClickHouse for high-performance real-time queries, and Cube.js as our semantic layer. Concurrently, we are rebuilding our entire ERP system on Odoo, a Python-based platform that will serve as our central system of record. As a Data Engineer, you will play a crucial role in maintaining and enhancing our analytics infrastructure. You will collaborate closely with the Associate Director of Development to own the data layer connecting the ERP to our reporting stack, developing Cube.js data models, writing Python scripts for data extraction and ingestion from ERP and APIs, and optimizing critical database performance.

Key Responsibilities:

Database Performance & Configuration

• Assist in monitoring, tuning, and configuring the central PostgreSQL database.
• Diagnose and resolve query performance issues, recommending indexing and configuration enhancements.
• Manage and document database schemas, relationships, and access patterns.
• Develop and manage ClickHouse tables, schemas, and materialized views to ensure optimal real-time analytics performance.

Semantic Layer & Data Modeling

• Construct and maintain data models within Cube.js, defining cubes, measures, dimensions, joins, and pre-aggregations.
• Partner with the BI & Reporting analyst to ensure data model accuracy, documentation, and performance.
• Provide direct support for Power BI reporting and dashboard maintenance as required.
• Continuously evolve the semantic layer to accommodate new data sources and evolving business needs.

Data Pipelines & Integrations

• Create Python scripts for extracting and ingesting data from Odoo's PostgreSQL database and external APIs into ClickHouse and the analytics layer.
• Design and maintain reliable ETL/ELT pipelines for incorporating new data sources.
• Evaluate and integrate diverse new data source types as our business expands.
• Collaborate with the Odoo ERP implementation team to map, extract, and model ERP data for analytics and reporting purposes.
• Maintain comprehensive documentation for all pipelines, ingestion schedules, and source-to-target mappings.

Required Skills:

• Advanced SQL proficiency, particularly in PostgreSQL (query optimization, performance tuning, indexing, schema design).
• Experience with PostgreSQL administration and monitoring (connection pooling, autovacuum, basic replication).
• Python scripting for REST API integration, ETL processes, and automation.
• Experience with ClickHouse or similar columnar/OLAP databases.
• Proficiency with Cube.js or other semantic layer modeling tools.
• Solid understanding of ETL/ELT pipeline design and maintenance.
• Experience with REST API integration and data ingestion techniques.
• Strong systems thinking with a focus on reliability and maintainability.

Preferred Skills:

• Expertise in ClickHouse schema design and performance optimization.
• Familiarity with Power BI and understanding of how BI tools consume data models.
• Experience with Odoo, including its ORM, data model, APIs (XML-RPC/JSON-RPC), or custom module development.
• Experience integrating ERP data (orders, inventory, finance) for analytical purposes.
• Knowledge of data warehouse design patterns such as star/snowflake schemas and slowly changing dimensions.

Why Maxima Apparel:

• Opportunity to shape data architecture at a pivotal stage of company growth and technological adoption.
• Work closely with an experienced Sr. Data Manager dedicated to team development.
• Gain comprehensive full-stack data experience, from ingestion to semantic modeling and BI delivery.
• Join a lean team where your contributions have a significant impact on core business systems.
• Engage in continuous learning with exposure to ClickHouse, Cube.js, Odoo, and modern data engineering practices.