Senior Data Analyst, Business Intelligence

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 over 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.

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.

We are seeking a highly motivated and experienced Senior Analyst, Business Intelligence to join our team. The ideal candidate will have a strong foundation in Power BI development, data validation, and stakeholder collaboration. You will play a pivotal role in creating impactful reports, mentoring junior analysts, and contributing to the continuous improvement of our BI processes. If you are a proactive problem-solver with a passion for data and a desire to make a tangible impact, we encourage you to apply!

As a Senior Data Analyst, Business Intelligence your responsibilities will include:

1. Power BI Expertise: Design and build impactful reports, adapting to evolving requirements
2. Data Integrity: Thoroughly validate data and ensure accuracy
3. Collaboration: Work effectively with teams to ensure report completeness and address challenges; communicate effectively with stakeholders
4. Continuous Improvement: Proactively identify and implement enhancements to BI processes and report development
5. Technical Support: Manage and resolve ServiceNow tickets related to BI reports and dashboards

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:

Technical Skills

• Strong understanding of data structures and quality principles
• Advanced Power BI skills, including data modelling, DAX, report creation, and Power Query (M) for data transformation
• Proficiency in Excel (data manipulation and analysis)
• Strong data visualization skills
• Working knowledge of SQL for data querying and extraction
• Familiarity with SharePoint for data access and collaboration
• Demonstrated ability to quickly learn and adapt to new systems and technologies

Experience

• 3 years of experience in a BI analyst or similar role, with a proven track record of delivering high-quality reports and dashboards

Core Competencies

• Excellent communication and interpersonal skills
• Strong analytical and problem-solving abilities
• Detail-oriented and proactive
• Ability to work independently and collaboratively
• Adaptable to changing priorities

Nice to Have

• Knowledge of data warehousing and ETL processes
• Familiarity with data governance and security
• Python or other programming knowledge
• SQL Server Reporting Services experience
• Dynamics 365 (Finance & Operations) experience
• Management Reporter experience
• Experience with predictive modelling techniques

*Please include your portfolio with your resume application*

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!

Are you ready to Discover Your Purple?

#LI-Onsite