Data Jobs in Vergennes, VT

1 job found

Include remote jobs

Today

Business Data Analyst

Simmonds Precision Products Vergennes, VT

Vergennes, VT

Today

$90k - $140k/yr Full time Business Analytics Business Intelligence Data Analysis

Apply Now

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

View full job page →

Get Data Jobs in Vergennes, VT alerts

New Data Jobs in Vergennes, VT, daily.