Prepare for and practice interview questions from The Judge Group.

The Judge Group Interview Questions

The Judge Group 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?

The Judge Group Salaries by Position

The Judge Group is currently seeking full time data analyst for a fantastic client of ours in Orange, CA! Below you can find a basic overview of the opportunity. If you would be interested to apply, please apply directly with the link to this posting. For more information or for any questions, please reach out to Jacob at jmaybrier@judge.com! Position Overview: The Data Analyst Intermediate will provide technical expertise for all data reporting and analysis functions for the Provider Data Management Services department. The incumbent will assist in data quality audit and provider data reconciliation of provider network data which includes working with internal departments and health networks to remediate data errors. The incumbent will support the department with developing and designing reports that will assist with the routine operational requirements of the organization and as required by California Department of Health Care Services (DHCS). The incumbent will conduct data analyses and develop data reports in support of major CalOptima Health initiatives. Minimum Qualifications: - Bachelor’s degree required.- 3 years of experience working as a data analyst in the health care industry, or in a managed care environment, required.- 2 years of experience writing SQL queries using tools such SQL Server Management Studio required.- An equivalent combination of education and experience sufficient to successfully perform the essential duties of the position such as those listed above may also be qualifying. Preferred Qualifications: - 2 years of experience building Tableau and/or Power BI dashboards. Again, If you would be interested to apply, please apply directly with the link to this posting. For more information or for any questions, please reach out to Jacob at jmaybrier@judge.com! Thank You,Jacob

Are you a strategic thinker with a passion for innovation? Our client, a leading medical device company, is seeking a talented Product Manager to lead their key product lines. This is a unique opportunity to make a significant impact on patient care and business growth. Key Responsibilities:<ul><li>Market Insights: Monitor industry trends, conduct market research, and analyze customer feedback to identify opportunities and challenges.</li><li>Product Lifecycle Management: Oversee the entire product lifecycle, from concept to launch and beyond, including product development, pricing, and portfolio optimization.</li><li>Innovation: Collaborate with cross-functional teams to develop and launch innovative products that meet unmet clinical needs.</li><li>Regulatory Affairs: Support regulatory submissions and ensure compliance with relevant standards and regulations.</li><li>Marketing and Sales: Develop and execute marketing strategies to drive product adoption and sales growth.</li></ul>Qualifications:<ul><li>Bachelor's degree in engineering, business, or a related field</li><li>Minimum of 3 years of product management experience in the medical device industry</li><li>Strong analytical and problem-solving skills</li><li>Excellent communication and presentation skills</li><li>Ability to work effectively in a cross-functional team environment</li></ul> Join a team that values innovation, collaboration, and patient impact. If you're ready to take your career to the next level, please apply today. #productmanagement #medicaldevice #healthcare #innovation #jobsearch

A financial firm based in Chicago is looking to add a Java Engineer to their team. The company is currently in the beginning stages of a long term transformation as they rebuild three of their main platforms from scratch. If you are looking for a place where you can grow professionally and financially all while adding value to your team, please consider applying. What you'll do:<ul><li>Key role in design and technical direction/architecture of the updated platform</li><li>You will lead/mentor other junior and mid level and Senior developers</li><li>You will be able to help others understand how the technical decision will impact the business</li><li>Will work with leadership to increase innovation and creativity within the team</li></ul> What you need:<ul><li>5+ years of experience as a Java engineer</li><li>Kafka, spring and REST experience preferred</li><li>Strong with Data Structures and Algorithms</li><li>Experience with GIT workflows</li><li>Multithreading and concurrency</li><li>Experience with one of the following testing frameworks. (JUnit, TestingNG, Citrus etc.)</li><li>AWS experience is preferred</li></ul>

I came across your profile and was wondering if you are open to new opportunities? If so, I have a Java developer role open in Columbus, Ohio. If you’re interested, please reach out today. Project Details:This team is focusing on building their reusable APIs that are used across their commercial banking application. They are accessing other internal APIs (SOAP & restful) as well as utilizing Kafka for messaging. Must haves:Java/Spring bootStrong API experience (will be writing most from scratch)MicroservicesKafka5 plus years development experience Nice to haves:GCP (Moving to this)Experience creating API proxies on Google Apigee gateway- They expose their APIS through Google Apigee and deploy code onto the gateway.

Ideal Skill Set<ul><li>Data Engineering with good Data pipelines development experience</li><li>Good Experience in Informatica IDMC</li><li>Very good Python and SQL programming</li><li>Good knowledge of AWS technologies.</li><li>Kafka Data Streaming and API experience</li></ul> PURPOSE:The Senior Data Engineer will design, code, test, and analyze software programs and applications. This includes researching, designing, documenting, and modifying software specifications throughout the production lifecycle. POSITION RESPONSIBILITIES:<ul><li>Work with Product team to determine requirements and propose approaches to address users' needs</li><li>Analyze requirements to determine approach/proposed solution</li><li>Design and Build Solutions using relevant programming languages</li><li>Thoroughly test solutions using relevant approaches and tools</li><li>Conduct research into software-related issues and products</li><li>Bring out-of-box thinking and solutions to address challenging issues</li><li>Effectively prioritize and execute tasks in a fast-paced environment</li></ul> EXPERIENCE AND QUALIFICATIONS:<ul><li>Strong verbal and written communication skills</li><li>Demonstrate integrity and maturity, and a constructive approach to challenges</li><li>Demonstrate analytical and problem-solving skills, particularly those that apply to Data Warehouse and Big Data environments</li><li>Open minded, solution oriented and a very good team player</li><li>Hands on experience in developing Data Lake and Data Warehouse and Data Marts</li><li>Proficiency in SQL and Scripting (Unix sell scripts, Python)</li><li>Hands on experience in data pipeline development using modern ETL tools specifically on Informatica PowerCenter, Informatica IICS</li><li>Hands on experience in trouble shooting complex ETL and SQL problems</li><li>Hands on experience in designing and building data pipelines in AWS cloud using S3, Lambda, API Gateway, RDS, Redshift, etc.</li></ul>

Our client is looking for a Sr Project Manager with experience digital payments / digital wallet focused projects This is a long term contract that is remote Candidates must be fluent in Spanish Responsibilities: <ul><li>Partners with product and platform leads to develop the business case, scope the work, and ensure alignment on vision and strategy</li><li>Planning and overseeing product initiatives from inception to implementation in the digital banking area</li><li>Drives or assists research and/or brainstorming sessions; helps promote a culture of innovation within the department</li><li>Define structure for strategically critical initiatives and develop and manage a comprehensive plan for successful product launch</li></ul> Qualifications: <ul><li>5+ years of PM experience managing projects in the digital payments / digital wallet space</li><li>PMP a plus</li><li>Banking experience</li></ul>

Contract to hireHybird - Chicago, IL “This is for the LLM role, will require setting up infrastructure on AWS initially - API Gateway, Lambda Functions, CloudFormation, CodePipelines, Cross region deployment. Once that's done is when we'll get into deploying/utilizing language models inside lambda functions, SageMaker endpoints.” AWS concentration Looking for experience with LangChain LLM (Large Language models) experienceExperience building algorithmic products/applications Mid-Sr Experience7+ yearsEverything other than building the model itself Infra, deployment, future engineering, No Data movement, Data manipulations. Overall bring the product to life Algorithmic Product/Data Science teams Seeking a Machine Learning Engineer to help build the algorithmic assets and features that guests, members, customers and internal users leverage to transform the guest experience and drive efficiencies across the operations of our business. In this role you will design and implement algorithmic product architectures to bring our machine learning models to life across the full lifecycle of the product including data ingestion, ML processing, and results delivery/activation. This role will work cross-functionally with various data science teams, data engineering teams, and data architecture teams. The ideal candidate can serve as both solutions architect as well as hands-on implementation engineer and guide the team towards best-in-class algorithmic product implementations. POSITION RESPONSIBILITIES: • Partner with data scientists to design workflows/architectures that activate ML models and maximize their impact, such as real-time streaming use-cases and offline batch optimizations. • Partner with data scientists to develop prototype solutions of algorithmic products leveraging appropriate AWS services with appropriate consideration for scale and latency where applicable. • Implement and productionize final solutions via infrastructure-as-code pattern. • Implement data processing workflows to enhance our Feature Store with impactful data including appropriate data cleansing/imputation logic. • Enhance existing algorithmic products architecture/workflow as needed to maximize impact of the algorithmic product. • Partner with data engineering team to ensure data science data needs are being delivered in the appropriate format/cadence required for maximum impact. • Stay up to date with latest design patterns and AWS services with respect to Machine Learning Engineering. • Partner with data architecture, data governance, and security team to ensure solutions meet required standards. EXPERIENCE AND QUALIFICATIONS: • 5+ years of implementing software product solutions in a cloud environment with a focus on algorithmic/machine learning products, hospitality experience not required • Expertise in AWS cloud services • Expertise in Python, SQL, PySpark, Docker • Experience with streaming and batch data architectures at scale • Experience operating in an Agile Methodology environment. • Experience with DevOps and CI/CD concepts • Excellent communication and teamwork skills • Position will not require customer-facing interactions. EDUCATION: master’s degree in computer science, software engineering, or related fields required

Our client is currently seeking a Business Intelligence Analyst. Our client has quickly became a billion dollar firm and this growth is not slowing down. It is a great time to consider this opportunity if you want to join a company that is going to double in size in a few short years as you will have a lot of growth opportunities.If you are looking to join a fast growing organization where you can make a direct impact each day please consider applying. The ideal person is someone who can work in a fast paced environment, is able to self-direct, collaborate and deliver on critical Business Intelligence projects. You will be reporting directly to the Sr. Executives. Your work will be influential in the business decisions they make which means this role will be highly visible to leaders in the firm. Qualifications & Requirements:<ul><li>3+ years of experience as a business intelligence analyst</li><li>Expert SQL skills (joins, tables, stored procedures)</li><li>Strong skills with Power BI</li><li>Great business acumen. You must be able to articulate and present your work to executives of the company</li><li>Great communication skills</li><li>Must have a "whatever it takes" attitude coupled with a collaborative mindset</li></ul>

The Judge Group Interview Questions

The Judge Group Interview Guides

The Judge Group Interview Questions

The Judge Group Salaries by Position

The Judge Group Opening Jobs