Senior Data Engineer – BI Analytics & Data Warehousing

Confidential Search | Permanent | Pune/Bangalore, India

The Organization

Our client is a rapidly growing technology organisation focused on building innovative solutions across AI, software engineering and enterprise technology. The organisation works with both emerging and established businesses to develop technology solutions that improve efficiency, enable growth and unlock new opportunities through modern digital capabilities.

With a strong culture of innovation, collaboration and high ownership, the organisation is continuing to expand its in-house engineering capabilities and is looking for experienced professionals who enjoy working in a fast-paced, technology-driven environment.

The Opportunity / Role

We are seeking a Senior Data Engineer – BI Analytics & Data Warehousing to contribute to the development of scalable data infrastructure and efficient data pipelines that power business intelligence and analytics.

The role will suit a hands-on Data Engineering professional with 6–9 years of experience across ETL/ELT development, data modelling, SQL and database engineering.

You will work across data ingestion, transformation, warehousing and analytics enablement, helping ensure that data is reliable, accessible and optimised for business use.

Roles & Responsibilities

ETL / ELT Development

Design, build and maintain efficient ETL and ELT pipelines using Azure Data Factory, Databricks or similar orchestration frameworks.
Ensure reliable ingestion of data from multiple sources into centralised data warehouses and data lakes.

Data Modelling & Warehousing

Design relational and dimensional data models aligned with business and analytical requirements.
Develop and maintain data models optimised for analytics and reporting.
Work with modern data platforms such as Snowflake, Redshift and PostgreSQL.

Database Engineering

Develop efficient SQL queries and stored procedures for data transformation, cleansing and aggregation.
Work with complex joins and analytical workloads while supporting data and query performance.

BI & Analytics Support

Support reporting and dashboard development using Power BI, Tableau or similar visualisation platforms.
Collaborate with analysts and business users to understand reporting requirements and enable self-service analytics.

Performance & Data Quality

Monitor and troubleshoot data pipelines and warehouse processes.
Implement appropriate data-quality checks and validations to ensure accurate and timely data availability.

The Candidate

We are looking for a Data Engineering professional who combines strong technical depth with practical experience building and supporting production data environments.

Key Requirements

5–10 years of experience in Data Engineering
Bachelor's degree in Computer Science, Information Systems, Data Engineering or a related field
Hands-on experience in ETL/ELT development and data modelling
Strong SQL skills
Experience with databases such as SQL Server, PostgreSQL, Snowflake or Redshift
Exposure to cloud and data engineering technologies such as:
AWS S3
Azure Data Factory
Databricks
Lambda functions
Familiarity with Python for scripting and data manipulation
Basic understanding of JSON, Parquet and CSV
Exposure to Power BI or Tableau will be an advantage

What Will Differentiate You

Candidates who have experience in building reliable production-grade pipelines, designing analytical data models, troubleshooting data-quality or performance issues, and working closely with analysts and business stakeholders will be particularly relevant.

Senior Data Engineer BI Analytics & Data Warehousing