Business Analyst Doherty Enterprises - 3.5 Allendale, NJ Job Details Full-time $65,000 - $75,000 a year 12 hours ago Benefits Partner benefits Health insurance Dental insurance 401(k) Paid time off 401(k) matching Opportunities for advancement Life insurance Qualifications Performance dashboard reports Business financial process improvement Financial forecasting Commercial use (data warehousing systems) Financial close processing Economics Cloud analytics services Preparation of internal financial performance reports Databricks Data visualization software proficiency Data Integration (Data management) Financial data reconciliation Financial model construction Cloud data warehouses Data preparation projects Sales analysis Dashboard creation R Dashboard creation support Labor cost analysis Process design Metrics Reporting Snowflake Budget forecasting SQL Sales data analysis Business intelligence tools Data-driven problem-solving Financial projection model development Closing the books

Full Job 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.