Senior Data Analyst, Legal & Risk Services

Title: Senior Data Analyst, Legal & Risk Services

Employee Working Location: Partially Virtual / Hybrid (Canada)

Employment Status: Permanent Full-time

The Canadian Red Cross (Red Cross) - an inspirational not for profit organization, helps people and communities in Canada and around the world in times of need and supports them in strengthening their resilience. As a Canada's Best Employers 2024, we are committed to having an accessible, diverse, inclusive, and barrier-free work environment.

The Senior Data Analyst plays a critical role in driving data-informed decision-making by performing advanced data analysis, developing reports, and optimizing data processes. Working under broad direction and using best practices, this position works with large datasets, designs dashboards and other visualizations, and provides analytics results to support business strategies. They collaborate, influence and drive consensus with cross-functional teams, ensure data quality, provide meaningful insights, and contribute to the development of best practices in data management and analytics.

Success in this role takes more than great analysis, attention to detail, and a thirst for continual improvement - ultimately, the incumbent will be responsible for turning risk related data into a compelling story, pairing crisp insights with an engaging narrative and clear, audience-ready visualizations.

In this role, you will :

Lead Data Analysis, Insights, Reporting, & Visualization (Enhance Service Delivery)

• Lead and coordinate data analysis, reporting, and audit activities for assigned clients or projects.
• Apply analytical techniques to identify trends, insights, and areas for improvement.
• Develop reports and presentations to communicate findings and insights, tailored to different audiences, including partners and organizational leadership.
• Develop visualizations and dashboards to communicate data insights to stakeholders and make data accessible. Examples may include:
• Create visualizations that highlight trends, including incident frequency, severity, and resolution timelines.
• Translate complex risk and incident data into clear, accessible insights for non-technical stakeholders at all levels of the organization, supporting informed decision-making.
• Design dashboards that integrate data from multiple sources (e.g., incident reports, claims, audits) to provide a holistic view of organizational risk.
• Support the development of performance indicators

Optimize Data Solutions & Architecture (Provide Specialized Advice and Solutions)

• Design and implement data-driven solutions to optimize processes, performance and leverage technology.
• Perform source system data analysis in order to manage source to target data mapping and ensure that mapping is up to date.
• Collaborate to rationalize and standardize cross-platform data analysis
• Partner with TG data engineers to optimize data structures and improve accessibility.
• Coordinate on SaaS product updates including support to testing.
• Identify opportunities for continuous improvement and provide recommendations to automate data processes, improve quality and efficiency.

Advise, Collaborate, and Engage with Stakeholders (Guide with Expertise)

• Collaborate with leaders to identify data requirements and ensure data deliverables are accurate, efficient and align with business objectives
• Build relationships with clients and partners and collaborate to identify and solve problems and implement solutions.
• Provide technical expertise to clients and colleagues in data analysis methodologies and tools
• Work with vendors, internal and external partners to exchange information on processes, data usage, enhancements, etc.
• Ensure a seamless user experience for the platforms and systems with their areas of responsibility

Strengthen Data Governance, Leadership & Build Capacity (Influence to Drive Consensus)

• Act as a data ambassador, promoting a data-driven culture across the organization and implementing best practices for data governance, data quality assurance, and documentation based on established organizational standards
• Create and maintain accurate and up-to-date documentation of data processes, requirements, and specifications.
• Provide coaching and mentorship to team members and technical review of the work of others.
• Stay current on, and ensure compliance with relevant legislation, policies, and regulations related to data management and privacy.
• Identify emerging trends and opportunities in the data analytics field and provide recommendations on how to leverage these to enhance the organization's data analytics capabilities.
• Actively participates in and contributes to data governance and management forums

What we are looking for :

• Qualifications include a minimum of 6-9 years experience and a 3-year college diploma or university degree and/or an equivalent combination of education and experience.
• Strong understanding of basic statistical concepts and data analysis techniques.
• Strong competency in conducting qualitative analysis through the systematic collection, organization, and interpretation of non-numerical data.
• Proficiency in standard computer applications (Microsoft Office Suite) and Excel (e.g. macros, VBA, functions, pivot tables, formulas, and charts).
• Proficiency in SQL for data extraction, transformation, and optimization.
• Advanced skills in data visualization techniques and software (e.g., Power BI or similar)
• Experience with and understanding of best practices around data management concepts, including data quality, data cleansing, standardization, metadata management, privacy, and security governance
• Knowledge of the business area, to inform design of meaningful and focused analytics, KPIs and visualization
• Ability to identify complex problems, analyze interrelated factors, assess and mitigate risks, and develop solutions using specialized skills.
• Communication and influence skills to gather perspectives, understand needs, and present information to reach consensus, often in somewhat sensitive situations.
• Ability to provide guidance to others and ensure work is completed in compliance with applicable data and privacy policy and legislation
• Experience using Python or R for data extraction, transformation, automation, and analysis, with an understanding of ETL workflows and automated data pipelines considered an asset.

Working Conditions :

• As we work with and support people (managers, colleagues, beneficiaries/customers, volunteers, donors and external partners) and communities in Canada and around the world, applicants whose first language is not English may be required to perform the responsibilities of the role in English.
• Eligibility to work in Canada: At this time, we welcome applications from candidates eligible to work in Canada. If you are not a citizen or permanent resident of Canada, we encourage you to carefully review your visa to find out whether you are eligible to work in the job you are considering applying for. Refer to our FAQ for more information.
• If you are selected for this role, you will be required to complete a successful pre-employment screening process which includes a satisfactory Enhanced Police Information Check (E-PIC).