Financial BI Analyst - Power BI & Dynamics 365

KGPCo; Lenexa (KS); On-site; USD 75,000 - 110,000; Full time

Benefits offered by this job

Medical, Dental, Vision and Supplement

401(k) with Company match

Generous vacation, holiday, and sick/s

Job summary

KGPCo in Lenexa, KS is seeking a Financial BI Analyst to transform financial and operational data into scalable dashboards and KPI reporting. The role collaborates with finance, IT, and business leaders to deliver actionable insights using data warehouses and Dynamics 365.

You will build semantic models in Power BI, automate recurring reports, ensure data quality, and support planning and performance management.

Qualifications

• Bachelor's degree in Finance, Accounting, Business Analytics, Information Systems, Data Analytics, or a related field.
• Experience developing financial or business intelligence reporting with dashboards, data models, and KPI definitions.
• Advanced Microsoft Excel skills with PivotTables, Power Query, Power Pivot, and large data set analysis.
• Hands-on Power BI experience including report/dashboard development and data modeling.
• Experience using Microsoft Dynamics 365 or Dynamics 365 Finance data for reporting and reconciliation.
• Experience extracting, transforming, and validating data from data warehouses, ERP systems, or relational databases; SQL knowledge.
• Strong financial acumen, analytical judgment, attention to detail, and communication skills.
• Experience in FP&A, accounting, telecom, or data governance is preferred.

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 directly to data warehouses, Microsoft Dynamics 365, ERP systems, and other governed data sources; develop reliable queries, data models, relationships, calculations, and refresh processes.
• Translate financial reporting and business requirements into intuitive, accurate, and 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 that enable consistent and scalable self-service reporting.
• Reconcile dashboards and reports to financial systems and approved source data; investigate discrepancies and establish documentation, controls, and validation routines that build trust in reported results.
• Partner with FP&A, Accounting, Operations, IT, and business leaders to define KPIs, prioritize reporting needs, improve data quality, and continuously enhance the user experience and value of financial analytics.

Skills

Dashboard development

Data modeling

SQL

Power BI

Excel advanced

Dynamics 365

Financial analytics

Education

Bachelor's degree in Finance, Accounting, Business Analytics, Information Systems, Data Analytics, or a related field

Tools

Power BI

Microsoft Dynamics 365

SQL

Job description

KGPCo in Lenexa, KS is seeking a Financial BI Analyst to transform financial and operational data into scalable dashboards and KPI reporting. The role collaborates with finance, IT, and business leaders to deliver actionable insights using data warehouses and Dynamics 365.

You will build semantic models in Power BI, automate recurring reports, ensure data quality, and support planning and performance management.