Power BI and Dynamics 365 BC Consultant

Power BI Financial Reporting & Business Intelligence Analyst Position Overview An established organization undergoing a major ERP transformation is seeking a Power BI Financial Reporting & Business Intelligence Analyst to support enterprise-wide reporting initiatives. This role will focus on consolidating, analyzing, and visualizing historical financial data from multiple domestic and international business units following the implementation of a new Microsoft Dynamics 365 Business Central environment. The ideal consultant will help bridge historical and current financial reporting by transforming legacy financial information into meaningful dashboards and reports that provide leadership with actionable business insights. This position requires strong financial acumen, advanced Power BI expertise, and experience working with data from multiple accounting systems and international entities. Key Responsibilities • Design, develop, and maintain Power BI reports and dashboards that provide visibility into financial performance across multiple business units. • Consolidate and analyze historical financial data to create year-over-year comparisons and trend analysis reporting. • Build reporting solutions for general ledger activity, trial balances, ending balances, and other key financial metrics. • Collaborate with finance, accounting, and business stakeholders to define reporting requirements and ensure data accuracy. • Extract, cleanse, validate, and transform financial data from various legacy accounting platforms and source systems. • Work with accounting teams to reconcile financial information and ensure consistency across global operations. • Develop data models and reporting structures that support executive decision-making and operational performance analysis. • Create dashboards that provide leadership with visibility into profitability, business performance, pricing trends, and location-level financial results. • Document reporting processes, data sources, and business rules to support long-term reporting governance. • Assist with ongoing ERP and business intelligence initiatives as additional reporting needs emerge. Required Qualifications • Strong experience developing reports and dashboards using Microsoft Power BI. • Experience working with financial data, including general ledger transactions, trial balances, account reconciliations, and financial reporting. • Proficiency in data transformation and modeling using Power Query, DAX, SQL, or similar tools. • Experience integrating data from multiple source systems and disparate accounting environments. • Ability to analyze complex datasets and present findings in a clear, business-friendly format. • Strong communication skills with the ability to partner effectively with finance and executive stakeholders. • Experience gathering requirements and translating business needs into reporting solutions. Preferred Qualifications • Experience supporting Microsoft Dynamics 365 Business Central environments. • Background working with ERP implementations, migrations, or post-implementation reporting projects. • Knowledge of international accounting processes and multi-entity financial reporting. • Familiarity with VAT reporting considerations and country-specific financial requirements. • Experience working with manufacturing, distribution, or multi-location organizations. • Understanding of financial performance analysis, management reporting, and executive dashboards. Project Scope Phase 1 • Develop financial reporting for North American operations using historical and current financial data. • Create reporting for general ledger activity, ending balances, trial balances, and financial trends. • Establish a framework for incorporating historical financial information into the new reporting environment. Phase 2 • Expand reporting capabilities to include international business units and additional legacy data sources. • Develop executive-level dashboards providing visibility into operational and financial performance across locations. • Deliver business intelligence tools that support strategic planning, pricing analysis, and performance benchmarking. Ideal Candidate This role is well-suited for a consultant who combines Power BI development expertise with strong financial reporting knowledge, enjoys working through complex data challenges, and can transform fragmented financial information into actionable insights for business leadership.