Position Summary

As a motivated and highly organized individual, the Sr. Business Analyst for California Customer Care is responsible for creating and maintaining all reporting related to self-insured retention (SIR) amounts for various insurance policies. In addition, this role will be responsible for California Customer Care report optimization and generation. This position requires the ability build the necessary reporting for ongoing tracking of self-insured retention from multiple data sources. This is a business role requiring strong technical skills, attention to detail and problem solving acumen. The Sr. Business Analyst will ensure accuracy in the data presented, optimize the data gathering and reporting function, and generate management and analytical reporting.  In addition, the Sr. Business Analyst will respond to insurance company requests.


Areas of Responsibility 

Data Analytics 

  • Proven ability to create and update reporting from existing data sources.
  • Track, monitor and report all dollars applied to various insurance policies in line with business rules and policy SIR thresholds across multiple business units.
  • Assess accuracy of information through exception reporting and auditing of data.
  • Create automated reporting solutions and management dashboards for SIR tracking. Information is currently fragmented and from several different sources.
  • Ability to create data exception reporting to ensure data integrity.
  • Review and analyze claim submissions and the supporting documentation for accuracy.
  • Analyze and interpret trends and patterns and create management dashboards that present information in actionable format.
  • Perform analysis by policy, project and lot to ensure accuracy of cumulative SIR amounts.
  • Communicate as needed with insurance carriers, trace contractors and other departments.
  • Optimize existing California Customer Care reporting which includes weekly, monthly and ad hoc reporting.
  • Create management dashboards within California Customer Care SharePoint site.
  • Co-create and maintain quarterly staffing forecasts for California Customer Care based upon activity reports.

California Customer Care 

  • Cross train with Builder Coordinator of the department to ensure coverage for task.
  • Act as a SharePoint administrator as needed.
  • Assist in various projects for process improvements of the department.
  • Periodic review and completion of CCC BHIP submissions to the insurance committee.



  • Finance, accounting or business related 4-year college degree required
  • 3-5 years of experience needed
  • Demonstrates a high proficiency in using various applications including:
    • Report Development (Power BI, SQL, Tableau)
    • Excel (power pivots, macros)
    • MS Office Suite
    • SharePoint Administration
  • Excellent analytical, technical, and organizational skills required
  • Experience reading, writing and running SQL queries is required
  • Attention to detail and demonstrated problem-solving skills
  • Strong written and verbal communication skills
  • Ability to work independently under limited supervision
  • Data Analytics Certification is a plus
  • Knowledge of insurance terminology a plus
  • This position is located in the Costa Mesa office and requires collaboration with the team members within Costa Mesa office as well as other Brookfield offices across North America.


Your Opportunity

 We are proud to offer our employees what they value most:

• Competitive compensation
• Excellent extended health benefits
• 401k matching
• Generous tuition assistance program
• Leadership development and mentorship programs 
• Charitable donation matching
• A culture based on our values of Passion, Integrity and Community

 Your New Home

Brookfield Residential is a leading North American land developer and homebuilder with one goal in mind - to create the best places to call home. From the development of award winning master-planned communities, to the building of well-designed homes and commercial properties, we are committed to cultivating exceptional life experience for our customers and for our employees.

Building great communities and homes takes vision and dedication, but most importantly, it takes a strong team. Having been in business for more than 60 years, we know it is our people who make Brookfield Residential what it is today. We were humbled to be named by Aon as one of the Best Employers in Canada and U.S. in 2017.


Apply for this Job

* Required

U.S. Equal Opportunity Employment Information (Completion is voluntary)

Individuals seeking employment at Brookfield Residential are considered without regards to race, color, religion, national origin, age, sex, marital status, ancestry, physical or mental disability, veteran status, gender identity, or sexual orientation. You are being given the opportunity to provide the following information in order to help us comply with federal and state Equal Employment Opportunity/Affirmative Action record keeping, reporting, and other legal requirements.

Completion of the form is entirely voluntary. Whatever your decision, it will not be considered in the hiring process or thereafter. Any information that you do provide will be recorded and maintained in a confidential file.

Race & Ethnicity Definitions

If you believe you belong to any of the categories of protected veterans listed below, please indicate by making the appropriate selection. As a government contractor subject to Vietnam Era Veterans Readjustment Assistance Act (VEVRAA), we request this information in order to measure the effectiveness of the outreach and positive recruitment efforts we undertake pursuant to VEVRAA. Classification of protected categories is as follows:

A "disabled veteran" is one of the following: a veteran of the U.S. military, ground, naval or air service who is entitled to compensation (or who but for the receipt of military retired pay would be entitled to compensation) under laws administered by the Secretary of Veterans Affairs; or a person who was discharged or released from active duty because of a service-connected disability.

A "recently separated veteran" means any veteran during the three-year period beginning on the date of such veteran's discharge or release from active duty in the U.S. military, ground, naval, or air service.

An "active duty wartime or campaign badge veteran" means a veteran who served on active duty in the U.S. military, ground, naval or air service during a war, or in a campaign or expedition for which a campaign badge has been authorized under the laws administered by the Department of Defense.

An "Armed forces service medal veteran" means a veteran who, while serving on active duty in the U.S. military, ground, naval or air service, participated in a United States military operation for which an Armed Forces service medal was awarded pursuant to Executive Order 12985.

Form CC-305

OMB Control Number 1250-0005

Expires 1/31/2020

Voluntary Self-Identification of Disability

Why are you being asked to complete this form?

Because we do business with the government, we must reach out to, hire, and provide equal opportunity to qualified people with disabilities1. To help us measure how well we are doing, we are asking you to tell us if you have a disability or if you ever had a disability. Completing this form is voluntary, but we hope that you will choose to fill it out. If you are applying for a job, any answer you give will be kept private and will not be used against you in any way.

If you already work for us, your answer will not be used against you in any way. Because a person may become disabled at any time, we are required to ask all of our employees to update their information every five years. You may voluntarily self-identify as having a disability on this form without fear of any punishment because you did not identify as having a disability earlier.

How do I know if I have a disability?

You are considered to have a disability if you have a physical or mental impairment or medical condition that substantially limits a major life activity, or if you have a history or record of such an impairment or medical condition.

Disabilities include, but are not limited to:

  • Blindness
  • Deafness
  • Cancer
  • Diabetes
  • Epilepsy
  • Autism
  • Cerebral palsy
  • Schizophrenia
  • Muscular dystrophy
  • Bipolar disorder
  • Major depression
  • Multiple sclerosis (MS)
  • Missing limbs or partially missing limbs
  • Post-traumatic stress disorder (PTSD)
  • Obsessive compulsive disorder
  • Impairments requiring the use of a wheelchair
  • Intellectual disability (previously called mental retardation)
Reasonable Accommodation Notice

Federal law requires employers to provide reasonable accommodation to qualified individuals with disabilities. Please tell us if you require a reasonable accommodation to apply for a job or to perform your job. Examples of reasonable accommodation include making a change to the application process or work procedures, providing documents in an alternate format, using a sign language interpreter, or using specialized equipment.

1Section 503 of the Rehabilitation Act of 1973, as amended. For more information about this form or the equal employment obligations of Federal contractors, visit the U.S. Department of Labor's Office of Federal Contract Compliance Programs (OFCCP) website at www.dol.gov/ofccp.

PUBLIC BURDEN STATEMENT: According to the Paperwork Reduction Act of 1995 no persons are required to respond to a collection of information unless such collection displays a valid OMB control number. This survey should take about 5 minutes to complete.