Business Data Analyst

Bring finance and business intelligence together to create reporting, analysis, and actionable insights for aerospace and defense manufacturing leadership.

• Design, build, and maintain production reports and dashboards in Power BI or Infor Birst
  , from data source 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 to ensure consistent metric definitions
• Own report governance including refresh schedules, access and row-level security
  , version control, and retirement of redundant or manual reporting
• Analyze manufacturing cost performance across 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 changes
• Build variance analysis connecting actual to standard, plan, and forecast in a format operating leaders can act on
• Provide analytics for inventory valuation, excess and obsolete reserves, cycle count accuracy, and inventory turns
• Conduct ad hoc analysis for 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 financial impact
• Build and maintain advanced Excel models using pivot tables, Power Query, Power Pivot, and scenario analysis
• Develop and track key performance indicators with operating leaders, ensuring KPI definitions tie back to reported financial results
• Partner with IT and ERP resources on data structures, master data quality, and system enhancements affecting reporting
• Reconcile and validate BI outputs to general ledger and ERP source data before publishing results
• Document data lineage, business rules, and report logic to make reporting supportable without relying on a single person
• Present analysis to site and business unit leadership with clear conclusions supported by evidence
• Work cross-functionally with operations, supply chain, quality, engineering, and program management to understand processes behind the data
• Exercise judgment and discretion with confidential financial, customer, and employee data

• 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 for data extraction and transformation 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
• U.S. Person status as defined under ITAR and EAR due to the nature of the work performed

• Power BI
• Infor Birst
• SQL
• ERP
• Excel
• Power Query
• Power Pivot
• CTEs
• window functions
• BOM
• Power Automate
• Python
• R
• VBA
• Infor Cloud Suite Industrial (Syte Line)

• Comprehensive medical, dental, and vision coverage
• HSA and FSA options
• Onsite cafeteria and fitness center
• Competitive pay
• Annual bonus opportunity
• 401(k)-retirement plan with up to a 4% company match plus an additional annual…