Practice Area Analyst Job in Delhi at Boston Consulting Group (BCG)

BCG is hiring for the role of Practice Area Analyst! 

Responsibilities of Candidate: 

• Engage different stakeholders to provide insights for data-driven decision-making on wide-ranging use cases
• Support forecasting revenue and business momentum based on investment data, YTD status and pipeline in collaboration with topic managers and Finance departments
• Analyze the composition of the PA portfolio across various parameters (e.g., region, system, topic, business, IPA)
• Monitor and develop (where appropriate) key performance indicators (e.g. NCC, price points, global and local investments, global pro bono partners budgets, win rates and commercial performance insights, competitors’ monitoring, etc.); this requires working collaboratively with local, regional and global stakeholders addressing a broad set of internal and external metrics and bringing together different data sources and tools into aggregated views
• Define relevant metrics and influence key stakeholders with actionable insights
• Execute defined tasks independently, seeking guidance as needed
• Solve problems with a forward-thinking mindset, suggesting workarounds and bringing excellent organization skills
• Develop judgment and think analytically through alternatives.

Requirements: 

• Business and Financial reporting and analysis
• All aspects of data analytics including mining, scrubbing and visualization
• Understanding popular data analysis tools and databases Visualization, storytelling, and best practices to convey insights in an intuitive and visually compelling way
• Bachelor’s degree with 2-4+ years relevant experience
• Experience in data visualization using Tableau (Tableau Desktop and Server) and Tableau certification will be a plus
• Strong analytics concepts and have applied the same in past projects (example: data correlation, forecasting, creating complex visuals and usage of tableau extensions)
• Good SQL & data warehouse skills (comfortable with writing SQL codes, nested queries, creating table/views)
• Ability to work with large data sets both structured and unstructured data
• Professional experience in building robust data pipelines using ETL tools (e.g., Alteryx, Power BI)
• Excellent written and verbal communication skills
• Professional, service oriented, proactive and flexible attitude
• Proficiency in Outlook, PowerPoint, and Advanced Excel is a must