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
Applicant Notices & Disclaimers
For information on benefits, equal opportunity employment, and location-specific applicant notices, click here
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.
