14 Nov
|
Jobgether
|
Winnipeg
14 Nov
Jobgether
Winnipeg
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 qualified 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.
📌 Power Bi Specialist (Winnipeg)
🏢 Jobgether
📍 Winnipeg