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.
Responsibilities
Develop, implement, and maintain O'Dell's Microsoft Power BI reporting environment, including dashboards, scorecards, and management reports
Establish standardized KPIs, reporting methodologies, and data definitions across departments
Integrate data from NetSuite, CRM, eCommerce, and other business systems
Build and maintain data models, datasets, Power Query transformations, DAX calculations, and reporting processes
Act as primary internal administrator and system owner of the company-wide CRM platform
Support CRM implementation, configuration, maintenance, and ongoing system enhancements
Manage CRM workflows, pipelines, permissions, dashboards, and customer data standards
Ensure accuracy, consistency, and integrity of customer, contact, opportunity, and activity data
Collaborate with Sales, Marketing, Customer Experience, Service, and other departments to understand reporting needs and improve CRM utilization
Develop system documentation, user guidelines, and training materials
Monitor CRM adoption, data quality, and reporting accuracy
Identify opportunities to reduce manual reporting, automate workflows, and improve operational efficiency
Establish and maintain company-wide data governance standards and consistent sources of information
Work with IT, business leaders, and external vendors to support system integrations, troubleshooting, and improvements
Support integration and standardization of business data and reporting processes across new locations and acquisitions
Perform other responsibilities as assigned
Requirements
Post-secondary education in Business Analytics, Information Technology, Computer Science, Business Administration, or a related field
Minimum of five (5) years of experience in business intelligence, data analytics, CRM administration, or business systems management
Advanced proficiency in Microsoft Power BI, including Power Query, SQL, DAX, data modelling, data warehousing, ELT, and dashboard development
Experience administering, configuring, and optimizing CRM platforms, including workflows, permissions, reporting, and data management
Strong understanding of data integration, reporting architecture, and data governance principles
Experience working with ERP systems
Ability to translate business requirements into technical solutions and actionable reporting
Experience supporting system implementations, user training, and change management initiatives
Strong analytical and problem-solving skills
Excellent communication and interpersonal skills
Strong organizational skills and ability to independently manage projects and competing priorities
Bilingualism in French and English is considered an asset
Experience supporting a growing, multi-location organization is considered an asset
Familiarity with automation tools, AI-powered analytics, and emerging business technologies is considered an asset
NetSuite experience is considered an asset
Benefits
Competitive Salary & Profit Sharing
Comprehensive Benefits
Health Spending Account
RRSP Plan
Professional Development
Company-Wide Holiday Shutdown with paid time off during the holiday season
Summer Fridays with early wrap-up on summer afternoons
Accommodations during the hiring process or on the job
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.
Business Intelligence Consulting Intern supporting RSM clients with SQL, dashboards, data models, and prototypes. Collaborating with consulting teams in a hybrid, client - facing role.
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.
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.