Prepare for and practice interview questions from Square Peg Technologies.

Square Peg Technologies Interview Questions

Square Peg Technologies Interview Guides

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

<p>What factors could have biased this result, and what would you look into?</p>


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

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?

Statistics

<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>The schema below is for a retail online shopping company consisting of two tables, <code>attribution</code> and <code>user_sessions</code>.</p>

<ul>
<li><p>The attribution table logs a session visit for each row.</p></li>

<li><p>If <code>conversion</code> is <code>true</code>, then the user converted to buying on that session.</p></li>

<li><p>The <code>channel</code> column represents which advertising platform the user was attributed to for that specific session.</p></li>

<li><p>Lastly the <code>user_sessions</code> table maps many to one session visits back to one user.</p></li>
</ul>

<p>First touch attribution is defined as the channel with which the converted user was associated when they first discovered the website.</p>

<p>Calculate the first touch attribution for each <code>user_id</code> that converted. </p>

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

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

<p><code>attribution</code> table</p>

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

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

<tr>
<td><code>channel</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>conversion</code></td>
<td>BOOLEAN</td>
</tr>
</tbody>
</table>
<p><code>user_sessions</code> table</p>

<table>
<thead>
<tr>
<th>column</th>
<th>type</th>
</tr>
</thead>

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

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

<tr>
<td><code>user_id</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>
<p><strong>Example output:</strong></p>

<table>
<thead>
<tr>
<th><code>user_id</code></th>
<th><code>channel</code></th>
</tr>
</thead>

<tbody>
<tr>
<td>123</td>
<td>facebook</td>
</tr>

<tr>
<td>145</td>
<td>google</td>
</tr>

<tr>
<td>153</td>
<td>facebook</td>
</tr>

<tr>
<td>172</td>
<td>organic</td>
</tr>

<tr>
<td>173</td>
<td>email</td>
</tr>
</tbody>
</table>


First Touch Attribution

<h3>Job Description</h3><div>Job Description<div><div><div></div></div><div><p><br /></p><p><strong>Clearance Level Required:</strong></p><p>Position Requires a Top Secret (TS/SCI) Clearance with a Polygraph. </p><p><strong>Location:</strong></p><p>Northern Virginia</p><p><strong>The Mission: </strong></p><p>Square Peg Technologies is looking for data scientists who enjoy leveraging large sets of data to tell stories. In this role, you will apply modern machine and deep learning approaches to import, clean, transform and model data that supports our nation's core intelligence decision-makers. You will be responsible for designing or presenting conclusions gained from analyzing data using statistical tools like Tableau, Python, R and others.</p><p><strong>Basic Qualifications</strong></p><ul><li>Work as the lead data strategist, identifying and integrating new datasets that can be leveraged through our product capabilities and work closely with the engineering team to strategize and execute the development of data products</li><li>Execute analytical experiments methodically to help solve various problems and make a true impact across various domains and industries</li><li>Research and devise innovative statistical models for data analysis</li><li>Communicate findings to all stakeholders</li><li>Enable smarter business processes—and implement analytics for meaningful insights</li><li>Identify relevant data sources and sets to mine for client business needs, and collect large structured and unstructured datasets and variables</li><li>Devise and utilize algorithms and models to mine big data stores, perform data and error analysis to improve models, and clean and validate data for uniformity and accuracy</li><li>Analyze data for trends and patterns, and Interpret data with a clear objective in mind</li><li>Implement analytical models into production by collaborating with software developers and machine learning engineers.</li></ul><p><strong>Preferred Qualifications</strong></p><ul><li>Bachelor’s degree in statistics, applied mathematics, or related discipline</li><li>2+ years experience in data science</li><li>Proficiency in data mining, mathematics, and statistical analysis</li><li>Advanced pattern recognition and predictive modeling experience</li><li>Experience with Excel, PowerPoint, Tableau, SQL, and programming languages (i.e., Java/Python, SAS)</li><li>Master’s degree in stats, applied math, or related discipline</li></ul><p><strong>Square Peg Technologies Company Information </strong></p><p>Square Peg Technologies is a boutique technology consulting firm that specializes in data solutions using the latest technologies in analytics, data science, data engineering, and data management. Our mission is to develop and integrate cutting-edge technology solutions that inspire our customers to push the fields of science and technology forward. Here at Square Peg, you will not get lost in a crowd. We value each person’s contribution, celebrate wins together, and invest in the personal and professional development of our employees. Along with a strong positive culture that allows employees to thrive and grow, we also offer top-notch benefits including a large amount of vacation, annual bonuses, 401k matching, paid training, and 100% health care coverage. </p><p>At Square Peg Tech, we aim to be at the forefront of technology and innovation. Our ideal candidate must be forward-leaning and eager to engage with customers, academia, and industry leaders on the future applications of AI/ML, as well as best practices in advanced analytics. With a firm footprint in the Intelligence Community, Square Peg Tech is looking to expand its capabilities into the Department of Defense, NASA, and other prominent government agencies.</p><p><br /></p></div></div></div>

<h3>Job Description</h3><div>Job Description<div><div><div><div></div></div></div><div><p><br /><strong>Full Job Description </strong></p><p>Position Requires a Top Secret (TS/SCI) Clearance with a Polygraph. </p><p><strong>The Mission: </strong></p><p>At Square Peg, we rely on powerfully insightful data to inform our systems and solutions—and we’re seeking an experienced pipeline-centric data engineer to put it to use. The Data Engineer will be responsible for designing, implementing, and maintaining data pipelines for our customers. The Data Engineer will develop automated pipelines for a variety of data types and datasets.</p><p><strong>Basic Qualifications: </strong></p><ul><li>Work with data to solve business problems, building and maintaining the infrastructure to answer questions and improve processes</li><li>Help streamline our data science workflows, adding value to our product offering and building out our customer lifecycle and retention models</li><li>Work closely with the data science and business intelligence teams to develop data models and pipelines for research, reporting, and machine learning</li><li>Be an advocate for best practices and continued learning</li><li>Work closely with our data science to help build complex algorithms that provide unique insights into our data</li><li>Use agile software development processes to iteratively make improvements to our back-end systems</li><li>Model front-end and back-end data sources to help draw a more comprehensive picture of user flows throughout our system and enable powerful data analysis</li><li>Build data pipelines that clean, transform and aggregate data from disparate sources</li><li>Develop models that can be used to make predictions and answer questions for the overall business</li></ul><p><strong>Preferred Qualifications</strong></p><ul><li>Bachelor’s degree in computer science, information technology, engineering or equivalent</li><li>3+ years of experience with Python, SQL, and data <span class="long-word">visualization/exploration</span> tools</li><li>Familiarity with the AWS ecosystem specifically RedShift and RDS</li><li>Communication skills, especially explaining technical concepts to non-technical business leaders</li><li>Experience building or maintaining ETL processes</li></ul><p><strong>Square Peg Technologies Company Information </strong></p><p>Square Peg Technologies is a boutique technology consulting firm that specializes in data solutions using the latest technologies in analytics, data science, data engineering, and data management. Our mission is to develop and integrate cutting-edge technology solutions that inspire our customers to push the fields of science and technology forward. Here at Square Peg, you will not get lost in a crowd. We value each person’s contribution, celebrate wins together, and invest in the personal and professional development of our employees. Along with a strong positive culture that allows employees to thrive and grow, we also offer top-notch benefits including a large amount of vacation, annual bonuses, 401k matching, paid training, and 100% health care coverage. </p><p>At Square Peg Tech, we aim to be at the forefront of technology and innovation. Our ideal candidate must be forward-leaning and eager to engage with customers, academia, and industry leaders on the future applications of AI/ML, as well as best practices in advanced analytics. With a firm footprint in the Intelligence Community, Square Peg Tech is looking to expand its capabilities into the Department of Defense, NASA, and other prominent government agencies.</p><p><br /></p><p><br /></p><p></p><p><br /></p></div></div></div>

<h3>Job Description</h3><div>Job Description<div><div><p><strong>Clearance Required:</strong></p><p>Position Requires a Top Secret (TS/SCI) Clearance with a Polygraph. </p><p><strong>Location:</strong></p><p>Northern Virginia</p><p><strong>The Mission:</strong></p><p></p><p>Square Peg is seeking a Data Engineer to be responsible for designing, implementing, and maintaining data pipelines for our customers. The Data Engineer will develop automated pipelines for a variety of data types and datasets. Using Databricks, which was named to both the Magic Quadrant for Cloud Database Management Systems and the Magic Quadrant for Data Science and Machine Learning Platforms, you'll using best in class technology to help our customer solve some of their most challenging data problems. </p><p>Don't know Databricks, no problem! Sign up for our extensive training program to be a part of shaping the future of AI/ML</p><p><strong>Basic Qualifications: </strong></p><ul><li>Proficient with one or more programming languages (Python, SQL, Java)</li><li>Prepare big data, implement data models and develop database to support the business solutions</li><li>Understanding of SQL database structures and mapping data structures between different SQL databases</li><li>Knowledge of API development techniques</li><li>Demonstrated experience in data engineering, data processing and modeling techniques using cloud-based data management, data science, and ML platforms such as Databricks, Splunk, Cloudera, and Snowflake. </li><li>Demonstrated experience with cloud based database services such as Databricks and AWS</li></ul><p><strong>Preferred Qualifications</strong></p><ul><li>Experience with using Apache Spark and Hadoop to conduct large-scale data processing</li><li>Extensive experience in Extract-Transform-Load (ETL) processes </li><li>Demonstrated extensive experience with cloud services (AWS strongly preferred) </li><li>Familiarity with open source data engineering tools and processes</li></ul><p><strong>Square Peg Technologies Company Information</strong></p><p>Square Peg Technologies is a boutique technology consulting firm that specializes in data solutions using the latest technologies in analytics, data science, data engineering and data management. Our mission is to develop and integrate cutting edge technology solutions that inspire our customers to push the fields of science and technology forward. Here at Square Peg, you will not get lost in a crowd. We value each person’s contribution, celebrate wins together and invest in the personal and professional development of our employees. Along with a strong positive culture that allows employees to thrive and grow, we also offer top notch benefits to include a large amount of vacation, annual bonuses, 401k matching, paid training, and 100% health care coverage. </p><p>At Square Peg Tech, we aim to be at the forefront of technology and innovation. Our ideal candidate must be forward leaning and eager to engage with customers, academia and industry leaders on the future applications of AI/ML, as well as best practices in advanced analytics. With a firm footprint in the Intelligence Community, Square Peg Tech is looking to expand its capabilities into the Department of Defense, NASA and other prominent government agencies.</p><p></p><p></p><p></p><p></p><p><br /></p></div></div></div>

<h3>Job Description</h3><div>Job Description<div><div><div></div></div><strong>Clearance Level:</strong><p>Position Requires a Top Secret (TS/SCI) Clearance with a Polygraph. </p><p><strong>Location:</strong></p><p>Northern Virginia</p><p><strong>The Mission:</strong></p><p>Square Peg is seeking a Data Scientist who can turn structure and unstructured data sets into useful information to solve challenges. You'll work closely with the customer and stakeholders to optimize business processes through data engineering and machine learning techniques and help integrate the developed models into a form useful to the organization. Using Databricks, which was named to both the Magic Quadrant for Cloud Database Management Systems and the Magic Quadrant for Data Science and Machine Learning Platforms, you'll using best in class technology to help our customer solve some of their most challenging data problems. </p><p>Don't know Databricks, no problem! Sign up for our extensive training program to be a part of shaping the future of AI/ML. </p><p><strong>Basic Qualifications:</strong></p><ul><li>2+ years of experience with one or more of following programming languages: Python, Java, or SQL</li><li>Experience with designing and executing machine learning models and applications </li><li>Experience with building statistical models and developing machine learning algorithms, including supervised, unsupervised, or reinforcement </li><li>Advanced math and statistics background with programming, domain knowledge, and communication skills to analyze data, create applied mathematical models, and present results in a form useful to the organization</li><li>Knowledge of Data Science Libraries (e.g. SparkML, Tensorflow, Sci-Kit Learn) </li><li>Knowledge of applying time-series / regression analysis, clustering-methods, effectiveness testing (A-/B-hypotheses testing) to solve diverse business problems </li><li>Experience cleaning data for data science applications </li></ul><p><strong>Preferred Qualifications:</strong></p><ul><li>Knowledge in big-data technologies (Hadoop, Apache Spark, Databricks) </li><li>Experience with business intelligence tools like Tableau</li><li>Experience with data lakes/warehouses</li><li>Experience with cloud services, including AWS, Azure, or Google Cloud </li><li>Experience with enterprise DataOps, DevSecOps, and MLOps processes to operationalize and monitor data science models</li><li>Possession of excellent verbal and written communication skills </li><li>A self-motivated and proactive individual with a can-do attitude and the ability to work on projects and solve problems independently </li></ul><p><strong>Square Peg Technologies Company Information</strong></p><p>Square Peg Technologies is a boutique technology consulting firm that specializes in data solutions using the latest technologies in analytics, data science, data engineering and data management. Our mission is to develop and integrate cutting edge technology solutions that inspire our customers to push the fields of science and technology forward. Here at Square Peg, you will not get lost in a crowd. We value each person’s contribution, celebrate wins together and invest in the personal and professional development of our employees. Along with a strong positive culture that allows employees to thrive and grow, we also offer top notch benefits to include a large amount of vacation, annual bonuses, 401k matching, paid training, and 100% health care coverage. </p><p>At Square Peg Tech, we aim to be at the forefront of technology and innovation. Our ideal candidate must be forward leaning and eager to engage with customers, academia and industry leaders on the future applications of AI/ML, as well as best practices in advanced analytics. With a firm footprint in the Intelligence Community, Square Peg Tech is looking to expand its capabilities into the Department of Defense, NASA and other prominent government agencies.</p><p></p><p><br /></p><p></p></div></div>

Question	Topic	Difficulty	Ask Chance
Boarding Times Bias	Statistics	Medium	Very High
Hundreds of Hypotheses	Statistics	Medium	Very High
First Touch Attribution	SQL	Hard	Very High

Square Peg Technologies Interview Questions

Square Peg Technologies Interview Guides

Square Peg Technologies Interview Questions

Square Peg Technologies Opening Jobs