Business Intelligence Consulting Intern supporting RSM clients with SQL, dashboards, data models, and prototypes. Collaborating with consulting teams in a hybrid, client-facing role.
Responsibilities
Execute solution delivery engagements
Discern, define, refine, and document client requirements
Build reports, dashboards, and scorecards using a variety of tools
Provide ongoing support to existing clients
Build demonstration scenarios and prototypes
Collaborate effectively with consultants in other regions and practices
Provide operational support to RSM clients and engagement teams
Travel to assigned client locations as required
Requirements
Working towards B.A. or B.S. degree or equivalent from an accredited university
Currently pursuing or recently completed a Bachelor’s or Master’s degree in Business Administration, Accounting, Computer Science, Data Science/Analytics, Management Information Systems
90 credit hours completed
Developing proficiency with Microsoft SQL Server Database Engine, SQL Server Reporting Services, and SQL Server Integration Services
Ability to work with data visualization tools and dashboards
Strong Excel fundamentals
Experience using T-SQL scripts, including stored procedures, views, and functions
Experience with normalized and de-normalized data models
Experience developing basic web/desktop applications using ASP.NET framework
Ability to communicate effectively in writing and verbally
Ability to interact effectively with internal and external resources
Excellent project management, organization, and follow-up skills
Strong critical thinking and problem-solving skills
Must be a team player able to work in virtual teams and independently
Must have access to and be able to arrange reliable transportation to assigned client locations
Ability to travel up to 25%
Minimum 3.0 GPA preferred
Benefits
Competitive benefits and compensation package
Hybrid workstyle with in-person connection and office alignment
Senior Business Intelligence Analyst improving Cash App reconciliation and financial reporting. Building SQL automation and controls for Block’s global payments ecosystem.
Finance and business intelligence director leading accounting, budgeting, reporting, and analytics for Ontario workplace safety organization WSPS. Supporting strategic decisions, compliance, and enterprise projects.
Business Intelligence Specialist developing BI reporting, dashboards, and analytics for TD’s credit card and personal lending risk teams. Supporting portfolio insights and risk mitigation.
Product Owner shaping enterprise reporting, KPIs, dashboards, and data products for Western Canada’s leading independent appliance retailer. Driving trusted analytics and data - informed decisions across business teams.
HCM & Reporting Analyst supporting Dexterra Group’s Dayforce implementation through reporting, SQL data validation, migration, and Power BI dashboards. Remote role with occasional office trips.
Senior Director leading GS1 Canada’s business intelligence, subscriber analytics, and market insight function. Transforming analytics through AI while guiding enterprise KPIs, executive reporting, and strategic decisions.
Business intelligence and CRM manager optimizing Power BI reporting, data governance, and CRM systems. Supporting O'Dell HVAC Group’s Canada - wide HVAC equipment partnerships and operational growth.
Senior data advisor modernizing Desjardins’s Guidewire Data Studio platform. Designing scalable models, ETL processes, and governed datasets for business teams.
IFRS Reporting Analyst supporting consolidation, intercompany reconciliations, and IFRS reporting for MGID’s global native advertising platform. Improving standardized finance processes across international entities.
Senior Financial Analyst supporting McCarthy Tétrault, a Canadian law firm, with financial reporting, rate analysis, budgeting, and business insights. Automating BI reporting and informing pricing and operational strategy.