Job title: Systems Analyst and Report Developer Services, 696-003-181

Location: Ottawa

Type of work: Onsite

Start Date : May 2025

End Date: May 2026

Clearance: Reliability status

Responsibilities:

• Run existing SAS EG projects until they can be migrated to our modern platform.
• Determines the best source of information to suit the users' needs and develops queries and reports
• Provides analysis of query/report output for clients and/or conducts statistical analyses, interprets results, and writes reports to explain findings
• Represents the client and their needs when dealing with data platform issues and helps to evaluate, select, test, and optimize both hardware and software products
• Identifies data integrity issues and determine feasible solutions and maintains documentation, templates, procedures, processes, building codes, and standards relating to data.
• Performs all aspects of the data lifecycle management including consulting with business users to articulate requirements, translating the requirements into viable solutions, testing and deployment of solutions.

Specific Project Requirements

• SAS Enterprise Guide
• Denodo
• SQL
• Power BI/ Microsoft Fabric

Top Skills Required:

• Experience with SAS EG
• Experience writing SQL queries (Microsoft SQL Server or Oracle)
• Knowledge of Data Transformation tools
• Experience with developing Dashboards in Power BI

Other Skills Required:

• Advanced data analysis skills

Assets:

• Experience with Data virtualization software, such as Denodo
• Experience with Data Transformation tools, such as Databricks, DataStage, MS Fabric
• Experience using R and/or Python

Experience with SAS Enterprise Guide