Prepare for and practice interview questions from Mitchell Martin Inc..

Mitchell Martin Inc. Interview Questions

Mitchell Martin Inc. Interview Guides

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

Suppose there exists a new airline named Jetco that flies domestically across North America. Jetco recently had a study commissioned that tested the boarding time of every airline, and it came out that Jetco had the fastest average boarding times of any airline.

What factors could have biased this result, and what would you look into?

What could potentially bias the average boarding time in favor of an airline that only flies domestically?

What could potentially bias the average boarding time in favor of an airline that only flies domestically?

Boarding Times Bias

A new airline came out as the fastest average boarding times compared to other airlines.  What factors could have biased this result and what would you look into?

Mitchell Martin Inc. Salaries by Position

Our Client, An American bermuda-based public limited liability company, is seeking a Data Engineer (Software Developer). Location: Raleigh, NC Position Type: Full-Time/Perm Schedule: Hybrid 2 Days Onsite in a Week Job Summary: The Data Engineer (internally known as Software Engineer III), will specialize in designing, implementing, and optimizing database systems for efficient storage, retrieval, and management of structured data. Join us as we embark on an exciting modernization journey, transitioning from our legacy platforms to cutting-edge technologies like Power BI and Snowflake. We're seeking passionate individuals to drive this transformation, leveraging their expertise to revamp our data infrastructure and propel us into the future. Responsibilities: Works with the Agile Program Manager (APM), Digital Product Manager (DPM), and Business Systems Analyst (BSA) to accurately capture stakeholder requests and system specifications and translate them into engineering artifacts, which typically include design specifications, source code, test scripts and test results. Coordinates with software architects and Software engineer IVs to ensure that the engineering realization is in accordance with Enterprise Architecture principles and software development best practices. As part of Agile teams, completes software development work which includes application design, coding, code review and testing. Keeps Agile team and APM apprised of project status. Offers suggestions to stakeholders on devising effective and efficient approaches to achieve project and program objectives. Manages engineering risks by proactively tracking and communicating issues and devising methods to mitigating them. Liaises with other project and program areas to coordinate interdependencies and resolve issues. Supports business units in the resolution of in-depth user questions and issues following production support process and SLA's. Maintains a working knowledge of new technology and software engineering standards, practices and tools. Provides input to APM/DPM in creation of Product Roadmap, High Level Estimates Collaborates with IT management to define and develop documentation & engineering artifact standards, guidelines, processes, and templates. Education and Experience: Strong understanding of data warehouse concepts and experience with different modeling approaches like DVM, Kimball etc. Experience in cloud data architecture that supports advanced analytics including Snowflake, Azure 5-7 years of experience in developing reports, preferably using Power BI. 5-7 years of experience in ETL using SSIS or similar technologies. Strong SQL knowledge and hands on experience working with structured & semi-structured databases like SQL server, DB2 & Mongo. Hands on experience in administering Cognos (Installation/Configuration, Security Setup, Scheduling, Data Source setup) & Power BI (Gateway installation/Configuration, Creating connections). Hands on experience in DataOps. Excellent analytical, problem solving and organizational skills. Excellent interpersonal, and written and oral communication skills. Strong customer service skills to provide end user/business owner systems support. Knowledge of production support processes such as incident and problem management techniques. Required knowledge and skills would typically be acquired through a Bachelors degree in computer science, business, or related field plus 5 to 7 years of related experience. #LI-SL1

Fulltime Role Fully remote- must work EST Hours End Client Will NOT Sponsor Job Title: BI Analyst Job Description: We are seeking a skilled BI Analyst with expertise in data blending to join our team. The ideal candidate will have experience in combining data from multiple sources to create comprehensive and actionable insights. You will be responsible for designing, developing, and maintaining BI solutions, including dashboards and reports, to support data-driven decision-making across the organization. Key Responsibilities: <ul> <li>Perform data blending to merge data from various sources, ensuring accuracy and consistency. </li><li>Develop and maintain dashboards, reports, and data visualizations using BI tools. </li><li>Collaborate with stakeholders to understand business needs and translate them into analytical solutions. </li><li>Conduct data analysis to identify trends, patterns, and actionable insights. </li><li>Ensure data integrity and accuracy throughout all BI processes. </li></ul> <li> Qualifications: <ul> <li>Proven experience as a BI Analyst with strong data blending skills. </li><li>Proficiency in BI tools (e.g., Tableau, Power BI, or similar). </li><li>Strong understanding of SQL and data modeling. </li><li>Excellent analytical and problem-solving skills. </li><li>Ability to communicate complex data insights to non-technical stakeholders. </li> </ul>

*****W2 ONLY, NO C2C***** Job Title: Business Analyst ( w/ Basel experience )Client Location: Plano, TX / Atlanta, GAType: ContractSet-up: Hybrid (3 days a week in the office) Role/ Team Overview:Team supports the Capital Management function. The team will be subject to multiple critical regulations and also going through a Technology Transformation Journey to build and adopt General capabilities for Data Ingestion, Rules Authoring Execution, and Analytics capabilities. This is a greenfield project that requires meticulous design to replace multiple legacy applications within Treasury Technology. These applications will also house some critical regulatory programs such as Basel IV, FRTB. Required skills:• 10+ years’ experience with at least 3+ years’ experience as a BA/FA• Delivery focused techno-functional role• Good knowledge of SQL programming preferably with databases such as Oracle Exadata• Programming experience with Python or Java/.Net• Excellent analytical and problem solving skills• Deep understanding of Capital Markets with focus on Credit Risk,Market Risk or Capital calculations• Understanding of regulations within the Capital Markets space (Basel, CRR, CRD IV etc)• Attention to detail and self-starter, with an ability to identify risks and issues and suggest improvements. BE PART OF OUR GROWING TEAM!

Our banking client is looking to hire a Quality Data Engineer role to join their data engineering team. You will be testing in a data environment, working with data pipelines, and migrating ETL jobs from Oracle/Informatica to AWS/Databricks ecosytems. You will be evaulating the specs, writing test cases and working in an Agile/Scrum environment. *** NO SPONSORSHIP AVAILABLE AT THIS TIME*** Onsite 2 days per week in NYC Requirements: <ul><li>Experience as a Data Engineer building data pipelines.</li><li>Must have experience using Databricks.</li><li>Experience transitioning from Oracle/SQL to Databricks.</li><li>Experience testing in a data environment and ability to write and automate test cases.</li><li>Experience working in AWS. </li><li>Experience working in an Agile/Scrum environment. </li><li>Proficiency with using Python. </li><li>Experience using SQL.</li></ul>

Fulltime RoleFully remote- must work EST HoursEnd Client Will NOT Sponsor Job Title: BI Analyst Job Description:We are seeking a skilled BI Analyst with expertise in data blending to join our team. The ideal candidate will have experience in combining data from multiple sources to create comprehensive and actionable insights. You will be responsible for designing, developing, and maintaining BI solutions, including dashboards and reports, to support data-driven decision-making across the organization. Key Responsibilities:<ul><li>Perform data blending to merge data from various sources, ensuring accuracy and consistency.</li><li>Develop and maintain dashboards, reports, and data visualizations using BI tools.</li><li>Collaborate with stakeholders to understand business needs and translate them into analytical solutions.</li><li>Conduct data analysis to identify trends, patterns, and actionable insights.</li><li>Ensure data integrity and accuracy throughout all BI processes.</li></ul><li></li>Qualifications:<ul><li>Proven experience as a BI Analyst with strong data blending skills.</li><li>Proficiency in BI tools (e.g., Tableau, Power BI, or similar).</li><li>Strong understanding of SQL and data modeling.</li><li>Excellent analytical and problem-solving skills.</li><li>Ability to communicate complex data insights to non-technical stakeholders.</li></ul>

Title: Data ArchitectLocation: - Jersey City, NJ/Charlotte, NCPosition Type: Contract Duration: 12-18 MonthsSchedule: Hybrid 3 Days in the Office Candidates who can work independently for any employer only can apply!!!This is a hybrid position!!! Job Responsibilities:<ul><li>Support the implementation of the strategy for identification, certification, adoption and monitoring of Authoritative Data Sources (ADS)</li><li>Supporting ADS adherence to Enterprise Data Management (EDM) Standards, including the implementation and ongoing monitoring of all technology controls associated with an ADS</li><li>Support the establishment and run the Risk & Finance Data Design Authority to govern the adoption of data governance practices</li><li>Drive the enhancement and implementation of the Authoritative Source Certification Framework</li><li>Build a common data culture between business leaders, architects and the CDO community to ensure clear lines of responsibility, accountability for all aspects of data ownership, data management and data remediation activities.</li><li>Establish and maintain relationships across stakeholder groups (COOs of business functions, IT architects, IT service owners, domain architects and the wider CDO community)</li><li>Drive value realization through data architecture by recommending data strategies and programs</li><li>Drive program coordination, stakeholder management and executive level reports for strategic data program using strong data story telling skills</li></ul>Required Skills:<ul><li>Knowledge of data management fundamentals - including data architecture, data quality, data governance, metadata management, data lineage and analytics</li><li>Strong project management experience, including attention to details, ability to work independently</li><li>Communication and relationship building- work with a variety of stakeholders to drive forward program while building relationships</li><li>Problem solving, analysis & ability to learn new skills quickly</li><li>Proven passion for the data quality discipline</li><li>Strong analytical and problem-solving skills</li><li>Desired: Tableau, SQL, Collibra</li></ul>

Here are the details: Location: Tampa, FL /, Rutherford, NJ Position type: Long term contract / contract-to-hire possible H1B Transfer candidates are WELCOME to apply!H4-EAD, Green Card, EAD and US Citizens are encouraged to apply. Unfortunately, we cannot work with additional employers (3rd Party/C2C ) Job DescriptionCandidate must have at least 12+ years Big Data Development experience.At least 8+ years experience with the following skills:• HDFS• Hive/HQL• Shell Scripting• Spark• Arcadia• Kafka• Good communication skills• Good troubleshooting skills• Agile knowledge is a must• Good team player

We are seeking a BI/Data -Analyst If you are interested, please apply to KVasamshetti@itmmi.com Here are the details: Location: Irving TX (hybrid role) Position type: Long term Contract. Note : No third parties, Only w2 or Independent crop (ok with L2 or H4 EADs) Qualifications: <ul> <li>Financial services, expert Tableau & Excel skills (Macros) </li><li>Strong experience in creating Tableau reports, report optimization and modeling </li><li>Familiarity with risk management frameworks, industry standards and financial industry regulatory requirements </li><li>Experience in Database and Middleware technologies (Oracle, SQL Server) </li><li>Advanced Knowledge of Business Processes, Systems and Tools used in the risk and controls environment with a focus on PowerBI and Tableau </li></ul> RATE: Top Market Value! Apply to KVasamshetti@itmmi.com If you are NOT interested, please forward the details to your friends and colleagues that may fit. I can pay a SUBSTANTIAL REFERRAL

We are seeking a BI/Data -AnalystIf you are interested, please apply to KVasamshetti@itmmi.com Here are the details: Location: Irving TX (hybrid role) Position type: Long term Contract. Note : No third parties, Only w2 or Independent crop (ok with L2 or H4 EADs)Qualifications:<ul><li>Financial services, expert Tableau & Excel skills (Macros)</li><li>Strong experience in creating Tableau reports, report optimization and modeling</li><li>Familiarity with risk management frameworks, industry standards and financial industry regulatory requirements</li><li>Experience in Database and Middleware technologies (Oracle, SQL Server)</li><li>Advanced Knowledge of Business Processes, Systems and Tools used in the risk and controls environment with a focus on PowerBI and Tableau</li></ul>RATE: Top Market Value! Apply to KVasamshetti@itmmi.comIf you are NOT interested, please forward the details to your friends and colleagues that may fit.I can pay a SUBSTANTIAL REFERRAL

Mitchell Martin Inc. Interview Questions

Mitchell Martin Inc. Interview Guides

Mitchell Martin Inc. Interview Questions

Mitchell Martin Inc. Salaries by Position

Mitchell Martin Inc. Opening Jobs