Data Analyst

Intellifi; Remote; CAD 85,000 - 95,000; Full time

Job summary

A leading mortgage technology company is seeking a Data Analyst to manage and optimize their reporting ecosystem using SSRS and Power BI. The ideal candidate has 3-5 years of experience in data analysis, a strong understanding of SQL, and the ability to create intuitive dashboards. This role offers an incredible opportunity for growth and collaboration in a fast-paced environment, with a salary ranging from CAD 85,000 to CAD 95,000. Diversity and inclusion are highly valued in the company culture.

Benefits

Best-in-Class Tools

Accelerated Growth Opportunities

Diversity and Inclusion Initiatives

Qualifications

• 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.
• Expert knowledge of Power BI Desktop and Power BI Service.

Responsibilities

• Handle all incoming requests for SQL Server Reporting Services (SSRS), scoping and building new reports.
• Design, develop, and deploy advanced Power BI dashboards that are intuitive and visually compelling.
• Work directly with business units to understand their KPIs and translate them into technical reporting specifications.

Skills

Data Analysis

SQL

Power BI

SSRS

T-SQL

Tools

Power BI

SQL Server

Azure SQL

Job description

Join nesto — proudly named Canadian Rocketship 2025*. A Deloitte Fast 50 company evolving alongside Canada’s top tech innovators and disrupting a 2.1 Trillion-dollar mortgage industry at light speed by building the mortgage ecosystem of the future.

BUILD lending technology with the best developers, AI engineers, and mortgage experts in the country. Work on a modern tech stack and a development framework designed to unlock your full potential and accelerate your career.

• Hypergrowth: Deloitte Fast 50 — 3 years in a row
• Tech community credibility: TechTO Canadian Rocketship 2025*
• Industry leadership: CLA Lending Company of the Year — 4 consecutive years
• Talent magnet: CMP Top Mortgage Employer 2025
• Trusted technology: powering major financial institutions across Canada
• An entrepreneurial culture built on trust, speed, uncomfortable ambition, being stronger together, and a relentless obsession with our clients.

About nesto and Nesto Cloud

nesto is Canada’s leading provider of mortgage technology and financing solutions, managing $73B+ CAD in residential and commercial mortgages, with 1,000+ team members across 12 offices nationwide. You will be working on Nesto Cloud, Canada’s most advanced cloud platform, delivering end-to-end technology solutions for lenders in the digital age.

As Data Analyst your primary focus is the administration, development, and optimization of our reporting ecosystem. You will serve as the bridge between legacy and modern reporting, taking full ownership of our SSRS request queue while simultaneously building high-impact dashboards in Power BI. This role is ideal for a hands-on developer who is comfortable managing a busy ticket queue and driving the adoption of modern analytics.

Who You Are

• A "Doer": You are comfortable jumping into a fast-paced environment and taking immediate ownership of the reporting backlog.
• A Visual Storyteller: You don’t just put charts on a page; you build dashboards that tell a clear story and drive action.
• The "Admin" Mindset: You enjoy the organization and governance required to keep a BI environment running smoothly.

Key Responsibilities

SSRS Development & Maintenance (Core Responsibility)

• Ownership of Requests: Handle all incoming requests for SQL Server Reporting Services (SSRS). This includes scoping and building new reports from scratch based on business needs.
• Change Management: Execute change requests for existing SSRS reports, optimizing queries and adjusting layouts to match evolving business processes.
• Troubleshooting: Diagnose and resolve issues with report rendering, data accuracy, or subscription delivery in a timely manner.

Power BI Development & Administration

• Modern Visualization: Design, develop, and deploy advanced Power BI dashboards that are intuitive, performant, and visually compelling.
• Environment Admin: Oversee Power BI Service administration, including workspace management, security roles (RLS), and gateway configurations.
• Data Modeling: Translate business requirements into clean, functional data models (DAX/Power Query) that serve as a "single source of truth."

Stakeholder Collaboration & Governance

• Requirement Gathering: Work directly with business units to understand their KPIs and translate them into technical reporting specifications.
• Data Integrity: Partner with the Data Engineering team to validate underlying data in SQL Server and Azure SQL.
• Best Practices: Champion reporting standards, ensuring all new builds follow internal UI/UX and data governance guidelines.

Required Skills & Qualifications

Technical Expertise

• Experience: 3–5 years of experience in data analysis and BI reporting, preferably in Financial Services or FinTech.
• SSRS Proficiency: Strong ability to design, develop, and deploy paginated reports using SSRS (Visual Studio / Report Builder). You should be comfortable writing complex T-SQL queries / stored procedures to feed these reports.
• Power BI Mastery: Expert knowledge of Power BI Desktop and Power BI Service (Admin). Proficiency in DAX and Power Query (M) is essential.
• Database Skills: Strong proficiency in SQL (T-SQL) for data extraction and a solid understanding of relational database structures (SQL Server / Azure SQL).

Soft Skills

• Queue Management: 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.
• Communication: Ability to explain data trends and technical limitations to non-technical business users.

Time Zone: 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.

The Reward

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.

Best-in-Class Tools: Access to the resources and tech you need to execute without friction.

Working framework: the environment that makes you productive and enables teamwork.

Diversity & Inclusion

At nesto, we believe that creativity and collaboration are the result of a diverse team. We are committed to fostering a culture of diversity, equity, inclusion, and belonging, and we strongly encourage women, people of color, LGBTQIA+ individuals, and individuals with disabilities to apply. We are committed to creating a workplace that is inclusive and welcoming to all.

#LI-DNI
#LI-Remote

The pay range for this role is:

85,000 - 95,000 CAD per year (Remote (Canada))