Power BI Specialist (Dynamics 365 F&O)

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.