Job Title: Data and Reporting Analyst
Job Duration: 13 months (possibility of extension)
Work Location: 100 King St W, Toronto, ON, 4 days onsite
Working hours: 9:00 am to 5:00 pm
 
Day-to-day tasks:
Process Administration, Maintenance, and Change Management Responsibilities:
Managing Security Updates

• Submitting a 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:
• Dashboard Access
• 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:
• Validate data refreshes were successful
• 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
• Attending project meetings
• Compiling requirements from meetings and email requests
• Story Creation & Updates
• 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: $ 40.70/hr.