Prepare for and practice interview questions from American Systems.

American Systems Interview Questions

American Systems Interview Guides

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

American Systems Salaries by Position

Join Our Team of Innovators at AMERICAN SYSTEMS! For nearly half a century, AMERICAN SYSTEMS has been a trusted partner to the Navy, tackling some of their most challenging projects with dedication and expertise. Our success is powered by our innovative employee-owners, who thrive on the autonomy to deliver the right solutions when and where they're needed. Are you ready to make your next career move to a company that values forward-thinking and creativity? At AMERICAN SYSTEMS, you'll not only contribute to meaningful projects but also enjoy the benefits of employee ownership.As a Data Scientist, you will:* Work with a team of driven, supportive and highly skilled professionals.* Receive a robust benefits package that includes Employee Stock Ownership Plan!* Enjoy flexibility managing your work hours and personal needs with a single accrual leave plan.* Work with leading-edge technologies.A week in the life of a Data Scientist:* Develop and implement a set of techniques or analytics applications to transform raw data into meaningful information using data-oriented programming languages and visualization software* Conduct data mining, data modeling, natural language processing, and machine learning to extract and analyze information from large structured and unstructured datasets* Perform software integration or testing, including analyzing and implementing test plans and scripts* Visualize, interpret, and report data findings; Create dynamic data reports.Job Requirements* Active Secret Clearance* IAT Level II (CCNA-Security, CySA+, GICSP, GSEC, Security+ CE, CND, SSCP)* 10 years of experience in:* Scripting language use, such as Python and using packages commonly used in data science applications or advanced analytics* With data science, data mining, statistics, or graph algorithms to support analytics objectives* Applying Structured Query Language (SQL), Non Structured Query Language (NoSQL), Application Program Interface (API) Building, Extract, Transform, and Load (ETL) pipelines, Web Application Servers, or Search Index;* Applying complex mathematical and statistical concepts* Applying statistical and operations research methods and tools* Employing spreadsheets for data manipulation and visualization* Agile/DevSecOps* Cloud Experience: Amazon Web Services (AWS), Azure, Google Platform (GCP) and Microsoft 365Founded in 1975, AMERICAN SYSTEMS is one of the largest employee-owned companies in the United States. We are a government services contractor focused on delivering Strategic Solutions to complex national priority programs with 100+ locations worldwide. Through our focus on quality, strong cultural beliefs and innovation we deliver excellence every day.Company Awards:* Forbes National Best Midsize Companies* Energage National Best Workplaces, National* Washington Post Best WorkplacesVeteran Hiring Awards:* U.S. Department of Labor Hire Vets Medallion* BEST FOR VETS by Military Times* TOP 10 MILITARY FRIENDLY COMPANY by MilitaryFriendly.comEOE Minorities/Women/Disabled/Veterans/Gender Identity/Sexual Orientation

We are looking for an experienced Acoustic Data Analyst with demonstrated experience supporting DoD requirements to join our team at Naval Surface Warfare Center Carderock Division (NSWCCD), West Bethesda, MD!As an Acoustic Data Analyst, you will:* Apply your knowledge as an Acoustic Data Analyst to support NSWCCD laboratory operations and acoustic calibration and certification efforts.* Work with a team of driven, supportive, and highly skilled professionals.* Receive a robust benefits package that includes an Employee Stock Ownership Plan! (ESOP).* Enjoy flexibility managing your work hours and personal needs with a single accrual leave plan.A week in the life of an Acoustic Data Analyst:* Process and report the analysis results of acoustic data collected by recording systems during SONAR groom and calibration events.* Generate Sonar Calibration (SOCAL) reports.* Provide support for the TUBA Acoustic Reporting and Processing System (TARPS) laboratory efforts, including developing, integrating, testing, and sustaining upgrades to the acoustic processing systems.* Support NSWCCD engineers in the development of new acoustic data processing equipment and associated Research and Development (R&D) efforts.* Support development of technical documentation and procedures, provide In-Service Engineering Agent (ISEA) support, support fleet training efforts, support Sonar Calibration (SOCAL) trial efforts, and provide engineering support to TUBA system development and upgrade efforts.* Assist NSWCCD in analyzing measurement data in support of generic and platform certification efforts, as well as to investigate problems and verify proper system behavior.Job Requirements* Bachelor's degree in engineering or physics OR three years of U.S. Navy fleet operational experience with at-sea measurement trials.* 3 - 7 years of technical experience with acoustic data acquisition systems which process, analyze, and report on beam noise, FFT, time series, PC-IMAT/STK, K-OMEGA, or transmission loss recorded acoustic data.* Have an active Secret security clearance.* Two years of experience conducting R&D efforts to support the design and evaluation of time series data recorded from sonar systems/sensors for post processing and analysis.* Proficiency in MS Office tools, LINUX RED HAT, MS SQL, MATLAB, JIRA, ACROBAT, ADOBE AUDITION, or AUDACITY.* Two years of experience with system analysis of large Navy sonar radiated noise, self-noise, and structure-borne noise systems, including acoustical signal acquisition, transmission, telemetry and processing subsystem, and numerical and acoustic model development, implementation, and data analysis.* Strong analytical and problem-solving skills* Excellent interpersonal and listening skills; Team player.* Ability to meet deadlines on assigned tasks and responsibilities.* Multi-task oriented and capable of prioritizing.Founded in 1975, AMERICAN SYSTEMS is one of the largest employee-owned companies in the United States. We are a government services contractor focused on delivering Strategic Solutions to complex national priority programs with 100+ locations worldwide. Through our focus on quality, strong cultural beliefs, and innovation we deliver excellence every day.Company Awards:* Forbes National Best Midsize Companies* Energage National Best Workplaces, National* Washington Post Best WorkplacesVeteran Hiring Awards:* U.S. Department of Labor Hire Vets Medallion* BEST FOR VETS by Military Times* TOP 10 MILITARY FRIENDLY COMPANY by MilitaryFriendly.comAMERICAN SYSTEMS is committed to pay transparency for our applicants and employee-owners. The salary range for this position is $65,000 - 82,000. Actual compensation will be determined based on several factors permitted by law. AMERICAN SYSTEMS provides for the welfare of its employees and their dependents through a comprehensive benefits program by offering healthcare benefits, paid leave, retirement plans (including ESOP and 401k), insurance programs, and education and training assistance.EOE Minorities/Women/Disabled/Veterans/Gender Identity/Sexual Orientation

Data Scientist III - Secret Clearance - (24459) Share this job as a link in your status update to LinkedIn. Job Title / Level Data Scientist III - Secret Clearance Clearance Required? Secret Location: CHARLESTON, SC 29407 US (Primary) % Travel 0 - 10% Job Description Join Our Team of Innovators at AMERICAN SYSTEMS!For nearly half a century, AMERICAN SYSTEMS has been a trusted partner to the Navy, tackling some of their most challenging projects with dedication and expertise. Our success is powered by our innovative employee-owners, who thrive on the autonomy to deliver the right solutions when and where they're needed. Are you ready to make your next career move to a company that values forward-thinking and creativity? At AMERICAN SYSTEMS, youll not only contribute to meaningful projects but also enjoy the benefits of employee ownership. As a Data Scientist, you will: + Work with a team of driven, supportive and highly skilled professionals. + Receive a robust benefits package that includesEmployee Stock Ownership Plan (https://vimeo.com/729673832/55ff22ab92) ! + Enjoy flexibility managing your work hours and personal needs with a single accrual leave plan. + Work with leading-edge technologies. A week in the life of a Data Scientist: + Develop and implement a set of techniques or analytics applications to transform raw data into meaningful information using data-oriented programming languages and visualization software + Conduct data mining, data modeling, natural language processing, and machine learning to extract and analyze information from large structured and unstructured datasets + Perform software integration or testing, including analyzing and implementing test plans and scripts + Visualize, interpret, and report data findings; Create dynamic data reports. Job Requirements + Active Secret Clearance + IAT Level II (CCNA-Security, CySA+, GICSP, GSEC, Security+ CE, CND, SSCP) + 10 years of experience in: + Scripting language use, such as Python and using packages commonly used in data science applications or advanced analytics + With data science, data mining, statistics, or graph algorithms to support analytics objectives + Applying Structured Query Language (SQL), Non Structured Query Language (NoSQL), Application Program Interface (API) Building, Extract, Transform, and Load (ETL) pipelines, Web Application Servers, or Search Index; + Applying complex mathematical and statistical concepts + Applying statistical and operations research methods and tools + Employing spreadsheets for data manipulation and visualization + Agile/DevSecOps + Cloud Experience: Amazon Web Services (AWS), Azure, Google Platform (GCP) and Microsoft 365 Founded in 1975, AMERICAN SYSTEMS is one of the largest employee-owned companies in the United States. We are a government services contractor focused on delivering Strategic Solutions to complex national priority programs with 100+ locations worldwide. Through our focus on quality, strong cultural beliefs and innovation we deliver excellence every day. Company Awards: + Forbes National Best Midsize Companies + Energage National Best Workplaces, National + Washington Post Best Workplaces Veteran Hiring Awards: + U.S. Department of Labor Hire Vets Medallion + BEST FOR VETS by Military Times + TOP 10 MILITARY FRIENDLY COMPANY by MilitaryFriendly.com EOE Minorities/Women/Disabled/Veterans/Gender Identity/Sexual Orientation

American Systems Interview Questions

American Systems Interview Guides

American Systems Interview Questions

American Systems Salaries by Position

American Systems Opening Jobs