Doherty Enterprises

Business Analyst

Doherty Enterprises Allendale, New Jersey, United States · $65K–$75K/yr

Restaurants · 5,001-10,000 employees

Yesterday
business-analyst Junior (0-2 yrs) Full-time United States
Create a free account to apply — email only, no card. You can also save this posting or score it against your profile with AI.

About the role

The Business Analyst will manage data practices, perform ad hoc business analyses, and assist with financial reporting. They will also build financial models, maintain data pipelines, and support monthly budgeting and forecasting processes.

What they look for

Microsoft Excel SQL Python R Financial modeling Data visualization Power BI Tableau ETL processes Data warehousing Snowflake Databricks Fabric Financial reporting Communication skills Problem-solving

Requirements

Candidates must possess advanced Microsoft Excel skills and proficiency in SQL, Python, or R for data extraction and analysis. A basic understanding of ETL processes, data warehousing, and restaurant industry KPIs is required.

Benefits

Medical insurance Dental insurance Life insurance Domestic partner benefits Flexible dependent spending accounts Health spending accounts 401(k) savings plan Company matching Paid time off

Full description

Position & Perks

The Business Analyst serves as a junior member of Doherty’s FP&A team, helping manage the company’s data practices, ad hoc analyses on the business’ operations, and financial reporting.

Along with an inclusive environment and great advancement opportunities, we offer a banquet of benefits that will protect your health, ensure your future and provide the tools you need to succeed at work and in life.

  • Competitive Pay
  • Bonus Opportunity
  • Medical, Dental and Life Insurance for you and your family
  • Domestic Partner Benefits
  • Flexible Dependent and Health Spending Accounts
  • 401(k) Savings Plan with company matching
  • Paid Time Off and a whole lot more

*NOTE: This is not a remote position. Candidates must commute to/from office during training, then we offer a current hybrid schedule.

Responsibilities

  • Assist in the improvement of business processes by helping the team design, test and implement new data strategies and work flows across the company
  • Build and maintain financial models to analyze unit economics, labor and food cost trends, and new store performance
  • Write SQL queries to pull and validate data from our cloud data warehouse (Snowflake) for recurring reporting and one-off analysis
  • Partner with Accounting, Operations, IT and Restaurant Systems teams to understand how store-level data flows through our ETL pipelines and into the data warehouse
  • Maintain and improve existing Excel-based reporting and dashboards used across the FP&A team
  • Support monthly close, budgeting, and forecasting processes across corporate and store-level P&Ls

Qualifications

  • Advanced Microsoft Excel Skills, ability to craft complex formulas and basic financial models from scratch
  • Proficiency using languages like SQL, Python or R to clean, reconcile and extract meaningful insight from large data sets
  • Strong verbal, written, and presentation skills, with the ability to communicate and collaborate effectively with other departments/stakeholders
  • Creative problem-solving skills, curiosity to chase questions without clear answers, ability to communicate your findings and thought process
  • Familiarity using cloud data platforms like Snowflake, Databricks, or Fabric
  • Proficiency in data visualization tools like Power BI or Tableau
  • Basic understanding of ETL processes and data warehousing concepts (how data moves from source systems into a warehouse and gets modeled for reporting)
  • Experience with restaurant industry KPIs and an understanding of the metrics used to examine revenue and costs in a multi-unit company.

Similar roles