Senior Data Engineer (Immediate Joiner)

Vopa; Pune District; On-site; INR 600,000 - 720,000; Full time

Job summary

Vopa in Pune seeks a Senior Data Engineer to independently extract and optimize data from relational databases, build state-level and public-facing Power BI dashboards, and translate complex datasets into decision-ready insights for government and project stakeholders.

The role includes mentoring junior data engineers, collaborating with the project team, and delivering end-to-end data workflows with strong technical, analytical, and communication skills.

Qualifications

• 4–5 years of relevant experience in data extraction, analysis, or dashboard development, preferably using SQL and Power BI in a production environment.
• Demonstrated experience working independently with large datasets and public‑facing dashboards.
• Strong SQL optimization and data modeling skills for Power BI.
• Experience mentoring or guiding junior team members is a plus.

Responsibilities

• Independently extract data from relational databases using optimized SQL (CTEs, subqueries, window functions, various joins).
• Design, build, and maintain Power BI dashboards for state-level and public-facing stakeholders.
• Optimize SQL queries and Power BI data models for performance and reliability across large datasets.
• Clean, transform, and structure data with Excel, Power Query, and Python (Pandas).
• Present data and findings clearly to technical and non-technical audiences on a regular basis.

Skills

Advanced SQL

Power BI

Excel

Python (Pandas)

DAX Measures

Education

Bachelor's or Master's in CS/Stats/IT

Tools

SQL

Python

Job description

We are seeking an experienced Senior Data Engineer to join our Research, Monitoring and Evaluation team. This role involves independently extracting and optimizing data from relational databases, building state-level and public-facing Power BI dashboards, and translating complex datasets into clear, decision-ready insights for government and project stakeholders. The ideal candidate will work independently on end-to-end data workflows, mentor junior team members, and collaborate closely with the project team to ensure timely, high-quality, data‑driven decision‑making. Strong technical, analytical, communication, and coordination skills are essential for success in this role.

Roles and Responsibilities

• Independently extract data from relational databases using advanced, optimized SQL — including CTEs, sub-queries, window functions, and all types of joins.
• Independently design, build, and maintain Power BI dashboards, including public-facing dashboards, for state‑level and project stakeholders, with strong data modeling and DAX‑based measures and KPIs.
• Optimize SQL queries and Power BI data models for performance and reliability across large, production‑scale datasets.
• Clean, transform, and structure data using advanced Excel functions, Power Query, and Python (Pandas) for more complex or repetitive data processing tasks.
• Analyze data to generate periodic insights and inform strategic decision‑making.
• Present data and findings in a clear, easy‑to‑understand form for both technical and non‑technical audiences.
• Independently create appealing presentations and deliver them to internal teams, partners, and government stakeholders.
• Independently create data, M&E, and impact reports for specific teams and projects.
• Support and mentor junior data engineers on SQL, Power BI, and data analysis practices.
• Coordinate with the Project team and district‑level stakeholders to deliver timely, district‑wise data and reports.
• Support and institutionalize robust data management systems and processes across teams.
• Continuously upgrade technical skills and stay current with evolving data tools and best practices.
• Additional responsibilities as needed in response to evolving organizational priorities and project requirements.

Qualifications

• Bachelor's or Master's degree in Computer Science, Statistics, Data Science, Information Technology, or a related field.
• Formal training in SQL, data analytics, data engineering, or related technical tools is preferred.
• 4–5 years of relevant experience in data extraction, analysis, or dashboard development, preferably using SQL and Power BI in a production environment.
• Demonstrated experience working independently with large datasets and public‑facing dashboards.

SKILLS

Technical & Analytical

• Advanced SQL, including query optimization, CTEs, sub‑queries, and window functions, with the ability to independently design and optimize complex queries against production databases.
• Advanced Power BI: independent dashboard creation, including data modeling for table relationships and DAX for calculated measures and KPIs.
• Intermediate Excel: strong command of functions such as IF, COUNTIF, SUMPRODUCT, VLOOKUP, XLOOKUP, FILTER, and SUMIFS, along with Power Query for data cleaning and transformation.
• Working knowledge of Python (Pandas) for data analysis, automation, and building reusable data workflows.
• Understanding of database structures and relational data models.
• Understanding of data visualization and reporting best practices.

Communication & Documentation

• Strong written and verbal communication skills.
• Ability to compile and present findings clearly for internal teams and external stakeholders.
• Documentation and reporting skills with attention to detail.

Project & Coordination

• Ability to work independently and manage end-to-end data extraction, dashboarding, and reporting workflows.
• Ability to coordinate with multiple teams, including state‑level and district‑level stakeholders, and manage timelines for data reporting.
• Experience supporting large‑scale data collection and database or tool standardization efforts.
• Experience mentoring or guiding junior team members is a plus.
• Strong organizational and problem‑solving skills.

Soft Skills

• Adaptability and willingness to work independently in a dynamic team environment.
• Proactive, detail‑oriented, and self‑motivated.
• Ethical handling of data with respect for confidentiality and accuracy.

Other Details

Location

Kothrud, Pune.

Salary :- 6 LPA to 7.20 LPA (Depending on experience, Last Drawn Salary, interview and Skills).