Consultant – Business Intelligence & Data Analytics
Core
Consultant conducting in-depth analyses for management using financial and business data to build comprehensive management reporting for clients.
Role type
Business Intelligence & Data Analytics Consultant
Builds
Financial dashboards, operational performance trackers, and custom data warehouses
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, Machine Learning, Data Extraction
Preferred skills
Microsoft Azure, Coaching junior staff, White paper writing
Technologies
SQL, MySQL, Python, R, C#, Power BI, Tableau, Microsoft Azure, Excel
Responsibilities
Extract data from various systems using tools and custom coding; Mine, analyze, and model large datasets to define database structure; Perform comprehensive data manipulations and transformations using SQL; Use predictive modeling to estimate revenue and business outcomes; Prepare client outputs including business reporting packages and dashboards; Coordinate with client teams to implement models; Develop financial analyses providing actionable insights; Oversee quality control for Analysts; Manage client relationships; Assist with proposals and marketing material development.