Senior Data Analyst, Business Intelligence

Original job posting

Lead business intelligence initiatives by designing and optimizing Power BI reports and semantic models using Microsoft Fabric and SQL. Collaborate with stakeholders to translate business needs into scalable reporting solutions and mentor junior analysts.

Job details

Who We Are You know those big cities that still feel like small towns? Where everyone’s friendly and helps each other out? That’s like Doane Grant Thornton. Except here we’re all professionals and there isn’t a mayor or a general store. What we’re trying to say is that we’re a large and growing professional services firm that still feels like a community. We employ about 3000 people across Canada, and we truly care about our colleagues, our clients and the communities where we work and live. That’s what’s most important to us. We’re building a thriving organization that’s purpose driven and still want to remember what your favourite milkshake flavour is. Senior Data Analyst, Business Intelligence We are seeking an experienced Senior Data Analyst to join our Business Intelligence team. This role will independently lead reporting initiatives, build reliable and scalable solutions using Power BI and Microsoft Fabric, and work closely with stakeholders to translate business needs into practical outcomes. The ideal candidate combines strong business intelligence fundamentals, Microsoft Dynamics 365 experience, ownership, sound judgment, and the ability to learn complex systems and business processes quickly. As a Senior Data Analyst, Business Intelligence your responsibilities will include: Lead business intelligence initiatives from requirements and solution design through testing, deployment, and ongoing support. Design, develop, and optimize Power BI reports, dashboards, semantic models, and reusable components using Microsoft Fabric, SQL, Power Query, and DAX. Work with data from Microsoft Dynamics 365 applications, including Finance and Operations, Project Operations, Sales Hub, and other Dataverse-based solutions. Translate business needs into clear requirements, expected outcomes, validation responsibilities, and timelines, while proactively communicating progress, risks, dependencies, and recommended solutions. Validate data, investigate reporting discrepancies, and maintain clear documentation of data sources, business logic, technical decisions, testing, and data lineage. Support report security, deployment, monitoring, and production issues. Mentor junior analysts and contribute to peer reviews, shared standards, reusable patterns, knowledge sharing, and continuous improvement. Doane Grant Thornton If you’re a bit like us, you’re driven to connect with how others are feeling and thinking. Here we walk in others shoes before taking action. Just imagine being part of a team that puts “we before me”, where flexAbility is a mindset, and where you trust your colleagues to have your back. At Doane Grant Thornton, you’ll work with inspiring leaders who support your development, both personally and professionally. This is a place where your insatiable curiosity enables you to think, see and hear from a variety of perspectives, a place where every day is different and having the courage to grow is part of who you are. And when all this comes together, well that’s when the magic happens! Want to learn more about who we are and how we live our purple every day? Read our colleagues’ stories at www.discoveryourpurple.ca Think you’ve got what it takes to be a Senior Data Analyst, Business Intelligence? Like the colour purple? Great. Here's a few more boxes we’re also hoping you can tick: Three or more years of experience in business intelligence, analytics, reporting, or a related role. Post-secondary degree or diploma in data analytics, information systems, business analytics, computer science, or a related field. An equivalent combination of education and relevant experience will also be considered. Advanced Power BI skills, including data modeling, DAX, Power Query, report development, and performance optimization. Strong SQL skills for querying, transformation, validation, and troubleshooting. Hands-on experience with one or more Microsoft Dynamics 365 applications or Dataverse-based solutions. Experience with Microsoft Fabric, Azure data services, or a comparable modern cloud analytics platform. Experience independently delivering reporting or analytics solutions from initial requirements through production. Strong analytical, validation, problem-solving, and stakeholder communication skills. Consistent ownership, follow-through, sound judgment, and attention to quality. Ability to work independently, collaborate effectively, learn quickly, and support the development of others. Experience That Would Be Valuable Experience working with data warehouses, including dimensional models, ETL or ELT processes, curated reporting layers, row-level security, or data governance. Experience with Azure DevOps, Git, SQL Server Reporting Services, Power Automate, or similar tools. Experience with finance, accounting, professional services, or enterprise resource planning reporting. At Doane Grant Thornton we’re focused on making a difference in the lives of our clients, our colleagues and our communities. That’s our purpose. Or, as we like to say, living our purple. What's in it for you? Profit sharing, Flex days, RRSP contributions, Firmwide holiday closure, Wellness benefits, Concierge-like benefits, Work from anywhere in Canada in the summer for 4 weeks, and more! At Doane Grant Thornton, we believe compensation should reflect more than just market data—it should reflect you. We’re serious about compensation. We benchmark regularly across a wide spectrum of roles, industries, sectors, and levels to ensure our ranges are both competitive and current. But we don’t stop there. We also consider the unique strengths, experiences, and impact each individual brings to the table. Our salary ranges are reviewed annually, and where you land within the range depends on a mix of factors—your background, your skills, and how your contributions align with internal equity. To help start the conversation, the current salary range for this role is $74,800–$93,600 in Toronto. If the role is available in other locations, the range may differ to reflect local market factors. Our special culture shines through when we have the opportunity to connect in person. That’s why we’re working in a model where teams are required to be together in the office 4 days per week. Are you ready to Discover Your Purple? Doane Grant Thornton is committed to employment equity, human rights and respectful workplace principles throughout the life cycle of employment, including at the recruitment and hiring stages. We welcome applications from members of all equity deserving groups, including persons with disabilities, women, racialized and/or Indigenous applicants. Should you require accommodation in relation to the recruitment process, please notify us by emailing and we will work with you to meet your accommodation needs.

What you’ll do

Lead business intelligence initiatives by designing and optimizing Power BI reports and semantic models using Microsoft Fabric and SQL. Collaborate with stakeholders to translate business needs into scalable reporting solutions and mentor junior analysts.

Requirements

Requires three or more years of experience in BI and analytics with advanced skills in Power BI, DAX, and SQL. A post-secondary degree in a data or computer science field and experience with Microsoft Dynamics 365 or Dataverse is required.

Benefits

• Profit Sharing • Flex Days • RRSP Contributions • Firmwide Holiday Closure • Wellness Benefits • Concierge-like Benefits • Summer Remote Work Option

Listed skills

• Power BI · Preferred
• SQL · Preferred

Other relevant skills

Identified from the job description. Confirm important requirements above.

• Power BI
• Microsoft Fabric
• SQL
• DAX
• Power Query
• Microsoft Dynamics 365
• Dataverse
• Data Modeling
• Stakeholder Communication
• Business Intelligence
• Azure Data Services
• ETL/ELT

Job areas

• Data & Analytics
• Technology
• Consulting
• Finance & Accounting
• Software