Sql jobs in Canada

Work Location: Montréal, Quebec, Canada

Hours: 35

Line of Business: Analytics, Insights, & Artificial Intelligence

Pay Details: 66 800 $/$66,800 - 94 300$/$94,300 CAD

TD is committed to providing fair and equitable compensation opportunities to all colleagues. Growth opportunities and skill development are defining features of the colleague experience at TD. Our compensation policies and practices have been designed to allow colleagues to progress through the salary range over time as they progress in their role. The base pay actually offered may vary based upon the candidate's skills and experience, job-related knowledge, geographic location, and other specific business and organizational needs. As a candidate, you are encouraged to ask compensation related questions and have an open dialogue with your recruiter who can provide you more specific details for this role.

As part of TD Insurance, the Data, Analysis, and Insight (DAI) group supports internal business partners by providing valuable insights and analyses. Within DAI, the team is a trusted partner to executive, operational, and actuarial stakeholders such as Claims Operations, Pricing, Corporate Actuarial, Product, Vendor Management, and others. The team combines talent from actuaries, business intelligence analysts, and data specialists to provide business-specific insights and analytics to our partners helping guide decision-making. Relied on to investigate emerging claims trends, the Claims Insights team generates KPI monitoring, in-depth analyses, as well as actionable recommendations to partners supporting frequency, severity and expense management. The Business Insight Analyst will explore all aspects of data and processes with the opportunity to collaborate with key partners across the organization. You will be instrumental in the delivery of key strategic priorities with regular opportunities to present analyses and reporting broadly to partners and executives.

• Apply understanding of respective business knowledge and strategies to produce relevant and meaningful analysis and materials to support the creation and maturation of business goals and objectives.
• Develop analysis and proper visualization or presentation to illustrate business trends and identify areas of business opportunities.
• Produce insights and recommend business actions to support business strategy and/or solve business problems.
• Work in partnership with various functional areas to provide day-to-day support and delivery of analytics.
• Execute on data requests accurately and within a timely manner.
• Represent functional area as an analytics & insights professional and key resource.
• Act as a bridge to translate business requirements to analytics and reporting needs for a given domain while leveraging tools/ techniques/ methods that can be easily interpreted by the target audience.
• Provides day-to-day support and delivery of analytics insights and collateral.
• Contribute to the identification of key performance indicators.

• Provide suggestions, ideas, and opportunities to support business needs.
• Identify opportunities for business/revenue growth and/or efficiencies for an assigned business or function.
• Identify and investigate data/analytics related issues.
• Ensure data analysis and insights are reviewed to validate accuracy and minimize any potential errors.
• Develop analysis to corroborate initial proof of concept.
• May be required to educate/train business users on how to integrate analytics into decisions.
• Provide recommendations on financial / monetization goals to deliver on (e.g. quantify functional value, cost savings and revenue generated etc.)
• Build business requirements and facilitate project execution to develop insights.
• Utilize quantitative and qualitative methodologies to interpret and present data effectively and clearly.
• Be knowledgeable of practices and procedures within own area of responsibility and keep abreast of emerging trends for own functional area.
• Protect the interests of the organization - identify and manage risks, and elevate non-standard, high risk activities as necessary.
• Conduct internal and external research projects; support the development / delivery of presentations / communications to management or broader audience.
• Adhere to internal policies/procedures and applicable regulatory guidelines.
• Keep abreast of emerging issues, trends, and evolving regulatory requirements and assess potential impacts.
• Maintain a culture of risk management and control, supported by effective processes in alignment with risk appetite.
• May lead work streams by acting as a project lead / subject matter expert for small scale projects / initiatives in accordance with project management methodologies.

• Participate fully as a member of the team, support a positive work environment that promotes service to the business, quality, innovation and teamwork and ensure timely communication of issues/ points of interest.
• Support the team by continuously enhancing knowledge / expertise in own area and participate in knowledge transfer within the team and business unit.
• Keep current on emerging trends/ developments and grow knowledge of the business, related tools and techniques.
• Participate in personal performance management and development activities, including cross training within own team.
• Keep others informed and up to date about the status / progress of projects and / or all relevant or useful information related to day-to-day activities.
• Contribute to the success of the team by willingly assisting others in the completion and performance of work activities; provide training, coaching and/or guidance as appropriate.
• Contribute to a fair, positive and equitable environment that supports a diverse workforce.
• Act as a brand ambassador for your business area/function and the bank, both internally and/or externally.

• Experienced professional role providing specialized guidance/ assistance to function supported.
• Focus on short to medium-term non-routine specialized/ fewer complex issues and/or initial escalated matters.
• Independently perform activities from end to end.
• Generally, reports to a Senior / Manager role.

• Bachelor's or master's degree in Mathematics, Statistics, Computer Sciences, Engineering or relevant discipline.
• Minimum of 2 to 5 years of relevant work experience.
• Experience in General Insurance.
• Strong programming skills (SQL, Python, R).
• Highly developed problem-solving and analysis skills with consistent rigor in quality of work.
• Uses innovation and creativity to improve work efficiency and results.
• Effective in managing multiple priorities with strong organization and time management skills.
• Strong collaborator who engages colleagues, business partners and external stakeholders.

As part of TD Bank Group, one of Canada's largest financial institutions, at TD Insurance, we care for Canadian families, making it easy to get the best advice, protection, and support in their moments of need, always. TD Insurance offers a wide range of products, including General Insurance and Life and Health. More than four million customers count on us. As the largest direct to consumer insurer in Canada, we are always innovating and providing exciting and rewarding career opportunities for our Canada-wide workforce.

Our Total Rewards package reflects the investments we make in our colleagues to help them and their families achieve their financial, physical, and mental well-being goals. Total Rewards at TD includes a base salary, variable compensation, and several other key plans such as health and well-being benefits, savings and retirement programs, paid time off, banking benefits and discounts, career development, and reward and recognition programs.

We're delighted that you're considering building a career with TD. Through regular development conversations, training programs, and a competitive benefits plan, we're committed to providing the support our colleagues need to thrive both at work and at home. Please be advised that this job opportunity is subject to provincial regulation for employment purposes.

If you're interested in a specific career path or are looking to build certain skills, we want to help you succeed. You'll have regular career, development, and performance conversations with your manager, as well as access to an online learning platform and a variety of mentoring programs to help you unlock future opportunities.

We will provide training and onboarding sessions to ensure that you've got everything you need to succeed in your new role.

We'll reach out to candidates of interest to schedule an interview. We do our best to communicate outcomes to all applicants by email or phone call.

Your accessibility is important to us. Please let us know if you'd like accommodations (including accessible meeting rooms, captioning for virtual interviews, etc.) to help us remove barriers so that you can participate throughout the interview process.

Remarque: Étant donné que cet affichage concerne de futurs postes vacants… (remaining text omitted for brevity).