FP&A Systems & Insight Analyst

Array-Technologies-2; Chandler (AZ); On-site; USD 100,000 - 140,000; Full time

Job summary

Array Tech, Inc. is seeking a highly technical FP&A Systems & Insights Analyst to elevate our Finance organization with best-in-class reporting, automation, and data architecture.

You will own Power BI development, financial data models, and planning system structures, delivering scalable analytics across Corporate and Commercial Finance. The role emphasizes durable, system-driven solutions, high performance dashboards, and end-to-end data pipelines.

Qualifications

• Bachelor’s degree in data analytics, information systems, finance, or accounting.
• Advanced Power BI: DAX, Power Query, dimensional modeling.
• 2–6 years in BI development, data analytics, FP&A, or financial reporting.
• Strong Excel proficiency.
• SQL or relational databases experience preferred.

Responsibilities

• Own Power BI development and dashboards for Corporate FP&A and Commercial Finance.
• Build and maintain data models, DAX logic, and dataflows.
• Design end‑to‑end reporting pipelines between ERP, HRIS, CRM, and FP&A tools.
• Automate manual reporting and streamline forecasting and close cycles.
• Support quarterly forecasting, monthly outlooks, and annual planning.

Skills

Power BI

DAX

Power Query

Data modeling

Dataflows

Workspace management

SQL

ERP integrations

Education

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

Tools

Adaptive Insights

Planful

Anaplan

ERP/HRIS/CRM integrations

Job description

Job Description:FP&A Systems & Insight AnalystJob 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 & OwnershipServe 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 solutionsData Architecture & Systems IntegrationOwn 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 planningDiagnosing 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 OptimizationAutomate 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 SupportSupport 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.#LI-JS1