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-11-26 |