BI & AI Analyst
HybridDorval, Quebec, Canada
Job Summary
Build trusted business reporting by developing clear Power BI dashboards and reports using governed Gold-layer datasets. Turn business questions into actionable insights by translating reporting needs into KPIs, visualizations, and practical recommendations across Finance, Inventory, and Operations. Partner with SMEs to validate requirements, interpret results, and ensure reports answer real business needs while documenting metric definitions and calculation logic. Support decision-making by analyzing data to identify risks, opportunities, and improvement ideas, then collaborate with technical teams to confirm dataset readiness and reporting constraints. Track adoption levels and business value to drive user confidence and self-service analytics. This role helps the business turn trusted data into better decisions within a defense training environment focused on innovation and safety.
Required Qualifications
- Bachelor's degree in Business Analytics, Data Analytics, Computer Science, Statistics, Engineering, Finance, Operations Management, or a related field
- 3–7 years of experience in business intelligence, reporting, analytics, business analysis, or data-driven business support
- Strong hands-on Power BI experience, including dashboard design, data visualization, usability, DAX basics, and report development
- Working knowledge of SQL and structured datasets, with the ability to explore, validate, interpret, and explain business data
- Experience gathering business requirements and converting them into KPIs, dashboards, analytical outputs, and recommendations
- Ability to define and document business metrics, reporting assumptions, data definitions, and performance management outputs
- Strong communication skills, with the ability to explain insights clearly to business users, technical teams, and leadership audiences
- Collaborative mindset and ability to work effectively with SMEs, Data Product Owners, BI/Data Developers, IT, and non-technical stakeholders
- Level II clearance with the Canadian Government and the ability to gain access to the Canadian Controlled Goods Program
Desired Qualifications
- Experience in aviation, MRO, engineering, operations, finance, inventory management, supply chain, or another regulated operational environment
- Familiarity with Microsoft Fabric, Lakehouse/Warehouse concepts, semantic models, Gold-layer datasets, or governed reporting environments
- Knowledge of ERP, MRO, or enterprise systems such as Ramco, SAP, IFS, AMOS, Oracle, UKG, or HCL Notes
- Exposure to AI opportunity identification, forecasting, optimization, automation, anomaly detection, or AI-assisted analytics
- Experience with Microsoft Copilot, Power BI Copilot, or other AI productivity tools
- Experience supporting self-service analytics, data governance, reporting standards, data literacy, or user adoption initiatives
- Experience designing executive dashboards, scorecards, management reports, adoption metrics, or business value tracking reports
Hiring someone like this?
Get your role in front of qualified candidates on Sorce.