Chief Fonctional and Data Analyst

A career as a Senior Functional and Data Analyst means taking on a key role in National Bank's technological transformation, to analyze, optimize and evolve business applications and information systems, while working closely with a multidisciplinary team.This role allows you to actively contribute to our organization through your understanding of user needs, requirements management, and process analysis to ensure functional consistency of the solutions implemented.

Your job

• Ensure data quality and integrity, including data evolution management (Slowly Changing Dimension (SCD) vs. Snapshot)
• Translate needs into functional requirements and maintain documentation (use cases, diagrams)
• Analyze and produce complex SQL queries to support the accounting team
• Respond to changing needs, ad hoc requests, resolve technical issues, and offer reliable support to ensure the integrity of the data consumed by the accounting team
• Collaborate with the various stakeholders (technical teams, projects, architecture, analysts and production support) to ensure the quality of deliverables and the performance of data delivery processes
• Actively participate in corporate projects and optimize data processing.

Your team

IT is more than 2300 specialists who work in an agile, proactive and collaborative manner to seize opportunities, stay on the cutting edge of technology and continuously improve processes.
Within the IT Delivery Management Corporate Services sector in Finance, you will be part of a large team of 6 colleagues and you will report to the Application Director. Our team stands out for its level of maturity, experience and knowledge of the business sector.
We aim to offer you maximum flexibility to promote your quality of life. This is reflected in a hybrid work environment, as well as a flexible and adaptable schedule.The Bank values continuous development and internal mobility. Our personalized training programs, based on learning in action, allow you to master your craft and develop new areas of expertise. Tools such as the Data Academy, language training, the Harvard Learning Center, and coaching and mentoring support are available to you at all times.

Prerequisites

• Computer science degree or equivalent, with 5+ years of experience as a functional analyst (banking environment preferred)
• 5 years of experience in functional analysis and excellent command of SQL
• Good understanding of complex data structures, relational models, and data warehouses
• Knowledge of relational databases (mandatory); Oracle and Datastage (assets)
• Data integration and problem-solving skills
• Familiarity with Agile methodologies and Atlassian tools (Jira, Xray, Confluence)
• Excellent interpersonal skills and ability to evolve in a changing environment.

Your benefits In addition to competitive compensation, upon hiring you’ll be eligible for a wide range of flexible benefits to help promote your wellbeing and that of your family.    * Health and wellness program, including many options * Flexible group insurance * Generous pension plan * Employee Share Ownership Plan * Employee and Family Assistance Program * Preferential banking services * Opportunities to get involved in community initiatives * Telemedicine service * Virtual sleep clinic    These are a few of the benefits available to you. We have an offer that keeps up with trends as well as your needs and those of your family.   Our dynamic work environments and cutting-edge collaboration tools foster a positive employee experience. We actively listen to employees’ ideas. Whether through our surveys or programs, regular feedback and ongoing communication is encouraged.   We're putting people first We're a bank on a human scale that stands out for its courage, entrepreneurial culture, and passion for people. Our mission is to have a positive impact on peoples' lives. Our core values of partnership, agility, and empowerment inspire us, and inclusivity is central to our commitments. We offer a barrier-free workplace that is accessible to all employees.     We want our recruitment process to be fully accessible. If you require accommodation, feel free to let us know during your first conversations with us. We welcome all candidates! What can you bring to our team?    Come live your ambitions with us!