Job Title: Data and Reporting Analyst -84252-1
Job Duration: 12 months (Possibility of Conversion)
Work Location: 100 King St W, Toronto, ON, 4 days onsite
 
Day to day tasks:
Process Administration, Maintenance, and Change Management Responsibilities:
Managing Security Updates
•           Submitting request for active directory access for new users
•           Updating tables driving row level security for dashboards
 
Managing User Requests (Access & Dashboard Questions)
•           Reviewing shared inbox request emails for:
o          Dashboard Access
o          Questions On Dashboards
 
Managing SQL Data Refreshes Jobs
•           Executing SAS Jobs and Stored Procedures to refresh key data sets
•           Performing validating checks on the refreshes
•           Communicating refresh statuses to the team
 
Managing Dashboard Data Refreshes
•           Scheduling and executing Dashboard refreshes on the Ad Hoc server
 
Daily Dashboard Data Refreshes Validations
•           Reviewing key dashboards each morning to:
o          Validate data refreshes were successful
o          Taking action if there were issues with the refresh
 
Managing Project Migration Into Ad Hoc and Production
•           Submitting Jira requests for Production team tasks
•           Loading dashboard files into GitHub
•           Validation of dashboards once published
 
Agile Project Responsibilities:
•           Requirements Gathering
o          Attending project meetings
o          Compiling requirements from meetings and email requests
 
•           Story Creation & Updates
o          Creating stories in the JIRA Backlog
 
Must Have

• Minimum bachelor’s degree
• 2 to 4 years’ experience
• SQL Intermediate Level Skills
• Excellent communication skills (verbal & written)

 
Nice To Have:

• Banking/Financial Industry experience
• SAS
• GitHub
• JIRA
• Power BI Server

 
  
 
At SPECTRAFORCE, we are committed to maintaining a workplace that ensures fair compensation and wage transparency in adherence with all applicable state and local laws. This position’s starting pay is: $ 44.52/hr.