About the role :

Summit Consulting builds Global Capability Centers (GCCs) in India for private equity firms, their portfolio companies and midmarket clients. We are hiring a Senior Analyst with two equal halves to the job: owning our talent acquisition (TA) and HR operations reporting in Power BI, and building GenAI-based automation across our delivery work.

On the BI side, you take raw tracker data to client-ready dashboards and PPT outputs. On the automation side, you use GenAI tools and workflow automation to remove manual effort from recurring work such as reporting, document generation and data standardization. You will work directly with the manager who leads the workstream, and your outputs go to client leadership.

This is a hands-on role for someone who builds, takes feedback, and delivers to a standard without being walked through each step.

What you will do

Power BI and reporting

- Design and build Power BI data models (star schema, relationships, DAX measures) for TA and HR operations reporting across client engagements
- Clean and standardize messy tracker data in Power Query and Excel, log data issues with a workaround, and keep building without waiting on upstream fixes
- Build client-ready dashboards and PPT exports to a consulting-grade visual standard, replicating approved templates and palettes exactly
- Reconcile every number to source before it goes out, and document measures, data dictionaries and refresh steps

GenAI and automation

- Identify repetitive work across TA, HR operations and consulting delivery, and turn it into automated workflows
- Build GenAI-based solutions using LLM tools, Copilot and prompt design, for tasks such as data standardization,



job title classification, summarization and drafting
- Build document and report generation flows using Power Automate, Word and PPT templates, SharePoint and Excel Online
- Test outputs for accuracy, write short usage guides, and keep the automations running as source data and requirements change

Ways of working

- Share progress in short written updates, flag risks to timelines at least a day ahead, and close feedback items fully before the next review

What you bring

- 3 to 5 years of experience in analytics, BI, reporting or automation, ideally in consulting, HR/TA analytics or shared services
- Power BI: a portfolio of live work that you built yourself. You can walk us through the data model, the DAX and why you made each design choice
- GenAI and automation: at least one automation you built and shipped using LLM tools, Copilot or Power Automate. You can explain what it replaced, how you tested it and where it fails
- Strong Power Query and advanced Excel skills for cleaning and standardizing large, inconsistent datasets
- An eye for consulting-grade output: clean layouts, consistent palettes, and PPT and dashboard pages that are client-ready on the first pass
- A record of acting on feedback. You close every comment, not most of them, and you can show an example
- Ownership of your timelines. You commit to dates you can meet, and you tell us early when one is at risk

Positive to have

- Python for automation, including python-pptx or python-docx for generated decks and documents
- Power Apps or agentic AI platform experience
- Exposure to TA, HR operations or hiring funnel data (requisitions, pipeline stages, offers, time to fill)

📌 Senior Analyst_Power BI (Bengaluru)
🏢 Summit Consulting Services
📍 Bengaluru