Functional Data Analyst defining BI requirements, KPIs, and data validation for Quebec’s energy sector. Delivering Databricks and Azure analytics solutions in a hybrid Montreal setting.
Responsibilities
Analyze and document business needs related to data and Business Intelligence initiatives
Facilitate discovery, requirements-gathering, and clarification workshops
Define business objectives, performance indicators, and success criteria
Translate stakeholder needs into structured functional requirements
Produce and maintain user stories, acceptance criteria, and use cases
Maintain traceability between business needs, data, and deliverables
Identify and document data required for BI use cases
Perform exploratory analyses using SQL and Databricks
Validate the consistency, quality, and relevance of data
Participate in defining and validating KPIs
Verify that data and indicators meet business objectives
Collaborate with technical teams to clarify functional rules and data needs
Contribute to data governance and data-quality practices
Collaborate with architects and governance leads
Support continuous improvement of data quality and data usage
Participate in Agile Scrum/Kanban ceremonies
Collaborate on backlog prioritization and management
Track requirements and deliverables using Jira and Confluence
Coordinate with BI developers, data architects, and business partners
Ensure the functional consistency of developed solutions
Prepare and support user acceptance testing
Document deviations and contribute to their resolution
Support business teams during solution implementation
Contribute to training, communication, and change-management activities
Promote adoption of BI solutions
Requirements
4 to 6 years of relevant experience in business and data analysis within a BI context
Hands-on experience delivering BI projects in a large-scale environment
Expertise in business analysis for data initiatives, including requirements scoping, use cases, business objectives, KPIs, success criteria, and business value measurement
Experience gathering and formalizing requirements through workshops, stakeholder interviews, user stories, acceptance criteria, use cases, and user journeys
Strong ability to document business requirements and functional specifications
Experience with Atlassian Jira and Confluence
Understanding of data governance and data quality concepts
Knowledge of functional Business Intelligence approaches and capabilities
Very good SQL skills, particularly in Databricks, for data exploration, functional validation, KPI verification, and data consistency analysis
Knowledge of data-oriented cloud platforms and services, particularly Databricks and the Azure ecosystem
Knowledge of Agile Scrum/Kanban practices
Experience managing and prioritizing backlogs, roadmaps, and value criteria
Experience with user acceptance testing, change management, communication and training, and solution adoption
Ability to facilitate workshops and explain complex technical concepts
Ability to collaborate with business, IT, security, legal, and governance teams
Fluency in French is mandatory
Ability to work from Quebec and attend the Montreal office 2 days per week
Python knowledge for prototyping and data validation is an asset
Spark and PySpark knowledge in Big Data environments is an asset
Experience with Microsoft Azure analytics platforms is an asset
Energy-sector or critical-infrastructure experience is an asset
Knowledge of compliance and strategic asset-management issues is an asset
Benefits
Contract assignment through June 30, 2027
Hybrid work arrangement with client-site presence 2 days per week
37.5-hour work week
Opportunities to contribute to strategic digital transformation initiatives
Work on BI, data governance, performance management, compliance, and strategic asset management initiatives
BI Developer modernizing Iceberg Finance’s analytics platform with Microsoft Fabric, SQL, Python, Spark, and Power BI. Building data pipelines and models that drive finance business decisions.
Analyste BI chez iA Financial Group, assureur et gestionnaire d’épargne, développant des tableaux de bord et analyses d’expérience client. Mesure les parcours numériques, le NPS et les occasions d’amélioration.
Business Intelligence Analyst supporting Intact Insurance’s underwriting teams with KPI development and operational performance analytics. Improving data quality, productivity, service quality, and operational excellence.
Remote Power BI Specialist building enterprise dashboards and reports from Dynamics 365 F&O data. Optimizing DAX, SQL, data pipelines, and executive analytics for Canadian stakeholders.
Senior Business Intelligence Analyst driving KPI management, forecasting, and profitability insights for MGID’s global native advertising platform. Partnering with Commercial, Demand, Finance, Product, Sales, and Data teams.
Senior Business Intelligence Analyst driving KPI management, forecasting, and profitability insights for MGID’s global native advertising platform. Supporting commercial growth through SQL, Python, BI, and data analysis.
Étudiant(e) analyste BI chez iA Financial Group, développant des rapports et tableaux de bord. Automatisation de processus et analyse de données pour l’assurance, l’épargne et la retraite.
Senior BI Engineer building data models, semantic layers, and dashboards for Jobber’s small - business service platform. Driving governed self - service analytics and trusted business metrics.
Senior BI Data Engineer building data pipelines, warehouses, and reporting solutions for Trillium Health Partners hospitals. Leading Microsoft BI architecture, integration, and technical delivery.
Business intelligence consultant building Sage Intacct and Sage 300 CRE financial reports. Supporting accounting and operations teams with SQL - integrated, multi - entity reporting solutions.