Financial Analyst

3 weeks ago

Pasadena, United States Dine Brands Global Full time

Based inPasadena, California,Dine Brands Global, Inc.(NYSE: DIN), through its subsidiaries, franchises restaurants under Applebee's Neighborhood Grill + Bar, IHOP and Fuzzy's Taco Shop brands. With over 3,500 restaurants combined in 18 countries and 354 franchisees as of December 31, 2023, Dine Brands is one of the largest full-service restaurant companies in the world. For more information on Dine Brands, visit the Company's website located atwww.dinebrands.com.

Analyze financial data through the use of Alteryx workflows and Excel Macros in VBA in a timely and efficient manner. Work with a finance team that is motivated to achieve results while focusing on Dine's core values.

Role & Responsibilities

  • Run and troubleshoot Alteryx workflows which take franchisee income statements and map them to a standardized income statement
    • Run and troubleshoot Excel macros and queries that aggregate various types of financial data from these income statements
  • Run and troubleshoot Alteryx workflows which take labor efficiency metric data from franchisees and map them to a standardized format
  • Calculate royalty and advertising credits for each restaurant based on delivery incentive program (monthly) and delivery service program (quarterly)
    • Entails gathering and aggregating data from appropriate sources, and running Alteryx workflows as well as Excel macros to process the data
  • Prepare monthly sales forecasts reports
  • Other duties include assisting Finance Director with various initiatives and tasks, including updating and maintaining trackers related to Applebee's franchisees (i.e. for letters of credit, guarantees, promissory note balances, restaurant remodels, debt leverage, debt maturity, restaurant closures, poorly performing restaurants, etc), and other ad hoc projects

Skills & Requirements

**In-depth experience with and knowledge of VBA, writing and troubleshooting Excel macros and queries, AND Alteryx workflows**

  • Create macros without using the Record function built into Excel
  • Experience reading established VBA scripts (including troubleshooting loops) and debugging a macro if script crashes/fails
  • Ability to declare variables (VBA), potentially identifying and modifying new or existing DIMs
  • Solid experience in building Alteryx workflows to efficiently generate and transpose data from various sources to a standardized data format
  • Create and manipulate pivot tables; use 'Power Query Editor' function in Excel to transform data
  • Write advanced formulas and create charts/graphs in Excel
  • Strong time management and organization skills; demonstrated ability to meet established deadlines
  • Detail-oriented, strong communication skills, take initiative and look for efficient solutions
  • Understanding of and experience with P&Ls preferred
  • BA/BS degree preferred
  • Target base salary 80k+

Equal Employment Opportunity Statement

Dine Brands Global strongly supports equal employment opportunity for all applicants regardless of race, color, religion, sex, gender identity, pregnancy, national origin, ancestry, citizenship, age, marital status, veteran status, physical disability, mental disability, medical condition, sexual orientation, genetic information, or any other status protected by federal, state, or local law. All employment is decided on the basis of qualifications, merit, and business need.

For information on how we collect and use your personal information, please visit our Applicant & Employee Privacy Notice.

  • Financial Data Analyst

    4 days ago

    Pasadena, California, United States Dine Brands Global Full time

    Job DescriptionDine Brands Global is seeking a highly skilled Financial Analyst to join our team. As a Financial Analyst, you will play a critical role in analyzing financial data and providing insights to support business decisions.Key Responsibilities:Financial Data Analysis: Run and troubleshoot Alteryx workflows and Excel macros to analyze financial data...

  • Construction Financial Analyst

    3 months ago

    Pasadena, United States System One Holdings, LLC Full time

    Construction Financial Analyst Pasadena, TX System One is currently seeking a Construction Financial Analyst on a 6 month contract position located in Pasadena, TX. Construction Financial Analyst Responsibilities: Work assignments are complex in nature, and require considerable judgment, tact, creativity, and initiative to resolve problems. Prepares...

  • Senior Financial Analyst

    2 days ago

    Pasadena, United States Talent Consulting Experts Full time

    Join our team as a Senior Financial Analyst to drive datadriven financial insights and strategic initiatives. Enjoy a competitive salary remote work flexibility and growth opportunities. Apply now!Join a forwardthinking organization where datadriven decisionmaking and strategic financial management are key to our success. Our mission is to foster a culture...

  • Senior Financial Analyst

    7 days ago

    Pasadena, California, United States Rose International Full time

    Senior Business AnalystRose International is seeking a highly skilled Senior Business Analyst to drive business growth and improvement through data-driven insights and strategic recommendations.Key Responsibilities:Manage and reconcile daily financial transactions, ensuring accuracy and timeliness.Oversee financial processes, ensuring automated posting and...

  • Senior Financial Analyst

    2 weeks ago

    Pasadena, United States Talent Consulting Experts Full time

    Job DescriptionJob DescriptionJoin our team as a Senior Financial Analyst to drive data-driven financial insights and strategic initiatives. Enjoy a competitive salary, remote work flexibility, and growth opportunities. Apply now!Join a forward-thinking organization where data-driven decision-making and strategic financial management are key to our success....

  • Senior Financial Analyst

    1 month ago

    Pasadena, United States Talent Consulting Experts Full time

    Job DescriptionJob DescriptionJoin our team as a Senior Financial Analyst to drive data-driven financial insights and strategic initiatives. Enjoy a competitive salary, remote work flexibility, and growth opportunities. Apply now!Join a forward-thinking organization where data-driven decision-making and strategic financial management are key to our success....

  • Lead Financial Analyst

    7 days ago

    Pasadena, California, United States Adroit Partners Full time

    Job OverviewWe are seeking a Lead Financial Analyst to oversee the preparation and assessment of financial documentation for our client. This role is pivotal in ensuring accurate financial reporting and compliance.Key Responsibilities:Review and analyze accounting records, financial statements, tax documents, and various financial reportsGenerate and...

  • Senior Financial Analyst

    7 days ago

    Pasadena, California, United States East West Bank Full time

    About East West BankEast West Bank is a leading financial institution with a strong presence in the U.S. and Greater China markets. With a commitment to absolute integrity and a focus on serving a growing and profitable market, we offer a stable and rewarding work environment for our employees.Job SummaryWe are seeking a highly skilled Senior Financial...

  • Senior Financial Analyst

    14 hours ago

    Pasadena, California, United States BYD COACH & BUS LLC Full time

    Job SummaryBYD COACH & BUS LLC is seeking a highly skilled Senior Financial Analyst to join our team. As a key member of our finance department, you will be responsible for maintaining accurate financial records, preparing financial reports, and ensuring compliance with accounting policies and internal controls.Key Responsibilities:Maintain accurate general...

  • Senior Financial Reporting Analyst

    2 weeks ago

    Pasadena, California, United States Vertical Careers, Inc. Full time

    Senior Financial Reporting AnalystVertical Careers, Inc. is collaborating with a distinguished and large publicly traded Financial Services organization. We are looking for a dedicated and enthusiastic Accounting Professional to fill the role of Senior Financial Reporting Analyst within the Corporate Accounting & Finance division.Our client values...

  • Senior Financial Analyst

    1 week ago

    Pasadena, California, United States East West Bank Full time

    About East West BankEast West Bank is a leading financial institution with a strong presence in the U.S. and Greater China markets. With a commitment to absolute integrity and a focus on serving a growing and profitable market, we offer a stable and rewarding career path for our employees.Job SummaryWe are seeking a highly skilled Senior Financial Analyst to...

  • Lead Financial Analyst

    2 weeks ago

    Pasadena, California, United States Dine Brands Global Full time

    Position OverviewThe Senior Financial Analyst will play a crucial role in delivering precise and timely financial evaluations and reports to facilitate informed financial decision-making within the organization.Key Responsibilities1. Conduct comprehensive analysis of current and historical financial data, ensuring reporting aligns with the expectations of...

  • Senior Financial Analyst

    16 hours ago

    Pasadena, California, United States Talent Consulting Experts Full time

    Job SummaryWe are seeking a highly skilled Senior Financial Analyst to join our team at Talent Consulting Experts. As a key member of our finance department, you will play a critical role in driving business growth and success through data-driven financial insights and strategic initiatives.Key ResponsibilitiesDevelop and manage financial models and tools to...

  • Sr. Financial Analyst

    2 months ago

    Pasadena, United States Pinnacle Living Full time

    We are building a team of trailblazers, who embody growth, impact, and excellence. Job Description As a Senior Financial Analyst, you will play a key role in the development, management, and analysis of data across Pinnacle. You will work across all groups within Pinnacle including the Leadership Team, Operations, Sales Functions, Board of Directors and...

  • Financial Analyst for Construction Projects

    2 weeks ago

    Pasadena, Texas, United States System One Full time

    Financial Analyst for Construction ProjectsSystem One is seeking a Financial Analyst specializing in construction for a contract position.Key Responsibilities: - Engage in complex assignments that require significant judgment, creativity, and initiative to address challenges. - Prepare and evaluate monthly variance analyses and cost reports, including...

  • Lead Financial Reporting Analyst

    7 days ago

    Pasadena, California, United States Intrepidus Talent Solutions Full time

    Job OverviewIntrepidus Talent Solutions is seeking a highly skilled professional to join our team as a Senior Financial Reporting Analyst. This role is pivotal in ensuring the accuracy and compliance of financial reporting within our organization.Key ResponsibilitiesPrepare and manage both internal and external financial reports, including regulatory...

  • Financial Analyst

    2 days ago

    Pasadena, California, United States Amalgamated Bank of NY Full time

    Job DescriptionJob Summary:Amalgamated Bank of NY is seeking a highly skilled Financial Analyst - Credit Risk Management to join our team. As a Credit Analyst, you will play a critical role in analyzing financial statements, conducting due diligence, and assessing credit risk ratings to ensure the bank's financial stability and growth.Key...

  • Senior Financial Analyst

    7 days ago

    Pasadena, California, United States Vertical Careers, Inc. Full time

    Senior Financial Analyst - Credit Risk ExpertAt Vertical Careers, Inc., we are seeking a highly skilled Senior Financial Analyst to join our team. As a Senior Financial Analyst, you will play a critical role in providing expert financial analysis and guidance to support the company's credit risk management efforts.Key Responsibilities:Allowance for Credit...

  • Senior Financial Analyst

    1 week ago

    Pasadena, California, United States East West Bank Full time

    About East West BankEast West Bank is a leading financial institution with a strong presence in the U.S. and Greater China markets. With a commitment to absolute integrity and a focus on serving the needs of its customers, the bank has established itself as a trusted partner for businesses and individuals alike.Job SummaryWe are seeking a highly skilled...

  • Senior Financial Analyst

    2 weeks ago

    Pasadena, Texas, United States Pinnacle Full time

    Pinnacle is seeking a dynamic individual who exemplifies growth, impact, and excellence. Position Overview As a Senior Financial Analyst, you will be instrumental in the creation, oversight, and examination of financial data throughout Pinnacle. Your role will involve collaboration with various departments, including the Leadership Team, Operations, Sales,...