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 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 you work for a social media company that has just done a launch in a new city. Looking at weekly metrics, you see a slow decrease in the average number of comments per user from January to March in this city.

The company has been consistently growing new users in the city from January to March.

What are some reasons why the average number of comments per user would be decreasing and what metrics would you look into?

What metric could be used to measure if active users are still engaging on the platform despite an overall decrease in the average number of comments per user?

What metric could be used to measure if active users are still engaging on the platform despite an overall decrease in the average number of comments per user?

Decreasing Comments

How would you investigate a decline in the average number of comments per user?

Berkley Salaries by Position

Company Details Company URL: https://www.berkleytechnologyservices.com/ Berkley Technology Services (BTS) is the dynamic technology solution for W. R. Berkley Corporation, a Fortune 500 Commercial Lines Insurance Company. With key locations in Urbandale, IA and Wilmington, DE, BTS provides innovative and customer-focused IT solutions to the majority of WRBCs 60 operating units across the globe. BTSs wide reach ensures that ideas and opinions are considered at every level of the organization to guarantee we find the best solutions possible. Driven by a commitment to collaboration, BTS acts as consultants to our customers and Operating Units by providing comprehensive solutions that not only address the challenge at hand, but proactively plan for the Whats Next in our industry and beyond. With a culture centered on innovation and entrepreneurial spirit, BTS stands as a community of technology leaders with eyes toward the future leaders who truly care about growing not only their team members, but themselves, and take pride in their employees who shine. BTS 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. Berkley Technology Services: Right Team, Right Technology, Simple and Secure. Responsibilities Join Our Innovative Insurance Data Team Were looking for a Senior Data Engineer with a deep understanding of insurance reporting and company operations. If you have a knack for mastering business data processes, system interfaces, and data structures, this is the role for you In this position, youll be tackling advanced tasks like ETL, cube creation, ad-hoc and management reporting, and crafting eye-catching dashboards and data extracts. Youll be part of a vibrant team that supports multiple companies, providing top-notch data resources and development. Your mission includes analyzing, designing, and coding innovative solutions for fast-growing companies in the Property & Casualty insurance industry. Get ready to make a big impact and have some fun along the way Design & Implement: Create and manage ETL processes, data structures, and both analytical and operational reporting environments. Innovate: Develop new system functionalities with a focus on performance, stability, and supportability. Lead by Example: Apply industry best practices in modeling, workflow, and presentation. Extract & Integrate: Design and implement data extracts for both internal and external sources. Organize & Communicate: Utilize your strong organizational and communication skills to keep everything running smoothly. Solve Problems: Tackle challenges across application, middleware, and infrastructure levels with thorough impact analysis. Set Standards: Help define standards and design patterns for data processes and structures within the team. Guide & Mentor: Provide guidance on development standards and quality expectations, and mentor new team members. Collaborate: Communicate effectively with employees at all levels, both within the company and with clients. Influence: Develop a sphere of influence with other teams and foster a collaborative environment. Be On Call: Participate in on-call rotations to ensure smooth operations. Travel: Enjoy occasional travel, up to 20%. Qualifications SQL Maestro : 7 years of experience with SQL and ETL processes, including crafting queries, stored procedures, jobs, and functions. Extensive experience with ETL tools. Proven Performer: Demonstrated ability to meet key accountabilities or the drive to learn and excel in them. Passionate Go-Getter: A self-motivated individual with an unyielding passion for success. Impact Analyst: Skilled at understanding how changes affect customers and other systems. Communication Pro: Excellent communication and organizational skills to keep everything on track. Team Player: Thrives in a fast-paced team environment. Tech Enthusiast: Quick to adapt and eager to learn new technologies. Independent Worker: Capable of working independently with minimal supervision. Customer Champion: Strong focus on customer and business needs. Bachelors degree with emphasis in related field or equivalent experience. Behavioral Core Competencies Technically Astute Managing Information Customer Service Oriented Business Knowledge Influential Conceptual Thinking The Company is an equal employment opportunity employer.

Company Details: <img src="https://berkley.icims.com/icims2/servlet/icims2?module=AppInert&action=download&id=146181&hashed=-921410266" alt="BFM_Combined_Color" width="267" height="75" /> 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 style="margin-left: .5in;">Works with end user to complete business requirements for multiple and/or high company profile projects.</li><li style="margin-left: .5in;">Provides Subject Matter Expertise and deep functional product expertise, including upstream/downstream impact of changes.</li><li style="margin-left: .5in;">Able to make multiple recommendations on how to improve the business processes/workflow. </li><li style="margin-left: .5in;">Acts in a consultative role to provide resolutions to complex problems. </li><li style="margin-left: .5in;">Forms strong customer relationships and has good understanding of how corporation/company operates. </li><li style="margin-left: .5in;">Develops & executes test plans on assigned projects.</li><li style="margin-left: .5in;">Assists with resource & project planning.</li><li style="margin-left: .5in;">Leads meetings regarding projects, enhancements and support.</li><li style="margin-left: .5in;">Travel for this position is up to 15%.</li></ul> Qualifications: <ul><li style="margin-left: .5in;">Bachelors degree with emphasis in related field or equivalent experience </li><li style="margin-left: .5in;">7+ years BA/P&C/functional experience. Understands P&C insurance systems and business processes.</li><li style="margin-left: .5in;">Must have demonstrated the capability of meeting the key functions/responsibilities of the position.</li><li style="margin-left: .5in;">Software Development Life Cycle experience, including Agile.</li><li style="margin-left: .5in;">Excellent problem solving and analytical skills.</li><li style="margin-left: .5in;">Strong interpersonal and communication skills, both oral and written.</li><li style="margin-left: .5in;">Ability to quickly learn new processes and concepts.</li><li style="margin-left: .5in;">Working knowledge of Jira.</li><li style="margin-left: .5in;">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 Company URL: https://www.berkleytechnologyservices.com/ Berkley Technology Services (BTS) is the dynamic technology solution for W. R. Berkley Corporation, a Fortune 500 Commercial Lines Insurance Company. With key locations in Urbandale, IA and Wilmington, DE, BTS provides innovative and customer-focused IT solutions to the majority of WRBCs 60 operating units across the globe. BTSs wide reach ensures that ideas and opinions are considered at every level of the organization to guarantee we find the best solutions possible. Driven by a commitment to collaboration, BTS acts as consultants to our customers and Operating Units by providing comprehensive solutions that not only address the challenge at hand, but proactively plan for the Whats Next in our industry and beyond. With a culture centered on innovation and entrepreneurial spirit, BTS stands as a community of technology leaders with eyes toward the future leaders who truly care about growing not only their team members, but themselves, and take pride in their employees who shine. BTS 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. Berkley Technology Services: Right Team, Right Technology, Simple and Secure. Responsibilities Join Our Innovative Insurance Data Team Were looking for a Senior Data Engineer with a deep understanding of insurance reporting and company operations. If you have a knack for mastering business data processes, system interfaces, and data structures, this is the role for you In this position, youll be tackling advanced tasks like ETL, cube creation, ad-hoc and management reporting, and crafting eye-catching dashboards and data extracts. Youll be part of a vibrant team that supports multiple companies, providing top-notch data resources and development. Your mission includes analyzing, designing, and coding innovative solutions for fast-growing companies in the Property & Casualty insurance industry. Get ready to make a big impact and have some fun along the way Design & Implement: Create and manage ETL processes, data structures, and both analytical and operational reporting environments. Innovate: Develop new system functionalities with a focus on performance, stability, and supportability. Lead by Example: Apply industry best practices in modeling, workflow, and presentation. Extract & Integrate: Design and implement data extracts for both internal and external sources. Organize & Communicate: Utilize your strong organizational and communication skills to keep everything running smoothly. Solve Problems: Tackle challenges across application, middleware, and infrastructure levels with thorough impact analysis. Set Standards: Help define standards and design patterns for data processes and structures within the team. Guide & Mentor: Provide guidance on development standards and quality expectations, and mentor new team members. Collaborate: Communicate effectively with employees at all levels, both within the company and with clients. Influence: Develop a sphere of influence with other teams and foster a collaborative environment. Be On Call: Participate in on-call rotations to ensure smooth operations. Travel: Enjoy occasional travel, up to 20%. Qualifications SQL Maestro : 7 years of experience with SQL and ETL processes, including crafting queries, stored procedures, jobs, and functions. Extensive experience with ETL tools. Proven Performer: Demonstrated ability to meet key accountabilities or the drive to learn and excel in them. Passionate Go-Getter: A self-motivated individual with an unyielding passion for success. Impact Analyst: Skilled at understanding how changes affect customers and other systems. Communication Pro: Excellent communication and organizational skills to keep everything on track. Team Player: Thrives in a fast-paced team environment. Tech Enthusiast: Quick to adapt and eager to learn new technologies. Independent Worker: Capable of working independently with minimal supervision. Customer Champion: Strong focus on customer and business needs. Bachelors degree with emphasis in related field or equivalent experience. Behavioral Core Competencies Technically Astute Managing Information Customer Service Oriented Business Knowledge Influential Conceptual Thinking The Company is an equal employment opportunity employer.

Company Details Midwest Employers Casualty (MEC) is a member of the W. R. Berkley Corporation, a fortune 500 company, rated A (Superior) by A.M. Best Company, based in Chesterfield, MO. We improve the quality of life for employees severely injured on the job and help companies understand and mitigate their risk for workers compensation injuries. MEC has a friendly, results-focused work environment. We seek employees who take initiative, are quick to adapt, are dependable, and like working as part of a team. Company URL: https://www.mecasualty.com/ The company is an equal opportunity employer. Responsibilities The Data Science Intern role offers students pursuing an undergraduate or graduate degree in Data Science, Statistics, Mathematics, or related fields an opportunity to gain hands-on experience in a professional data science environment. This role will provide exposure across many facets of a full stack data scientist including data management, advanced modeling, analytics, visualization, and communication of insights. Interns will work with large data sets to uncover actionable business insights. This position will connect disparate data sources and analyze information to solve business problems. In addition to developing core data analysis skills, interns will learn about IT systems, project management approaches, software development lifecycles, and learn about the insurance industry. We help companies understand and mitigate their risk for workers compensation injuries and get employees who are severely injured on the job the care they need. The Predictive Analytics department explores, arranges, and investigates data to develop valuable analytical processes. MEC has a friendly, results-focused work environment. We seek employees who take the initiative, are quick to adapt, dependable, and like working as part of a team. Our ideal candidate is someone who isnt afraid to try something new, wants exposure to code management, report automation, documentation, and requirement gathering. This internship enables students to expand their knowledge, skills, and professional network. Key functions inlcude but are not limited to: Data Management Ensure that data and/or associated reports are accurate and securely delivered in a timely fashion. Identify, research, analyze, and document data errors for correction. Utilize data to answer assigned business problems. Provide written, graphical, and verbal summaries of the analysis. Connect unrelated data sets from multiple sources both inside and outside the organization and extract meaningful insights. Service the data needs of both internal and external customers by providing reports and/or electronic files, as needed. Participate in code review and test code results by analyzing data output. Exposure Work in a professional environment and interact/network with staff and leadership. Observe and participate in all facets of the model/application development lifecycle including planning, requirements, development, and testing. Develop a basic understanding of information technology especially as it relates to data, data warehousing, ETL processes, and data mining. Understand project management practices and approaches including waterfall and Agile methodologies. Tools Expected to use and be competent with Microsoft technologies such as SQL Server, Power BI, & the Office Suite. Expected to use and be competent with other applications such as Python, GitHub, Jira, & Confluence. Qualifications Applicants should be working toward an undergraduate or masters degree with a focus in Data Science, Statistics, Mathematics, or related fields. Clearly demonstrates and models WR Berkley and Midwest innovation behaviors. Highly self-motivated and self-directed. Passion for working with data to solve problems. Proficiency with Excel; experience with database querying a plus. Strong analytical and critical thinking skills. Ability to communicate data insights verbally and visually. Proficiency in offering and actively engaging with constructive feedback Flexible schedule where the hours required are 15 hours/week during the school year and up to 38 hours/week during the summer. Additional Company Details We do not accept any unsolicited resumes from external recruiting agencies or firms. 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.

Company Details: <img src="https://berkley.icims.com/icims2/servlet/icims2?module=AppInert&action=download&id=10189&hashed=239491296" alt="Berkley_Select_Logo" /> Berkley Select IT supports 4 WRBC Companies when it comes to IT support. The team supports multiple companies within the Berkley organization and provides the expertise when it comes to the common IT platforms that all of the companies share. The BA role is responsible for collaborating with the business units establishing business requirements that enable the technical team to configure applications solutions. The company is an equal opportunity employer. Responsibilities: The Business Analyst is responsible for performing the analysis required to support the development, maintenance and enhancement of applications used by the company and its business partners. Reviews, analyzes, and evaluates business systems and user needs. Document requirements, tests system functionality, defines scope and objectives, and formulates systems to support key business processes. Act as a liaison between IT and other business departments. Key functions include but are not limited to:<ul><li>Review and analyze project requests to determine impact to existing systems. Translate business requirements into detailed specifications for use by the IT development staff/external providers.</li><li>Analyze and document current workflows, identify opportunities to meet project objectives, business processes, and make recommendations for future approaches.</li><li>Utilize user definitions, use cases and workflow diagrams to illustrate business problems.</li><li>Identify issues and escalate them as appropriate.</li><li>Lead meetings, e.g., business requirements review, testing strategy review, etc. </li><li>Actively participate in formal presentations to a variety of management levels.</li><li>Perform system/user testing as required; analyze and validate testing results.</li><li>Provide support and guidance to other IT personnel in business requirements documentation as well as system/user testing.</li><li>Act as a reference and provide support to application users with respect to questions arising from application/functionality adoption and use.</li><li>Perform rules authoring as required to support business requirements</li></ul> Qualifications: <ul><li>Bachelor's Degree in Computer Science/Management Information Systems or related field, or equivalent work experience.</li><li>Minimum of two years of prior Business Analyst or Information Technology experience</li><li>Experience should include process reengineering, flow charting and block diagramming, as well as, a good understanding of the desktop environment, user interface design and web architecture. </li><li>Strong skills needed in verbal and written communication, including communicating effectively with business users and software developers</li><li>Excellent organizational and planning skills</li><li>Ability to lead and facilitate diverse groups of people to move towards solutions</li><li>Excellent analytical and problem solving skills</li><li>Familiarity or experience with Agile/Scrum Framework is a plus.</li><li>Familiarity with business rules management system is a plus.</li><li>Experience in Insurance industry is preferred but not required.</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: <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

Berkley Interview Questions

Berkley Interview Guides

Berkley Interview Questions

Berkley Salaries by Position

Berkley Opening Jobs