Prepare for and practice interview questions from Emergent software.

Emergent software Interview Questions

Emergent software 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

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?

Emergent software Salaries by Position

** This is a direct hire position for one of our clients. This is a hybrid role located in Austin, TX. Candidates must be able to work in the US without sponsorship.** We are seeking a highly skilled and motivated Data Analyst to join our client's team at our Austin, TX location. As the lead data expert on-site, you will play a pivotal role in driving data-driven decision-making across the organization. In this position, you will collaborate with executives, business stakeholders, and IT teams to deliver impactful insights through advanced data analysis and dashboard creation. If you are a self-starter with a strong technical background in tools like Looker, Sigma, Snowflake, PowerBI, SQL, and Python, and you excel at translating complex data into clear, actionable strategies, we want to hear from you. Experience in finance or private equity is a plus but not required. Responsibilities: <ul> <li>Lead data initiatives at the Austin, TX office, acting as the primary data point of contact. </li><li>Build and maintain dashboards using Looker, Sigma, and other data visualization tools to provide actionable insights. </li><li>Develop complex SQL queries and Python scripts for data extraction, analysis, and reporting. </li><li>Collaborate closely with executive leadership and cross-functional teams to communicate data insights and influence strategic decisions. </li><li>Work independently to manage and prioritize data projects, driving initiatives that align with company goals. </li><li>Leverage Snowflake to manage and integrate data from various sources for deeper analysis. </li><li>Support the finance and business teams by providing data-driven insights that inform operational and strategic decisions. </li><li>Ensure data accuracy, integrity, and consistency across all reports and dashboards. </li></ul>Requirements: <ul> <li>Technical Expertise: Proficiency with data tools such as Looker, Sigma, Snowflake, PowerBI, SQL, and Python. </li><li>Dashboard Creation: Must have experience in creating dashboards, visualizing data, and telling compelling stories using tools (specifically Cigna for dashboard creation). </li><li>Data Storytelling: Ability to extract insights from data and present findings in a clear and actionable way to stakeholders. </li><li>Cross-functional Communication: Strong communication skills to interact with C-Suite executives, business stakeholders, and IT teams. </li><li>Leadership and Independence: Must be able to work independently and take initiative, as the data team is spread out throughout multiple locations. </li><li>Location: Must be willing to work on-site in Austin, TX. </li><li>It is preferred to have experience in finance or private equity, with an understanding of how data analytics supports financial performance. </li></ul>Our Vetting Process At Emergent Staffing, we work hard to find the individual who is the right fit for our clients. Here are the steps of our vetting process for this position: <ul> <li>Application (5 minutes) </li><li>Online Assessment & Short Algorithm Challenge (40-60 minutes) </li><li>Initial Phone Interview (30-45 minutes) </li><li>3 Interviews with the Client </li><li>Job Offer! </li></ul> #EmergentStaffing In this role, you will build and maintain dashboards and create complex SQL queries.

** This is a direct hire position for one of our clients. This position is fully remote but needs to be on EST or CST time zone. Candidates must be able to work in the US without sponsorship.** We are looking for an experienced Software Developer to join our client's fast-growing technology company. The ideal candidate will have a strong background in creating web applications with Python and using AWS tools. You will be responsible for building and maintaining the backend and frontend of our applications and systems. Responsibilities: <ul><li>Design and develop API's using Redshift </li><li>Build and maintain scalable, high-performance systems</li><li>Collaborate with cross-functional teams to design and launch new features</li><li>Debug and optimize applications to ensure they are running smoothly</li><li>Write clean, maintainable, and efficient code</li><li>Stay up-to-date with new technologies and methodologies</li></ul>Requirements: <ul><li>Strong experience with web development, with Python</li><li>Experience on AWS cloud and using AWS tools is a PLUS</li><li>Bachelor's degree in Computer Science or related field required.</li><li>Excellent problem-solving and analytical skills</li><li>Comfortable working in a fast-paced, high-pressure environment</li><li>Excellent communication skills, both written and verbal</li><li>No ego, and comfortable working in a team-oriented environment</li></ul>Our Vetting Process At Emergent Software, we work hard to find the software engineers who are the right fit for our clients. Here are the steps of our vetting process for this position: <ul><li>Application (5 minutes)</li><li>Online Assessment & Short Algorithm Challenge (40-60 minutes)</li><li>Initial Phone Interview (30-45 minutes)</li><li>3 Interviews with the Client</li><li>Job Offer!</li></ul> #Emergentstaffing In this role, you will be responsible for designing, developing, and maintaining software applications to meet the specific needs of the business. See the job description for requirements.

** This is a direct hire position for one of our clients. This position is hybrid with the office location in Coralville, IA. Candidates must be able to work in the US without sponsorship.** We are looking for a motivated Junior or Mid-Level Software Engineer to join our dynamic development team. In this role, you will play a key part in designing, developing, and maintaining our software solutions using TypeScript, Next.js, Nest.js, and Docker. You'll collaborate with senior engineers, product owners, and cross-functional teams to drive innovation and enhance the efficiency of our internal software systems. Responsibilities: <ul><li>Assist in developing and maintaining software applications utilizing TypeScript, Next.js, and Nest.js frameworks. </li><li>Collaborate with senior engineers to gather requirements and implement effective software solutions. </li><li>Contribute to the design and maintenance of RESTful APIs to facilitate communication between software components. </li><li>Support and maintain legacy applications developed in ASP 3.0 and Visual Basic. </li><li>Work with database administrators to ensure data integrity and optimize performance. </li><li>Participate in code reviews, testing, and debugging to ensure high-quality software delivery. </li><li>Utilize containerization technologies like Docker and TeamCity to enhance deployment processes. </li><li>Stay abreast of industry trends and engage in continuous learning. </li><li>Troubleshoot and resolve software issues in a production environment to minimize downtime.</li></ul>Requirements: <ul><li>1-3 years of experience in software development, with hands-on knowledge in one or more of the following: <ul><li>TypeScript </li><li>Next.js / React </li><li>Nest.js </li></ul></li><li>Basic experience with Docker and Windows Server environments. </li><li>Familiarity with SQL. </li><li>Understanding of RESTful API development using the OpenAPI Specification. </li><li>Proficient with Git. </li><li>Some exposure to legacy systems (ASP 3.0, Visual Basic, UniData, UniBasic) is a plus. </li><li>Strong problem-solving skills and a willingness to learn from experienced team members. </li><li>Excellent communication and collaboration abilities. </li></ul>Our Vetting Process At Emergent Staffing, we work hard to find the software engineers who are the right fit for our clients. Here are the steps of our vetting process for this position: <ul><li>Application (5 minutes)</li><li>Online Assessment & Short Algorithm Challenge (40-60 minutes)</li><li>Initial Phone Interview (30-45 minutes)</li><li>3 Interviews with the Client</li><li>Job Offer!</li></ul> #EmergentStaffing In this role, you will design, develop and maintain software applications to meet the specific needs of the business.

Emergent software Interview Questions

Emergent software Interview Guides

Emergent software Interview Questions

Emergent software Salaries by Position

Emergent software Opening Jobs