Senior Business Finance Analyst

IDEAL Industries, Inc.; Sycamore (IL); On-site; USD 96,000 - 129,000; Full time

Benefits offered by this job

Education Reimbursement

Wellness Programs

401k with Company Match

Cash Balance Pension Plan

Vacation

Personal Days

Holidays

Job summary

IDEAL Industries, Inc. is seeking a Senior Business Finance Analyst in Sycamore, IL. You will lead BI reporting and analytics across Finance, collaborating with FP&A, Controllership, Operations and IT to improve data quality and automate processes.

You will design scalable reporting, validate data, and translate Finance needs into system improvements, enabling data-driven decisions and operational excellence.

Qualifications

• Finance analytics, budgeting, forecasting, and variance analysis experience.
• Strong Power BI, DAX, Excel and data modeling skills.
• Experience with finance systems and data reconciliation.
• Ability to partner with FP&A, Controllership, Operations and cross-functional teams.
• Advanced communication, documentation and facilitation skills.

Responsibilities

• Lead the design, development, and maintenance of Power BI dashboards and KPI reporting for Finance.
• Translate business requirements into scalable reporting solutions and data models.
• Develop reporting solutions using Power BI, DAX, Excel, and OneStream.
• Analyze financial and operational results to identify trends and opportunities.
• Support Finance transformation and automation initiatives across systems.

Skills

Finance analytics

Power BI dashboards

Advanced Excel

Cross-functional partnering

Problem solving

Education

Bachelor's degree in Finance or related field

Tools

Power BI

OneStream

Microsoft Dynamics 365

SQL

Job description

Senior Business Finance Analyst

Staff, Office Sycamore, IL, US

7 days ago Requisition ID: 1283

Salary Range: $95,845.00 To $129,155.00 Annually

IDEAL Industries, Inc. has built a reputation for over a century by crafting iconic tools and practical technology required in aerospace, data communications, electrical, wire processing and construction. The global family of IDEAL brands includes IDEAL Electrical, Anderson Power, and Enatel. A vibrant and dynamic company, IDEAL is best known for our wire connectors, the gold standard for making electrical connections around the world. Nearly every commercial jet is assembled using IDEAL wire strippers and, as part of the critical equipment on NASA missions, our tools even help NASA astronauts fly to the moon. Most important, our products benefit skilled tradespeople, who reach for IDEAL tools every day.

IDEAL is propelled by the concept of Building an IDEAL World. Our family-run business is committed to building ideal relationships with customers, employees, and communities by crafting some of our industry’s most innovative and trusted tools.

The Senior Finance Business Analyst helps transform how Finance operates through improved analytics, processes, data, systems, and automation. Working at the intersection of Finance and Technology, this role develops scalable reporting solutions, translates Finance needs into system and process improvements, strengthens data quality, and reduces manual effort.

Essential Job Functions

Business Intelligence & Analytics

• Lead the design, development, and maintenance of Power BI dashboards, reports, data models, and standardized KPI reporting for Finance and business leaders.
• Translate business requirements into scalable reporting solutions that provide insights into financial and operational performance.
• Develop reporting and analytical solutions using Power BI, DAX, Excel, Power Query, OneStream, and workflow or automation technologies.
• Ensure reporting is accurate, consistent, well documented, and supported by clear data definitions and governance.
• Analyze financial and operational results to identify trends, performance drivers, risks, and opportunities.

Finance Systems, Data & Process Improvement

• Support and continuously improve Finance applications, including OneStream, Microsoft Dynamics 365, planning platforms, reporting tools, and emerging AI-based capabilities.
• Understand and improve financial data flows between source systems, planning applications, and reporting platforms.
• Validate and reconcile data, investigate reporting issues, and coordinate resolution with Finance and technology teams.
• Analyze current Finance processes and design standardized, scalable future-state processes.
• Identify and implement opportunities to automate activities, reduce spreadsheet dependency, and eliminate repetitive data preparation.

Business Analysis, Implementation & Change

• Gather and translate Finance needs into clear business requirements, functional requirements, workflows, business rules, data requirements, and acceptance criteria.
• Facilitate stakeholder workshops and act as the liaison among Finance, IT, business teams, external consultants, and software providers.
• Develop test scenarios, coordinate user acceptance testing, validate calculations and data flows, and track issues through resolution.
• Support Finance transformation initiatives from requirements through deployment, including project coordination, risk and issue monitoring, training, and user adoption.
• Develop process maps, procedures, solution documentation, and user guidance to support sustainable implementation.

Financial Analysis & Business Partnership

• Provide variance, trend, performance-driver, financial modeling, and scenario analysis to support business decisions.
• Assist with budgeting, forecasting, long-range planning, management reporting, and executive presentations.
• Partner with FP&A, Controllership, Operations, Manufacturing, Supply Chain, and Commercial teams to analyze performance and identify risks and opportunities.
• Deliver clear, actionable insights and recommendations based on financial and operational data.
• Support continuous improvement initiatives and special projects that enhance Finance effectiveness.
• Actively engage in responsibilities and initiatives to ensure a safe work environment.
• Comply with and contribute to the continuous improvement of company policies, processes, and procedures.
• Contribute to a collaborative, team-oriented workplace, which may include other duties as assigned.

Additional Responsibilities:

• Perform other Finance analysis, reporting, systems, or transformation assignments as business needs require.

Knowledge, Skills and Abilities

• Strong understanding of Finance processes, including financial reporting, variance analysis, budgeting, forecasting, and management reporting.
• Hands-on skill designing, developing, and maintaining Power BI dashboards, reports, semantic models, relationships, and DAX calculations.
• Advanced analytical and problem-solving ability, including investigating data issues, identifying root causes, and translating findings into actionable insights.
• Ability to work with cloud-based data warehouses and reconcile data across multiple source systems.
• Advanced Microsoft Excel skills and proficiency with the broader Microsoft 365 environment.
• Strong interpersonal skills and the ability to partner effectively across global and cross-functional teams.
• Excellent written, verbal, presentation, documentation, and facilitation skills.

Qualifications:

• Bachelor's degree in Finance, Accounting, Business Analytics, Information Systems, or a related field required.
• Five or more years of progressively responsible experience in Finance analytics, business intelligence, business analysis, or Finance systems, preferably in a manufacturing or operational environment.
• Experience with Microsoft Dynamics 365 or a similar Tier 1 ERP system preferred.
• Experience with OneStream or another enterprise planning and performance-management platform preferred.
• FP&A, budgeting, or forecasting experience in a global or multi-entity environment preferred.
• Familiarity with SQL, cloud-data platforms, or data-integration concepts preferred.

The expected salary for this position is between $95,845.00 and $129,155.00 per year. This range represents a good faith estimate for the position and actual compensation will be based on numerous factors including knowledge, location, skills, training and experience.

IDEALemployees enjoy a wide range of valuable benefits including:

• Education Reimbursement
• Wellness Programs
• 401k with Company Match
• Cash Balance Pension Plan

IDEAL values rest, personal time and community involvement facilitating these through several paid time off programs including:

• Vacation
• Personal Days
• Holidays

IDEAL INDUSTRIES, INC. is proud to be one of Newsweek’s Global Top 100 Most Loved Workplaces and an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability, or protected veteran status. We know when you honor relationships, success for all will follow. To learn more about us, visit www.idealindustries.com