Deloitte—Consultant | Power BI | Bengaluru | Finance Transformation | Finance Strategy

Job description

Description: Consultant | Power BI | Bengaluru | Finance Transformation | Finance Strategy • Job requisition ID : 107108 • Location: Bengaluru • Entity: Deloitte Touche Tohmatsu India LLP 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 you’ll 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 transformations—such 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 environment 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 How you’ll grow At Deloitte, our professional development plan focuses on helping people at every level of their career to identify and use their strengths to do their best work every day. From entry-level employees to senior leaders, we believe there’s always room to learn. We offer opportunities to help build world-class skills in addition to hands-on experience in the global, fast-changing business world. From on-the-job learning experiences to formal development Programs at Deloitte University, our professionals have a variety of opportunities to continue to grow throughout their career. Explore Deloitte University, The Leadership Centre. Benefits At Deloitte, we know that great people make a great organization. We value our people and offer employees a broad range of benefits. Learn more about what working at Deloitte can mean for you. Our purpose Deloitte is led by a purpose: To make an impact that matters. Every day, Deloitte people are making a real impact in the places they live and work. We pride ourselves on doing not only what is good for clients, but also what is good for our people and the communities in which we live and work—always striving to be an organization that is held up as a role model of quality, integrity, and positive change. Learn more about Deloitte's impact on the world Recruiter tips We want job seekers exploring opportunities at Deloitte to feel prepared and confident. To help you with your interview, we suggest that you do your research: know some background about the organization and the business area you’re applying to. Check out recruiting tips from Deloitte professionals.