Business Intelligence Data Analyst (Program Admin Officer 3)
Competition # : 48286
Department: Service Nova Scotia
Location: HALIFAX
Type of Employment: Permanent
Union Status: NSGEU - NSPG
Closing Date: 09-Apr-26 (Applications are accepted until 11:59 PM Atlantic Time)
About Us
Procurement Services, a branch of the Department of Service Nova Scotia, is a dynamic and innovative team dedicated to supporting our clients who procure goods, services, and construction to benefit Nova Scotians. We oversee the Nova Scotia Sustainable Procurement Policy, providing leadership and direction in the development and delivery of procurement programs, plans, and strategies that align with departmental and government priorities.
Our Business Intelligence (BI) Team offers comprehensive business systems support and analytics services to the branch and a wide range of clients across the Nova Scotia Public Sector. The BI Team engages in daily service and support as well as larger transformational projects that affect the broader Procurement service and its clients.
About Our Opportunity
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.
The ideal candidate will be a strong communicator, relationship builder, and innovative thinker with the ability to effectively convey technical concepts to the managers. They demonstrate initiative, analytical thinking, and adaptability, along with proven collaboration skills in a dynamic, procurement-focused environment.
Assets
- Masters’ degree in a related discipline.
- Experience with machine learning techniques and tools.
- Experience in public sector procurement.
- Certifications in Azure databricks.
- Experience in data governance, data quality, and data security practices.
We will assess the above qualifications and competencies using one or more of the following tools: written examination, standardized tests, oral and/or electronic presentations, interview(s), and reference checks.
Equivalency
An equivalent combination of related training and experience may be accepted in place of education requirements. Applicants relying on education and experience equivalencies must demonstrate such equivalencies in their application.
Join the Department of Service Nova Scotia and experience the benefits of a fulfilling career, supported by comprehensive benefits, career development opportunities, and a diverse range of paths to explore within our department and across the government.
Benefits
Based on the employment status, the Government of Nova Scotia offers its employees a wide range of benefits such as a Defined Benefit Pension Plan, Health, Dental, Life Insurance, General illness, Short and Long Term Disability, Vacation and Employee and Family Assistance Programs. For information on all our Benefit program offerings, click here: Benefits for government employees.
Additional Information
This is a permanent, full-time employment opportunity.
What We Offer
- Career development where you have access to career guidance, tools, resources, and ongoing training for every stage of your career
- Engaging workplace: our employees feel valued, respected, connected, and tuned in, we have forward-thinking policies and strategies
- Countless career paths
- A Dynamic, client-focused office environment where service excellence and teamwork are our focus.
Pay Grade: PR 13
Salary Range: $2,805.63 - $3,410.48 Bi-Weekly
Employment Equity Statement:
Our goal is to be a diverse workforce that is representative, at all job levels, of the citizens we serve. The Government of Nova Scotia has an Employment Equity Policy, and we welcome applications from Indigenous People, African Nova Scotians and Other Racially Visible Persons, Persons with Disabilities and Women in occupations or positions where they are under-represented. If you are a member of one of these equity groups, you are encouraged to self-identify on your electronic application.
Accommodation Statement:
We are committed to providing an inclusive and accessible recruitment process. Candidates may request accommodations based on any grounds protected by the Human Rights Act. If you require an accommodation throughout the recruitment process, please contact us at competitions@novascotia.ca.
This is a bargaining unit position initially restricted to current civil service employees represented by the Nova Scotia Government Employees Union (NSGEU). If applying from outside a government office, employees must apply correctly via this link:
Failure to apply correctly means that your application will not be given first consideration as a bargaining unit applicant, and will only be included if external applications are pursued.
External applicants and current casual employees will only be considered if there are no qualified civil service bargaining unit candidates. PLEASE NOTE: Candidates will not be considered for an interview if applications are incomplete or are missing information.
Offer of employment is conditional upon the completion of all applicable background checks and confirmation of credentials, the results of which must be satisfactory to the employer. We thank all applicants for the interest, however, only those selected for an interview will be contacted. All questions and concerns may be directed to Competitions@novascotia.ca.
