Job Description:
Data Engineer (Azure, Real-Time, Analytics & Data Platforms)

Role Summary

We are seeking a skilled and detail-oriented Data Engineer to design, build, and maintain scalable data systems that power analytics, reporting, and enterprise applications. This role is responsible for implementing robust data pipelines, database solutions, and integration frameworks, ensuring high data quality, reliability, and performance across platforms.

The ideal candidate will bring robust expertise in data architecture, ETL/ELT development, and database engineering, with the ability to work across cross-functional teams to deliver production-grade data solutions.

Core Responsibilities

Data Architecture & Modeling
- Design and maintain enterprise data models supporting SaaS applications and reporting platforms
- Develop logical and physical database architectures
- Design normalized and denormalized schemas based on performance requirements
- Define data standards, naming conventions, and governance frameworks
- Design scalable, multi-tenant data structures





Database Engineering & Performance Optimization
- Develop complex SQL queries, views, stored procedures, and functions
- Analyze query execution plans and implement performance tuning strategies
- Design indexing strategies to optimize data access and performance
- Resolve database bottlenecks, locking, and contention issues
- Implement partitioning and archival strategies for large datasets
- Monitor and tune database performance in production environments

Change Data Capture (CDC) & Incremental Processing
- Design and implement CDC frameworks for near real-time data synchronization
- Build incremental data processing pipelines to optimize performance
- Track inserts, updates, and deletes across source systems
- Implement reconciliation processes to ensure data consistency
- Maintain data lineage and change tracking across systems
- Support event-driven and near real-time data architectures

ETL / ELT Enginee

📌 Data Engineer (Bengaluru)
🏢 Dentsu (ANZ) Management Services
📍 Bengaluru