Data Engineer

JOB DESCRIPTION

Summary/Objective:

House of Spices (India) is seeking a Data Engineer to design, build, maintain, and optimize data solutions that support reporting, analytics, and data-driven decision-making across the organization. The ideal candidate will have hands-on experience in T-SQL, Azure Data Services, data warehousing, data modeling, and ETL/ELT development. This role will work closely with BI developers, IT teams, and business stakeholders to develop reliable, scalable, and well-documented data pipelines and data models.

The Data Engineer will help improve data quality, performance, and availability while supporting enterprise reporting needs, including data from Microsoft Dynamics NAV / Business Central and other business systems.
Essential Functions
Data Solution Development:
Build, enhance, and support reliable data solutions for reporting, analytics, and system integration needs.
Create, update, and optimize logical and physical data models to improve data accuracy, scalability, and query performance.
ETL/ELT Development:
Build, maintain, and troubleshoot ETL/ELT processes using T-SQL, Azure Data Factory, Azure Synapse Analytics and other Azure data services.
Monitor, tune, and resolve issues in data pipelines to support reliable processing, timely data availability, and production stability.
Azure Data Engineering:
Develop and support data pipelines using Azure Data Factory and Azure Synapse Analytics.
Desirable:
Support data orchestration and workflow automation using Azure Logic Apps and related Azure services.
Data Warehousing:
Build and maintain data warehouse tables, views, stored procedures, and related objects that support BI and reporting needs.
Tune data warehouse queries and objects to improve report performance, data retrieval, and processing efficiency.
Data Governance & Quality:
Apply data governance, security, and compliance standards while developing and maintaining data solutions.
Develop and run data quality checks, validation rules, and reconciliation processes to maintain trusted and accurate data.
Collaboration & Communication:
Work with BI developers, data scientists, IT teams, and business stakeholders to convert approved requirements into working data pipelines, datasets, and technical deliverables.

Competencies

Teamwork & Collaboration.  Works effectively with BI developers, IT teams, data analysts, business users, and cross-functional stakeholders.
Clear Communication.  Communicates technical information clearly and professionally to both technical and non-technical audiences.
Ethical Handling of Data.  Handles business, customer, financial, and operational data responsibly while following confidentiality, security, and compliance expectations.
Analytical Thinking & Problem Solving.  Investigates data issues, identifies root causes, and applies practical solutions to support accurate reporting and reliable data processing.
Attention to Detail.  Reviews data pipelines, queries, transformations, and outputs carefully to reduce errors and improve data accuracy.
Data Quality Mindset.  Maintains a strong focus on validation, reconciliation, consistency, completeness, and trustworthiness of data.
Technical Troubleshooting.  Monitors, diagnoses, and resolves issues related to data pipelines, SQL queries, performance, and data availability.
Adaptability & Continuous Learning.  Learns new tools, technologies, business processes, and data sources as needed to support changing business and reporting needs.

Supervisory Responsibility
This position is an individual contributor role with no direct reports. The employee may be expected to share knowledge, document best practices, and support knowledge-transfer sessions for team members and business users as needed.
Work Environment
This job operates primarily in a remote professional work environment. The employee is expected to maintain a reliable internet connection, use company-approved collaboration and communication tools, and work effectively with teams across India and U.S. business hours. Based on business requirements, the employee may be required to visit the Mumbai office for corporate meetings approximately one to four times per…