Power BI and Data Integration Developer

Power BI and Data Integration Developer

Edmonton, AB, CA Ottawa, ON, CA Calgary, AB, CA Toronto, ON, CA Montreal, Quebec, CA Vancouver, British Columbia, CA

Apr 7, 2026

Dentons is designed to be different. Our Firm leads the way in a rapidly changing legal marketplace. We challenge the status quo and deliver consistent results as well as uncompromising quality and value to our clients. Our global presence is renowned as a Firm with over 21,000 individuals in more than 200 offices serving clients across 80+ countries.

Dentons Canada is committed to its people and communities. We are consistently recognized as an employer of choice having received numerous awards including being selected as one of Canada’s Top 100 Employers (2026). Canada’s Top Employers for Young People (2026), and Canada’s Best Diversity Employers (2026).

This role is an opportunity for you to join Canada’s Global Law Firm, a Firm that offers opportunities to build your career while growing your skills and deepening your expertise.

POSITION SUMMARY

Are you passionate about transforming business intelligence and data integration? We are seeking an experienced, hands-on Power BI and Data Integration Developer to lead our organization’s BI initiatives. This role is responsible for the development and administration of Microsoft Power BI solutions, management of data pipelines, and ensuring data quality and governance across integrated sources. You will also play a vital role in supporting and training teams to maximize their use of Power BI and related tools. Candidates should hold or be in pursuit of Microsoft Fabric Data Engineer or Analytics certifications (DP-600/DP-700) and demonstrate proficiency with the Microsoft Graph API for data integration.

KEY RESPONSIBILITIES

• Power BI Development & Administration: Design, develop, and maintain Power BI dashboards and interactive reports to enable data-driven decision-making. Create and optimize data models, visualizations, and DAX calculations for insightful and performant reporting. Administer the Power BI environment, including workspaces, data gateways, and user access, following best practices for governance and security.
• Data Integration & Management: Oversee all datasets and data pipelines required for BI solutions using Microsoft Fabric components (OneLake, Dataflows Gen2, Data Factory pipelines, Lakehouse/Warehouse). Integrate data from multiple sources—databases, cloud services, enterprise APIs, and files—ensuring consistent ETL/ELT processes for analysis. Monitor and optimize data refresh schedules and troubleshoot dataflows for reliability.
• Data Modeling & Quality Assurance: Develop robust semantic data models (star schemas, relationships, calculation groups) for reusability and single-source-of-truth reporting. Implement data validation, error checks, and row-level security (RLS) to ensure data accuracy, privacy, and integrity. Establish and enforce data governance standards and documentation for BI datasets and integrations.
• Stakeholder Collaboration & Training: Collaborate with business stakeholders to gather requirements and translate business needs into BI solutions. Conduct workshops and maintain ongoing communication with non-technical teams. Provide user training and support to maximize Power BI adoption and champion a data-driven culture.
• Performance Optimization: Optimize BI solutions for performance and scalability. Tune data models and SQL queries for faster load times and query responses. Leverage DirectQuery/Import vs. Direct Lake modes appropriately and implement features to enhance report usability and performance.
• Emerging Technologies & Strategy: Stay current with Microsoft BI and data integration advancements. Evaluate and recommend new tools (Azure Synapse, Databricks, AI integrations) to continuously improve BI infrastructure. Utilize the Microsoft Graph API to integrate enterprise data from Microsoft 365 and Azure AD, and contribute to the organization’s overall data strategy and analytics roadmap.

QUALIFICATIONS

• Education & Experience: Bachelor’s degree in Computer Science, Information Systems, or related field. 3-5+ years of hands-on experience in business intelligence development and data integration, including substantial Power BI experience in a production environment. Experience with Microsoft Fabric (lakehouses, data pipelines, or Fabric-enabled Power BI datasets) required.
• Technical Skills: Advanced Power BI (Desktop and Service), DAX, Power Query, and data modeling. Strong SQL (T-SQL) skills for querying and transforming large datasets. Familiarity with Microsoft Graph API, RESTful web service integrations (JSON, REST APIs), and Azure data platforms (Data Factory, Synapse, SQL Database, Data Lake Storage). Experience with implementing data security (RLS/OLS).
• Certifications: Microsoft Power BI and Fabric certifications (e.g., PL-300, DP-600/DP-700) are highly valued. Microsoft Graph or Power Platform training is a plus.
• Analytical & Problem-Solving Skills: Ability to analyze complex data from multiple sources and design effective analytics solutions. Knowledge of data warehousing principles and troubleshooting experience in BI systems.
• Soft Skills: Excellent communication and collaboration skills. Proven ability to work with cross-functional teams and deliver solutions that meet business needs. Experience in training or coaching team members or end-users on BI tools and data literacy. Proactive, self-driven, and able to manage multiple projects and deadlines.

ADDITIONAL QUALIFICATIONS (NICE-TO-HAVE)

• Programming & Scripting: Experience with Python or other scripting languages for data automation, and familiarity with PowerShell or C# for Microsoft Graph API or Power BI administration.
• Alternate BI/Analytics Tools: Experience with Tableau, Qlik, Databricks, or Snowflake is an asset.
• Azure and Cloud Ecosystem: Deep understanding of the Azure ecosystem (Data Lake, Synapse, Machine Learning) and integration with Power BI and Fabric. Familiarity with Apache Spark or Databricks for data processing and CI/CD tools for BI deployments.
• Domain Knowledge: Experience in legal or professional services data environments is a plus.

ADDITIONAL TOOLS & TECHNOLOGIES

• SQL and Databases: Mastery of SQL and experience with relational databases (SQL Server, Azure SQL Database). Knowledge of data warehousing solutions (Azure Synapse, SQL Server Analysis Services).
• Azure and Cloud Services: Familiarity with Azure Data Factory, Synapse, Databricks, and Data Lake Storage (OneLake).
• Programming/Scripting Languages: Proficiency in Python (for data manipulation and Graph API integrations) and PowerShell (for Power BI automation).
• Power Platform: Experience with Power Apps and Power Automate to complement Power BI dashboards and automate workflows.
• Other BI/Analytics Tools: Awareness of Tableau, Qlik, R, and Excel Power Query/Pivot is beneficial.
• By joining our team, you will lead the way in developing and managing sophisticated Power BI dashboards and data integrations, ensure knowledge transfer through team training and support, and help drive our organization’s adoption of the latest Microsoft data technologies for enhanced reporting and insight generation. If you’re ready to elevate our data-driven culture, we want to hear from you!

We thank all applicants for their interest, however, only those selected for an interview will be contacted.

This is a new role. The target salary range for this position is $120,000 - $130,000, commensurate with the successful candidate’s skills, experience, and qualifications. Dentons is committed to equitable and competitive compensation. This target range falls within our internal salary ranges, which are based on comparable roles in the external market. We strive to hire, promote, and transfer individuals at the entry point of the range, with consideration given to prior experience, relevant skills, and market conditions.

We recognize that rewarding exceptional talent goes beyond salary. Our comprehensive total rewards package includes inclusive and flexible benefits that support the wellbeing and development of our people. This includes extended health and mental health benefits, paid time off, retirement savings plans, a fitness subsidy, parental leave top-up, and more.

In addition, our learning and development programs—such as mentorship opportunities, employee networks, and leadership development initiatives—are designed to support personal and professional growth.

At Dentons, all candidate screening, assessment, and hiring decisions are made by people. From time to time, we use AI-enabled tools to assist in enhancing our recruitment process and materials; however, these tools do not screen candidates or make hiring decisions.

Note: Availability of benefits and programs may vary depending on your location and employment type and may be subject to eligibility criteria. Dentons reserves the right to modify or discontinue offerings, in whole or in part, at its discretion and without prior notice.

Equal Opportunity Statement

At Dentons Canada, inclusion, diversity, equity and accessibility (IDEA) are not just ancillary values, they are foundational to our business. We believe that IDEA is essential to the shared success of our team and our clients. Our forward-thinking and inclusive culture supports the professional development of all our people, enhances the leading services we offer to our clients, and informs our commitment to make a positive impact in the communities where we live and work. As a testament to our commitment to IDEA, we have been recognized as one of Canada’s Best Diversity Employer’s for 16 consecutive years (2011-2026), as well as one of Canada’s Top Employers for Young People (2026) for the ninth time.

Dentons Canada is an equal opportunity employer, and we welcome your application. All employment decisions, including hiring, will be made without regard to age, ancestry, citizenship, colour, creed, disability, ethnic origin, family status, gender identity, marital status, place of origin, race, sexual orientation, or any other characteristic protected by applicable human rights legislation.

We are committed to providing you with an inclusive, barrier-free, and accessible workplace to support your success. Should you require accommodation during the recruitment process, for example as a result of a disability, please contact us at .