Prepare for and practice interview questions from Cru.

Cru Interview Questions

Cru Interview Guides

<p>You are testing hundreds of hypotheses with many <em>t</em>-tests. What considerations should be made?</p>


<p>What is a key disadvantage of the F-test when compared to multiple t-tests?</p>

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?

<p>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.</p>

<p>Write a query to randomly sample a row from this table.</p>

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

<p><code>big_table</code> table</p>

<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

<p>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.</p>

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

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


<p>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?</p>

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?

Cru Salaries by Position

<p>Job Description:

Pay: Negotiable

Full Time, Hybrid (Part of the week in the office and part out)

Location: Orlando, FL

Ministry/Team: US Technology

About Us: Cru is a pioneer in world Christian Missions, passionate about spreading the Gospel of Jesus Christ to the nations. We seek talented individuals eager to use their God-given skills to make a global impact. At Cru Headquarters, your faith is integral to who you are, and we encourage you to bring your gifts to further the Kingdom each day.

Role Overview: As the Data Engineer and Analytics Team Leader, you'll design, build, and maintain data structures to support our ministry’s data and analytics strategy. You’ll use top-tier ETL/ELT tools to develop data pipelines, integrate data from various sources, and manage our enterprise data warehouse (EDW). Lead and mentor a team of skilled Data Engineers and Business Intelligence Analysts to create a robust data environment that supports our mission.

What We're Looking For:

BA/BS in Math, Stats, Business, CS, or Data Science (master’s preferred).

7 - 10 years of data engineering/analysis experience.

Passion for leveraging your technical skills to support our mission.

What You'll Do:

Lead Projects: Manage project planning, requirements documentation, development, and testing. Stay proficient in ETL/ELT processes and BI reports/dashboards.

Data Modeling: Create and optimize dimensional data models for BI performance in collaboration with analysts.

ETL/ELT Development: Integrate data from Oracle, Postgres, and MySQL databases into our EDW.

Data Pipelines: Design, build, and manage automated data pipelines. Ensure efficiency and reliability.

Standard Operating Procedures: Develop CI/CD practices for data integrations and BI solutions. Create training materials and manuals.

Code Reviews: Lead code reviews to resolve errors and optimize solutions.

Critical Projects: Direct data projects, mentor team members, and keep leadership informed.

Data Strategy: Assist in developing data governance and management strategies to ensure data integrity, security, and usability.

Data Governance: Participate in implementing data governance and quality capabilities. Define business rules and ensure enterprise-wide data usage standards.

Why Join Us?

Mission-Driven: Make a global impact by supporting our mission to spread the Gospel.

Collaborative Environment: Work in a faith-integrated, supportive team environment.

Career Growth: Professional and spiritual growth opportunities while furthering the Kingdom.

Experience and Skills:

Bachelors Degree preferably in Math, Statistics, Business, Computer Science, or Data Science.

Preferred Master's in related area.

7 - 10 years Data engineering/analysis experience.

From: Cru

#J-18808-Ljbffr</p>

Cru Interview Questions

Cru Interview Guides

Cru Interview Questions

Cru Salaries by Position

Cru Opening Jobs