Business Data 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

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.

Key Responsibilities

Business Intelligence & Reporting

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

Business Analysis & Decision Support

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

Data Integrity & Systems

• Partner with IT and ERP resources on data structures, master data quality, and system enhancements affecting reporting.
• Reconcile and validate business intelligence outputs to the general ledger and ERP source data before results are published.
• Document data lineage, business rules, and report logic so reporting is supportable and not dependent on a single individual.

Communication & Partnership

• Present analysis to site and business unit leadership in a clear, concise format that leads with the conclusion and supports it with evidence.
• Work cross-functionally with operations, supply chain, quality, engineering, and program management to understand the processes behind the data.
• Exercise appropriate judgment and discretion with confidential financial, customer, and employee data.

Required 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, preferably in a manufacturing environment.
• Demonstrated 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.

Preferred Qualifications

• Hands-on experience with Infor Birst and Infor CloudSuite Industrial (SyteLine).
• Experience in aerospace or defense manufacturing, including program-based accounting and familiarity with FAR/DFARS requirements.
• Exposure to data warehouse concepts and dimensional modeling.
• Experience with Python, R, VBA, or Power Automate for data preparation and process automation.
• Professional certification such as CMA, CPA, or a business intelligence certification (e.g., Microsoft PL-300).
• Strong analytical and problem-solving skills with the curiosity to pursue root cause rather than stop at the symptom.
• Healthy skepticism toward data quality, with the discipline to validate results before publishing them.
• Ability to simplify complex information without losing the accuracy that makes it useful.
• Self-directed, able to manage multiple priorities and competing requests in a fast-paced manufacturing environment.
• Collaborative approach with the confidence to challenge assumptions and influence decisions.
• High ethical standards and commitment to accuracy, compliance, and confidentiality.

Working Conditions & Physical Requirements

• Office setting within a manufacturing facility, with regular interaction on the production floor.
• Extended periods of computer use, data analysis, and report development.
• Occasional extended hours during month-end close, budgeting cycles, and critical reporting deadlines.
• Occasional travel to other company sites or customer locations may be required.

Great work deserves great rewards—and benefits that support you both at work and beyond. Our comprehensive total rewards package is designed to help you stay healthy, build financial security, enjoy time away from work, and continue growing throughout your career.

• Health & Wellness: Take care of yourself and your family with comprehensive medical, dental, and vision coverage, HSA and FSA options, and convenient access to an onsite cafeteria and fitness center.
• Invest in Your Future: Enjoy competitive pay, an annual bonus opportunity, and a 401(k)-retirement plan that includes up to a 4% company match plus an additional annual employer contribution starting at 3%. Company-paid life and disability insurance provide additional financial protection and peace of mind.
• Time to Recharge: We believe time away from work matters. Enjoy four weeks of vacation, plus five additional paid days during our annual holiday shutdown, paid sick leave, and paid maternity and paternity leave—giving you more time for the moments that matter.
• Grow Your Career: Keep building your skills and advancing your career with up to $20,000 in annual tuition reimbursement, along with ongoing professional development and learning opportunities.
• Benefits Beyond the Basics: Choose from additional programs designed to make life a little easier, including supplemental insurance, an Employee Assistance Program (EAP), legal services, identity theft protection, discounted auto and home insurance, and pet insurance.

Your career is more than a paycheck. Join a company that invests in your health, your future, your growth, and your life outside of work.

Compensation Range

$90,000-$140,000

Full-time/Part-time

Full-time

This Company is an Equal Opportunity Employer, and does not discriminate on the basis of race, gender, ethnicity, religion, national origin, age, disability, veteran status, or on any other basis prohibited by law. Information on race, gender and national origin will only be used for statistical and recordkeeping purposes, and will not be used in making any employment decisions. All information provided will be kept separate from your expression of interest. Providing this information is strictly voluntary, and you will not be subjected to any adverse action or treatment if you choose not to provide this information. If you do not choose to answer these questions, we ask that you select "Decline to Identify" for each question. Thank you for your voluntary cooperation.