Business Data Analyst

For nearly a century, Simmonds Precision has been helping shape the future of flight from our home in Vergennes, Vermont. Today, our technologies are trusted across hundreds of commercial and military aircraft platforms worldwide, helping aircraft operate safely, reliably, and efficiently.

At Simmonds Precision, we design and manufacture advanced sensing, monitoring, fuel management, and precision control technologies that solve some of aerospace’s most demanding challenges. Behind every solution is a team of talented people who bring together engineering expertise, advanced manufacturing, craftsmanship, and a drive to innovate.

When you join Simmonds Precision, you’re not just taking the next step in your career, you’re contributing to technology that takes flight around the world. Whether your expertise is in engineering, manufacturing, quality, operations, or business support, there’s an opportunity to make your mark.

Find your next opportunity where precision meets possibility—and build your career in aerospace with Simmonds Precision.

The Business Data Analyst bridges finance and business intelligence, turning data from the ERP and surrounding systems into reporting, analysis, and insight that leadership uses to run the business. This role is financial with a heavy focus on information technology skills: building and maintaining reports and dashboards, writing the SQL behind them, and then applying accounting and operational judgment to explain what the numbers actually mean.

This position partners with finance, operations, supply chain and IT to establish trusted, consistent sources of truth for business performance. The analyst is expected to move from a leadership question to a validated answer independently, and to present findings clearly and concisely to both financial and non-financial audiences in an aerospace and defense manufacturing environment.

• 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, including joins, aggregations, CTEs, and window functions.
• Develop and maintain data models, calculated measures, and a documented data dictionary so that metric definitions are consistent across the business.
• Manage report governance: refresh schedules, access and row-level security, version control, and retirement of redundant or manual reporting.
• Analyze manufacturing cost performance including direct labor, material, overhead absorption, purchase price variance, scrap, rework, and yield.
• Support standard cost development, annual cost rolls, and review of BOM, routing, and rate data for accuracy and reasonableness.
• Perform margin analysis by program, product line, customer, and part number, and explain drivers behind period-over-period movement.
• Build variance analysis that bridges actual to standard, plan, and forecast in a way operating leaders can act on.
• Provide analytics supporting inventory valuation, excess and obsolete reserves, cycle count accuracy, and inventory turns.

• Conduct ad hoc analysis supporting pricing, make-versus-buy, capacity planning, capital investment, and cost reduction initiatives.
• Identify trends and anomalies in operational and financial data, investigate root cause, and quantify the financial impact of the opportunity or risk.
• Build and maintain advanced Excel models using pivot tables, Power Query, Power Pivot, and scenario analysis to support planning and business cases.
• Develop and track key performance indicators with operating leaders, ensuring measures tie back to reported financial…