Power BI Specialist (Dynamics 365 F&O)

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.