Data Analyst

About magniX

Based in the beautiful Pacific Northwest, magniX is a pioneer in electric propulsion and battery technology for the aerospace industry. We’re working to revolutionize how the world connects by transforming the way aircraft are powered. magniX has been at the leading edge of electric propulsion innovation for almost 20 years, and has successfully demonstrated our technology in flight. We are now on the path to take our proven technology and innovative products to market.

Join us to be part of a passionate team that is ushering in a new era of aviation.

The Data Analyst role exists to make our data trustworthy. MagniX operates across multiple systems — ERP, program management, and financial planning tools — and this analyst will be the person who understands how data flows between them, where it breaks down, and how to fix it. Working closely with our Program Analytics PM and Finance lead, you will own the data layer that makes everyone else’s analysis reliable.

This is a build environment, not a maintenance environment. If you are excited by the idea of creating structure where there isn’t any yet — and doing it in an aerospace company that is redefining what electric flight looks like — this role is for you.

Data Integrity & Source Understanding

• Develop a working understanding of magniX’s key data sources — ERP, program management systems, and financial planning tools — and how data flows between them.
• Identify inconsistencies in data (e.g., project codes, cost center IDs, naming conventions) across systems and work with stakeholders to resolve them at the source.
• Build and maintain basic data controls: validation rules, naming standards, and flagging logic to catch upstream errors before they propagate downstream.
• Create and maintain a living data dictionary: document what key fields mean, where they come from, and who owns them.

Power BI Development & Maintenance

• Build, maintain, and improve Power BI reports and dashboards supporting Finance, Program Management, and Operations.
• Write and maintain Power Query (M) transformations to clean, shape, and stage data for reporting.
• Partner with the Finance lead on financial model logic and own the technical implementation in Power BI Desktop.
• Diagnose and resolve data load errors, schema mismatches, and query failures in the Power BI model.
• Support the evolution of department-level dashboards into executive-level reporting tools.

Reporting & Analysis Support

• Produce recurring financial and operational reports (actuals vs. budget, program cost tracking, variance analysis) with accuracy and on schedule.
• Translate data into clear insights for non-technical stakeholders — program managers, finance, and senior leadership.
• Support preparation of PSRs, PMRs, and QERs with accurate, well-structured data packages.

Cross-Functional Collaboration

• Work alongside the Program Analytics PM to align data definitions, reporting standards, and dashboard strategy across programs and functions.
• Engage with program managers and operations staff to understand their data needs and surface gaps early.
• Proactively communicate data issues and their downstream impacts rather than waiting to be asked.

• 3+ years of experience in data analysis, business intelligence, FP&A, or a closely related function.
• Proficiency in Power BI, including report and dashboard development.
• Hands‑on Power Query (M) experience — ability to write, read, and debug M code, not just use the GUI.
• Familiarity with data modeling concepts: fact vs. dimension tables, relationships, cardinality.
• Financial literacy: ability to read and interpret a P&L, balance sheet, and cash flow statement; understanding of actuals vs. budget vs. forecast.

• Experience in an aerospace, defense, manufacturing or aviation environment.
• FP&A background or experience supporting a finance function directly.
• Exposure to ERP systems (SAP, Odoo)
• Familiarity with SharePoint as a data source.
• Familiarity with program financial reporting (EVMS, Earned Value, program cost tracking).
• Exposure to project management tooling (MS Project, Unanet, or similar).

Applicants…