Financial Analyst Position Available In Hamilton, Tennessee

Financial Analyst Hutton 736 Cherry Street, Chattanooga, TN 37402

Position:

Financial Analyst We are looking for a detail oriented, problem solver with a strong work ethic. The ideal candidate will have a roll up the sleeves, can do attitude, will be relationship-oriented, and have a passion for real estate and financial analyses. They will perform a variety of integral functions related to the Asset Management department and be adept at working through problems using analytical tools and by creating internal and external relationships to assist in generating the best possible result. The Financial Analyst will assist in corporate-level budgeting, forecasting and analysis, lender communication, investor relations and other company-oriented analytics and assessments. They will have a broad set of responsibilities and tasks, working closely with the acquisitions & dispositions, legal, accounting, finance, IT, real estate, property management, development and construction teams. We will require demonstration of excel proficiency by requesting previous or current models that show strong understanding of Excel and financial concepts.

Requirements:

3+ years of business finance or other relevant experience High proficiency in financial modeling techniques Strong fluency with Excel formulas and functions Basic arithmetic formulas such as SUM(), AVERAGE(), COUNT(), MAX(), MIN(), etc. Basic logic formulas such as IF(), IFERROR(), AND(), OR(), etc. Reference formulas such as XLOOKUP(), INDEX(), MATCH(), etc. Logic based arithmetic formulas such as SUMIF(), AVERAGEIF(), COUNTIF(), etc. Strong analytical and data gathering skills Good business acumen Operates with a mindset of delivering consistent and exceptional customer service to all internal and external clients and partners Strong interpersonal skills necessary to interact with groups internally and externally, including senior executives Demonstrated resourcefulness Excellent attention to detail Reliable self-starter with the ability to work independently and within a team Advanced verbal and written communication skills Highly motivated, innovative team player Robust technology skills, including proficiency in Microsoft Office Suite; experience with Microsoft CRM preferred Strong capabilities or interest in financial modeling preferred

Essential Functions:

Perform financial forecasting, reporting, and operational metrics tracking Analyze financial data and create financial models for decision support Report on financial performance and prepare for regular leadership reviews Ability to create ad hoc reports within Excel without the need for templates or previous framework Maintain the company’s Operating Portfolio, work with Asset Management & Leadership in identifying assets for disposition. Leverage Microsoft Power Query & Power BI to create automated reports and dashboards, within Power BI and also Excel Centralize data from multiple locations and/or departments to create reports that drive decisions Three (3) years of experience in financial analysis, data analysis, budgeting, or accounting Advanced proficiency in Microsoft Excel, including dynamic array functions (FILTER, LET, SEQUENCE, SORT, UNIQUE, XLOOKUP, TEXTAFTER/BEFORE/SPLIT), INDIRECT, OFFSET, INDEX/MATCH/MATCH, SUMPRODUCT, and

FIND/SEARCH

Strong understanding of Excel’s logic-based functions (IF(S), AND, OR) and arithmetic functions (SUMIF(S), AVERAGEIF(S), COUNTIF(S)) Experience manipulating and summarizing date-based data (e.g., converting daily data into monthly, and monthly into yearly reports) Clean, structured, and well-documented work practices Familiarity with Power Query to shuttle in data from other spreadsheets/systems Microsoft Power BI experience Comfortable learning new systems Excellent analytical, organizational, and problem-solving skills Strong communication skills, both written and verbal High level of integrity, confidentiality, and professionalism Ability to manage multiple projects and meet deadlines in a fast-paced environment Analyze past results, perform variance analysis, identify trends, and make recommendations for improvements Work closely with the accounting & finance team to ensure accurate financial reporting Transform data from multiple software outputs into reportable Excel models Collaborate with any & all departments necessary to utilize the most accurate information for analysis Microsoft Power Query experience. Understanding of how to connect to a database and perform ETL to an Excel destination. Power BI experience – ability to create reports and dashboards within the software as well as publish them for various departments to make decisions Leverage our various software to translate business problems into data-driven solutions. Regularly involved in projects that require members from multiple departments collaborating successfully to get the best results, taking data received from multiple departments and translating the information into easily digestible reports Understand the flow of data between data sources, intermediary reports, and end-product reports. Able to analyze and deploy solution for any unforeseen issues. Evaluate financial performance by comparing and analyzing actual results with plans and forecasts Guide the cost analysis process by establishing and enforcing policies and procedures Provide analysis of trends and forecasts and recommend actions for optimization Recommend actions by analyzing and interpreting data and making comparative analyses; study proposed changes in methods and materials Identify and drive process improvements, including the creation of standard and ad-hoc reports, tools, and Excel dashboards Increase productivity by developing automated reporting/forecasting tools Perform market research, data mining, business intelligence, and valuation comps Maintain a strong financial analysis foundation creating forecasts and models Proficiency with Microsoft Excel is mentioned in virtually any financial analyst job description; familiarity with data query/data management tools is extremely helpful (Access, Power Query, SQL)

Educational Requirements:

Bachelor’s degree in finance, Accounting, Economics, STEM, or related field Our Service Philosophy We create relationships that instill trust and exceed expectations through customer service, quality, and experience. We commit to the following standards Responsiveness Communication Accuracy Flexibility Courtesy Hutton does not accept unsolicited resumes through or from search firms or staffing agencies. All unsolicited resumes will be considered the property of Hutton and Hutton will not be obligated to pay a placement fee.

Job Type:

Full-time Benefits:

401(k) Dental insurance Health insurance Health savings account Life insurance Paid time off Vision insurance

Schedule:

8 hour shift Monday to Friday Ability to

Commute:

Chattanooga, TN 37402 (Required)

Work Location:

In person