Prepare for and practice interview questions from Berkley.

Berkley Interview Questions

Berkley Interview Guides

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?

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

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

Berkley Salaries by Position

Company Details: Berkley Fire & Marine (BFM) is an operating unit of W.R. Berkley, a Fortune 500, $12 Billion revenue, Property & Casualty insurance company. At BFM, our mission is to offer best-in-class inland marine insurance to our valued agent & broker partners nationwide. Our business is built around relationships and service and enabled by cutting-edge technology. The newly established BFM technology team is focused on delivering technology solutions that will improve efficiency, help make decisions that will drive growth & profitability and create a differentiated agent experience. W.R. Berkley offers endless ways to get involved and have the chance to grow your career into a wide range of roles you'd never known existed. Come join us as we push forward into the future of industry leading technological solutions. Responsibilities: Consults with business users to gather business requirements to bridge the needs of the business with the use of IT. This includes determining client and organizational needs, system and operational requirements, downstream system impacts, and legal & compliance obligations. <ul><li>Works with end user to complete business requirements for multiple and/or high company profile projects. </li><li>Provides Subject Matter Expertise and deep functional product expertise, including upstream/downstream impact of changes. </li><li>Able to make multiple recommendations on how to improve the business processes/workflow. </li><li>Acts in a consultative role to provide resolutions to complex problems. </li><li>Forms strong customer relationships and has good understanding of how corporation/company operates. </li><li>Develops & executes test plans on assigned projects. </li><li>Assists with resource & project planning. </li><li>Leads meetings regarding projects, enhancements and support. </li><li>Travel for this position is up to 15%. </li></ul>Qualifications: <ul> <li>Bachelors degree with emphasis in related field or equivalent experience </li><li>7+ years BA/P&C/functional experience. Understands P&C insurance systems and business processes. </li><li>Must have demonstrated the capability of meeting the key functions/responsibilities of the position. </li><li>Software Development Life Cycle experience, including Agile. </li><li>Excellent problem solving and analytical skills. </li><li>Strong interpersonal and communication skills, both oral and written. </li><li>Ability to quickly learn new processes and concepts. </li><li>Working knowledge of Jira. </li><li>Requires little oversight. </li></ul> The Company is an equal employment opportunity employer. Additional Company Details: *The above job description is not intended to be an all-inclusive list of the duties and responsibilities of the job described, nor is it intended to be such a listing of the skills and abilities required to do the job. Rather, it is intended only to describe the general nature of the job.

Company Details: <img src="https://berkley.icims.com/icims2/servlet/icims2?module=AppInert&action=download&id=6972&hashed=-1991107329" alt="Berkley_Oil_&_Gas_Logo" /> Berkley Oil & Gas, (a W.R. Berkley Company) is an insurance underwriting manager providing unique property and casualty products and risk services to customers engaged in the energy sector. Our customers recognize the importance of the expertise we provide and appreciate the opportunity to work with professionals who understand their business. We are in turn committed to delivering innovative products and exceptional service to them, our valued agents and brokers, Berkley Oil & Gas is dedicated in its efforts to be well-informed of the changing dynamics of the industry; support industry efforts to minimize and mitigate risks and hazards in the oil patch, and to constantly seek ways to improve our products and services to meet customer needs. Company URL: <a href="https://berkleyoil-gas.com/" target="_blank" rel="noopener">https://berkleyoil-gas.com/</a> The company is an equal opportunity employer. Responsibilities: As a Data Scientist, you will focus on leveraging the companys substantial data assets to deliver actionable and meaningful business insights using analytics, predictive models, machine learning, and artificial intelligence. The ideal candidate will possess a strong technology background with mid-to-advanced-level expertise in data analysis and building (and deploying) predictive models. We are looking for a highly motivated individual with the ability to help us deliver next-generation solutions. This position requires improving and supporting our application infrastructure, writing code, analyzing data, creating models, creating ad hoc apps/reports/dashboards, working with both internal and external customers, participating in project management and execution, and leading small individual and team projects. The Advanced Analytics team is passionate about continuous learning and turning that knowledge into cutting-edge analytical solutions. We strive to deliver innovative analytical solutions that generate tangible business results. <ul><li>Develop, test, deploy, and help monitor analytics products and predictive models including data engineering, data analysis, and AI/ML/NLP</li><li>Service the analytical needs of internal and external customers by providing high-value analysis, reports, dashboards, and/or electronic files as needed</li><li>Execute and participate in leading high-value data science projects including defining project deliverables, estimating timelines, estimating expected business value, assigning project tasks, and ensuring efficient execution and proper documentation from ideation through business integration</li><li>Help implement automated solutions to monitor and maintain the performance of the teams analytical products.</li><li>Identify when model retraining or new solutions are needed</li><li>Design and execute well-documented experiments to identify novel uses of internal and external data to deliver business value</li><li>Keep up to date with AI and ML best practices as relates to the companys initiatives and share key insights with the team</li><li>Help design, evangelize, and continuously improve group best practices</li><li>Conduct formal peer reviews of data science projects from other team members</li><li>Work on cross-functional teams within the company and across the larger corporation to develop and implement novel analytics and data science solutions</li><li>Provide mentorship to junior team members</li><li>Create and deliver presentations to internal and external customers as needed</li></ul> Qualifications: <ul><li>Requires minimum of 2 to 5 years of business experience as a data scientist or in a related field.</li><li>Possesses an intense curiosity and determination to explore and solve complex business problems utilizing data, technology, and analytical techniques.</li><li>Ability to multitask and manage assigned work under very tight deadlines.</li><li>Advanced understanding of a variety of statistical and machine learning algorithms</li><li>Intermediate-to-Advanced understanding of natural language processing</li><li>History of following data visualization best practices</li><li>History of following coding best practices</li><li>Experience in breaking projects down into deliverables, setting timelines, and providing accurate status reports to management</li><li>Significant experience with working with large databases for analytical purposes. This would include both transactional systems and data warehouse systems.</li><li>Intermediate-to-Advanced level understanding of SQL Databases and the SQL Programming Language SQL Server / Oracle and including programming in T-SQL, PL/SQL or the like.</li><li>Intermediate-to-Advanced level programming experience with Python and/or other DS software/platforms</li><li>Knowledge of information technology practices relating to data, data warehousing, ETL processes and data mining.</li><li>Understanding of project management practices and approaches including waterfall and Agile methodologies and experience with project management software such as Microsoft Team Foundation Server, Jira, Trello, etc.</li><li>Experience with code management (version control) techniques utilizing tools such as Microsoft Team Foundation Server, GitHub, etc.</li><li>Intermediate experience with UNIX and Docker</li><li>Excellent listening and interpersonal skills.</li><li>Experience working in a team-oriented, collaborative environment.</li><li>Ability to translate very complex subject matter into understandable written and oral communications.</li></ul> Education Requirement<ul><li>Bachelors or Advanced degree in data science, computer science, mathematics, statistics, engineering, physics or other sciences (or college degree with significant technical experience in a corporate setting).</li><li>Education should include significant work in advanced mathematics, statistics, and/or data science. Undergraduate or graduate work in computer science is a plus.</li><li>Insurance knowledge and experience is a plus.</li></ul> Additional Company Details: We do not accept any unsolicited resumes from external recruiting agencies or firms. The company offers a competitive compensation plan and robust benefits package for full time regular employees. The actual salary for this position will be determined by a number of factors, including the scope, complexity and location of the role; the skills, education, training, credentials and experience of the candidate; and other conditions of employment. Sponsorship Details: Sponsorship not Offered for this Role

Company Details: With a focus on technology and strategic operations, Berkley Alternative Markets Tech is a group of technologists with a passion for making insurance better. We work with a team of industry experts from six different Berkley insurance brands who focus on delivering value to the workers compensation market. As we grow our team, we are looking for inquisitive, entrepreneurial minded people who are excited to reimagine the insurance industry. Insurance is too complex. Help us make it better. Responsibilities: As a Product Manager, you will be responsible for building software products that delight our customers and advance our business interests. Specifically, you will own the vision, strategy, design, and execution of a technology product, while also building consensus across your stakeholders and teammates. Beyond that, were looking for someone with a high degree of ownership. And the way we tend to define ownership is in terms of your willingness to look critically at yourself and make changes. Problems are inevitable, and you are going to fail a lot. We are looking for people who will take responsibility for failures, learn from them, and reinvest that learning in their work. <ul> <li>Assist in defining product vision. Complete product planning and execution throughout the product lifecycle. </li><li>Collaborate with business stakeholders and end users to understand and prioritize product requirements. Act as customer liaison for technical issues, product integration and development. </li><li>Work closely with developers and cross-functional teams to ensure fulfillment of product performance. </li><li>Deliver Results. You will curate the best ideas, hypothesize their value, and implement the most promising of them. You will constantly re-assess what we have built to make sure we are realizing actual value. </li><li>Focusing on the Data. You will establish OKRs that define our goals and quantify our results. You will regularly review your indicators for actionable insights and you will host OKR Reviews to create cross-functional alignment. </li><li>Understand Our Customers. You will keep yourself and our team highly exposed to customer feedback. You will use this exposure to anticipate customer needs and constantly improve their experiences. </li><li>Saying no. You will help us choose the right problem to solve next. Sometimes you will have to say no to things. You will consistently weigh short- and long-term trade-offs while keeping a healthy bias toward the long term. </li><li>Challenge the Status Quo. For various processes, you will understand what we do and why we do it. Then you will work across Business, Operations, Design, Data, and Engineering teams to reimagine how. </li></ul> Qualifications: Skills/Experience <ul> <li>Experience driving product vision, go-to-market strategy, and design discussions </li><li>Experience with product discovery techniques, such as A/B testing and canary releases </li><li>Experiences setting objectives and key results </li><li>Experience serving as the product owner for an agile team </li><li>Demonstrated ability to empower teams with context </li><li>Proven record building strong stakeholder relationships </li><li>Knowledge of data structures, algorithms, and computing fundamentals (preferred) </li></ul> Education <ul> <li>Bachelors degree in computer science, engineering, product management or equivalent experience (preferred) </li></ul> Travel Requirements <ul> <li>Low level of domestic U.S. travel required (up to 5% of time) </li></ul> Additional Company Details: The Company is an equal employment opportunity employer We do not accept any unsolicited resumes from external recruiting agencies or firms. The company offers a competitive compensation plan and robust benefits package for full time regular employees. The actual salary for this position will be determined by a number of factors, including the scope, complexity and location of the role; the skills, education, training, credentials and experience of the candidate; and other conditions of employment. https://berkleyalternativemarkets.tech/

Berkley Interview Questions

Berkley Interview Guides

Berkley Interview Questions

Berkley Salaries by Position

Berkley Opening Jobs