Data Analyst I Location: Toronto, ON/ Hybrid Duration: 2 years with possible contract to hire/ possible extension Description: Degree/Certifications Required: Relevant cert would be nice (java, power platforms). Years of experience: 2 minimum Project Scope: Working on a mix of projects within process improvement Team Size: Pod would be about 15 to 20 people Personality Style/Team Culture: Looking for someone who can come in and hit the ground running in the role. Inclusive, collaborative team. Selling Points of Position: Long term role with Client, working on important projects for the bank. Best Vs Average Candidate: Technical- web development, VBA, MS desktop application would helpful Java, HTML, SQL, Power platforms How will performance be measured: Deliverables Summary of day to day responsibilities: Most project work- perform tasks as assigned within priority Unit testing, working to resolve issues Investigating/troubleshooting bugs Documentation Working in an agile environment Meeting with stakeholders Manage their tasks that aligns in priority with the pod Must have: -VBA -Access -SQL Nice to have: -Power platforms -Java -HTML -Agile environment Data Analyst, Process Improvement Technologies & Transformation Team (CPB Operations) Department Overview: We are a team of business line subject matter experts that support the end-to-end analysis, design, and support for tactical business tools and applications that support all areas of CPB Operations. Dedicated technology builds are always the preference, however for smaller use cases it isn't always the right solution. We assess, build, and support the right way, ensuring adherence to all enterprise EUC and Application policy. Job Description: This successful candidate for this full-time position will be joining the Process Improvement Technologies & Transformation team (PITT team) operating in the agile. - They will be supporting existing production tools used across Operations & Delivery, while also working with business partners and our delivery teams on the creation of new process improvement tools. - The PITT Crew is a passionate team of technically savvy subject matter experts that reside under Operations Performance & Modernization, CPB Operations. We support the ideation, development, deployment and governance of new tools, processes and workflows that support our production teams. - We embrace Agile methodologies, allowing us to deploy new tools quickly and efficiently that exceeds the expectation of our business partners. Job Requirements: - Advanced knowledge of Visual Basic, MS Access, and MS Excel. - Strong Asset- 2+ years working with Html/CSS and JavaScript coding with the ability to code high quality output independently. - Knowledgeable in using built-in browser dev tools to understand web site API methods. - Knowledge of SQL and past experience working with SQL Databases - MS Power past experience would be an asset. - Strong communication and stakeholder management skills are an asset. - Experience working in an Agile operating model using JIRA/Confluence would be beneficial. Qualification Assessment Must Have Skills Analysis Experience 2 years MS Access 3 years SQL exp 2 years VBA 3 years Nice to Have Skills Agile delivery experience 2 years Experience using MS power apps 2 years HTML 2 years JavaScript 2 years As an equal opportunity employer, ICONMA provides an employment environment that supports and encourages the abilities of all persons without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws.