FP&A Systems & Insight Analyst

Array Tech, Inc.; Chandler (AZ); On-site; USD 70,000 - 90,000; Full time

Job summary

Array Tech, Inc. is seeking a highly technical FP&A Systems & Insight Analyst to drive best-in-class reporting and automation. This role involves owning Power BI development and enhancing financial data architectures to modernize FP&A operations.

You will develop key dashboards, integrate financial systems, and automate processes to improve data integrity. The ideal candidate has a Bachelor’s in a related field and 2–6 years of experience in financial analytics.

Qualifications

• Expertise in Power BI including DAX and dataflows.
• 2–6 years of experience in financial reporting or data analytics.
• Strong analytical mindset and communication skills.

Responsibilities

• Develop and maintain dashboards in Power BI.
• Integrate data between various financial systems.
• Automate financial reporting processes.

Skills

Power BI development

Data analytics

Financial statements understanding

Excel proficiency

Workflow automation

Education

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

Tools

Power BI

SQL

Job description

FP&A Systems & Insight Analyst

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. Diagnose and resolve 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.

Equal Employment Opportunity

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.