Job Title: Data Analyst – Junior- 31794-1
Start/End Dates: 9/23/2019 – 3/22/2020
Work Location: TORONTO
GROUP/ROLE OVERVIEW:
The Junior Data Analyst, Finance Data Governance and Services, supports BMO Finance in maintaining excellence in Master and Reference Data stewardship, data entry, and analysis. This role requires interaction our major stakeholders in Finance Tax and Treasury, as well as with the rest of the team. The Junior Data Analyst will be responsible for ensuring:
? Our data stewardship processes are well-supported,
? Our immediate requirement for assistance with data entry is fulfilled, and;
? We are able to fully support all of the report-out and analysis requirements of our team.
Your primary responsibility is to support and execute Master and Reference Data maintenance processes as we consolidate these processes into a single team for the whole Bank. This includes active participation and engagement in these processes, as well as filling in data rekeying gaps as we centralize and retire legacy data applications. Additionally, you will be called upon to pull report and help with producing analyses on our data as needed.
RESPONSIBILITIES INCLUDE (but are not limited to):
Data Stewardship (support)
• Reviews master data requests for completeness
• Numbers new master data dimension members
• Provides quality assurance on master data
• Assists with the commissioning and decommissioning of data sets
Data Entry (support)
• Manually transfers / rekeys data from one application to another
• Verifies data by comparing it to its source
• Updates existing data, and retrieves data from databases or electronic files as requested
• Organizes paperwork and backup so that it is not lost
Data Analysis (analysis)
• Helps develop reports and analysis
• Helps to troubleshoot master data and analysis issues
• Produces reports and analyses on demand
TOP SKILLS / EXPERIENCE:
• 1 to 2 years of progressive work experience in information governance, Data governance, or records management experience
• Intermediate knowledge of Microsoft Excel 2010 or higher
• Medium-level competency at writing SQL queries (nice to have)
SOFT SKILLS:
• Great attention to detail
• Is comfortable communicating with new people on a regular basis
• Good command of English (both oral and written) and customer services skills
• Basic understanding of databases
NICE TO HAVES:
? Previous work with Confluence and JIRA would be an asset
EDUCATION/CERTIFICATIONS:
Possesses a university degree (preferably in accounting, finance or business)