Role: Business Analyst (Python & SQL)
Location: Montreal, QC or Mississauga, ON
Type: Contract
Role Summary
Act as a senior Business Analyst with previous experience working in Financial Services, governance and metadata management tools. The Business Analyst will work in a team setting to gather requirements on various metadata management tools and to support governance activities related to Data Cataloging, Glossaries, Dictionaries and Data Lineage. The role needs strong analytical skills, ability to anticipate issues, verify the enhancements, and trouble shoot production issues and must be able to problem solve and work independently. Must be adept at making data useful and digestible by all parties involved. Strong Python, SQL scripting and analysis skills are required. Experience with Snowflake, Databricks would be helpful.
Major Responsibilities
- Work with domain pillar and business users to understand needs and document them using various tools
- Anticipate user needs and propose solutions and alternatives
- Understand functional and non-functional requirements
- Work with development teams in building and testing the solutions
- Maintain active communication channels with all stakeholders on deliverables and report statuses
- Track all outstanding issues and manage them from initiation to production deployment
- Ability to multitask and work with multiple teams
- Manage enhancement requests and production issues. Able to prioritize and allocate resources effectively
- Quality control of, SQL, Snowflake Data
- Standardize data as needed
Skills
- Working knowledge of the financial industry is required
- previous experience working in a Sell Side bank is required
- Demonstrable proficiency with Python and SQL Server and data mining skills
- Experience with Snowflake, Databricks helpful
- Experience with Metadata management tools; Data Catalog, Data Lineage, Data Dictionaries and Glossaries required
- Strong verbal, written, and presentation skills
- Excellent with MS Office tools (Words, Excel, PowerPoint, Visio)
- Working knowledge of JIRA and familiarity with Agile methodology
- Application support
- Regulatory reporting
