FP&A Data Analyst — BI Dashboards & Forecasting

Garney Construction; North Kansas City (MO); On-site; USD 85,000 - 110,000; Full time

Benefits offered by this job

Medical/dental/vision plans

Stock options

401(k) match

Weekly pay

Paid time off

HSA

Life insurance

Disability coverage

Counseling services

Legal/financial consultations

Job summary

Garney Construction is seeking a Financial Data Analyst to support its newly established FP&A function by analyzing financial and operational data, developing dashboards and KPI reporting, and providing data-driven insights to forecast and plan. This role will work closely with FP&A leadership and Financial Analysts to build reporting capabilities and transform data into actionable business intelligence.

The ideal candidate will have 3+ years in data analytics, strong Excel and SQL skills, and

Qualifications

• Bachelor's degree required in data/analytics or related field.
• 3+ years in data analytics, BI, reporting or similar analytical role.
• Strong analytical and problem-solving skills with ability to interpret complex data.
• Experience building dashboards, reports, and data visualizations using Power BI or similar BI tools.
• Advanced Excel skills and experience working with large, complex datasets.
• Proficiency with SQL, Power Query, or other data analysis/reporting tools.
• Ability to translate data into clear, actionable insights for business decisions.
• Strong attention to detail and commitment to data quality and integrity.
• Excellent organizational, communication, and collaboration skills, able to manage multiple priorities.
• Experience supporting finance, FP&A, accounting, or business planning; construction/engineering industry a plus.

Responsibilities

• Analyze financial, operational, and project data to identify trends, risks, opportunities, and key business drivers.
• Develop reporting and analyses that support budgeting, forecasting, and long-term business planning.
• Perform variance analysis and provide data-driven recommendations for strategic decision-making.
• Build and maintain dashboards, KPI reporting, and executive scorecards for visibility into performance.
• Create clear data visualizations that transform complex information into actionable insights.
• Partner with leaders and cross-functional teams to develop performance metrics and reporting solutions.
• Support forecasting and scenario modeling through data preparation, analysis, and reporting.
• Ensure accuracy, reliability, and integrity of data used for reporting and decision-making.
• Drive process improvements by automating recurring reports and enhancing reporting efficiency via BI tools.
• Collaborate with FP&A, IT, and stakeholders to strengthen data governance and reporting capabilities.

Skills

Power BI

SQL

Excel

Data analysis

Communication

Education

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

Tools

Power BI

SQL

Power Query

Excel

Job description

Garney Construction is seeking a Financial Data Analyst to support its newly established FP&A function by analyzing financial and operational data, developing dashboards and KPI reporting, and providing data-driven insights to forecast and plan. This role will work closely with FP&A leadership and Financial Analysts to build reporting capabilities and transform data into actionable business intelligence.

The ideal candidate will have 3+ years in data analytics, strong Excel and SQL skills, and