Financial Business Intelligence (BI) Analyst

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

Overview

KGPCo is the go-to partner to Communications Service Providers. Our customers rely on our extensive range of network solutions and services to help them build, maintain, and transform networks that connect the world.

The communications industry is evolving every day and we are at the frontline of these innovations. From ground to cloud, the work we do is transforming networks and impacting communities nationwide. It’s work that happens because of our motivated teams of doers and problem solvers.

Our Core Values define how we do business:

• The Customer is Everything.
• Relationships Matter. All of Them.
• Question Things. Take Action.
• Work Hard. Work Smart. Enjoy the Experience.
• Growth Mindset.

It’s not just a job – it’s a step in your career!

Responsibilities

This position is based in Lenexa, KS and doesnotoffer relocation assistance, and candidates must be able to work at the designated location without employer-provided relocation support. Additionally, this position isnot eligiblefor U.S. work visa sponsorship. Candidates must belegally authorized to work in the United Statesat the time of application without sponsorship.

SUMMARY 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. This 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.

Qualifications

Key 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.

Required 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 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, with the ability to translate technical findings into clear business insights and manage multiple priorities.

Preferred Qualifications

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; and relevant Microsoft Power BI or Dynamics 365 certifications.

WORK ENVIRONMENT

The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this position. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

The noise level in the work environment is usually moderate.

BENEFITS

• Medical, Dental, Vision and Supplemental insurance plans
• Flexible Spending Accounts
• 401(k) with Company match
• Generous vacation, holiday, and sick/safe time
• Pet insurance for our non-human family members

Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability, protected veteran status or other characteristics protected by law.

#KGP2018