Business Data Analyst

DataJobs; Vergennes (VT); On-site; USD 90,000 - 140,000; Full time

Benefits offered by this job

401(k) match

Annual bonus

Tuition reimbursement

Paid time off

Onsite cafeteria

Life and disability insurance

Parental leave

Holiday shutdown days

Employee assistance program

Job summary

DataJobs in Vergennes, VT seeks a finance BI Analyst to design and maintain production reports and dashboards using Power BI or Infor Birst. You will optimize SQL against ERP databases, build data models, and govern reporting with secure access and governance practices.

You will analyze manufacturing cost performance, support standard cost, margin analysis, and ad hoc pricing/capacity studies, delivering actionable insights for leadership.

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, BI, or data analytics, preferably in manufacturing
• Demonstrated experience building and maintaining production reports and dashboards in Power BI, Infor Birst, or a comparable 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

Responsibilities

• Design, build, and maintain production reports and dashboards in Power BI or Infor Birst
• Write, optimize, and troubleshoot SQL against ERP tables, views, and reporting databases
• Develop and maintain data models, calculated measures, and a documented data dictionary
• Own report governance including refresh schedules, access, row-level security, version control, and retirement of redundant reporting
• Analyze manufacturing cost performance across direct labor, material, overhead absorption, and variances
• Support standard cost development, annual cost rolls, and review of BOM, routing, and rate data
• Perform margin analysis by program, product line, customer, and part number
• Build variance analysis connecting actual to standard, plan, and forecast
• Provide analytics for inventory valuation and turns
• Conduct ad hoc analysis for pricing, capacity planning, and cost reduction initiatives
• Identify trends and quantify financial impact
• Build and maintain advanced Excel models using Pivot, Power Query, Power Pivot, and scenario analysis
• Develop and track KPIs with operating leaders
• Partner with IT and ERP resources on data structures and data quality
• Reconcile BI outputs to GL and ERP source data
• Document data lineage, business rules, and report logic
• Present analysis to leadership with evidence-based conclusions
• Work cross-functionally with operations, supply chain, quality, engineering, and program management
• Exercise judgment with confidential data

Skills

Power BI

SQL

Excel

ERP systems

Financial analysis

Data analytics

Stakeholder communication

Education

Bachelor's degree in Finance, Accounting, Business Analytics, Information Systems, Data Science, or related field

Tools

Infor Birst

Infor CloudSuite Industrial (SyteLine)

Power Automate

Python

R

VBA

Job description

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

Responsibilities

• 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

Requirements

• 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

Technologies

• Power BI
• Infor Birst
• SQL
• ERP
• Excel
• Power Query
• Power Pivot
• CTEs
• window functions
• BOM
• Power Automate
• Python
• R
• VBA
• Infor CloudSuite Industrial (SyteLine)

Benefits

• 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 employer contribution starting at 3%
• Company-paid life and disability insurance
• Four weeks of vacation
• Five additional paid days during annual holiday shutdown
• Paid sick leave
• Paid maternity and paternity leave
• Up to $20,000 in annual tuition reimbursement
• Ongoing professional development and learning opportunities
• Supplemental insurance
• Employee Assistance Program (EAP)
• Legal services
• Identity theft protection
• Discounted auto and home insurance
• Pet insurance

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)

Compensation

• $90,000-$140,000 per year

Location and Work Setting

• Vergennes, VT (onsite)
• Office setting within a manufacturing facility with regular interaction on the production floor

Working Conditions & Physical Requirements

• Extended periods of computer use for 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