Data/Analytics Engineer Data/Analytics Engineer Experience- 5 to 8 Years

Hoonartek; Gurgaon; On-site; INR 1,500,000 - 2,300,000; Full time

Job summary

Hoonartek in India is seeking an Analytics Engineer to provide end-to-end production support for WMS analytics assets. You will maintain reliable data pipelines, accurate reports and reconciliations, and scalable data models across inventory, transfers and assets.

The role emphasizes incident resolution, bug fixes in SQL, dbt, PySpark and Tableau, plus performance tuning and CI/CD deployment. You will collaborate with analytics, engineering and business users to ensure reliable dashboards and

Qualifications

• Strong SQL and data modelling capabilities with data quality checks.
• Experience in production support and incident management.
• Structured troubleshooting across data pipelines and dashboards.
• Experience with dbt models, PySpark transformations and CI/CD.

Responsibilities

• Monitor scheduled data pipelines, dashboards, and data quality checks.
• Investigate and resolve production issues affecting models, pipelines or reports.
• Analyze source-to-report mismatches and apply validated fixes.
• Improve performance of data models and pipelines without changing outputs.
• Support Tableau dashboards and data sources; coordinate with business users.

Skills

SQL & Data Modelling

Production support

Troubleshooting

Tools

dbt

PySpark

Apache Spark

Apache Airflow

Tableau

Git & CI/CD

Job description

We empower enterprises globally through intelligent, creative, and insightful services for data integration, data analytics and data visualization.

Hoonartek is a leader in enterprise transformation, data engineering and an acknowledged world-class Ab Initio delivery partner.

Using centuries of cumulative experience, research and leadership, we help our clients eliminate the complexities & risk of legacy modernization and safely deliver big data hubs, operational data integration, business intelligence, risk & compliance solutions and traditional data warehouses & marts.

At Hoonartek, we work to ensure that our customers, partners and employees all benefit from our unstinting commitment to delivery, quality and value. Hoonartek is increasingly the choice for customers seeking a trusted partner of vision, value and integrity

How We Work?

Define, Design and Deliver (D3) is our in-house delivery philosophy. It’s culled from agile and rapid methodologies and focused on ‘just enough design’. We embrace this philosophy in everything we do, leading to numerous client success stories and indeed to our own success.

We embrace change, empowering and trusting our people and building long and valuable relationships with our employees, our customers and our partners. We work flexibly, even adopting traditional/waterfall methods where circumstances demand it. At Hoonartek, the focus is always on delivery and value.

Job Description

ANALYTICS ENGINEER

WMS Production Support & Optimization

Function

Analytics & Reporting Production Support

Business Domain

WMS Analytics - SCM & Fixed Assets

Role Focus

Production support, bug fixing, minor enhancements, reconciliation and performance optimization

Reports, dashboards, data models, reconciliation assets and scheduled data pipelines

Role Purpose

The Analytics Engineer will provide end-to-end production support and continuous improvement for WMS analytics assets. The role is responsible for maintaining reliable data pipelines, accurate reports and reconciliations, available dashboards, and efficient data models across inventory, transfer orders, capitalization, installation, shipment and business reporting processes.

Key Responsibilities

• Production monitoring: Monitor scheduled data pipelines, report refreshes, dashboard availability and data-completeness controls; identify failures or delays and coordinate timely recovery.
• Incident resolution: Investigate and resolve production issues involving model failures, pipeline failures, report unavailability, incorrect calculations, missing data and dashboard defects.
• Data mismatch and reconciliation support: Analyse source-to-report mismatches and reconciliation discrepancies, isolate the failing logic or data dependency, and implement validated corrections.
• Bug fixing: Deliver durable fixes for defects in SQL logic, dbt models, PySpark transformations, orchestration workflows, dashboard datasets and reconciliation rules.
• Minor enhancements: Implement approved changes to existing reports, dashboards, filters, fields, data models, reconciliation logic and business rules within the agreed scope.
• Performance and technical-debt reduction: Optimise data models, queries and pipelines to improve runtime, stability, maintainability and resource utilisation without changing approved business outputs.
• Dashboard support: Support Tableau dashboards, including data-source validation, refresh troubleshooting, filter/field changes and issue analysis in coordination with business users.
• Root-cause analysis: Prepare clear RCA documentation for significant or recurring incidents, including impact, cause, corrective action, preventive action and dependency tracking.
• Release and CI/CD support: Participate in code reviews, testing, deployment, rollback planning and controlled promotion of fixes and enhancements through CI/CD pipelines.
• Stakeholder coordination: Work with analytics, business, source-system, infrastructure and platform teams to resolve dependencies, upstream data issues and production outages.
• Governance and documentation: Maintain issue trackers, weekly and monthly status inputs, RCA records, runbooks, support procedures and handover material for supported WMS analytics assets.

Required Technical Skills

• SQL and data modelling: Strong hands-on capability in complex SQL, joins, aggregations, window functions, data-quality checks, model design and troubleshooting.
• dbt: Experience developing, testing, debugging and supporting dbt models, dependencies, incremental processing and production deployments.
• PySpark / Apache Spark: Ability to develop and diagnose distributed transformations, investigate performance bottlenecks and optimise Spark workloads.
• Apache Airflow: Experience supporting scheduled workflows, task dependencies, retries, failure analysis, backfills and operational recovery.
• CI/CD: Working knowledge of Git-based development, automated validation, deployment pipelines and controlled release practices.
• Tableau support: Experience supporting dashboards and their underlying datasets, refreshes, fields, filters and report-level issues.
• Reconciliation and data quality: Ability to design and troubleshoot reconciliation logic, completeness checks, duplicate checks and source-to-target validation.
• Production support: Demonstrated experience handling business-impacting incidents, prioritisation, RCA, workaround design and permanent resolution.

Functional and Operational Capabilities

• Ability to understand existing report logic and translate business issues into model-, pipeline- or dashboard-level fixes.
• Structured troubleshooting across source data, transformation logic, orchestration, target tables and presentation layers.
• Strong attention to data accuracy, reconciliation integrity and regression prevention.
• Clear written and verbal communication for incident updates, RCA reviews, blockers, risks and delivery status.
• Ability to work within a fixed scope, distinguish defects from enhancements, and escape out-of-scope requests appropriately.
• Strong ownership of production issues and a quality-focused approach to testing, regression validation and controlled deployment.

Good-to-Have Skills

• Hive and Hive-compatible data warehousing environments.
• Metabase dashboard and report support.
• Experience with WMS, SCM, inventory, transfer orders, shipment, installation, capitalization or fixed-asset analytics.
• Experience optimising large-volume analytical workloads while preserving exact business-rule and report-output parity.