Role Overview
AIVION
is expanding its Data & AI consulting capability and is looking for a
Data Engineer
with 4+ years of experience to support client delivery across data engineering, analytics, reporting, and modern data platform projects.
This role will be particularly useful as
AIVION
opens new client accounts, where clients need support with data pipelines, data warehousing, reporting datasets, analytics platforms, and AI-ready data foundations.
The ideal candidate should have strong SQL skills, practical data engineering experience, and the ability to work with cloud data platforms, ETL/ELT tools, reporting datasets, and business-facing data requirements.
Key Responsibilities
Data Engineering & Pipeline Development
- Build, maintain, and optimise data pipelines from multiple source systems into centralised data platforms.
- Develop ingestion, transformation, validation, and reconciliation processes.
- Work with structured and semi-structured data from databases, files, APIs, SharePoint, Excel, and other business systems.
- Support the creation of staging, canonical,
history, and reporting layers.
- Implement reusable data engineering patterns and maintain clean, well-documented code.
SQL, Data Modelling & Transformation
- Write productive SQL queries, stored procedures, views, and transformation logic.
- Support dimensional modelling and reporting data model design.
- Build data marts and curated datasets for business reporting, dashboards, and analytics.
- Apply data quality checks, exception handling, and validation rules.
- Support transformation frameworks such as DBT or similar tools.
Cloud Data Platform Support
- Work with cloud data platforms such as Snowflake, Azure SQL, PostgreSQL, or similar.
- Support data loading, scheduling, orchestration, and monitoring.
- Assist with platform configuration, access control, performance tuning, and cost-aware design.
- Work with ETL/ELT tools such as Matillion, DBT, Azure Data Factory, Airflow, or similar te
📌 Data Engineer (Ambala)
🏢 AIVION
📍 Ambala