Associate - Visualization CoE (Power BI)

About us

Bain & Company is a global management consulting firm that helps the world’s most ambitious change makers define the future. Across 65 offices in 40 countries, we work alongside our clients as one team with a shared ambition to achieve extraordinary results, outperform the competition and redefine industries. Since our founding in 1973, we have measured our success by the success of our clients, and we proudly maintain the highest level of client advocacy in the industry.

In 2004, the firm established its presence in the Indian market by opening the Bain Capability Center (BCC) in New Delhi. The BCC is now known as BCN (Bain Capability Network) with its nodes across various geographies. BCN is an integral and largest unit of (ECD) Expert Client Delivery. ECD plays a critical role as it adds value to Bain's case teams globally by supporting them with analytics and research solutioning across all industries, specific domains for corporate cases, client development, private equity diligence or Bain intellectual property. The BCN comprises of Consulting Services, Knowledge Services and Shared Services.

Who you will work with

This role is based out of the Visualization Centre of Excellence (CoE) at the BCN. Visualization CoE works closely with global Bain case teams, Bain Partners and end-clients providing them data analytics and business intelligence support using advanced data analysis and visualization tools (e.g., SQL, Python, Azure, AWS, Tableau, PowerBI, Alteryx etc.). The CoE is a one-stop shop for all case requests related to converting data into insightful visualizations tools (e.g., survey analytics, leadership KPI dashboards, etc).

What you’ll do 

• Work with Bain team or end-clients as an expert on Microsoft Power Platforms (Power BI, Power Apps, Power Automate, etc.) in individual capacity or as part of a larger team
• Design, implement, and deploy end-to-end visualization, dashboarding and reporting solutions to address key business problems
• Gather requirements and business process knowledge in order to transform the data in a way that is geared towards the needs of end-users. Responsible for end-to-end handling of the entire process, i.e., requirement gathering, data cleaning, processing, visualization and deployment
• Work under the guidance of a Manager/ Sr. Manager, playing a key role in driving the team’s overall answer, client communication, work planning, and team management
• Lead the design, development, and deployment of Power BI dashboards that deliver intuitive, high-performance data visualizations. You'll create complex data models and write optimized DAX formulas to support self-service reporting and in-depth analysis
• Design and build tailored business applications using Power Apps to automate manual processes. These apps will integrate seamlessly with existing systems, utilizing your expertise in connecting data sources and applying the full capabilities of MS Power Platforms
• Create and maintain dataflows in Power BI Service, leveraging your experience with databases to prepare and cleanse data for reporting
• Automate workflows with Power Automate, allowing seamless integration between different applications, data sources, and business processes
• May also take responsibility for assigning work streams to Analysts, monitor and balance workload; Provide tool-based technical expertise to the team members when required
• Solve complex custom visualization and analysis issues, providing thought leadership and business judgment; Prepare documentation for future references
• Lead client/ case team calls and effectively communicate data, knowledge, insights and actionable next steps to the case team; relay implications to his/ her own internal team
• Keep abreast of new and current data visualization tools & techniques

About you

• Candidate should be a Graduate/ Post-Graduate from Top-tier College with strong academic records and with 3-5 years of relevant work experience in areas related to Data Management, Business Intelligence or Business Analytics. 
• Concentration in a quantitative discipline such as Statistics, Mathematics, Engineering, Computer Science, Econometrics, Business Analytics, or Market Research is strongly preferred 
• Minimum 3+ years of experience in data preparation and visualization using tools such as Microsoft Power Platforms (Power BI, Power Apps, Power Automate, etc.)
• Extensive experience in developing Power BI reports and dashboards, with a focus on data modeling, report performance optimization, and creating interactive visualizations
• Experience in developing custom Power Apps applications is a plus, with an emphasis on integrating Power Apps with diverse data sources, including SQL Server, Dataverse, and external APIs
• Candidates with certifications in PowerBI/ Power Platforms will be preferred
• Familiarity with data governance practices, compliance frameworks, knowledge of Agile methodologies and 
• Must have experience/ ability to work in a fast-paced environment and handle multiple workstreams. Ability to prioritize projects, manage multiple competing priorities and drive projects to completion under tight deadlines
• Should be a motivated and collaborative team player, who is a role-model and at-cause individual within the team 
• Knowledge/ Proficiency in other tools and languages such as Tableau, Python, SQL, understanding of database architecture and ETL tools such as Azure Data factory, Databricks, AWS Glue etc. is a plus
• Excellent oral and written communication skills including the ability to communicate effectively with both technical and non-technical senior stakeholders

What makes us a great place to work