Sql data analyst Jobs in Birmingham, AL

Land Analyst

Lennar is one of the nation's leading homebuilders, dedicated to making an impact and creating an extraordinary experience for their Homeowners, Communities, and Associates by building quality homes and providing exceptional customer service, giving back to the communities in which we work and live in, and fostering a culture of opportunity and growth for our Associates throughout their career. Lennar has been recognized as a Fortune 500 company and consistently ranked among the top homebuilders in the United States.

Join a Company that Empowers you to Build your Future Land Analysts will work closely with the Vice President of Land Acquisition and Land Transaction Manager to source prepare competitive market analysis studies and reports and assemble financial reports and statements, help to research deal specific tasks, and provide support in preparing feasibility books ("Green Books"), memoranda, and other documentation for corporate approval.

A career with purpose.

A career built on making dreams come true.

A career built on building zero defect homes, cost management, and adherence to schedules.

Your Responsibilities on the Team

• Perform a lead role in the financial analysis inherent to quarterly and annual Division Business Plans summarizing actual and projected financial performance for the Division and each Division asset
• Prepare gross revenues, profit margins, sources and uses of funds and related distribution projections, cash flow forecasts, break-even analysis, cost-basis and cost-of-sales analysis, return-on-assets, and internal rate of return
• Assist in financial feasibility analysis for each of the Division's acquisitions opportunities
• Prepare underwriting proformas and related financial documentation for each asset acquired by Division
• Perform asset sales pricing analysis (e.g., residual value analysis) and formulate/analyze financial deal points for each of the Division's disposition opportunities
• Recommend price/profit participation structures, price escalations/option payment schedules, interest rates, etc.
• Implement and maintain a computerized financial proforma model for community planning (versus formal accounting and reporting) purposes.
• In close cooperation with other management associates, "game" alternative business planning scenarios leading to a recommended "optimum" financial plan
• Perform liaisons role with our Corporate Finance "customers" to ensure that the Division is adhering to all financial strategies and related procedures and is providing financial analysis date in a manner that ensures easy use
• Maintain market analysis database for use in project feasibility analysis
• Understand competitive market by visiting sites as required and collate and analyze competitive pricing, features, costs, etc.
• Assist in Greenfolder process by preparation of vestacalcs, and other charts, graphs and reports as required
• Formulate budgets for assigned programs/projects and administer related vendor contracts, change orders, check requests and invoices. Prepare and periodically update annual objectives, budges, and scheduled

Requirements

• Bachelor's Degree required in Business, Economics, Real Estate, Finance, or similar discipline required.
• 3-5 years of related experience preferred.
• Basic understanding of real estate and residential land use.
• Local real estate knowledge extremely beneficial.
• Highly Proficient in Microsoft Excel, Word, and PowerPoint and working knowledge of mapping applications required.
• Detail oriented with a strong acumen for critical, logical thinking and problem-solving.
• Excellent interpersonal, written, and verbal communication skills.

Physical & Office/Site Presence Requirements:

Regular, in-person attendance at Company communities/job sites and offices during regular work hours is an essential function of this job. Requires the ability to work in excess of eight hours per day in the confined quarters of a construction trailer, the ability to operate a motor vehicle, read plans, climb stairs and ladders, bend, stoop, reach, lift, move and/or carry equipment which may be in excess of 50 pounds. Job may require occasional operation of construction equipment. Finger dexterity may be required to operate a computer keyboard and calculator.

Lennar is an equal opportunity employer and complies with all applicable federal, state, and local fair employment practices laws.