Functional Data Analyst – BI, Databricks, SQL

Posted 2 weeks ago

Apply Now

Resume Score

Check how well your resume matches this job before you apply.

Sign in to check score

About the role

  • 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

Job type

Contract

Experience level

Mid levelSenior

Salary

Not specified

Degree requirement

No Education Requirement

Tech skills

AzureCloudPySparkPythonSparkSQL

Location requirements

HybridMontrealCanada

Report this job

Found something wrong with the page? Please let us know by submitting a report below.