Senior Data Engineer – BI Analytics & Data Warehousing

Location: Vasanthanagar

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.