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.
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.
Cost Accounting & Financial Analysis
- 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.
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.
Why Join Us
At Simmonds Precision Products, Inc., employees support products and technologies that help power the aerospace industry. We are committed to safety, quality, innovation, and the continued development of highly skilled technical professionals.
Compensation & Benefits
We believe great work deserves great support. Our total rewards package is designed to take care of your health, your future, and your everyday life:
- Health & Wellness: Medical, dental, and vision coverage, plus HSA/FSA options, an onsite cafeteria and fitness center.
- Financial Security: Build your future with competitive pay, an annual bonus opportunity, a 401(k) plan with up to 4% company match with an additional annual employer contribution starting at 3% toward your retirement, and company-paid life and disability insurance.
- Time to Recharge: Enjoy four (4) weeks of vacation, five (5) additional days of paid time off during our annual holiday shutdown. We also offer paid sick leave, maternity and paternity leave, giving you time to rest, recharge and focus on the time you need.
- Grow Your Career: Generous tuition reimbursement up to $20,000 annually combined with ongoing professional development opportunities to keep learning and moving forward
- Extras That Make Life Easier: Supplemental insurance options, Employee Assistance Program (EAP), legal services, identity theft protection, discounted auto/home insurance, and pet insurance
