Power BI Specialist (Dynamics 365 F&O)

Jobgether; United States; Remote; USD 86,000 - 107,000; Full time

Benefits offered by this job

Remote work: Canada

Job summary

Jobgether seeks an accomplished BI professional to craft and maintain enterprise Power BI solutions fed by Dynamics 365 Finance & Operations data. You will design data models, implement complex DAX calculations, and build robust data pipelines using BYOD, Dataverse, and Azure Synapse Link.

Collaboration with leadership to deliver trusted insights is essential. Responsibilities include reporting across GL, AP, AR, SCM and Inventory, ensuring data quality, and tuning performance for

Qualifications

• At least 10 years in data analytics, BI, and data warehousing.
• Expertise designing, building, and maintaining enterprise Power BI solutions from Dynamics 365 F&O.
• Strong DAX skills for complex calculations and analytics.
• Proficient in Power Query and SQL for ETL, modeling, analysis and performance optimization.
• Deep knowledge of Dynamics 365 F&O data structures (GL, AP, AR, SCM, Inventory).
• Experience with data integration approaches (BYOD, Dataverse, Azure Synapse Link).
• Solid data warehousing and analytical modeling fundamentals.
• Excellent communication with technical teams and executive stakeholders.
• Analytical problem solving and data quality practices.
• Based in Canada with legal work authorization.

Responsibilities

• Power BI solution development: end-to-end reporting solutions using Dynamics 365 F&O data.
• Advanced data modeling and analytics with DAX, measures, and tabular models.
• Configure data pipelines and integration using BYOD, Dataverse, and Azure Synapse Link.
• Transform ERP data into actionable insights for leadership and teams.
• Develop reports for GL, AP, AR, SCM, and Inventory operations.
• Validate data quality and accuracy of reporting outputs.
• Optimize query performance and data models for enterprise scale.
• Collaborate with stakeholders to align dashboards with objectives.
• Identify opportunities to improve reporting architecture and processing.

Skills

Power BI

DAX

SQL

Data modeling

Data warehousing

Performance tuning

Stakeholder communication

Analytical thinking

Tools

BYOD

Dataverse

Azure Synapse Link

Dynamics 365 F&O

Power Query

Job description

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.