FP&A Systems & Insight Analyst
Array Technologies · Chandler, AZ · 1 mo ago
Information TechnologyFull-time
Key Job Responsibilities
- 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.
- 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.
- 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.
- 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.