Sql data analyst Jobs in Paterson, NJ

Applegreen Finance Analyst

At Applegreen, our mission is to delight customers in transit with passionate hospitality and brands they love. Applegreen is a leading roadside retailer operating high-quality travel plazas and service areas in the US, Ireland, and the UK. Founded on a commitment to innovation, operational excellence, and customer experience, Applegreen combines fuel, convenience retail, and a diverse portfolio of food and beverage offerings to create welcoming destinations for customers.

In the U.S., Applegreen partners with major transportation authorities and operates more than 100 service plazas along some of the country's busiest highways and turnpikes. The company is known for modern facilities, strong national and local food brands, and an emphasis on freshness, quality, and sustainability.

At Applegreen, our people are at the heart of what we do. We foster a culture that values teamwork, development, and accountability, offering employees opportunities to grow their careers in a fast-paced, dynamic environment. Applegreen continues to expand while remaining focused on delivering exceptional service to customers and creating a great place to work.

Our core values define who we are and guide how we work every day. They shape our decisions, inspire our actions, and influence how we engage with our customers, suppliers, business partners, and one another.

• Our customers and communities are at the heart of everything we do.
• We value and develop our people.
• We are driven by pace, passion and performance.
• We seek opportunities and embrace change.

Applegreen offers a competitive benefits package designed to support the health and financial well-being of our associates and families. Available benefits include a variety of company-sponsored and voluntary options such as:

• Hybrid position with 3 days per week worked in our Glen Rock NJ office location and 2 days per week worked remotely.
• Medical/Dental/Vision Insurance
• Paid Time Off
• 401 (k) with Company Match
• 10% Annual Bonus
• Earned Wage Access Pay on Demand
• Education Assistance
• Employee Referral Bonus
• Pet Insurance

Applegreen US is a growth organization with both geographic and commercial expansion. We seek a Finance Analyst who will provide reporting, planning, forecasting and analytical support to the Commercial, Operations, IT and Facilities teams. This role is part of the US FP&A team based in Glen Rock, NJ. This role is critical to providing quality, timely, and accurate financial information to drive continuous improvement while also supporting reporting requirements and achieving deadlines.

The successful candidate will have strong technical and analytical skills, advanced communication skills to provide thoughtful insights to leadership, be a consummate team player to partner with Commercial, Operation as well as Accounting/Finance within the US, UK and Ireland, ability to adapt and pivot to changing directives, takes the initiative to solve problems, is passionate about self and team development and takes a hands-on approach to the role.

Key Responsibilities: As Applegreen expands, the responsibilities will evolve and change over time. The core responsibilities will center around the following areas:

• Assist in the preparation of the budget and forecasts including variance analysis
• Distil summarized budgets down to site-level, brand-level, account-level data that incorporates advanced allocation methodologies including seasonality curves and week-over week growth trends
• Prepare complex financial models to support Commercial, Operations, Facility projects
• Develop presentations with compelling visuals that provide impact, insights and elevate storytelling
• Leverage strong technical skills for advanced reporting within Excel
• Ability to synthesize large data sets with optimized Power BI capabilities
• Analysis of financial data to understand key business performance drivers via Smartview and EPM
• Preparation of monthly presentations to leadership that provide financial reporting, insightful commentary, and variance analysis
• Support Head Office leadership with reporting and analysis of monthly expenses and variances
• Partner with Finance Business Managers and the Head of Transformation to provide in depth analysis of other direct site costs that highlight cost outliers and savings opportunities
• Manage statistical accounts loads into ERP systems (PDI/EPM) and Labor systems (UKG) and provide data validation
• Prepare financial models for capital projects seeking approval at Investment Committee meetings, provide analysis of returns (ROCE, Payback), and conduct post-mortem analysis
• Analytical support for initiatives that drive business improvements and support of ad hoc projects

Qualifications, experience & skills

• BS/BA degree
• 2-3 years FP&A experience in financial analyst role or similar
• Retail, wholesale, or quick-serve restaurant experience a plus
• Advanced skills in developing complex financial models
• Superior analytical acumen to interpret and challenge data and to interrogate financial systems
• High/Expert proficiency in Microsoft Excel (Functions, Pivot Tables), Power BI, Smartview, Oracle EPM
• Strong aptitude to create PowerPoint presentations to provide clear visuals that facilitate decision making and provide actionable insights on key performance indicators.

Additional Key Skills & Attributes

• A dynamic individual who adapts well to change and can thrive in a rapidly growing organization that continues to evolve.
• Ability to execute directly at high quality and pace.
• Excellent drive, enthusiasm and commitment and a keen interest in developing a career in Applegreen.
• A 'can do' attitude and a positive solution focused mindset.
• Exceptional interpersonal skills, and ability to engage and develop relationships with individuals at all levels of the organization.
• Self-starter with ability collaboratively as a member of a highly interdependent team across many parts of Applegreen.