Senior Data Analyst transforming Sun Life insurance and financial - services data into actionable marketing insights. Building SQL, Python, AWS, Adobe Analytics, reporting, and dashboard solutions.
About the role
- Data Analyst responsible for SSRS and Power BI reporting in Canadian fintech environment. Collaborating across teams to deliver business insights and improve data accuracy.
Responsibilities
- Handle all incoming requests for SQL Server Reporting Services (SSRS)
- Execute change requests for existing SSRS reports, optimizing queries and adjusting layouts to match evolving business processes
- Diagnose and resolve issues with report rendering, data accuracy, or subscription delivery in a timely manner
- Design, develop, and deploy advanced Power BI dashboards that are intuitive, performant, and visually compelling
- Oversee Power BI Service administration , including workspace management, security roles (RLS), and gateway configurations
- Translate business requirements into clean, functional data models (DAX/Power Query) that serve as a 'single source of truth'
- Work directly with business units to understand their KPIs and translate them into technical reporting specifications
- Partner with the Data Engineering team to validate underlying data in SQL Server and Azure SQL
- Champion reporting standards, ensuring all new builds follow internal UI/UX and data governance guidelines.
Requirements
- 3–5 years of experience in data analysis and BI reporting, preferably in Financial Services or FinTech
- Strong ability to design, develop, and deploy paginated reports using SSRS (Visual Studio / Report Builder)
- Expert knowledge of Power BI Desktop and Power BI Service (Admin)
- Proficiency in DAX and Power Query (M) is essential
- Strong proficiency in SQL (T-SQL) for data extraction and a solid understanding of relational database structures (SQL Server / Azure SQL)
- Ability to prioritize and manage a backlog of reporting requests independently.
- Attention to Detail: A 'perfectionist' mindset when it comes to data accuracy and visual alignment.
- Must be located in or able to work consistently within the EST time zone (9:00 AM - 5:00 PM) to ensure synchronized collaboration with our national teams.
Benefits
- Best-in-Class Tools: Access to the resources and tech you need to execute without friction
- The A-Team: Work alongside high-performing talent in the industry
- Accelerated Growth: The slope of your learning curve here will be vertical. You will touch more production systems in one year than you would in five years at a bank
- Working framework: the environment that makes you productive and enables teamwork
- Diversity & Inclusion: We are committed to creating a workplace that is inclusive and welcoming to all.
Job title
Job type
Experience level
Salary
Degree requirement
Tech skills
Location requirements
Report this job
Found something wrong with the page? Please let us know by submitting a report below.
Student Data Analyst supporting Sun Life’s financial security mission through stakeholder insights and Tableau KPI reporting. Building data analysis skills during a four - month hybrid campus placement.
Analyste de données principal modernisant les plateformes et pipelines de données d’EDC, société financière publique canadienne. Traduction des besoins opérationnels en modèles, règles de transformation et récits utilisateurs.
Senior Data Analyst modernizing enterprise data capabilities at Export Development Canada. Translating business requirements into data models, mappings, pipelines and Agile delivery artifacts.
Data Analyst improving Instacart’s online grocery fulfillment quality through operational analytics. Monitoring retailer performance, diagnosing issues, and delivering recommendations to cross - functional stakeholders.
Web Analyst owning GA4, GTM, pixel, and conversion tracking for an education and nonprofit marketing agency. Ensuring accurate, privacy - compliant data across client campaigns and CRM systems.
Data Analyst supporting client data migrations and corporate actions for Computershare, a global financial administration and transfer agency leader. Ensuring data quality, mapping, validation, and operational sign - off.
Associate Director advancing UJA Toronto’s nonprofit fundraising through donor analytics, predictive modeling, and prospect intelligence. Leading data strategy, pipeline development, and a two - person analytics team.
Sales Force Effectiveness Specialist optimizing territories, targeting and dashboards for GSK, a global biopharma company. Translating sales and market data into actionable commercial insights.
Water and wastewater planning consultant analyzing infrastructure data, forecasting demand, and developing sustainable servicing strategies. Supporting KWL’s consulting engineering projects across Western Canada.