Prepare for and practice interview questions from Prescient Edge.

Prescient Edge Interview Questions

Prescient Edge Interview Guides

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?

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

Prescient Edge Salaries by Position

Job Title Front End Software Engineer Location McLean, VA 22102 US (Primary) Category Research, Development, and Engineering Job Type Full-Time Career Level Staff Education Bachelor's Degree Travel None Security Clearance Required Secret Job Description Prescient Edge is seeking a Front End Software Engineer to support a Federal government client. As a Frontend Software Engineer, you will: <ul> <li>Work on one or more projects to develop web applications for both internal and external users </li><li>Collaborate with the Design team to create awesome UX and beautiful frontends </li><li>Quickly prototype and iterate to refine and improve projects </li><li>Write tests and learn how to generally ensure application stability and reliability </li><li>Optionally work with our Impact team to use our skills to help the world </li><li>Learn collaboratively with a mentor and hopefully teach us something! </li></ul>Benefits At Prescient Edge, we believe that acting with integrity and serving our employees is the key to everyone's success. To that end, we provide employees with a best in class benefits package that includes: <ul> <li>A competitive salary with performance bonus opportunities. </li><li>Comprehensive healthcare benefits, including medical, vision, dental, and orthodontia coverage. </li><li>A substantial retirement plan with no vesting schedule. </li><li>Career development opportunities, including on-the-job training, tuition reimbursement, and networking. </li><li>A positive work environment where employees are respected, supported, and engaged. </li></ul>Job Requirements <ul><li>Active Secret security clearance or the ability to obtain one </li> <li>Bachelor's degree in a related field from a college or university accredited by the U.S. Department of Education </li><li>Minimum of 3 years of relevant experience </li> <li>Experience with the following technologies: ReactJS, Javascript (ES2020, ESNext), TypeScript, Emotion (CSS in JS generally), Webpack, Docker, Kubernetes, Jest, Puppeteer, Unit Tests </li><li>Experience with core web technologies (HTML, CSS, Javascript) </li><li>General understanding of algorithms, data structures, and code patterns used in web development </li><li>Effective written and verbal communication and collaboration skills </li><li>Desire to learn and grow as a software engineer </li><li>Personal projects or contributions to open source software </li> </ul> Prescient Edge is a Veteran-Owned Small Business (VOSB) founded as a counterintelligence (CI) and Human Intelligence (HUMINT) company in 2008. We are a global operations and solutions integrator delivering full-spectrum intelligence analysis support, training, security, and RD&E support solutions to the Department of Defense and throughout the intelligence community. Prescient Edge is an Equal Opportunity Employer (EEO). All applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran status, or any other characteristic that is protected by law. We strive to foster equity and inclusion throughout our organization because we believe that diversity of thought is critical for creating a safe and engaging work environment while also enabling the organization's success.

Job Title Mid Data Engineer Location Tampa, FL 33621 US (Primary) Category Research, Development, and Engineering Job Type Full-Time Career Level Staff Education Bachelor's Degree Travel None Security Clearance Required TS/SCI with CI Polygraph Job Description Prescient Edge is seeking a Mid. Data Engineer to support a federal government client. Benefits: At Prescient Edge, we believe that acting with integrity and serving our employees is the key to everyone's success. To that end, we provide employees with a best-in-class benefits package that includes: <ul> <li>A competitive salary with performance bonus opportunities. </li> <li>Comprehensive healthcare benefits, including medical, vision, dental, and orthodontia coverage. </li> <li>A substantial retirement plan with no vesting schedule. Career development opportunities, including on-the-job training, tuition reimbursement, and networking. </li> <li>A positive work environment where employees are respected, supported, and engaged. </li> </ul>Description: <ul> <li>Support for the CCJ2 Lakehouse Data Management platform and associated cloud applications and services. </li> <li>Enhance the AI/ML Test & Integration compute space in the Top-Secret Cloud Computing Services (TC2S) environment. </li> <li>The environment supports the ability to dynamically establish virtual workspaces where research and development can be done on AI/ML initiatives identified by the Government. </li> <li>New tools must be integrated to be available for use. Furthermore, functionally identical capabilities must be implemented on the Secret Cloud Computing Services (SC2S) and Unclassified Cloud Computing Services (UC2S) environment. </li> <li>Continue use and refinement of processes for USCENTCOM to effectively leverage the DevSecOps development tools available in DIA's new Agile IL5 Delivery Environment (AIDE). </li> <li>Continue to develop software enhancements to the USCENTCOM J2 Lakehouse Data Management Platform fielded during prior contracts. </li> <li>Anticipated enhancements are the implementation of more granular access controls, the addition of an AI/ML processing module which is reusable to support different models, the addition of a standardized data visualization dashboard function, and full operational implementation of cross domain data transfer from NIPR to SIPR/JWICS. </li> <li>Support new initiatives to develop domain specific UIs that enable operational elements to store data in the Lakehouse platform while simultaneously efficiently tagging/labeling data elements in accordance with new DOD and Intelligence Community (IC) standards. </li> <li>Work with the CCJ2 Partner Engagement community to automatically tag and store historical data and develop cloud-based applications running on the Lakehouse platform to modernize ongoing operations. A key component of this task is the visualization of the data in a web-based dashboard. </li> <li>Provide data science support for the implementation, testing and development of AI/ML processing models to be used with USCENTCOM data. </li> <li>It is currently envisioned these models will be implemented in Jupyter Notebooks/Lab integrated into the Lakehouse platform. </li> <li>Statistical analysis will be used to predict/verify the accuracy of the processing models. </li> <li>Conduct evaluations of new modeling tools and techniques as they become available. </li> <li>Support the implementation, security accreditation and administration of systems being fielded by USCENTCOM J2 in the UC2S, SC2S or TC2S cloud environments. These systems will not necessarily interact directly with the Lakehouse platform. Current examples include the USCENCOM J2 primary website (https://www.centcom.ic.gov) and the Virtual Joint Operations Center (VJOC) software maintained on the JWICS network by CCJ2. Web and SQL server management are critical. </li> <li>Engineers will continually integrate additional AI/ML processes and management services into the CCJ2 Lakehouse platform to support streamlined operations, the development of enhanced data sets and the ability to share information on a global basis through the improved discoverability of data as the result of the implementation of the Lakehouse architecture </li> <li>Data Engineers performing in the .NET Developer role will design, develop, and maintain server/client software in support of AI/ML Branch requirements. </li> <li>Must produce code using languages and technologies of the Microsoft .NET framework. </li> <li>Design, develop, and maintain SQL database systems in support of AI/ML Branch requirements. </li> <li>Data Engineers performing in the Journeyman Database Administrator role will design, develop, and maintain SQL database systems in support of AI/ML Branch requirements. </li> </ul>Job Requirements Desired Experience: <ul> <li>Minimum 8 years of experience conducting analysis relevant to the specific labor category with at least a portion of the experience within the last 2 years. </li> <li>Must have proven experience working in an Agile development environment and understand the Agile development environment. </li> <li>Have a familiarity with architectural styles/application programming interfaces (APIs) such as REST and RPC. </li> <li>Experience with the GOLang development language is highly desirable. </li> <li>Must have proven experience working in an Agile development environment. </li> <li>Be familiar with cloud-based solutions. </li> <li>Direct experience with the Amazon Web Service (AWS) line of relational databases services (RDS, Aurora) is highly desirable. </li> <li>Have a familiarity with architectural styles/application programming interfaces (APIs) such as REST and RPC. </li> <li>Knowledge of software development and interface applications. </li> <li>Familiarity with architectural styles/application programming interfaces (APIs) such as REST and RPC. </li> </ul>Desired Education: <ul> <li>Desired bachelor's degree in an area related to the labor category from a college or university accredited by an agency recognized by the U.S. Department of Education. </li> </ul>Security Clearance: <ul> <li>Security clearance required TS/SCI with CI POLY or the ability to obtain CI POLY. </li> </ul>Location: <ul> <li>USCENTCOM HQ, MacDill AFB, Florida </li></ul> Prescient Edge is a Veteran-Owned Small Business (VOSB) founded as a counterintelligence (CI) and Human Intelligence (HUMINT) company in 2008. We are a global operations and solutions integrator delivering full-spectrum intelligence analysis support, training, security, and RD&E support solutions to the Department of Defense and throughout the intelligence community. Prescient Edge is an Equal Opportunity Employer (EEO). All applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran status, or any other characteristic that is protected by law. We strive to foster equity and inclusion throughout our organization because we believe that diversity of thought is critical for creating a safe and engaging work environment while also enabling the organization's success.

Prescient Edge Interview Questions

Prescient Edge Interview Guides

Prescient Edge Interview Questions

Prescient Edge Salaries by Position

Prescient Edge Opening Jobs