FP&A & BI Analyst — Power BI, Forecasting & Insights

Great Lakes Dental Technologies; City of Tonawanda (NY); On-site; USD 85,000 - 95,000; Full time

Job summary

Great Lakes Dental Technologies is seeking an FP&A and Business Intelligence Analyst to support financial planning, forecasting, reporting, and business analysis. You will craft Power BI dashboards and financial models, partner with leaders to deliver insights, and help drive data‑driven decisions.

The role requires a Bachelor’s degree and 5+ years in FP&A or BI, with strong Excel and Power BI skills. The position offers a 9–5 schedule, typical Monday–Friday, in a United States location.

Qualifications

• Bachelor’s degree in Finance, Accounting, Business Administration, Business Analytics, Data Analytics, Information Systems, or a related field required.
• Five or more years of related experience in financial planning and analysis, financial reporting, business analytics, accounting, or business intelligence.
• Experience developing financial reports, dashboards, forecasts, budgets, variance analysis, and/or financial models required.
• Proficiency with Microsoft Excel, including advanced formulas, pivot tables, data analysis, and financial modeling required.
• Experience developing reports and dashboards in Microsoft Power BI required.
• Working knowledge of ERP systems and financial/business reporting systems required.
• Experience with SQL, data modeling, data validation, and/or data extraction preferred.

Responsibilities

• Supports the financial planning and analysis function, including budgeting, forecasting, financial modeling, variance analysis, and management reporting.
• Works with leaders to understand reporting needs, provide financial and operational information, analyze performance, and support data‑driven decision‑making.
• Develops, maintains, and enhances Power BI dashboards and reports for visibility into key metrics.
• Defines KPIs with department leaders and provides actionable insights.
• Prepares recurring and ad hoc reports on revenue, expenses, margins, labor, production, and inventory.
• Assists with monthly, quarterly, and annual financial reporting by gathering and analyzing data.
• Supports annual budgeting by compiling data and preparing schedules for budget‑to‑actual reporting.

Skills

Power BI dashboards

Excel advanced

Financial analysis

Variance analysis

Data visualization

Financial reporting

Education

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

Tools

SQL

ERP systems

Data modeling

Job description

Great Lakes Dental Technologies is seeking an FP&A and Business Intelligence Analyst to support financial planning, forecasting, reporting, and business analysis. You will craft Power BI dashboards and financial models, partner with leaders to deliver insights, and help drive data‑driven decisions.

The role requires a Bachelor’s degree and 5+ years in FP&A or BI, with strong Excel and Power BI skills. The position offers a 9–5 schedule, typical Monday–Friday, in a United States location.