Data Engineer Lead/Architect

Pune
March 25, 2026
Full Time
Apply Now

Job Description

This role focuses on designing and implementing Business Intelligence (BI) and Data Warehouse (DWH) solutions that help organizations make data-driven decisions. The position requires strong experience in BI architecture, ETL pipelines, data modeling, and visualization tools. The candidate will lead data engineering initiatives, collaborate with stakeholders, and mentor junior team members while ensuring scalable and high-performance analytics solutions.

Role Details

  • Role: Analytics / BI Manager
  • Industry Type: IT Services & Consulting
  • Department: Data Science & Analytics
  • Employment Type: Full Time, Permanent
  • Experience: 6–12 years
  • Education: B.Tech / BCA / B.Sc in Computer Science or related field

Key Responsibilities

BI Architecture and Data Warehouse Design
Design and implement scalable BI and Data Warehouse solutions using tools like Power BI and Tableau. Translate business requirements into technical architecture.

Data Integration and ETL
Manage ETL processes using SQL Server Integration Services to ensure efficient data extraction, transformation, and loading into data warehouses.

Data Modeling
Create and maintain data models that support reporting and analytics requirements.

Database Management
Write complex SQL queries, stored procedures, and manage transformations using joins and cursors. Maintain SQL Server databases.

Visualization Development
Develop dashboards and reports in Power BI and Tableau following data visualization best practices.

Collaboration
Work with stakeholders to gather requirements and convert them into technical specifications.

Performance Optimization
Analyze and optimize BI solutions for performance and scalability.

Data Governance
Implement data quality and governance practices to ensure accurate reporting.

Team Leadership
Guide and mentor junior BI developers and analysts.

Cloud and Analytics
Use Azure Databricks for data processing and analytics integration.

Required Skills and Experience

  • 6–12 years of experience in BI architecture and development
  • Strong knowledge of SQL Server and database management
  • Experience with ETL processes and SSIS
  • Python for exploratory data analysis
  • Knowledge of CRISP-DM methodology
  • Experience working with different data models
  • Familiarity with Snowflake, PostgreSQL, Redshift, and MongoDB
  • Experience with version control and collaborative development

Technical Skills

Programming and Data Analysis

  • Python (Pandas, NumPy, PySpark)
  • SQL

Data Engineering

  • Airflow for workflow orchestration
  • ETL pipeline development

Visualization Tools

  • Power BI
  • Tableau
  • QuickSight
  • Plotly or Dash

Cloud Technologies

  • AWS S3
  • AWS Lambda
  • Azure Databricks

Preferred Skills

  • Azure SDK
  • REST API integration
  • Web scraping
  • Advanced BI architecture experience

Key Skills

Data Modeling, Data Warehousing, ETL, SSIS, SQL, Azure Databricks, Data Pipeline, BI Architecture

Related Jobs