Aerospace Finance & BI Analyst (Power BI | SQL)

DataJobs; Vergennes (VT); Sur place; USD 90 000 - 140 000; Plein temps

Avantages offerts par ce poste

401(k) match

Annual bonus

Tuition reimbursement

Paid time off

Onsite cafeteria

Life and disability insurance

Parental leave

Holiday shutdown days

Employee assistance program

Résumé du poste

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

Responsabilités

• 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

Connaissances

Power BI

SQL

Excel

ERP systems

Financial analysis

Data analytics

Stakeholder communication

Formation

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

Outils

Infor Birst

Infor CloudSuite Industrial (SyteLine)

Power Automate

Python

R

VBA

Description du poste

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.