Job Information
Sun Communities Senior Fin. Planning & Analysis Analyst in Southfield, Michigan
Main Office (MOS) OVERVIEW Senior Financial Planning and Analysis Analysts are responsible for consolidating and validating the actual budget and/or forecast of key performance metrics, key drivers and assumptions to aid in the development of various models. They will be responsible for performing analysis resulting in value-adding recommendations to various departments throughout the company. Additionally, they assist in the administration of various reporting systems, perform monthly various analysis, and are responsible for other projects and ad-hoc analysis as requested. JOB DUTIES * Manage accurate entity structure, data set and calculation in the budget/forecast system. * Create, maintain and ensure accuracy of templates within various system. * Coordinate portions of the annual budget process, consolidate results and review budget models for errors; act as a liaison between Operations, Acquisitions, Accounting and Finance regarding budgeting and forecasting. * Analyze financial and operational results versus forecast and plan, and forecast and actual; research variances and understand the root causes of the variance. * Maintain and provide support for various internal and external reporting models. * Monitor internal Labor Dashboards to ensure accuracy and research variances as needed. * Manage administration of various systems related to budgeting, forecasting, internal reporting, and public reporting. * Assist with the corporate cash flow modeling, and developing models and analyses to aid in the validation of existing forecasts; support strategic initiatives and assist with reviewing critical financial decisions. * Develop key reporting within various systems to provide timely and actionable financial results. * Participate in the forecast/budget software implementation and development; assist in evaluation and development of additional models. * Attend various meetings to disseminate financial information as needed. * Provide financial support to the Operations department as requested. * Other duties and special projects as requested. * Evaluate Company systems and processes for accumulating and reporting data to provide value, adding recommendations to various departments. * Work closely with other departments to understand and document variances between actuals and budget. * Perform data analytics over large data sets, summarizing the information into executive level summaries. * Assist in the development and maintenance of various models and analyses to support strategic initiatives and assist with reviewing critical financial decisions. REQUIREMENTS * Bachelor's Degree in Accounting or Finance (Required) * 5 years budgeting/forecasting experience * Working knowledge of multiple budgeting techniques and budgeting tools/software * Excellent verbal and written communication skills * Strong attention to detail, organizational, analytical and problem-solving skills * Advanced computer proficiency in Microsoft Excel and Accounting/budgeting software programs * Prior experience with an accounting software conversion project, a plus * Prior experience with Anaplan software, a plus * Prior experience with Tableau, Yardi, Workiva, Netsuite, and/or Anaplan software, a plus * Prior Experience working at a Big 4 firm, a plus BENEFITS At Sun Communities, you will be part of an industry-leading organization where you will be challenged, inspired, rewarded and transformed. We place a high priority on our team members, and this is a big part of what sets us apart. We will ask you to give us your very best every day, and will challenge you with interesting work, stretch assignments, a collaborative and supportive work environment and plenty of learning and growth. In exchange, we will reward you with great pay, advancement opportunities, paid time off, great benefits, and flexibility. * Comprehensive Medical and Prescription coverage with 4 plan options so you can choose the plan that best meets the needs of you and your famil