Business Intelligence Data Analyst

 

Description:

Reporting to the Manager, the Business Intelligence Data Analyst is responsible for planning, coordinating, and executing activities related to data analysis and reporting, while supporting data-driven decision-making through the design and delivery of scalable data solutions.

The role focuses on integrating and transforming data from SAP S/4HANA, Ariba, and other enterprise systems into an Azure-based Lakehouse platform, legacy SQL database, and applying spend classification rules, and enabling analytics through Bronze, Silver, and Gold data layers.

Primary Accountabilities
 

  • Support data integration and loading from SAP S/4HANA, ECC, and Ariba into the database and the Azure data platform.
  • Apply and manage spend classification rules and transformation logic to ensure standardized datasets.
  • Develop and maintain dashboards and reports using Power BI and Tableau.
  • Design and maintain data pipelines using PySpark and Azure Databricks across Bronze, Silver, and Gold layers.
  • Perform data validation, reconciliation, and quality checks to ensure accuracy and consistency.
  • Collaborate with stakeholders to gather requirements and deliver scalable, data-driven solutions.
     

Qualifications And Experience

To be considered for this position, you must have a bachelor’s degree in a related field (e.g., Data Science, Computer Science, Information technology) in addition to 5+ years of experience in data analytics, business intelligence, or data engineering roles within a complex service environment.

The Successful Candidate Will Demonstrate
 

  • Experience working in a complex service or enterprise environment.
  • Strong knowledge of finance and procurement systems (e.g. SAP S/4HANA, ECC, and Ariba) data structures and processes.
  • Proven experience developing dashboards and reports using Power BI and/or Tableau.
  • Demonstrated experience building data pipelines, with preference given to candidates with specific experience using PySpark, Azure Databricks, and/or MS Data Fabric.
  • Demonstrated experience working with databases and programming languages (e.g., SQL Server, MySQL, Delta Lake, Python, PySpark).
  • Demonstrated experience designing and managing data integrations, APIs, and ETL processes.

Organization Government of Nova Scotia
Industry IT / Telecom / Software Jobs
Occupational Category Business Intelligence Data Analyst
Job Location Nova Scotia,Canada
Shift Type Morning
Job Type Full Time
Gender No Preference
Career Level Experienced Professional
Experience 5 Years
Posted at 2026-04-05 7:20 pm
Expires on 2026-05-20