Financial Business Intelligence (BI) Analyst

KGP Telecommunications, LLC•Lenexa, KS

About The Position

The Financial Business Intelligence (BI) Analyst is a hands-on analytics professional who transforms financial and operational data into scalable dashboards, reporting suites, and key performance indicators. The role works directly with data warehouses, Microsoft Dynamics 365, and other enterprise systems to build trusted data models, automate recurring reporting, strengthen data quality, and deliver clear insights that support planning, performance management, and business decisions. The analyst develops financial analytics for finance, business, and executive audiences and partners with FP&A, Accounting, Operations, IT, and business leaders to define KPIs, prioritize reporting needs, improve data quality, and continuously enhance reporting and the user experience.

Requirements

Bachelor's degree in Finance, Accounting, Business Analytics, Information Systems, Data Analytics, or a related field.
Experience developing financial or business intelligence reporting, with demonstrated ownership of dashboards, reporting solutions, data models, and KPI definitions.
Advanced Microsoft Excel skills, including complex formulas, PivotTables, Power Query, Power Pivot, data modeling, and efficient analysis of large data sets.
Hands-on Power BI experience, including report and dashboard development, data modeling, visual design, publishing, refresh management, and troubleshooting.
Hands-on experience using Microsoft Dynamics 365 or Dynamics 365 Finance data for financial reporting, analysis, and reconciliation.
Experience extracting, transforming, and validating data directly from data warehouses, ERP systems, or relational databases.
Working knowledge of SQL and dimensional data concepts.
Strong financial acumen, analytical judgment, attention to detail, and communication skills.
Ability to translate technical findings into clear business insights and manage multiple priorities.

Nice To Haves

Experience in FP&A, accounting, distribution, telecommunications, supply chain, and/or services environments.
Familiarity with Microsoft Fabric, Azure data services, SQL Server, data governance, row-level security, and financial planning or consolidation tools.
Relevant Microsoft Power BI or Dynamics 365 certifications.

Responsibilities

Design, build, maintain, and scale financial dashboards, reporting suites, scorecards, and KPIs in Power BI and Excel for finance, business, and executive audiences.
Connect to data warehouses, Microsoft Dynamics 365, ERP systems, and other governed data sources; develop queries, data models, relationships, calculations, and refresh processes.
Translate financial reporting and business requirements into accurate, actionable analytics, including revenue, gross margin, operating expense, working capital, forecast, and variance reporting.
Develop and maintain Power BI semantic models, measures, visualizations, drill-through capabilities, and security structures for consistent, scalable self-service reporting.
Reconcile dashboards and reports to financial systems and approved source data; investigate discrepancies and establish documentation, controls, and validation routines.
Partner with FP&A, Accounting, Operations, IT, and business leaders to define KPIs, prioritize reporting needs, improve data quality, and enhance the user experience and value of financial analytics.