Power BI Specialist (Dynamics 365 F&O)

Jobgether; Canada; Remote; CAD 90,000 - 150,000; Full time

Benefits offered by this job

Remote work from Canada

Enterprise-scale challenges

Professional development

Cross-functional collaboration

Technical impact

Job summary

Jobgether is seeking a seasoned Power BI Specialist (Dynamics 365 Finance & Operations) to design, develop, and optimize reporting solutions in a remote Canada-based role. You will transform ERP data into actionable insights through dashboards and executive reports, leveraging DAX, SQL, Power Query, and Microsoft data integration tools.

The ideal candidate brings deep technical knowledge with strong business understanding and excels at collaborating with stakeholders to deliver reliable business

Qualifications

• At least 10 years in data analytics, BI, and data warehousing.
• Expert in designing and maintaining enterprise Power BI solutions from Dynamics 365 F&O.
• Advanced DAX skills for complex calculations.
• Proficient in Power Query and SQL for data transformation.
• Deep understanding of Dynamics 365 F&O data structures.

Responsibilities

• Design, develop, test, and deploy end-to-end Power BI reporting solutions from Dynamics 365 F&O.
• Build and maintain complex DAX calculations and data models.
• Configure data pipelines using BYOD, Dataverse, and Azure Synapse Link.
• Transform ERP data into actionable insights for executives.
• Develop reports for GL, AP, AR, SCM, and Inventory.
• Ensure data quality and performance optimization.
• Collaborate with stakeholders to translate requirements into technical solutions.

Skills

Power BI

DAX

SQL

Power Query

Dynamics 365 F&O

Dataverse

BYOD

Azure Synapse Link

Data modeling

Data warehousing

Data quality

Tools

BYOD

Dataverse

Azure Synapse Link

Job description

This position is listed on behalf of a partner company, who manages all applications and next steps. Our partner is looking for a Power BI Specialist (Dynamics 365 F&O) based in Canada.

Join a data-driven environment where business intelligence and enterprise analytics play a critical role in strategic decision-making. As a Power BI Specialist, you will design, develop, and optimize reporting solutions using data from Microsoft Dynamics 365 Finance & Operations (F&O). You will transform complex financial and operational ERP data into actionable insights through interactive dashboards, advanced analytics, and executive reports. Working closely with business stakeholders, you will ensure reporting solutions deliver accurate, reliable, and relevant information across the organization. Your expertise in data modeling, DAX, SQL, and Microsoft data integration technologies will help improve reporting performance and data accessibility. This remote opportunity is ideal for a seasoned analytics professional who combines deep technical knowledge with strong business understanding and a passion for turning data into measurable business value.

Accountabilities

• Power BI solution development: Design, develop, test, and deploy end-to-end Power BI reporting solutions using data sourced directly from Microsoft Dynamics 365 Finance & Operations.
• Advanced data modeling and analytics: Build and maintain complex DAX calculations, measures, tabular data models, and custom visualizations to support business reporting and analytical requirements.
• Dynamics 365 F&O data integration: Configure and manage data pipelines and integration solutions using Bring Your Own Database (BYOD), Microsoft Dataverse, and Azure Synapse Link for Dynamics 365 F&O.
• ERP data transformation: Extract, transform, and analyze financial and operational data from enterprise systems, converting raw information into meaningful insights for executive leadership and functional teams.
• Financial and operational reporting: Develop reporting solutions that support key business areas, including General Ledger, Accounts Payable, Accounts Receivable, Supply Chain Management, and Inventory.
• Data quality and validation: Establish and perform data validation checks to ensure the accuracy, consistency, completeness, and reliability of reporting outputs.
• Performance optimization: Analyze and improve query execution, data models, report responsiveness, and overall Power BI performance to support efficient enterprise reporting.
• Stakeholder collaboration: Work closely with business stakeholders to understand reporting needs, translate requirements into technical solutions, and ensure dashboards align with organizational objectives.
• Continuous improvement: Identify opportunities to enhance reporting architecture, streamline data processing, and improve the usability and effectiveness of business intelligence solutions.

Requirements

• Professional experience: At least 10 years of overall experience in data analytics, business intelligence, and data warehousing.
• Power BI expertise: Demonstrated experience designing, building, and maintaining enterprise Power BI solutions using data directly from Microsoft Dynamics 365 Finance & Operations.
• Advanced DAX skills: Strong command of DAX, including complex calculations, measures, and analytical logic for sophisticated reporting requirements.
• Power Query and SQL: Proficiency in Power Query (M language) and SQL for data extraction, transformation, modeling, analysis, and performance optimization.
• Dynamics 365 F&O knowledge: Solid understanding of Dynamics 365 Finance & Operations data structures, particularly General Ledger, Accounts Payable, Accounts Receivable, Supply Chain Management, and Inventory.
• Data integration experience: Practical knowledge of enterprise data integration approaches, including BYOD, Dataverse, Azure Synapse Link, and related data pipeline technologies used with Dynamics 365 F&O.
• Data modeling and warehousing: Strong understanding of data warehousing principles, relational data structures, analytical modeling, and reporting architecture.
• Data quality and performance: Experience validating complex datasets, troubleshooting reporting discrepancies, tuning queries, and optimizing Power BI solutions for enterprise-scale use.
• Business communication: Excellent verbal and written communication skills, with the ability to collaborate effectively with technical teams, business stakeholders, and executive audiences.
• Analytical problem-solving: A detail-oriented, structured approach to investigating data issues, identifying root causes, and delivering reliable reporting solutions.
• Location and work authorization: Must be based in Canada and legally authorized to work in Canada.

Benefits

• Remote work: Opportunity to work remotely from Canada.
• Technical impact: Contribute to enterprise reporting solutions that transform complex ERP data into actionable business intelligence.
• Professional development: Apply and expand your expertise in Power BI, Dynamics 365 Finance & Operations, and Microsoft data integration technologies.
• Cross-functional collaboration: Work with business stakeholders and technical teams to deliver reporting solutions aligned with organizational priorities.
• Enterprise-scale challenges: Address complex data modeling, integration, validation, and performance optimization requirements.