Consultant | Power BI | Finance Transformation | Finance Strategy

- Location:

Bengaluru

The Team Enterprise Technology and Performance is a Service Area comprising of Consulting professionals providing various service offerings on Finance, Supply Chain, SAP, Oracle and Project/Program Management.

Work youll do

- Design and build multi-page, interactive Power BI dashboards featuring drill-throughs, bookmarks, custom visuals, and role-based filters to deliver tailored, actionable insights for diverse business users.
- Develop complex DAX measures, calculated tables, and time-intelligence functions to support dynamic KPI reporting and scenario modeling directly within the Power BI data model.
- Leverage Power Query (M-Query) to perform advanced data transformationssuch as unpivoting, merging, conditional logic, and parameterization—ensuring source data is cleansed and shaped for optimal dashboard performance.
- Configure and maintain on-premises or cloud Power BI Gateways, automate incremental and full refresh schedules, and troubleshoot connectivity issues to guarantee up-to-date reporting.

- Optimize report and data model performance through query folding, aggregation tables, star-schema design patterns, and best-practice visuals to minimize load times and enhance user experience.
- Partner closely with stakeholders to elicit requirements, design storyboard prototypes, and iterate on layouts and visuals based on user feedback and adoption metrics.

- Architect and implement end-to-end ETL pipelines in Azure Data Factory, orchestrating data ingestion, transformation, delivery, error handling,



and monitoring for reliable data flows.
- Develop and maintain PySpark notebooks on Azure Databricks to execute complex KPI logic, data cleansing, and aggregation workflows, supplemented by SQL scripts to validate ETL outputs and reconcile key metrics.
- Provision, secure, and govern data in Azure Data Lake

Storage Gen2 via Unity Catalog, managing access controls, data lineage, schema evolution, and audit trails in compliance with organizational policies.

- Operate within an Agile/Scrum framework—participating in sprint planning, daily stand-ups, backlog grooming, and retrospectives—and perform root cause analyses to identify data quality and performance issues, implementing preventive measures.
- Act as a thought partner in designing analytics and reporting solutions, including advanced developments like AI/ML, NLP/NLG solutions, recommendation engines, chatbots, and virtual assistants.

- Maintain comprehensive documentation and user guides for created products.
- Follow formal processes for incidents, change requests,

deployments, and service requests.

- Troubleshoot complex issues, provide root cause analysis,

and recommend permanent solutions.

- Identify ways to improve data reliability, efficiency,

and quality. Create well-designed,



testable, and efficient code. Identify bottlenecks and bugs and devise solutions. Ensure processes are documented.

- Work in an agile workplace with the scrum team, actively participating in daily scrums and sprint planning to meet the needs of business teams by delivering solutions.

- Maintain strong collaboration and relationships across the Global Development team, business teams, IT, data modeling, and architecture teams.
- Analyze quantitative and qualitative data to uncover actionable insights
- Develop dashboards, reports, and presentations for leadership and business teams Track key performance indicators (KPIs) and identify trends or anomalies

- Support strategic planning through data-driven recommendations

Key Skills required:

- Overall 3-6 years experience of which minimum 5 years must have been on Power BI and Analytics role
- Hands on experience in Agile/ Scrum Framework
- Power BI Desktop and Service, DAX, Power Query (M)
- Python, Apache PySpark, SQL (T-SQL, ANSI)
- Azure Data Factory, Databricks, ADLS Gen2, Unity Catalog, CI/CD tools (Git, Azure DevOps), data modeling, performance tuning

- Strong problem-solving skills and attention to detail
- Excellent communication and collaboration skills
- Adaptability to changing priorities
- Collaboration in cross-functional teams
- Time management, and a continuous-learning attitude

Education : UG and Above Interested candidates: Please share your updated CV/profile or reach out for further details.

[email protected]

📌 Power Bi Consultant (Bengaluru)
🏢 WSNE Consulting
📍 Bengaluru