Prepare for and practice interview questions from Brown & Brown Insurance.

Brown & Brown Insurance Interview Questions

Brown & Brown Insurance Interview Guides

Let’s say we have a table with an <code>id</code> and <code>name</code> fields. The table holds over 100 million rows and we want to sample a random row in the table without throttling the database.

Write a query to randomly sample a row from this table.

Input:

<code>big_table</code> table

<table>
<thead>
<tr>
<th>Columns</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>name</code></td>
<td>VARCHAR</td>
</tr>
</tbody>
</table>

Write a query to randomly sample a row from a big table.

Random SQL Sample

Let’s say that your company is running a standard control and variant AB test on a feature to increase conversion rates on the landing page. The PM checks the results and finds a .04 p-value.

How would you assess the validity of the result?

Experiment Validity

You are testing hundreds of hypotheses with many t-tests. What considerations should be made?

What is a key disadvantage of the F-test when compared to multiple t-tests?

What is a key disadvantage of the F-test when compared to multiple t-tests?

Hundreds of Hypotheses

You are testing hundreds of hypotheses with many t-tests. What considerations should be made?

Brown & Brown Insurance Salaries by Position

Built on meritocracy, our unique company culture rewards self-starters and those who are committed to doing what is best for our customers.
Brown & Brown is an independent insurance intermediary that through its licensed subsidiaries provides a variety of insurance and reinsurance products and services to corporate, public entity, institutional, trade, professional, association, and individual clients. Headquartered in Daytona Beach, Florida, offices are located across the United States, with products and services offered through four major business divisions. We are listed on the NYSE at BRO. Our drive to be the best has made Brown & Brown one of the largest and most respected independent insurance intermediaries in the nation, with over 75 years of continuous service. The Company is ranked as the sixth largest such organization in the United States and seventh in the World by Business Insurance magazine.
The Data Platform Engineer is a member of the Enterprise Data Platform team reporting to the Director, Enterprise Data Platforms. This experienced individual will develop, automate and manage cloud-based data capabilities and technologies in support of both the overall data strategy, architecture and roadmap and the delivery of divisional, corporate and enterprise data assets and insights. Partnering with the operations and delivery teams, they will ensure the availability, stability, performance and scalability of data capabilities and technologies.
Responsibilities: Engineer, deliver and support automated, Azure cloud-based data capabilities and technologies in support of the Modern Data Platform (MDP) strategy and roadmap.
Develop, deliver and support Infrastructure As Code templates for MDP capability deployments.
Monitor, measure and report on the utilization, performance, and cost of MDP capabilities.
Identify and implement enhancements to further automate and scale the MDP capabilities.
Provide implementation, production and consulting support to delivery teams leveraging the MDP.
Collaborate with the Enterprise Data Architecture and Enterprise Data Enablement teams on data solutions and roadmaps.
Define and automate data platform controls in support of Software Development Lifecycle (SDLC) requirements.
Mentor and provide guidance to Data Engineers with respect to MDP capabilities.
Work well with co-located and distributed team members and partners.
Demonstrate a high degree of creativity and problem-solving skills.
Other duties as assigned.
Required: Bachelor’s degree in computer science or related field or equivalent work experience.
Experience implementing data capabilities and technologies supporting data pipelines, data integration, data transformation, analytics, reporting and modeling (e.g. AI/ML).
Strong understanding of engineering, implementing, and supporting data platforms and solutions in a cloud environment.
Hands on experience implementing and using cloud-based storage, data lake, analytics, visualization, SQL, container, dev ops and security services.
Hands on experience developing and supporting Infrastructure As Code templates.
Hands on experience working with Python, Java, SQL and JSON.
Deep understanding of data management and data governance principles.
Passion for learning new technologies and enhancing existing skills.
Experience developing, implementing and supporting integrated frameworks across data capabilities and technologies.
Experience implementing and using CI/CD pipelines and automation.
Experience in end-to-end Software Development Life Cycle (SDLC) projects.
Experience working with key stakeholders and technology peers.
Excellent verbal and written communication skills.
Self-starter with the ability to build strong relationships and work collaboratively.
Ability to adapt and respond in a rapidly evolving business environment.
5+ years of related work experience.
Preferred: Experience in the insurance industry and/or basic knowledge of insurance.
Experience engineering, implementing, and supporting solutions covering multiple geographies.
Microsoft Azure Solutions Architect Expert, Azure Data Engineer Associate or equivalent certification(s).
Experience with Azure Data Factory, Azure Synapse Analytics, Azure Databricks, Snowflake and/or equivalent cloud data technologies and platforms.
Experience with data platforms supporting Data as a Product, Data as a Service, Data Mesh, Data Virtualization, Delta Lake, Lakehouse and/or Data Fabric.
What we offer: Excellent growth and advancement opportunities
Competitive pay based on experience.
Discretionary Time Off (DTO)
Generous benefits package: health, dental, vision, 401(k), etc.
Employee Stock Purchase Plan
Tuition Reimbursement and Student Loan Repayment Assistance
Mental Health Resources
We are an Equal Opportunity Employer. We take pride in the diversity of our team and seek diversity in our applicants.

#J-18808-Ljbffr

Built on meritocracy, our unique company culture rewards self-starters and those who are committed to doing what is best for our customers.
Brown & Brown is an independent insurance intermediary that through its licensed subsidiaries provides a variety of insurance and reinsurance products and services to corporate, public entity, institutional, trade, professional, association, and individual clients. Headquartered in Daytona Beach, Florida, offices are located across the United States, with products and services offered through four major business divisions. We are listed on the NYSE at BRO. Our drive to be the best has made Brown & Brown one of the largest and most respected independent insurance intermediaries in the nation, with over 75 years of continuous service. The Company is ranked as the sixth largest such organization in the United States and seventh in the World by Business Insurance magazine.
The Sr. Data Platform Engineer is a member of the Enterprise Data Platform team reporting to the Director, Enterprise Data Platforms. This experienced individual will develop, automate and manage cloud-based data capabilities and technologies in support of both the overall data strategy, architecture and roadmap and the delivery of divisional, corporate and enterprise data assets and insights. Partnering with the operations and delivery teams, they will ensure the availability, stability, performance and scalability of data capabilities and technologies.
Responsibilities: Engineer, deliver and support automated, Azure cloud-based data capabilities and technologies in support of the Modern Data Platform (MDP) strategy and roadmap.
Develop, deliver and support Infrastructure As Code templates for MDP capability deployments.
Monitor, measure and report on the utilization, performance and cost of MDP capabilities.
Identify and implement enhancements to further automate and scale the MDP capabilities.
Provide implementation, production and consulting support to delivery teams leveraging the MDP.
Collaborate with the Enterprise Data Architecture and Enterprise Data Enablement teams on data solutions and roadmaps.
Define and automate data platform controls in support of Software Development Lifecycle (SDLC) requirements.
Mentor and provide guidance to Data Engineers with respect to MDP capabilities.
Work well with co-located and distributed team members and partners.
Demonstrate a high degree of creativity and problem-solving skills.
Other duties as assigned.
Required: Bachelor’s degree in computer science or related field or equivalent work experience.
Experience implementing data capabilities and technologies supporting data pipelines, data integration, data transformation, analytics, reporting and modeling (e.g. AI/ML).
Deep understanding of engineering, implementing, and supporting data platforms and solutions in a cloud environment.
Strong hands-on experience implementing and using cloud-based storage, data lake, analytics, visualization, SQL, container, dev ops and security services.
Experience with data platforms supporting Data as a Product, Data as a Service, Data Mesh, Data Virtualization, Delta Lake, Lakehouse and/or Data Fabric.
Experience with Azure Data Factory, Azure Synapse Analytics, Azure Databricks, Snowflake, Denodo and/or equivalent cloud data technologies and platforms.
Strong hands-on experience developing and supporting Infrastructure As Code templates.
Strong hands-on experience working with Python, Java, SQL and JSON.
Deep understanding of data management and data governance principles.
Passion for learning new technologies and enhancing existing skills.
Experience developing, implementing, and supporting integrated frameworks across data capabilities and technologies.
Experience implementing and using CI/CD pipelines and automation.
Experience in end-to-end Software Development Life Cycle (SDLC) projects.
Experience working with key stakeholders and technology peers.
Excellent verbal and written communication skills.
Self-starter with the ability to build strong relationships and work collaboratively.
Ability to adapt and respond in a rapidly evolving business environment.
8+ years of related work experience.
Preferred: Experience engineering, implementing, and supporting data solutions in Azure.
Experience with Collibra, Purview, BigID, Unity Catalog and/or equivalent metadata, data quality and data cataloging technologies.
Experience working with Agile/Scrum methodologies.
12+ years of related work experience.
Microsoft Azure Solutions Architect Expert, Azure Data Engineer Associate, or equivalent certification(s).
Experience in the insurance industry and/or basic knowledge of insurance.
Experience engineering, implementing, and supporting solutions covering multiple geographies.
What we offer: Excellent growth and advancement opportunities.
Competitive pay based on experience.
Discretionary Time Off (DTO).
Generous benefits package: health, dental, vision, 401(k), etc.
Employee Stock Purchase Plan.
Tuition Reimbursement and Student Loan Repayment Assistance.
Mental Health Resources.
We are an Equal Opportunity Employer. We take pride in the diversity of our team and seek diversity in our applicants.

#J-18808-Ljbffr

Brown & Brown Insurance is hiring for a Benefits Marketing Analyst to join our team in White Plains, New York! HYBRID The Marketing Analyst will support new business and renewal marketing initiatives by assisting with the development of customer-focused, strategically oriented proposal responses and final presentations for employee benefit programs. How You Will Contribute: <ul><li>Maintain renewal tracking as well as the coordination and implementation of the client renewal process from end to end.</li><li>Accountable for the quality and timeliness of marketing renewals according to the account management teams planned strategy.</li><li>In collaboration with the account management team, responsible for producing a final and complete renewal presentation.</li><li>Set priorities and manage analytical workflow to ensure efficient, timely and accurate creation of monthly, quarterly and annual deliverables.</li><li>Support the benefits team to analyze and prepare financial reporting packages in accordance with client expectations (e.g. post renewal, mid-year, pre-renewal, renewal). </li><li>Work with the Underwriters and Account Executives to assist in developing alternative strategies, plan modeling and cost reduction opportunities.</li><li>Collaborate with Account Management team to maintain Agency Management Systems with current required information and documents on an ongoing basis – census, rates, benefit summaries, commissions, and other agency management system duties as required.</li><li>Work closely with service team members to assist with strategic objectives of client. </li><li>Evaluate data and perform reconciliation to ensure data integrity.</li><li>Assist in preparing materials for finalist sales presentations as requested for target clients and present data as appropriate. </li><li>Expected to have occasional client contact pertaining to final marketing deliverables and required to attend client meetings upon request.</li></ul> Skills & Experience to Be Successful: <ul><li>2+ years’ experience with Employee Benefits products and services </li><li>CT Life & Health Producer License obtained within one year.</li><li>Experienced in MS Office - strong knowledge of PowerPoint and Excel building illustrations and working with data.</li><li>General knowledge of Employee Benefits products and services </li><li>Experience managing multiple priorities and proven time management abilities.</li><li>Ability to maintain a high level of confidentiality</li><li>Effectively working in a team environment.</li></ul> Teammate Benefits & Total Well-Being: We go beyond standard benefits, focusing on the total well-being of our teammates, including: <ul><li>Health Benefits: Medical/Rx, Dental, Vision, Life Insurance, Disability Insurance </li><li>Financial Benefits: ESPP; 401k; Student Loan Assistance; Tuition Reimbursement </li><li>Mental Health & Wellness: Free Mental Health & Enhanced Advocacy Services; </li><li>Beyond Benefits: Paid Time Off, Holidays, Preferred Partner Discounts and more. </li></ul> The annual pay range is $52k - 65k paid on an hourly basis

Built on meritocracy, our unique company culture rewards self-starters and those who are committed to doing what is best for our customers. The Data Analyst is a key team member of the National Employee Benefits Technology (EBTech) Department. The department deploys various software tools to our valued customers and their employees for use in health care reform compliance, automated benefits enrollment, and other needs for automation. With oversight, the Data Analyst is responsible for carrying out various aspects of ongoing support processes, including data analysis/audits, testing, and training. How You Will Contribute: Develops knowledge of applicable software tools. Learn to audit and upload data for low to moderate complexity new implementations or on an ongoing basis for existing customers. Learn to create and configure low to moderate complexity EDI files for new and existing customer websites (using third party software). Basic skills to solve and troubleshoot routine issues. Basic understanding of testing and quality assurance process and works with senior analyst and others to quality check own data files and other work. Provide routine direct daily support to assigned customers and/or customers as directed Learn health and benefits products, services and tools in order to appropriately configure and test EDI/data files. Follow department guidelines, policies and procedures; including professional development and continuing education required for valid licensing. Skills and Experience to Be Successful Proficient with MS Office Suite Experience working with database applications Exceptional telephone demeanor Strong interpersonal skills, and ability to communicate with customers at all levels Ability to maintain a high level of confidentiality Preferred 1-2 years of experience in an office environment, preferably in the insurance, human resources, or financial sectors Associate's, or Bachelor's degree in a related field, or equivalent work experience Pay Range 20 - 23 Hourly The pay range provided above is made in good faith and based on our lowest and highest annual salary or hourly rate paid for the role and takes into account years of experience required, geography, and/or budget for the role. Teammate Benefits & Total Well-Being We go beyond standard benefits, focusing on the total well-being of our teammates, including: Health Benefits: Medical/Rx, Dental, Vision, Life Insurance, Disability Insurance Financial Benefits: ESPP; 401k; Student Loan Assistance; Tuition Reimbursement Mental Health & Wellness: Free Mental Health & Enhanced Advocacy Services Beyond Benefits: Paid Time Off, Holidays, Preferred Partner Discounts and more. Not reflective of all benefits. Enrollment waiting periods or eligibility criteria may apply to certain benefits. Benefit details and offerings may vary for subsidiary entities or in specific geographic locations. The Power to Be Yourself We are an Equal Opportunity Employer. Brown & Brown is committed to fostering an inclusive environment comprised of people from all backgrounds, with a variety of experiences and perspectives, guided by our Diversity, Inclusion & Belonging (DIB) motto, "The Power to Be Yourself".

Built on meritocracy, our unique company culture rewards self-starters and those who are committed to doing what is best for our customers. The Commercial Lines Marketing Analyst role in Phoenix, AZ will coordinate marketing efforts with competing insurance companies on an account-by-account basis for sales and customer service teammates. Responsible for reviewing, analyzing, and improving upon quotes received and evaluating and negotiating coverage and price for renewals and prospective business. How You Will Contribute <ul> <li>Coordinate the procurement of alternative quotes and carrier options to retain existing insurance programs. </li><li>Analyze market information to develop, design, and implement creative strategies for sales team members. </li><li>Review and recognize areas for improvement in existing policies and competing quotes and evaluate options alongside the sales team member and service representative. </li><li>Negotiate with insurance carriers' competitive coverage and pricing options on behalf of our client. </li><li>Provide sales and customer service teammates with any market information or insight. </li><li>Monitor, identify, and develop new methods, new markets, and new opportunities. </li><li>Review submissions from either the producer or account manager for completeness and accuracy. </li><li>Review submission to determine appropriate insurance companies for account solicitation. </li><li>Identify new markets through research and begin the process to contract with insurance companies or brokers if necessary and given approval from management. </li><li>Utilize and direct assistants in the process of online rating and proposal creation. </li></ul>Skills & Experience to Be Successful <ul> <li>Minimum education - college degree or related work experience </li><li>Proficient with MS Office & Excel </li><li>Exceptional telephone demeanor </li><li>Ability to maintain high level of confidentiality </li><li>3-5 years experience in a similar position </li><li>Must have and maintain current Property & Casualty Insurance License for required states. </li><li>Independent insurance agency experience (Preferred) </li><li>Property and Casualty Insurance Designation such as CISR, CRIS, AAI or similar designation (Preferred) </li></ul>Teammate Benefits & Total Well-Being We go beyond standard benefits, focusing on the total well-being of our teammates, including: <ul> <li>Health Benefits: Medical/Rx, Dental, Vision, Life Insurance, Disability Insurance </li></ul><ul><li>Financial Benefits: ESPP; 401k; Student Loan Assistance; Tuition Reimbursement </li></ul><ul><li>Mental Health & Wellness: Free Mental Health & Enhanced Advocacy Services; </li></ul><ul><li>Beyond Benefits: Paid Time Off, Holidays, Preferred Partner Discounts and more. </li></ul> Not reflective of all benefits. Enrollment waiting periods or eligibility criteria may apply to certain benefits. Benefit details and offerings may vary for subsidiary entities or in specific geographic locations. #LI-KM1 Teammate Benefits & Total Well-Being We go beyond standard benefits, focusing on the total well-being of our teammates, including: <ul> <li>Health Benefits: Medical/Rx, Dental, Vision, Life Insurance, Disability Insurance </li> <li>Financial Benefits: ESPP; 401k; Student Loan Assistance; Tuition Reimbursement </li> <li>Mental Health & Wellness: Free Mental Health & Enhanced Advocacy Services </li><li>Beyond Benefits: Paid Time Off, Holidays, Preferred Partner Discounts and more. </li> </ul> Not reflective of all benefits. Enrollment waiting periods or eligibility criteria may apply to certain benefits. Benefit details and offerings may vary for subsidiary entities or in specific geographic locations. The Power to Be Yourself We are an Equal Opportunity Employer. Brown & Brown is committed to fostering an inclusive environment comprised of people from all backgrounds, with a variety of experiences and perspectives, guided by our Diversity, Inclusion & Belonging (DIB) motto, "The Power to Be Yourself".

Built on meritocracy, our unique company culture rewards self-starters and those who are committed to doing what is best for our customers. Brown & Brown is an independent insurance intermediary that through its licensed subsidiaries provides a variety of insurance and reinsurance products and services to corporate, public entity, institutional, trade, professional, association, and individual clients. Headquartered in Daytona Beach, Florida, offices are located across the United States, with products and services offered through four major business divisions. We are listed on the NYSE at BRO. Our drive to be the best has made Brown & Brown one of the largest and most respected independent insurance intermediaries in the nation, with over 75 years of continuous service. The Company is ranked as the sixth largest such organization in the United States and seventh in the World by Business Insurance magazine. The Sr. Data Platform Engineer is a member of the Enterprise Data Platform team reporting to the Director, Enterprise Data Platforms. This experienced individual will develop, automate and manage cloud-based data capabilities and technologies in support of both the overall data strategy, architecture and roadmap and the delivery of divisional, corporate and enterprise data assets and insights. Partnering with the operations and delivery teams, they will ensure the availability, stability, performance and scalability of data capabilities and technologies. Responsibilities: <ul><li>Engineer, deliver and support automated, Azure cloud-based data capabilities and technologies in support of the Modern Data Platform (MDP) strategy and roadmap.</li><li>Develop, deliver and support Infrastructure As Code templates for MDP capability deployments.</li><li>Monitor, measure and report on the utilization, performance and cost of MDP capabilities.</li><li>Identify and implement enhancements to further automate and scale the MDP capabilities.</li><li>Provide implementation, production and consulting support to delivery teams leveraging the MDP.</li><li>Collaborate with the Enterprise Data Architecture and Enterprise Data Enablement teams on data solutions and roadmaps.</li><li>Define and automate data platform controls in support of Software Development Lifecycle (SDLC) requirements.</li><li>Mentor and provide guidance to Data Engineers with respect to MDP capabilities.</li><li>Work well with co-located and distributed team members and partners.</li><li>Demonstrate a high degree of creativity and problem-solving skills.</li><li>Other duties as assigned.</li></ul> Required: <ul><li>Bachelor's degree in computer science or related field or equivalent work experience.</li><li>Experience implementing data capabilities and technologies supporting data pipelines, data integration, data transformation, analytics, reporting and modeling (e.g. AI/ML).</li><li>Deep understanding of engineering, implementing, and supporting data platforms and solutions in a cloud environment.</li><li>Strong hands-on experience implementing and using cloud-based storage, data lake, analytics, visualization, SQL, container, dev ops and security services.</li><li>Experience with data platforms supporting Data as a Product, Data as a Service, Data Mesh, Data Virtualization, Delta Lake, Lakehouse and/or Data Fabric.</li><li>Experience with Azure Data Factory, Azure Synapse Analytics, Azure Databricks, Snowflake, Denodo and/or equivalent cloud data technologies and platforms.</li><li>Strong hands-on experience developing and supporting Infrastructure As Code templates.</li><li>Strong hands-on experience working with Python, Java, SQL and JSON.</li><li>Deep understanding of data management and data governance principles.</li><li>Passion for learning new technologies and enhancing existing skills.</li><li>Experience developing, implementing, and supporting integrated frameworks across data capabilities and technologies.</li><li>Experience implementing and using CI/CD pipelines and automation.</li><li>Experience in end-to-end Software Development Life Cycle (SDLC) projects.</li><li>Experience working with key stakeholders and technology peers.</li><li>Excellent verbal and written communication skills.</li><li>Self-starter with the ability to build strong relationships and work collaboratively.</li><li>Ability to adapt and respond in a rapidly evolving business environment.</li><li>8+ years of related work experience.</li></ul> Preferred : <ul><li>Experience engineering, implementing, and supporting data solutions in Azure.</li><li>Experience with Collibra, Purview, BigID, Unity Catalog and/or equivalent metadata, data quality and data cataloging technologies.</li><li>Experience working with Agile/Scrum methodologies.</li><li>12+ years of related work experience.</li><li>Microsoft Azure Solutions Architect Expert, Azure Data Engineer Associate, or equivalent certification(s).</li><li>Experience in the insurance industry and/or basic knowledge of insurance.</li><li>Experience engineering, implementing, and supporting solutions covering multiple geographies.</li></ul> What we offer: <ul><li>Excellent growth and advancement opportunities</li><li>Competitive pay based on experience.</li><li>Discretionary Time Off (DTO)</li><li>Generous benefits package: health, dental, vision, 401(k), etc.</li><li>Employee Stock Purchase Plan</li><li>Tuition Reimbursement and Student Loan Repayment Assistance</li><li>Mental Health Resources</li></ul> We are an Equal Opportunity Employer. We take pride in the diversity of our team and seek diversity in our applicants.

Brown & Brown Insurance Interview Questions

Brown & Brown Insurance Interview Guides

Brown & Brown Insurance Interview Questions

Brown & Brown Insurance Salaries by Position

Brown & Brown Insurance Opening Jobs