Analyst – Business Intelligence & Data Analytics
Core
Conduct in-depth analyses for management using financial and business data and build comprehensive management reporting for clients.
Role type
Junior Business Intelligence & Data Analytics Analyst
Builds
Financial dashboards, operational performance trackers, and business reporting packages
Domain
Management Consulting / Financial Services
Deliverable
dashboards & analysis
Required skills
SQL, Python, R, C#, Excel (VBA, Macros, Pivots), Data Visualization (Power BI, Tableau), Predictive Modeling, Data Warehousing
Preferred skills
Microsoft Azure, Machine Learning techniques (clustering, decision trees, neural networks), 0-2 years analytical experience
Technologies
SQL, Python, R, C#, Power BI, Tableau, Microsoft Azure, Excel
Responsibilities
Extract data from accounting, operational, and HR systems; Mine and model large datasets to define database structure; Perform data manipulation and transformation using SQL; Use predictive modeling to estimate revenue and business outcomes; Prepare client outputs including dashboards and trackers; Coordinate with client teams to implement models; Develop financial analyses providing actionable insights; Manage client relationships and assist with proposals and marketing materials.
Seniority
Junior, hands-on IC
