Finance BI Data Analyst (Power BI, SQL, ERP)

Simmonds Precision Products; St. Albans (VT); On-site; USD 75,000 - 110,000; Full time

Benefits offered by this job

Health & Wellness

Financial Security

Time to Recharge

Grow Your Career

Extras That Make Life Easier

Job summary

Simmonds Precision Products, Inc. seeks a Business Data Analyst to bridge finance and business intelligence, turning ERP and related data into reporting, analysis, and insight for leadership.

You will build and maintain reports and dashboards in Power BI or Infor Birst, write SQL against ERP data, and apply accounting judgment to explain numbers to senior stakeholders. Collaboration with IT and operations is essential.

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.
• 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.

Responsibilities

• 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.
• 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.

Skills

SQL

Excel

Data analysis

ERP data interpretation

Communicating insights

BI reporting

Education

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

Tools

Power BI

Infor Birst

Infor CloudSuite Industrial (SyteLine)

SQL Server / relational DBs

Job description

Simmonds Precision Products, Inc. seeks a Business Data Analyst to bridge finance and business intelligence, turning ERP and related data into reporting, analysis, and insight for leadership.

You will build and maintain reports and dashboards in Power BI or Infor Birst, write SQL against ERP data, and apply accounting judgment to explain numbers to senior stakeholders. Collaboration with IT and operations is essential.