Power BI Specialist; Dynamics 365 F&O Job Phoenix area,Arizona USA,IT/Tech

Position: 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.