Business Analyst
Doherty Enterprises Allendale, New Jersey, United States · $65K–$75K/yr
Restaurants · 5,001-10,000 employees
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
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
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
-
Business Analyst to Group Finance Director
Hayleys Advantis Sri Lanka
-
Business Analyst Intern
CoverGo Ho Chi Minh City, Vietnam
-
Senior Business Analyst - Remote
UnitedHealth Group Minnetonka, Minnesota, United States · $73K–$130K/yr
-
[쿠팡로지스틱스서비스] Principal, Business Analyst (OPEX)
Coupang Seoul, South Korea
-
M14 - Business Analyst
FPT Asia Pacific Pte Ltd Singapore, Singapore
-
Business Analyst
Qode New York, New York, United States