Strategic Financial BI Analyst: Power BI & Dynamics 365

KGP Telecommunications, LLC; Lackmans (KS); On-site; USD 85,000 - 120,000; Full time

Benefits offered by this job

Medical, Dental, Vision and Supplement

Flexible Spending Accounts

401(k) with Company match

Generous vacation, holiday, and sick/s

Pet insurance for our non-human family

Job summary

KGPCo is seeking a Financial BI Analyst based in Lenexa, KS. This hands-on role transforms financial and operational data into scalable dashboards, reporting suites, and KPIs.

You will work with data warehouses, Dynamics 365, and ERP systems to build trusted data models, automate reporting, ensure data quality, and deliver actionable insights for planning and performance management. The role requires collaboration with FP&A, Accounting, Operations, IT, and business leaders to define KPIs,

Qualifications

• Bachelor's degree in Finance, Accounting, or related field.
• Experience developing financial or business intelligence reporting with dashboards, data models and KPI definitions.
• Advanced Excel skills with PivotTables, Power Query, Power Pivot and data modeling.
• Hands-on Power BI report/dashboard development, data modeling and security.
• Experience using Dynamics 365/Finance for financial reporting and reconciliation.
• Experience extracting and validating data from data warehouses/ERP systems; knowledge of SQL.
• Strong analytical, business acumen and communication skills.

Responsibilities

• Design, build, maintain, and scale financial dashboards, reporting suites, scorecards, and KPIs in Power BI and Excel for finance, business, and exec audiences.
• Connect to data warehouses, Dynamics 365, ERP sources; develop queries, data models, relationships, calculations, and refresh processes.
• Translate financial requirements into analytics for revenue, gross margin, operating expense, working capital, forecasts, and variance reporting.
• Develop and maintain Power BI semantic models, measures, visuals, drill-through, and security.
• Reconcile dashboards to financial systems; investigate discrepancies and document controls.
• Partner with FP&A, Accounting, Operations, IT, and leaders to define KPIs and improve data quality and user experience.

Skills

Analytical thinking

Financial acumen

Attention to detail

Communication skills

Education

Bachelor's degree in Finance or related field

Tools

Power BI

Excel

Microsoft Dynamics 365

SQL

Job description

KGPCo is seeking a Financial BI Analyst based in Lenexa, KS. This hands-on role transforms financial and operational data into scalable dashboards, reporting suites, and KPIs.

You will work with data warehouses, Dynamics 365, and ERP systems to build trusted data models, automate reporting, ensure data quality, and deliver actionable insights for planning and performance management. The role requires collaboration with FP&A, Accounting, Operations, IT, and business leaders to define KPIs,