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.
Senior Data Analyst building financial models and Looker dashboards for Jane’s healthcare practice management platform. Supporting Finance and Payments with trusted revenue, billing, and transaction insights.
Senior Data Analyst building AI - enabled Tableau analytics for Sun Life, a global financial services company. Developing trusted metrics, data models, dashboards, and sales insights.
Marketing data advisor analyzing and valorizing member/client data for Desjardins, North America's largest cooperative financial group. Developing dashboards, self - service reports and recommendations for marketing decisions.
Intermediate Data Analyst transforming complex data into actionable insights for PLATO, Canada’s Indigenous - owned technology services company. Developing models, dashboards, and data management solutions with MS Dynamics and Azure.
Senior Data Analyst improving player engagement, monetization, and live operations for Big Viking Games’ YoWorld and FishWorld. Building SQL - driven dashboards and insights for product and business decisions.
Senior data analyst generating client acquisition insights for Sun Life, a global financial security and health company. Building KPIs, dashboards, forecasts, and automated analytics to improve lead conversion and client growth.
Data Analyst converting business data into actionable insights for StarTech.com, a global tech connectivity solutions provider. Building models, dashboards, and reports across product, inventory, revenue, customer, and marketing analytics.