Full Job Description
We are looking for a motivated, detailed, and service-oriented professional who is looking for a fun and flexible workplace that encourages innovation. While we are proud to have flourished these past ten years in the real estate industry, we still classify ourselves as a growing company. There are countless opportunities for someone in this position to quickly move up our Career Path. We're growing, fun, ambitious, and highly motivated to succeed. This combination creates an environment where you can develop professionally and find a long-term place for your career aspirations.Our Corporate Support Office is located in the heart of downtown Elmhurst and is not your typical “corporate” setting. We embrace collaboration with an open office concept. Imagine an office where the fridge is never empty, whiteboards are on walls, and ESPN is playing in the background. Company-branded hoodies are the norm, and neckties hardly exist. We love our company culture, and truly value the time we share with one another. From celebrating holidays in the office with potlucks and team outings to getting out and giving back to our local community, and receiving generous time off to spend with our friends and family, this is an awesome place to work!
We have created a culture that has been honored with multiple awards, including Crain's Chicago Best Places to Work and Top CEO! We encourage you to read up on Glassdoor.com about us, visit our website at www.newhomestar.com and check out our Youtube videos here: https://www.youtube.com/channel/UC-hhKTonQzDqmT96JarzKLA/videos.
PURPOSE OF THE ROLE
Here at New Home Star, we believe in the power of teamwork. As a member of the Finance team, you will work alongside a team of driven professionals working towards one goal: to build the best new home sales company in the world. lf you have the drive and passion to expand your career, you may be a great fit for our rapidly growing team!
JOB DESCRIPTION & RESPONSIBILITIES
This Financial Analyst Intern will gain high level visibility to executive management and be an integral player in preparing financial plans and business support.
Create and maintain complex financial models for small and large scale needs (on company-wide scale as well as down to a divisional level)
Produce timely and accurate documents including reports, memos, proposals, charts, agreements, presentations, etc.
Perform profit and loss analysis for multiple books of business.
Conduct analysis, suggest new ideas, and provide recommendations and creative alternatives to improve financial performance and/or reduce cost and complexity
Create and provide recommendations based on findings to executive level management
Run reports to identify company market trends and increase company revenue
Perform analytics on large sets of data to produce clear and concise findings and recommendations to executive leadership
Aid in the projecting, reporting and financial performance management frameworks for the business
Help define key performance indicators to evaluate overall business standing and suggest efficiencies as deemed necessary
Partner with team members and functional leaders in monthly, quarterly, and annual forecast cycles to identify planning assumptions for key business drivers
Actively participate in the strategic financial planning, target setting, and annual planning processes
Assist with various accounting processes and timely production of financial statements
Bachelor's Degree Required (Finance or Accounting Major or Focus preferred)
Student currently enrolled in Master's degree program for Finance, Accounting or Economics; MBA, MF or related area (strongly preferred)
1 - 3 years of practical exposure in some of the following areas: Financial Planning and Analysis, evaluating business performance, Financial Accounting and Control. Functional finance experience is a plus (e.g. Marketing, Sales, R&D, Operations, Procurement etc.)
A basic understanding of GAAP and the core financial statements
Strong finance and statistics knowledge
Proficient in financial modeling concepts
Proficiency in the Microsoft Office Suite; mastery of Excel data analysis functions
Self-motivated and works effectively under pressure in a fast paced, intense environment.
Must be comfortable dealing with all levels of employees, including executive level and CEO.
Team player with the ability to work cohesively with colleagues
Excellent written and oral communication skills (English language only)
Extreme attention to detail and time management
Exposure to financial analysis and modeling skills including forecasting, budgeting, and variance analysis through academics, internships or projects
Advanced Excel (i.e. VLOOKUP, pivot tables, etc.), Quick Books, Google Sheets, and Power Point skills
Strong analytical abilities and problem-solving skills
Ability to learn quickly and drive your work forward in an ambiguous environment
Exposure to SQL and Tableau a plus