FP&A Systems & Insight Analyst

Job Description:

FP&A Systems & Insight Analyst

Job Summary:

We are looking for a highly technical, systems-driven FP&A Systems & Insights Analyst to elevate our Finance organization through best-in-class reporting, automation, and data architecture. This role is the backbone of Finance’s analytical ecosystem—owning Power BI development, financial data models, planning system data structures, and system-driven process improvements. 

The ideal candidate is a Power BI and data analytics expert first, with strong fluency in financial statements and FP&A workflows, and a passion for building durable, system-driven solutions rather than manual reporting. 

This role builds the systems, dashboards, and automation that modernize how FP&A operates across Corporate and Commercial Finance. Your work enables faster insights, better decisions, and a scalable analytics environment. 

Key Job Responsibilities:

Power BI Development & Ownership 

• Serve as the Power BI expert for Finance and own all dashboards supporting Corporate FP&A and Commercial Finance—including revenue, margin, SG&A, OpEx, headcount, KPIs, forecasting, and executive reporting. 

• Build and maintain robust data models, DAX logic and dataflows. 

• Ensure high performance, governance, documentation, and scalability across all reports. 

• Standardize design, metrics, visualizations, and BI best practices across the organization. 

• Reduce ad-hoc reporting by delivering reusable datasets and self-service solutions 

Data Architecture & Systems Integration 

• Own and enhance end‑to‑end reporting pipelines between ERP, HRIS, CRM, FP&A planning tools, and BI systems. 

• Design and maintain data structures that support operational forecasting and long-range planning 

• Diagnosing and resolving data issues, refresh failures, and modeling inconsistencies. 

• Collaborate with IT and third‑party vendors on integrations, metadata structure, and system reliability. 

• Maintain a single source of truth for all corporate and commercial financial data. 

Automation & Process Optimization 

• Automate manual financial reporting using Power Query, dataflows, data modeling, and workflow automation tools. 

• Streamline forecasting, close and reporting cycles via system-driven enhancements. 

• Improve data integrity, metric consistency, and FP&A repeatability across all functions. 

• Enable evolve processes for AI solutions to accelerate real time information and predictability. 

FP&A Support 

• Support quarterly forecasting, monthly outlooks, and annual planning through automated tools and structured datasets. 

• Support analytics across Corporate FP&A and Commercial Finance. 

• Conduct variance analyses with data-driven insights. 

Qualifications:

• Bachelor’s degree in Data Analytics, Information Systems, Finance, Accounting, or related field. 

• Advanced Power BI expertise: DAX, Power Query (M), dimensional data modeling, dataflows, and workspace management. 

• 2–6 years of relevant experience in BI development, data analytics, FP&A, or financial reporting. 

• Strong understanding of financial statements and core budgeting/forecasting concepts. 

• High proficiency in Excel. 

• Demonstrated ability to automate manual workflows and build scalable reporting solutions. 

• Strong analytical mindset and communication skills. 

Preferred Qualifications:

• SQL or relational database experience. 

• Experience with ERP/HRIS/CRM systems. 

• Experience with FP&A platforms such as Adaptive Insights, Planful, or Anaplan. 

• Experience supporting revenue, margin, or commercial analytics. 

At Array Tech, Inc., we strive to lead with our culture, and believe that our people are a key enabler of our future state. Our total rewards philosophy supports Array’s ability to attract, develop, and retain our employees. We offer competitive compensation, benefits and wellness programs that align with the local markets where we do business. 

Array Tech, Inc. offers equal employment opportunity without regard to race, color, gender, age, creed, sex, religion, national origin, disability (physical or mental), marital status, citizenship, ancestry, sexual orientation, gender identity, and gender expression, or any other legally protected status.