Data Analyst

MAGNIX USA INC•Everett, WA

10h•$90,000 - $130,000•Onsite

About The Position

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 maintain 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.

Requirements

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.

Nice To Haves

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).

Responsibilities

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.
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.
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.
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.

Benefits

100% company-paid premiums for medical, dental, and vision insurance (for employees & dependents).
4 weeks paid vacation + 1-week annual end-of-year shutdown, sick time, and 11 paid holidays.
401K retirement plan with industry leading 9.5% company contribution.
Company paid Life insurance, AD&D, Short-Term and Long-Term disability insurance
Catered lunches and quarterly company fun-day events!

Stand Out From the Crowd

Upload your resume and get instant feedback on how well it matches this job.

Upload and Match Resume