Associate Engagement Lead - Data Engineering

ProcDNA; Maharashtra; On-site; INR 800,000 - 1,200,000; Full time

Job summary

A global consulting firm is seeking a skilled individual to design and implement complex data processing and reporting solutions. This role involves building and optimizing ETL pipelines, managing junior associates, and ensuring robust data integration. Candidates should have 4-5.5 years of experience in data warehousing and BI reporting, along with strong cloud data warehouse skills in Redshift, Azure Data Factory, and Snowflake. A B.Tech/B.E. degree is required, and Python proficiency is a plus.

Qualifications

• 4-5.5 years of experience in designing and building data warehouses and BI reporting.
• Prior experience in managing client stakeholders and junior team members.
• Extensive hands-on experience with cloud data warehouses.

Responsibilities

• Design and implement complex and scalable enterprise data processing solutions.
• Build and optimize ETL pipelines to enhance data warehouse systems.
• Coach and manage a team of junior associates.

Skills

Reporting

Data Warehousing

ETL

Education

B.Tech/B.E. degree from a reputed institution

Tools

Redshift

Azure Data Factory

Snowflake

SQL

Python

Job description

About ProcDNA

ProcDNA is a global consulting firm. We fuse design thinking with cutting‑edge technology to create game‑changing Commercial Analytics and Technology solutions for our clients. We’re a passionate team of 350+ across 6 offices, all growing and learning together since our launch during the pandemic. Here, you won’t be stuck in a cubicle; you’ll be out in the open water, shaping the future with brilliant minds. At ProcDNA, innovation isn’t just encouraged—it’s ingrained in our DNA. Ready to join our epic growth journey?

What We Are Looking For

You’ll build and maintain systems for efficient data collection, storage, and processing to ensure data pipelines are robust and scalable for seamless integration and analysis. We are seeking an individual who not only possesses the requisite expertise but also thrives in the dynamic landscape of a fast‑paced global firm.

What You’ll Do

• Design/implement complex and scalable enterprise data processing and BI reporting solutions.
• Design, build, and optimize ETL pipelines or underlying code to enhance data warehouse systems.
• Work towards optimizing the overall costs incurred due to system infrastructure, operations, change management, etc.
• Deliver end‑to‑end data solutions across multiple infrastructures and applications.
• Coach, mentor, and manage a team of junior associates to help them plan tasks effectively.
• Demonstrate overall client stakeholder and project management skills.
• Build strong partnerships with other teams to create valuable solutions.
• Stay up to date with the latest industry trends.

Must have

• 4‑5.5 years of experience in designing/built data warehouses and BI reporting
• B.Tech/B.E. degree from a reputed institution
• Prior experience in managing client stakeholders and junior team members
• Extensive hands‑on with cloud data warehouses like Redshift, Azure Data Factory, Snowflake, etc. and Proficiency in SQL, Data Modeling, and designing ETL pipelines is a must.
• Immediate to expert level proficiency in Python is a plus

Skills: reporting,data warehousing,etl