Associate Engagement Lead - Data Engineering

ProcDNA Analytics Pvt Ltd; Pune District; On-site; INR 1,000,000 - 1,500,000; Full time

Job summary

A global consulting firm is seeking an experienced data solutions architect to design and implement scalable data processing and BI reporting solutions. The ideal candidate must have 4-5.5 years of experience in building data warehouses and a B.Tech/B.E. degree. Proficiency in SQL and ETL pipeline design is essential, along with hands-on experience with cloud data warehouses like Redshift and Snowflake. This role also involves mentoring a team and managing client stakeholders.

Qualifications

• 4-5.5 years of experience in designing/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/implement complex and scalable enterprise data processing and BI reporting solutions.
• Work towards optimizing overall costs related to system infrastructure.
• Deliver end-to-end data solutions across multiple infrastructures and applications.

Skills

Data Warehousing

Business Intelligence Reporting

SQL

Data Modeling

ETL Pipeline Design

Python

Education

B.Tech/B.E. degree

Tools

Redshift

Azure Data Factory

Snowflake

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 arerobust and scalable for seamless integration and analysis.We are seeking an individual who not only possesses therequisite 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/building 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