Work with Bain teams as an expert on specific tools, such as Microsoft power platforms (PowerBI, PowerAutomate), SQL, Alteryx and Python to design and deliver impactful business intelligence tools or dashboardsDevelop understanding about the ARC tool and the data fields contained withinWork closely with the case team / end-client / ARC Customer Success team to understand the requirements, build proof of concepts and draw roadmap for output delivery with clear milestonesWork under the guidance of a Senior Associate / Team Manager, playing a key role in driving the team s overall answer and final materials, client communication, work planning, and team managementGather 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 deploymentApply knowledge of data warehousing and visualization to prepare dataflows using SQL, and then developing dashboards using PowerBI, to support case teams with analysis of KPIs and development of commercial dashboardsLead the design, development, and deployment of Power BI dashboards that deliver intuitive, high-performance data visualizations. Youll create complex data models and write optimized DAX formulas to support self-service reporting and in-depth analysisAutomate workflows with Power Automate, allowing seamless integration between different applications, data sources, and business processesSolve complex custom visualization and analysis issues, providing thought leadership and business judgmentBrainstorm any possible roadblocks with the team, providing thought leadership and business judgmentParticipate in case team calls and effectively communicate data, knowledge, insights and actionable next steps to the case team; relay implications to his / her own internal teamAbout you
- Candidate should be a Graduate from a Top-tier College with strong academic records, and with 1-3 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 1 year of experience in data preparation and visualization using tools such as Microsoft Power BI and SQL
- 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, along with knowledge of Alteryx and Python
- Competent with PowerBI Desktop, Gateway, Service and Report Server tools; good understanding of Power Query M-code and hands-on experience in building sophisticated DAX queries
Skills Required
Power Bi, Alteryx, Business Analytics, Power Apps, Power Query, Python, Sql