No experience
Employment Type:
Full time
Job Category:
Business Analyst
(This job is no longer available)
Marcus and Millichap | Calabasas, CA
Grad Date

Not sure what types of jobs you are interested in?

Explore Jobs
Based on Your Education

Follow This Company

Job Description

Marcus & Millichap, Inc, the nation's largest real estate investment brokerage company (80+ offices nationally), is looking to hire a highly motivated Business Analyst within our Corporate Accounting department.

The "Business Analyst" will be part of an "26 person" Accounting department team and will play a vital role in this highly dynamic environment. This position reports to the Director of Accounting located in Calabasas office.


* Develop and maintain advanced reporting, analytics, dashboards and other BI solutions using Microsoft BI based reporting solutions, Excel etc.
* Evaluate and utilize appropriate BI tool available in the toolkit to automate report generation and provide speed to business leader decision making, including self-serving tools that enable users to analyze data through many business dimensions with visibility to granular and historical data.
* Create all required documentation on all projects and keep documentation up to date on any existing report changes and facilitate training & roll out of new tools Collaborate with business, technology and support teams to develop and implement reports and dashboard solutions using Power BI.
* Identifies report requirements by interviewing users; analyzing department applications, programming, and operations; evaluating existing reports and designing new reports.
* Design, develop, implement, and maintain data models to be used by various reporting and data discovery tools.
* Document and streamline current and future processes.
* Identify opportunities for improved utilization of existing business applications and processes.
* Perform and coordinate system testing, user acceptance testing and beta testing.
* Provide technical support and troubleshooting for existing reports, dashboards, or other tools.
* Design, build and deploy BI solutions (e.g. PowerApps, Flow, Power BI, SharePoint).
* Train staff to build and deploy BI solutions.

Education and Experience Requirements:

* Minimum 3 years of related experience in commercial real estate and/or financial services.
* Bachelor's in Business, Accounting, Statistics, or Finance preferred.
* Superior Microsoft Excel skills with experience in VBA/Macros preferred.
* Microsoft SQL, Power Query or other query language experience is required.
* Excellent written and spoken communication skills are essential.
* Superior organizational skills.
* A high attention to detail is mandatory.
* An ability to work autonomously.

Our mission is to help our clients create and preserve wealth by providing the best real estate investment sales, financing, research, and advisory services available.

Founded in 1971, Marcus & Millichap (NYSE: MMI) is a leading commercial real estate brokerage firm focusing exclusively on investment sales, financing, research, and advisory services, with nearly 2,000 investment sales and financing professionals in 80+ offices throughout the United States and Canada.

Marcus & Millichap closes 4.5 transactions every business hour - more than any other real estate investment brokerage firm in the nation. In 2018, the firm closed 9,472 transactions with a sales volume of approximately $46.4 billion.

The firm has perfected a powerful property marketing system that integrates broker specialization by property type and market area; the industry's most comprehensive investment research; a long-standing culture of information sharing; relationships with the largest pool of qualified investors; and state-of-the-art technology that matches buyers and sellers.

Marcus & Millichap provides equal employment opportunities to all employees and applicants for employment without discrimination with regard to race, religious belief (including dress or grooming practices), color, sex, sex stereotype, pregnancy, childbirth or related medical conditions (including breast feeding), age, national origin, ancestry, sexual orientation, gender identification and expression, transgender status, physical or mental disability, medical condition, genetic characteristics, genetic information, family care, marital status, enrollment in any public assistance program, status as military, a veteran or qualified disabled veteran, status as an unpaid intern or volunteer, or any other classification protected by law. We also prohibit discrimination based on the perception that anyone has any of those characteristics, or is associated with a person who has or is perceived as having any of those characteristics. In addition to federal law requirements, Marcus & Millichap complies with applicable state and local laws governing nondiscrimination in employment in every location in which the company has facilities. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training.