Aerospace Data & BI Analyst

Simmonds Precision; Vermont; Hybrid; USD 90,000 - 140,000; Full time

Benefits offered by this job

Health & Wellness

Bonus & 401k

Vacation & time off

Tuition reimbursement

Additional benefits

Job summary

Simmonds Precision, a leader in aerospace manufacturing, seeks a Business Data Analyst to bridge finance and BI. You will turn ERP data into actionable reports, write SQL, and build dashboards that inform leadership decisions in a fast-paced environment.

You’ll partner with finance, operations, supply chain and IT, ensure data integrity, and present clear insights with concise storytelling. A bachelor’s in a related field and 3–5 years of BI or financial analytics are preferred.

Qualifications

• Bachelor’s degree in Finance, Accounting, Business Analytics, Information Systems, Data Science, or a related field.
• 3–5 years of experience in financial analysis, business intelligence, or data analytics.
• Experience building and maintaining production reports and dashboards in Power BI, Infor Birst, or a comparable enterprise BI platform.
• Proficiency writing and tuning SQL to extract and transform data from relational databases.
• Advanced Microsoft Excel skills, including complex formulas, pivot tables, Power Query, and financial modeling.
• Experience extracting and interpreting data from an ERP system.
• Ability to translate technical analysis into clear, actionable recommendations for non-technical stakeholders.
• Must be a U.S. Person as defined under ITAR and EAR due to the nature of the work performed.

Responsibilities

• Design, build, and maintain production reports and dashboards in Power BI or Infor Birst, from data source through to published visualization.
• Write, optimize, and troubleshoot SQL against ERP tables, views, and reporting databases.
• Develop and maintain data models, calculated measures, and a documented data dictionary.
• Manage report governance: refresh schedules, access and row-level security, version control, and retirement of redundant reporting.
• Analyze manufacturing cost performance including direct labor, material, overhead absorption, PO variance, scrap, rework, and yield.
• Support standard cost development, annual cost rolls, and review BOM, routing, and rate data for accuracy.
• Perform margin analysis by program, product line, customer, and part number.
• Build variance analysis bridging actual to standard, plan, and forecast for leaders.
• Provide analytics supporting inventory valuation, excess reserves, cycle count accuracy, and inventory turns.
• Conduct ad hoc analysis supporting pricing, make-versus-buy, capacity planning, and cost reduction.
• Identify trends, investigate root cause, and quantify financial impact.
• Build and track KPIs with operating leaders and tie measures to financial results.
• Reconcile BI outputs to GL and ERP data; document data lineage and rules.

Skills

Power BI

SQL

Excel

Financial analysis

Data analytics

Education

Bachelor's degree

Tools

Infor Birst

Infor CloudSuite Industrial (SyteLine)

Job description

Simmonds Precision, a leader in aerospace manufacturing, seeks a Business Data Analyst to bridge finance and BI. You will turn ERP data into actionable reports, write SQL, and build dashboards that inform leadership decisions in a fast-paced environment.

You’ll partner with finance, operations, supply chain and IT, ensure data integrity, and present clear insights with concise storytelling. A bachelor’s in a related field and 3–5 years of BI or financial analytics are preferred.