Financial Data Analyst

IRCA is a prominent international provider of semi-finished ingredients for the bakery, pastry, and gelato markets. They cater to independent producers as well as large food manufacturers, including consumer packaged goods (CPG) companies. The company's core product offerings consist of chocolate, chocolate decorations, creams, pastry mixes, gelato ingredients, and various other bakery and pastry ingredients.Headquartered in Italy, IRCA was acquired by Advent International, a global private equity firm, in July 2022. The company has demonstrated a strong history of growth over the past decade. As part of its growth strategy, IRCA made two bolt-on acquisitions in 2022. They acquired Cesarin, a provider of candied fruits, and Anastasi, a supplier of pistachio ingredients. These acquisitions expanded IRCA's product portfolio and market reach.More recently, IRCA acquired the leading manufacturer of sweet and cereal products in Europe and the US. The target company focuses on high-value specialty ingredients for the Food Manufacturers segment. Their product range includes sweet particulates, chocolate confections, baked inclusions, variegates, and fruit purées. This deal, successfully completed in March of 2023, is a transformative move for IRCA, establishing them as a global leader in the semi-finished ingredients industry.With this acquisition, IRCA has a combined revenue of €1 billion in 2023 and a presence in 22 manufacturing facilities across Europe, the US, and Vietnam. This expanded manufacturing footprint and diversified product portfolio positions IRCA as a key player in the market, serving a wide range of customers in the bakery, pastry, and gelato sectors, as well as food manufacturers.The Financial Data Analyst will be a key analytical resource to the Finance and Commercial Teams. This position will support the existing reporting structure for Sales, Pricing, and Finance. This role will help lead the structuring and cleaning of data; develop and automate robust reporting and visualization; and support a wide range of ad hoc analytics. The primary focus of the role will be commercial analytics including commercial pipeline administration; demand, revenue, and margin forecasting, reporting, variance analysis, and scenario running; Pricing and profitability analytics; and other related ad hoc analytics. This role is highly visible with senior leadership and will be expected to be able to flex communication from very detailed and granular to summary narrative.This is a Hybrid role and you can work in our offices located in either Duluth, GA. or River North, Chicago. ILResponsibilities• Maintain the existing MS Excel/MS Access reporting models via data extractions from SAP, data management/realignment tools and 3rd party data.• Review/validate data for accuracy and consistency and work with any other teams necessary to improve the reliability of data• Prepare internal management daily/weekly/monthly/quarterly commercial reporting and analysis to support senior leadership and sales - such as the Daily Sales Report, ABC Customer analysis, Logistical Heat Maps and Key Customer reporting.• Assist with the budget and forecasting analysis/templates for FP&A for Volume, Revenue, and Cost.• Create new reporting dashboards mirroring existing reporting and identified reporting from senior leadership.• Support the Pricing team with analytics around pricing tables, impact of price changes, margins, etc.• Provide other regular and ad hoc analytical support to the Finance team, as requiredQualifications• Bachelor's degree in Finance, Accounting, Economics, Mathematics, Statistics, Computer Science, or Data Analytics required• Advanced/Expert-level Excel skills and demonstrable ability to efficiently create advanced/dynamic data modeling thru VBA, Pivots, Slicers, and nested statements• Microsoft SQL Server, SQL, MS Access, Power BI, Power Query, and Python considered a plus• 2+ years of experience with data analysis & FP&A is preferred• Meticulous attention to detail with demonstrated ability to think out of the box and problem solve• Strong interpersonal skills with a desire to work in a fast-paced environment, meet deadlines, and complete time-sensitive duties with detailed data and inputs across the organization.• Demonstrable ability to effectively communicate at all levels of the organization• This is a hands-on position; and a successful candidate will have to roll up their sleeves to succeed.• Must be able to deep dive into the details of the business while staying focused on the big picture and be able to conceptualize both problems and solutions• The ideal candidate will be highly motivated, energetic, and possess a natural curiosity to learn• Travel, occasional travel may be required, able to work hybrid.Irca Group offers career growth opportunities as well as competitive compensation and benefits:Medical, Dental, & Vision, 401(k) matching, Paid Vacation, and Holidays, Employee Education Tuition Reimbursement ProgramPI256045314