Senior Business Finance Analyst

Lonestar State College; Sycamore (IL); On-site; USD 96,000 - 129,000; Full time

Benefits offered by this job

Medical, Dental & Vision Insurance

Education Reimbursement

Wellness Programs

401k with Company Match

Cash Balance Pension Plan

Job summary

IDEAL Industries, Inc. is seeking a Senior Finance Business Analyst to transform Finance analytics, reporting, and automation. The role sits at the intersection of Finance and Technology, delivering scalable reporting, data quality improvements, and system/process enhancements across planning and reporting tools.

You will lead Power BI reporting, work with OneStream and D365, and partner with Finance, IT, and operations to reduce manual effort and standardize processes.

Qualifications

• Bachelor's degree or higher in a finance/analytics field.
• 5+ years in finance analytics, BI, or finance systems.
• Experience with ERP and planning platforms (OneStream/D365).

Responsibilities

• Lead design, development, and maintenance of Power BI dashboards and KPI reporting for Finance and leaders.
• Translate business requirements into scalable reporting solutions.
• Analyze data to identify trends, risks, and opportunities.
• Improve data flows between source systems and reporting platforms.
• Support Finance transformation initiatives from requirements through deployment.

Skills

Power BI

DAX

Excel

Data governance

Analytical thinking

Stakeholder collaboration

SQL

Education

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

Tools

OneStream

Microsoft Dynamics 365

Job description

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

• 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:Medical, Dental & Vision InsuranceEducation ReimbursementWellness Programs401k with Company MatchCash Balance Pension PlanIDEAL values rest, personal time and community involvement facilitating these through several paid time off programs including:VacationPersonal DaysVolunteer TimeHolidaysParental Leave

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