Senior Data Analyst

Title: Senior Data Analyst Location: Cambridge, Ontario, Canada; Toronto, Ontario, Canada

The Senior Data Analyst will identify business metrics and reporting solutions to enhance the business intelligence function. This is a hands-on role responsible for developing and maintaining user-centric reporting and providing subject matter expertise to business leaders in alignment with business strategy and organizational needs. This role involves curating, monitoring, tracking, and notifying on data and insights across the enterprise.

​Key responsibilities include designing and prototyping new analyses, data modelling, reports, visualizations, and data analytics in accordance with data governance, reporting design, and testing standards. The role requires working in a fast-paced, dynamic project environment, leveraging design and storytelling to make sense of data presented in reports. Additionally, the Senior Data Analyst will ensure the creation and ongoing maintenance of process documentation for key deliverables and work in a cross-functional squad with other members of Enterprise Data and Analytics.

​The Senior Data Analyst will respond to key business opportunities and problems using data to investigate and generate solutions. They will proactively monitor portfolio performance, investigating positive and negative trends to understand current and future implications. The role also involves consulting and supporting stakeholders across the organization with the creation of analysis that informs strategic initiatives and considers a business mindset. Acting as the technical business owner on projects, the Senior Data Analyst ensures that technical solutions meet business requirements as defined by key stakeholders.​

What will you do?

​​Respond to key business opportunities and problems using data to investigate and generate data driven solutions such as dashboards and data assets.​​

• Produce analysis that will support decision making at a higher level. This analysis often results from unfolding business opportunities and issues and helps to infer the overall direction of business performance.
• Design and prototype new analyses, reports, visualizations, and data analytics in accordance with data governance and reporting design standards
• Identify business metrics and reporting solutions that will improve the overall effectiveness and efficiency of the Business Intelligence function
• Make sense of large amounts of disparate data to tell a consistent story focused on key strategic decision-making for executives and management

Proactively monitor performance of portfolio and investigate positive and negative trends to understand current and future implications​​

• Data storytelling: Crafting a narrative around data to make insights more engaging and understandable.
• Data monitoring: Continuously tracking data to ensure accuracy and identify trends or anomalies.
• Data reconciliation: Ensuring consistency and accuracy by comparing and aligning data from different sources.
• Creation of reporting solution in Power BI: Developing interactive and visually appealing reports using Power BI to facilitate data-driven decision-making.
• Creation of data asset using SQL or Python that is used in consumption of downstream analysis (OBT creation)

Consult and support (Stakeholders across organization) with creation of analysis that informs strategic initiatives​

• Data storytelling: Crafting a narrative around data to make insights more engaging and understandable.
• Business contextualization of technical output: Translating technical data into business-relevant insights to inform strategic decisions.
• Data reconciliation: Ensuring consistency and accuracy by comparing and aligning data from different sources.
• Benefits Realization Quantification: Measuring the tangible and intangible benefits achieved from a project or initiative.
• Tracking of Targets and overall corporate performance: Monitoring key performance indicators (KPIs) to assess progress towards goals and overall business health.

Act as the technical business owner on projects, ensuring that technical solutions meet business requirements as defined by​​

• Data modelling: Designing the structure of data solution to organize and manage data efficiently.
• Requirements gathering: Collecting and documenting the needs and expectations of stakeholders for a project.
• Data reconciliation: Ensuring consistency and accuracy by comparing and aligning data from different sources.
• Creation of reporting solution in Power BI: Developing interactive and visually appealing reports using Power BI to facilitate data-driven decision-making.
• Creation of data asset that is used in consumption of downstream analysis (OBT creation): Building a data resource that supports further analysis and reporting activities

 What will you need to succeed in this role?

• Bachelor’s or master’s degree in Mathematics, Statistics or a related field.
• 3-5 years experience in ​​Data Analysis & Visualization
• ​Insurance Domain Expertise 2+ years
• 3+ Years experience in ​Business Intelligence Software (Power BI, Tableau etc.)
• 2+ years experience in ​Project Leadership
• ​​Knowledge of data assets and key attributes and metrics commonly used in Business Intelligence, particularly within the P&C insurance sector.
• ​Experience working with enterprise-level data and reporting, including best practices for handling large quantities of data.
• ​Proven analytical ability to synthesize data, identify trends, and produce actionable insights.
• ​Knowledge of SQL databases, Business Intelligence, and analytics tools (Python, R, or equivalent).
• ​Ability to generate and engineer data features for advanced analytics and reporting.
• ​Ability to identify new opportunities for data acquisition and assist in the integration and utilization of new data assets.
• ​Strong communication skills to explain complex problems and solutions to an executive-level audience.
• ​Ability to collaborate with internal clients, such as Data Scientists and Business Users.
• ​Ability to multi-task, prioritize work, manage expectations, and meet deadlines in a fast-paced environment.
• ​Ability to work with minimal supervision while maintaining focus and productivity.
• ​Adaptability to new situations, changing business needs, and ambiguity.
• ​Curiosity and continuous learning to enhance knowledge and grow within the insights team.

The expected base salary range for this position is $79,500.00 - $129,500.00. Depending on your relevant experience, skills, qualifications, market conditions and business needs, base compensation may vary. You have the potential to earn more through Gore Mutual’s discretionary bonus program which gives you an opportunity to increase your total compensation, provided the business meets its performance targets and you meet your individual goals.

Please note: This range reflects the expected base salary for this role but may not represent the full compensation range for all experience and skill levels. During the recruitment process, we will discuss and consider how your unique qualifications align with the broader range for this position.

Gore Mutual is proud to offer a comprehensive total rewards package which includes extended health and dental benefits, disability insurance, retirement plan matching, paid time off, recognition and perk programs.

#LI-Hybrid