The Markel Corporation Business Intelligence interview guide, interview questions, salary data, and interview experiences.

Markel Corporation Business Intelligence Interview Guide

<p>Getting ready for an Business Intelligence interview at Markel Corporation? The Markel Corporation Business Intelligence interview span across 10 to 12 different question topics. In preparing for the interview:</p>
<ul>
<li>Know what skills are necessary for Markel Corporation Business Intelligence roles.</li>
<li>Gain insights into the Business Intelligence interview process at Markel Corporation.</li>
<li>Practice real Markel Corporation Business Intelligence interview questions.</li>
</ul>
<p>Interview Query regularly analyzes interview experience data, and we've used that data to produce this guide, with sample interview questions and an overview of the Markel Corporation Business Intelligence interview.</p>


Getting ready for an Business Intelligence interview at Markel Corporation? The Markel Corporation Business Intelligence interview span across 10 to 12 different question topics. In preparing for the interview:

- Know what skills are necessary for Markel Corporation Business Intelligence roles.
- Gain insights into the Business Intelligence interview process at Markel Corporation.
- Practice real Markel Corporation Business Intelligence interview questions.

Interview Query regularly analyzes interview experience data, and we've used that data to produce this guide, with sample interview questions and an overview of the Markel Corporation Business Intelligence interview.
        

Overview

Markel Corporation Business Intelligence Salary

<p>We've gathered this data from parsing thousands of interview experiences sourced from members.</p>

We've gathered this data from parsing thousands of interview experiences sourced from members.

Markel Corporation Business Intelligence Interview Process

<p>We’re given a table of bank transactions with three columns, <code>user_id</code>, a deposit or withdrawal value (determined if the value is positive or negative), and <code>created_at</code> time for each transaction.</p>

<p>Write a query to get the total three-day rolling average for deposits by day.</p>

<p><em>Note: Please use the format <code>&#39;%Y-%m-%d&#39;</code> for the date in the outout</em></p>

<p><strong>Example:</strong></p>

<p><strong>Input:</strong></p>

<p><code>bank_transactions</code> table</p>

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

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

<tr>
<td><code>created_at</code></td>
<td>DATETIME</td>
</tr>

<tr>
<td><code>transaction_value</code></td>
<td>FLOAT</td>
</tr>
</tbody>
</table>
<p><strong>Output:</strong></p>

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

<tbody>
<tr>
<td><code>dt</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>rolling_three_day</code></td>
<td>FLOAT</td>
</tr>
</tbody>
</table>


Rolling Bank Transactions

<p>Write a query to identify the manager with the biggest team size.</p>

<p>You may assume there is only one manager with the largest team size.</p>

<p><strong>Example:</strong></p>

<p><strong>Input:</strong></p>

<p><code>employees</code> table</p>

<table>
<thead>
<tr>
<th>Column</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>

<tr>
<td><code>manager_id</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>
<p><code>managers</code> table</p>

<table>
<thead>
<tr>
<th>Column</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>

<tr>
<td><code>team</code></td>
<td>VARCHAR</td>
</tr>
</tbody>
</table>
<p><strong>Output:</strong></p>

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

<tbody>
<tr>
<td><code>manager</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>team_size</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>


Manager Team Sizes

<p>Write a query to show the number of users, number of transactions placed, and total order amount per month in the year 2020. Assume that we are only interested in the monthly reports for a single year (January-December).</p>

<p><strong>Example:</strong></p>

<p><strong>Input:</strong></p>

<p><code>transactions</code> table</p>

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

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

<tr>
<td><code>user_id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>created_at</code></td>
<td>DATETIME</td>
</tr>

<tr>
<td><code>product_id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>quantity</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>
<p><code>products</code> table</p>

<table>
<thead>
<tr>
<th>Column</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>

<tr>
<td><code>price</code></td>
<td>FLOAT</td>
</tr>
</tbody>
</table>
<p><code>users</code> table</p>

<table>
<thead>
<tr>
<th>Column</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>

<tr>
<td><code>sex</code></td>
<td>VARCHAR</td>
</tr>
</tbody>
</table>
<p><strong>Output:</strong></p>

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

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

<tr>
<td><code>num_customers</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>num_orders</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>order_amt</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>


Monthly Customer Report

Markel Corporation Business Intelligence Interview Questions

What part will you play? If you're looking for a place where you can make a meaningful difference, you've found it. The work we do at Markel gives people the confidence to move forward and seize opportunities, and you'll find your fit amongst our global community of optimists and problem-solvers. We're always pushing each other to go further because we believe that when we realize our potential, we can help others reach theirs. <br><br>Join us and play your part in something special!<br>What part will you play? If you're looking for a place where you can make a meaningful difference, you've found it. The work we do at Markel gives people the confidence to move forward and seize opportunities, and you'll find your fit amongst our global community of optimists and problem-solvers. We're always pushing each other to go further because we believe that when we realize our potential, we can help others reach theirs. <br><br>Join us and play your part in something special! <br><br>The Network Infrastructure Engineering Manager role provides overall leadership for the day-to-day management, operational oversight, support, and technical expertise for the Enterprise Network infrastructure. <br><br>Provide overall leadership for the day-to-day management of a small team of Engineers that provide support to SNC's application and business customers.<br>•Deliver on project activities within agreed timelines, provide guidance and direction to support teams, as well as other areas of IT within the greater SNC organization. <br><br>This position will be responsible for participating directly in the planning, managing, and implementation of policies and procedures to ensure job scheduling, efficiency, capacity management, system performance, offsite replication, and maintenance.<br><br><b>Job Responsibilities</b><br><ul><li>Partner with Application teams to support SNC's business platforms and assorted enterprise toolsets, providing technical support for application and business customers.</li><li>Responsible for the Planning, design, implementation, and Securing of the Companies network Infrastructure including Cisco Switches, ASA VPN solutions, Palo Alto Firewalls, Wireless network, interoperating with Azure, and responding to threats and alerts.</li><li>Principal RTE (Run the Engine) support for SNC's Network operation, support escalation, troubleshooting system and server errors. Performs resolution of complex network hardware, software application and subsystems as part of critical incident response and remediation.</li><li>Participates in the planning and management of enterprise monthly Standard Maintenance weekend activities.</li><li>Collaborates with peer organizations in SNC to ensure SLAs for incident and problem management are met.</li><li>Provide proactive system performance monitoring and resolution of alerts for organization's assets, as well as performing preventative maintenance and daily health checks reducing system downtime.</li><li>Partner with and guide other internal infrastructure engineers to perform operational support and project activities and reporting to system owners and stakeholders.</li><li>Act as a technical escalation for engineers to assist in complex troubleshooting and resolution of issues.</li><li>Trains technical staff on use of software/hardware tools in accordance with required standards and procedures.</li><li>Participate in after-hours critical production support as required. On-call support will be required for this role.</li><li>Performs other related duties as assigned.</li></ul><br><br><b>Certification</b><br><ul><li> Certifications such as CCNP Security, CCNA Security, PCNSE or CISSP are highly desirable</li><li>Familiar with Project Management methodology and SDLC.</li><li>Other Cisco, Palo Alto, or Microsoft centric certifications a plus</li></ul><br><br><b>Work Experience</b><br><ul><li>5+ years of experience in information technology service/product management leadership.</li><li>3+ years of experience in Network and Network Security delivery management, Microsoft Azure AD integration, Securing Cloud network resources, Conditional Access Policy management and interoperating with third party applications.</li><li>Demonstrated Experience working with Azure AD, Cisco ASA, Cisco Meraki, Palo Alto firewalls.</li><li>Experience opening priority incidents with external vendors and driving to resolution.</li><li>Strong analytical and critical thinking skills, with the ability to troubleshoot and resolve complex issues.</li><li>Excellent communication and collaboration skills, with the ability to work effectively with cross-functional teams.</li><li>Thorough understanding of how discrete infrastructure components work together in an Enterprise environment</li></ul><br><br><b>Skill Sets</b><br><ul><li>Excellent interpersonal, negotiation, creativity, attention to detail, and oral and written communications skills tailored for the intended audience.</li><li>Exceptional skills in the mentoring and development of team resources to ensure a core focus on providing career development opportunities for your direct reports</li><li>Strong technical foundation that enables thoughtful troubleshooting during complex incidents.</li><li>Familiarity working in an Agile and DevOps environment preferred.</li></ul><br><br>Who we are: <br><br>Markel Group (NYSE - MKL) a fortune 500 company with over 60 offices in 20+ countries, is a holding company for insurance, reinsurance, specialist advisory and investment operations around the world. <br><br><b>We're all about people | We win together | We strive for better</b> <br><br><b>We enjoy the everyday | We think further</b> <br><br>What's in it for you: <br><br>In keeping with the values of the Markel Style, we strive to support our employees in living their lives to the fullest at home and at work. <br><ul><li>We offer competitive benefit programs that help meet our diverse and changing environment as well as support our employees' needs at all stages of life.</li><li>All full-time employees have the option to select from multiple health, dental and vision insurance plan options and optional life, disability, and AD&D insurance.</li><li>We also offer a 401(k) with employer match contributions, an Employee Stock Purchase Plan, PTO, corporate holidays and floating holidays, parental leave.</li><li>Markel offers hybrid working schedules of 3 days in the office and 2 days remote.</li></ul><br><br>Are you ready to play your part? <br><br>Choose 'Apply Now' to fill out our short application, so that we can find out more about you. <br><br>The base salary offered for the successful candidate will be based on compensable factors such as job-relevant education, job-relevant experience, training, licensure, demonstrated competencies, geographic location, and other factors. <br><br><b>Caution: Employment scams</b> <br><br>Markel is aware of employment-related scams where scammers will impersonate recruiters by sending fake job offers to those actively seeking employment in order to steal personal information. Frequently, the scammer will reach out to individuals who have posted their resume online. These "job offers" include convincing offer letters and frequently ask for confidential personal information. Therefore, for your safety, please note that: <br><ul><li>All legitimate job postings with Markel will be posted on Markel Group Careers.</li><li>All legitimate communications with Markel recruiters will come from Markel.com email addresses.</li></ul><br><br>We would also ask that you please report any job employment scams related to Markel to rarecruiting@markel.com. <br><br>Markel is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of any protected characteristic. This includes race; color; sex; religion; creed; national origin or place of birth; ancestry; age; disability; affectional or sexual orientation; gender expression or identity; genetic information, sickle cell trait, or atypical hereditary cellular or blood trait; refusal to submit to genetic tests or make genetic test results available; medical condition; citizenship status; pregnancy, childbirth, or related medical conditions; marital status, civil union status, domestic partnership status, familial status, or family responsibilities; military or veteran status, including unfavorable discharge from military service; personal appearance, height, or weight; matriculation or political affiliation; expunged juvenile records; arrest and court records where prohibited by applicable law; status as a victim of domestic or sexual violence; public assistance status; order of protection status; status as a smoker or nonsmoker; membership or activity in local commissions; the use or nonuse of lawful products off employer premises during non-work hours; declining to attend meetings or participate in communications about religious or political matters; or any other classification protected by applicable law. <br><br>Should you require any accommodation through the application process, please send an e-mail to the rarecruiting@markel.com. <br><br>No Agencies Please <br><br>#piq #deib <br><br><b>US Work Authorization</b><br><ul><li>US Work Authorization required. Markel does not provide visa sponsorship for this position, now or in the future.</li></ul><br><br><b>Who we are: </b><br><br>Markel Group (NYSE - MKL) a fortune 500 company with over 60 offices in 20+ countries, is a holding company for insurance, reinsurance, specialist advisory and investment operations around the world. <br><br><b>We're all about people | We win together | We strive for better</b> <br><br><b>We enjoy the everyday | We think further </b><br><br><b>What's in it for you:</b> <br><br>In keeping with the values of the Markel Style, we strive to support our employees in living their lives to the fullest at home and at work. <br><br><ul><li>We offer competitive benefit programs that help meet our diverse and changing environment as well as support our employees' needs at all stages of life.</li></ul><br><br><ul><li>All full-time employees have the option to select from multiple health, dental and vision insurance plan options and optional life, disability, and AD&D insurance.</li></ul><br><br><ul><li>We also offer a 401(k) with employer match contributions, an Employee Stock Purchase Plan, PTO, corporate holidays and floating holidays, parental leave.</li></ul><br><br><ul><li>Markel offers hybrid working schedules of 3 days in the office and 2 days remote.</li></ul><br><br><b>Are you ready to play your part? </b><br><br>Choose <b>'Apply Now'</b> to fill out our short application, so that we can find out more about you. <br><br><b>Caution: Employment scams </b><br><br>Markel is aware of employment-related scams where scammers will impersonate recruiters by sending fake job offers to those actively seeking employment in order to steal personal information. Frequently, the scammer will reach out to individuals who have posted their resume online. These "job offers" include convincing offer letters and frequently ask for confidential personal information. Therefore, for your safety, please note that: <br><br><ul><li>All legitimate job postings with Markel will be posted on Markel Careers. No other URL should be trusted for job postings.</li></ul><br><br><ul><li>All legitimate communications with Markel recruiters will come from Markel.com email addresses.</li></ul><br><br>We would also ask that you please report any job employment scams related to Markel to rarecruiting@markel.com. <br><br>Markel is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of any protected characteristic. This includes race; color; sex; religion; creed; national origin or place of birth; ancestry; age; disability; affectional or sexual orientation; gender expression or identity; genetic information, sickle cell trait, or atypical hereditary cellular or blood trait; refusal to submit to genetic tests or make genetic test results available; medical condition; citizenship status; pregnancy, childbirth, or related medical conditions; marital status, civil union status, domestic partnership status, familial status, or family responsibilities; military or veteran status, including unfavorable discharge from military service; personal appearance, height, or weight; matriculation or political affiliation; expunged juvenile records; arrest and court records where prohibited by applicable law; status as a victim of domestic or sexual violence; public assistance status; order of protection status; status as a smoker or nonsmoker; membership or activity in local commissions; the use or nonuse of lawful products off employer premises during non-work hours; declining to attend meetings or participate in communications about religious or political matters; or any other classification protected by applicable law. <br><br>Should you require any accommodation through the application process, please send an e-mail to the rarecruiting@markel.com. <br><br>No agencies please.

<p>What part will you play? If you're looking for a place where you can make a meaningful difference, you've found it. The work we do at Markel gives people the confidence to move forward and seize opportunities, and you'll find your fit amongst our global community of optimists and problem-solvers. We're always pushing each other to go further because we believe that when we realize our potential, we can help others reach theirs. <br> <br>Join us and play your part in something special! <br>The Security Compliance Analyst works to support the Security Program to ensure that adequate and effective processes and controls are followed and aligned to deliver compliance with security policies, standards, and regulatory requirements. This role performs security awareness training, develops and assesses security controls across the organization. This role communicates compliance requirements related to new and existing installed technology, and will translate compliance requirements into functional specifications. The Security Compliance Analyst will document and analyze risk for impact, and remediate issues. The analyst will work to understand industry best practices and how they can be applied at Markel. <br><br><b>Job Responsibilities</b> <br></p><ul> <li>Identify and communicate internal and external developments that may create or impact potential security risks to Markel. </li> <li>Identify vulnerabilities or weaknesses in Markel's systems. </li><li>Ensure security controls are adequate to protect sensitive information and systems to reduce overall risk. </li><li>Support the development and maintenance of the Markel security risk management framework and its associated controls and reporting. </li><li>Identify, evaluate, and mitigate security risks. </li> <li>Evaluate security risk by executing against the established methodology for quantifying security risk. </li><li>Review security risk management documentation to ensure clear linkages between risk drivers, mitigation activities and metrics. </li><li>Perform maintenance of security risk mitigation reports to ensure that remediation steps are effective. </li> <li>Develop and implement methodologies for the assessment of security risks throughout the organization, and reporting and monitoring security risk mitigation progress. </li><li>Create, update and modify monthly reporting mechanisms (reports, dashboards, etc.) to communicate status of security risk mitigation efforts. </li><li>Monitor and analyze the security risk management activities of the corporation. </li><li>Track the implementation of mitigation activities of security risks. </li> <li>Keep all technical skills up to date and share information learned about data protection to peers. </li></ul><b>Education</b> <ul> <li>Bachelor's degree, preferably in Information Security or Computer Science, or 4 years relevant work experience </li></ul><b>Certification</b> <ul> <li>ITIL preferred </li><li>Certified in Risk and Information Systems Control (CRISC) preferred </li><li>Certified Information Systems Security Professional (CISSP) preferred </li></ul><b>Work Experience/Skill Set</b> <ul> <li>Minimum of two years combined IT, risk management, security compliance and information security work experience. </li><li>Experience with vulnerability management tools. </li><li>Experience with IT process, risk and control frameworks, such as NIST, COBIT and ISO is preferred. </li><li>Critical thinking. </li><li>Cloud computing. </li><li>Attention to detail. </li><li>Good Microsoft Office knowledge. </li><li>Good communication, organization, documentation and presentation skills. </li></ul>#piq #deib <br> <br><b>US Work Authorization</b> <ul> <li>US Work Authorization required. Markel does not provide visa sponsorship for this position, now or in the future. </li></ul><b>Who we are: </b> <br><br>Markel Group (NYSE - MKL) a fortune 500 company with over 60 offices in 20+ countries, is a holding company for insurance, reinsurance, specialist advisory and investment operations around the world. <br> <br><b>We're all about people | We win together | We strive for better</b> <br> <br><b>We enjoy the everyday | We think further </b> <br><br><b>What's in it for you:</b> <br> <br>In keeping with the values of the Markel Style, we strive to support our employees in living their lives to the fullest at home and at work. <ul> <li>We offer competitive benefit programs that help meet our diverse and changing environment as well as support our employees' needs at all stages of life. </li></ul><ul><li>All full-time employees have the option to select from multiple health, dental and vision insurance plan options and optional life, disability, and AD&D insurance. </li></ul><ul><li>We also offer a 401(k) with employer match contributions, an Employee Stock Purchase Plan, PTO, corporate holidays and floating holidays, parental leave. </li></ul><ul><li>Markel offers hybrid working schedules of 3 days in the office and 2 days remote. </li></ul> <br><br><b>Are you ready to play your part? </b> <br><br>Choose <b>'Apply Now'</b> to fill out our short application, so that we can find out more about you. <br> <br><b>Caution: Employment scams </b> <br><br>Markel is aware of employment-related scams where scammers will impersonate recruiters by sending fake job offers to those actively seeking employment in order to steal personal information. Frequently, the scammer will reach out to individuals who have posted their resume online. These "job offers" include convincing offer letters and frequently ask for confidential personal information. Therefore, for your safety, please note that: <ul> <li>All legitimate job postings with Markel will be posted on Markel Careers. No other URL should be trusted for job postings. </li></ul><ul><li>All legitimate communications with Markel recruiters will come from Markel.com email addresses. </li></ul> <br><br>We would also ask that you please report any job employment scams related to Markel to rarecruiting@markel.com. <br> <br>Markel is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of any protected characteristic. This includes race; color; sex; religion; creed; national origin or place of birth; ancestry; age; disability; affectional or sexual orientation; gender expression or identity; genetic information, sickle cell trait, or atypical hereditary cellular or blood trait; refusal to submit to genetic tests or make genetic test results available; medical condition; citizenship status; pregnancy, childbirth, or related medical conditions; marital status, civil union status, domestic partnership status, familial status, or family responsibilities; military or veteran status, including unfavorable discharge from military service; personal appearance, height, or weight; matriculation or political affiliation; expunged juvenile records; arrest and court records where prohibited by applicable law; status as a victim of domestic or sexual violence; public assistance status; order of protection status; status as a smoker or nonsmoker; membership or activity in local commissions; the use or nonuse of lawful products off employer premises during non-work hours; declining to attend meetings or participate in communications about religious or political matters; or any other classification protected by applicable law. <br> <br>Should you require any accommodation through the application process, please send an e-mail to the rarecruiting@markel.com. <br> <br>No agencies please.

Markel Corporation Business Intelligence Interview Guide

Overview

Markel Corporation Business Intelligence Salary

Markel Corporation Business Intelligence Interview Process

Markel Corporation Business Intelligence Interview Questions

Markel Corporation Business Intelligence Jobs