Prepare for and practice interview questions from Michigan Technological University.

Michigan Technological University Interview Questions

Michigan Technological University 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?

Michigan Technological University Salaries by Position

Department: Information Technology Summary As a member of Information Technology, the Business Intelligence Analyst is responsible for data reporting. Primary responsibilities include writing reports, dashboards, creating data sets, executing test pl Business, Information Technology, Continuous Improvement, Intelligence, Analyst, Training

The Great Lakes Research Center (GLRC) at Michigan Technological University (Michigan Tech) seeks to create, expand, and accelerate research activities in environmental biotechnology. As a leading research Institute, the GLRC is a flagship Center of Excellence integrating faculty and professional researchers in multidisciplinary research collaborations to address critical challenges facing society. The Institute provides a full spectrum of research services, currently to more than 70 affiliated researchers from eighteen academic and non-academic units across campus, with annual research expenditures approaching 10M.The GLRC is seeking a research scientist to join our organization and the launch of a new thrust area in environmental biotechnology, including genomic biology, computational biology, systems and synthetic biology, bioenergy, and biosecurity. Ideal candidates will have a PhD in biology, environmental engineering, chemical engineering, or closely related discipline; have education or experience in translational research and/or commercialization; and must be able to obtain a U.S. Department of Defense security clearance, which requires United States citizenship.Essential Duties & Responsibilities (other duties may be assigned)* Seek and develop a sustainable research program that includes leading a portfolio of externally funded research* Contribute to the research success of others including faculty and other research staff through proposal development, submission, and successful project implementation* Participate in research dissemination through publication in peer-reviewed journals and through presentations at conferences and participation in technical workshops and working groups* Cultivate a network of external collaborators and partners to facilitate idea generation and innovation through research activities that promote the mission of the Institute and the University.* Participate in GLRC Institute activities and initiatives to support research growth* Commit to supporting a team environment* Commit to learning about continuous improvement strategies and applying them to everyday work. Actively engage in University continuous improvement initiatives* Apply safety-related knowledge, skills, and practices to everyday workRequired Education, Certifications, Licensures (minimum requirements)* PhD in Biology, Environmental Engineering, Chemical Engineering, or closely related discipline* Minimum of two-years' experience beyond degreeRequired Experience (minimum requirements)* Demonstrated expertise in microbiology, molecular biology, or genomics* Experience leading and working in multidisciplinary research teams* Experience obtaining and managing grants and contracts* Demonstrated experience in translating scientific information into research products and public communications for dissemination by non-technical audiencesDesirable Education and/or Experience* Experience with at least two of the following: microbial community analysis and engineering, metagenomics, bioprocess engineering, or protein biochemistry* NSF I-Corps or similar training* Experience de-risking of early-stage technologies* Experience with translational research like SBIR/STTR* Experience developing and implementing intellectual property strategy* Business development and other entrepreneurial experience* Experience working with Department of Defense clients* Investigator and/or senior personnel role on existing grants/contractsRequired Knowledge, Skills, and/or Abilities (minimum requirements)* Strong research, problem solving, and communication skills (both written and oral), coupled with strong attention to detail and scientific curiosity* Ability to supervise and mentor researchers such as graduate students, technicians, and other technical staff* Excellent analytical and organizational skills* Ability to take direction without continuous oversight, while demonstrating strong self-motivated accountability* Ability to exercise discretion, confidentiality, and independent judgment with respect to matters related to job duties* Demonstrated ability to participate in teams as both a leader and a contributor* Strong publication track record* Ability to manage multiple projects, concurrently* Excellent collaborative and interpersonal skills and a willingness to work in a fast-paced team environment* Ability to motivate others to achieve desirable outcomes* Demonstrated commitment to workplace safety* Ability to obtain a U.S. Department of Defense security clearance, which requires United States citizenship. Obtaining a national security clearance while holding a dual citizenship will not be possible when the foreign country poses a risk to the national security of the United States* Apply safety-related knowledge, skills, and practices to everyday workDesirable Knowledge, Skills, and/or Abilities* Understanding of the translation of environmental biological discoveries to biotechnology* Process knowledge of the various steps to move through invention disclosure to commercialization or patent* Acute business forward mind-set* Strong budget development skills* Demonstrated success in, or potential future contributions to, working with persons from diverse backgrounds, creating a sense of belonging, and fostering a fair, objective, welcoming place to work for persons with a wide variety of personal characteristics and viewpointsLanguage, Mathematics and/or Reasoning SkillsWork Environment and/or Physical Demands* The noise level in the work environment is usually low to moderate.Required Training and Other Conditions of EmploymentEvery employee at Michigan Technological University will receive the following 4 required trainings; additional training may be required by the department.Required University Training:* Employee Safety Overview* Anti-Harassment, Discrimination, Retaliation Training* Annual Data Security Training* Annual Title IX TrainingBackground Check:Offers of employment are contingent upon and not considered finalized until the required background check has been performed and the results received and assessed.Other Conditions of Employment:The successful applicant will be responsible for ensuring eligibility for employment in the United States on or before the effective date of the appointment. Visa sponsorship is unavailable at this time. This is not an E-Verified Position.Michigan Technological University is an Equal Opportunity Educational Institution/Equal Opportunity Employer that provides equal opportunity for all, including protected veterans and individuals with disabilitiesFull-Time Equivalent (FTE) % (1=100%)1.0FLSA StatusExemptAppointment Term12 monthsShiftPay Rate/SalaryNegotiable Based on ExperienceTitle of Position SupervisorAssociate Director, Great Lakes Research CenterPosting TypeInternal & ExternalDependent on FundingYesSpecial Instructions to Applicants (if applicable)Additional Information

Research Engineer / Scientist I - Environmental Remote Sensing Job No: 24308 Department: Michigan Tech Rsrch Institute(MTRI) Work Type: Staff - Full Time Location: Michigan Tech Research Institute (Ann Arbor, MI) Full Time / Part Time: Full Time Categories: Research Department: Michigan Tech Research Institute Summary The Research Scientist I - Remote Sensing position provides support for MTRI programs focused on the development and application of remote sensing and geospatial analysis to solve governmental and societal needs through sponsored research. Knowledge of remote sensing theory and an understanding of remote sensing applications for environmental and/or Earth science research is required. The applicant should be familiar the theory and application of Synthetic Aperture Radar (SAR) for environmental research. The applicant will be expected to help develop proposals for remote sensing research projects that apply their knowledge of sensing and image processing to research questions. The applicant will also be expected to conduct fieldwork in remote environments. Examples of current research areas the Remote Sensing Scientist may support include wildland and prescribed fire mapping and effects assessment, Great Lakes aquatic sensing, invasive species mapping, wetlands assessment, wildland fire danger and emissions mapping, processing and analysis of remote sensing data through custom coding and analysis, and improved geotemporal visualization of complex data and patterns. This in an in-person position based at MTRI in Ann Arbor, MI (https://mtu.edu/mtri). Responsibilities 1. Participate in research projects applying remote sensing, geospatial analysis, earth science knowledge, Synthetic Aperture Radar (SAR) sensing theory, and analysis skills to solve project tasks for ongoing and new MTRI research projects. 2. Participate as an integral team member on multi-disciplinary research relating to applying technological skills to solving governmental and societal needs for a diverse set of current research areas, including improved remote sensing data analysis and visualization of complex data for environmental and interdisciplinary projects. 3. Be able to troubleshoot issues encountered in data processing and analysis to ensure scientifically valid data collection. 4. Evaluate, select, and apply the results of data collected and research projects undertaken. Describe and share any concerns about the results or methodology and recommend or implement countermeasures. 5. Contribute technical expertise in sensing at a primary and co-author level to specific aspects of conference presentations, journal articles, and technical reports, and be able to take the lead on preparing technical reports. 6. Participate in fieldwork in remote environments, including navigation in remote areas and following data collection protocols. 7. Contribute to competitive proposals including development of specific tasks that use and exploit remote sensing data and products. 8. Assess effectiveness of safety measures and training and implement necessary changes. Anticipate and recognize problems and potential problems at the individual and system levels. Recognize and respond appropriately to potential and actual unsafe situations. 9. Apply safety-related knowledge, skills, and practices to everyday work. 10. Commit to learning about continuous improvement strategies and applying them to everyday work. Encourage continuous improvement practices among employees. Required Education, Certifications, Licensures <ul><li>Master's degree or higher in remote sensing, geospatial technology, geography, earth science, ecology, or closely related field</li></ul> Required Experience 1. Algorithm development and data processing with Synthetic Aperture Radar (SAR) for environmental applications. 2. Experience with analysis and processing of remote sensing data using desktop software tools (e.g. ERDAS Imagine, ENVI+IDL, OSGeo Opticks) or cloud-based platforms (e.g. Google Earth Engine). 3. Practical, demonstrated knowledge of Python or comparable programming language (ex. MATLAB, C/C++, Julia, Javascript). 4. Coursework in higher-level math, statistics, or remote sensing. 5. Coursework in at least one of the following remote sensing application areas: earth science, ecology, geography, environmental engineering. 6. Demonstrated organizational ability and attention to detail. 7. Demonstrated ability to participate in team projects. 8. Experience in preparing and contributing to competitive research proposals. Desirable Education and/or Experience 1. Experience with statistical analysis software (such as SAS or R). 2. Experience in a remote sensing and/or geospatial research environment. 3. Background in the mathematics and physics underlying Synthetic Aperture Radar (SAR). 4. Experience with development, management, and documentation of large geospatial and remote sensing datasets. 5. Familiarity with machine learning techniques. 6. Experience working with large datasets using advanced computational systems (e.g., cloud computing, multi-processor computing). 7. Experience with performing fieldwork (e.g. navigating via handheld GPS, following data collection protocols) Required Knowledge, Skills, and/or Abilities 1. Ability to obtain a U.S. Department of Defense security clearance, which requires United States citizenship. Obtaining a national security clearance while holding a dual citizenship will not be possible when the foreign country poses a risk to the national security of the United States. 2. Knowledge of remote sensing theory for science and/or application. 3. Ability to clearly communicate complex ideas through symposia presentations, methods documentation, reports, and publications. 4. Excellent written/oral communication skills. 5. Demonstrated organizational ability and attention to detail. 6. Ability to exercise discretion and independent judgment with respect to significant matters related to job duties. 7. Demonstrated ability to participate in team projects. 8. Demonstrated leadership of safety principles and practices. Desirable Knowledge, Skills, and/or Abilities 1. Experience in processing hyperspectral imagery such as mixture modeling methods and similar advanced spectral analysis methods. 2. Knowledge of geospatial data structures, visualization, and analysis and experience with GIS software (ESRI, QGIS, GDAL). 3.Demonstrated success in, or potential future contributions to, working with persons from diverse backgrounds, creating a sense of belonging, and fostering a fair, objective, welcoming place to work for persons with a wide variety of personal characteristics and viewpoints. Work Environment and/or Physical Demands The noise level in the work environment is usually low to moderate. Gender neutral bathrooms are available. Employees work in a typical office environment with few physical demands. Required Training and Other Conditions of Employment Every employee at Michigan Technological University will receive the following 4 required trainings; additional training may be required by the department. Required University Training: <ul><li>Employee Safety Overview</li><li>Anti-Harassment, Discrimination, Retaliation Training</li><li>Annual Data Security Training</li><li>Annual Title IX Training</li></ul> Background Check: Offers of employment are contingent upon and not considered finalized until the required background check has been performed and the results received and assessed. Other Conditions of Employment: Please note that successful applicants are responsible for ensuring their eligibility to work in the United States (i.e. a citizen or national of the United States, a lawful permanent resident, a foreign national authorized to work in the United States without the need of an employer sponsorship) on or before the effective date of your appointment, and maintain eligibility without sponsorship throughout your appointment. Michigan Technological University is an Equal Opportunity Educational Institution/Equal Opportunity Employer that provides equal opportunity for all, including protected veterans and individuals with disabilities Full-Time Equivalent (FTE) % (1=100%) 1 FLSA Status Exempt Appointment Term Shift Pay Rate/Salary Negotiable, Based on Experience Title of Position Supervisor Research Engigneer/Scientist I Posting Type Internal and External Dependent on Funding Yes Special Instructions to Applicants (if applicable) Additional Information To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. Michigan Technological University is an Equal Opportunity Educational Institution/Equal Opportunity Employer that provides equal opportunity for all, including protected veterans and individuals with disabilities. If you require any auxiliary aids, services, or accommodations during Michigan Tech's hiring process please notify the Human Resources office at 906-487-2280 or hr-help@mtu.edu. Required Education, Certifications, Licensures* (minimum requirements) Advertised: 25 Oct 2024 Eastern Daylight Time Applications close:

Assistant Research Scientist - Environmental Remote Sensing Hyperspectral Specialist Job No: 24295 Department: Michigan Tech Rsrch Institute(MTRI) Work Type: Staff - Full Time Location: Michigan Tech Research Institute (Ann Arbor, MI) Full Time / Part Time: Full Time Categories: Research Department: Michigan Tech Research Institute Summary This Assistant Research Scientist - Environmental Remote Sensing Hyperspectral Specialist position provides support for MTRI programs focused on locating invasive species in the Great Lakes region via remote sensing. Experience with GIS analysis and remote sensing data processing, particularly with multispectral and hyperspectral data sets, for water science research is required, as is knowledge of how remote sensing data relates to inherent optical properties. Applicants must be familiar with environmental characteristics that contribute to invasive species vulnerability. The applicant will be expected to conduct vegetation surveys along the coasts of the Great Lakes, as well as collect and process UAV imagery. The applicant will be expected to apply their knowledge of sensing and image processing to assist in the development of research questions and/or research programs. This in an in-person position based at MTRI in Ann Arbor, MI (https://mtu.edu/mtri). Responsibilities 1. Analyze multi- and hyperspectral data for water science applications and relate to inherent optical properties. 2. Perform land cover classification with high resolution UAV imagery to identify invasive species. 3. Conduct vegetation surveys in coastal areas of the Great Lakes region, with awareness of how field protocols relate to remote sensing capabilities. 4. Participate as an integral team member on multi-disciplinary research relating to applying technological skills to solving governmental and societal needs for a diverse set of current research areas, including improved remote sensing data analysis and visualization of complex data for environmental and interdisciplinary projects. 5. Be able to deal with issues encountered in data processing and analysis to ensure scientifically valid data collection. Evaluate, select, and apply the results of data collected and research projects undertaken. Describe and share any concerns about the results or methodology and recommend or implement countermeasures. 6. Participate in fieldwork in challenging environments, including navigation in remote areas and following data collection protocols. 7. Contribute to competitive proposals including development of specific tasks that use and exploit remote sensing data and products. 8. Assess effectiveness of safety measures and training and implement necessary changes. Anticipate and recognize problems and potential problems at the individual and system levels. Recognize and respond appropriately to potential and actual unsafe situations. Required Education, Certifications, Licensures Bachelor's degree in environmental science, or closely related field. Required Experience 1. Participation in research projects applying remote sensing, geospatial analysis, earth science knowledge, and analysis skills. 2. Processing multi- and hyperspectral data for water science applications. 3. Performing land cover classifying with high resolution UAV imagery. 4. Analysis and processing of remote sensing data using desktop software tools (e.g., ArcGIS Pro) or cloud-based platforms (e.g., eCognition). 5. Conducting vegetation surveys in coastal areas in the Great Lakes region. 6. Mapping areas that may be vulnerable to invasive species encroachment with remote sensing data products. 7. Field collection of inherent optical properties of water in the Great Lakes region. Desirable Education and/or Experience 1. Experience with using ArcPy to automate GIS processing tasks. 2. Experience with active sensor (multi-spectral or hyperspectral) data processing and analysis. 3. Experience with development, management, and documentation of large geospatial and remote sensing datasets. 4. Familiarity with machine learning techniques. 5. Experience working with large datasets with advanced computational systems (e.g., cloud computing, multi-processor supercomputing). 6. Experience with performing fieldwork (e.g. navigating via handheld GPS, following data collection protocols). Required Knowledge, Skills, and/or Abilities 1. Ability to obtain a U.S. Department of Defense security clearance, which requires United States citizenship. Obtaining a national security clearance while holding a dual citizenship will not be possible when the foreign country poses a risk to the national security of the United States. 2. Practical, demonstrated knowledge of using Python or a comparable programming language (ex. R, Matlab, C++, Julia, JavaScript) to process remote sensing data. 3. Ability to clearly communicate complex ideas through symposia presentations, methods documentation, reports, and publications. 4. Excellent written/oral communication skills. 5. Demonstrated organizational ability and attention to detail. 6. Ability to exercise discretion and independent judgment with respect to significant matters related to job duties. 7. Demonstrated ability to participate in team projects. 8. Demonstrated leadership of safety principles and practices. Desirable Knowledge, Skills, and/or Abilities 1. Experience in processing hyperspectral imagery such as mixture modeling methods and similar advanced spectral analysis methods. 2. Knowledge of geospatial data structures, visualization, and analysis and experience with GIS software (ESRI, QGIS, GDAL). 3. Demonstrated success in, or potential future contributions to, working with persons from diverse backgrounds, creating a sense of belonging, and fostering a fair, objective, welcoming place to work for persons with a wide variety of personal characteristics and viewpoints. Language, Mathematics and/or Reasoning Skills Work Environment and/or Physical Demands Required Training and Other Conditions of Employment Every employee at Michigan Technological University will receive the following 4 required trainings; additional training may be required by the department. Required University Training: <ul><li>Employee Safety Overview</li><li>Anti-Harassment, Discrimination, Retaliation Training</li><li>Annual Data Security Training</li><li>Annual Title IX Training</li></ul> Background Check: Offers of employment are contingent upon and not considered finalized until the required background check has been performed and the results received and assessed. Other Conditions of Employment: Please note that successful applicants are responsible for ensuring their eligibility to work in the United States (i.e. a citizen or national of the United States, a lawful permanent resident, a foreign national authorized to work in the United States without the need of an employer sponsorship) on or before the effective date of your appointment, and maintain eligibility without sponsorship throughout your appointment. Michigan Technological University is an Equal Opportunity Educational Institution/Equal Opportunity Employer that provides equal opportunity for all, including protected veterans and individuals with disabilities Full-Time Equivalent (FTE) % (1=100%) 1 FLSA Status Exempt Appointment Term Shift Pay Rate/Salary Negotiable, Based on Experience Title of Position Supervisor Research Engineer/Scientist I Posting Type Internal and External Dependent on Funding Yes Special Instructions to Applicants (if applicable) Additional Information To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. Michigan Technological University is an Equal Opportunity Educational Institution/Equal Opportunity Employer that provides equal opportunity for all, including protected veterans and individuals with disabilities. If you require any auxiliary aids, services, or accommodations during Michigan Tech's hiring process please notify the Human Resources office at 906-487-2280 or hr-help@mtu.edu. Required Education, Certifications, Licensures* (minimum requirements) Advertised: 04 Oct 2024 Eastern Daylight Time Applications close:

Michigan Technological University Interview Questions

Michigan Technological University Interview Guides

Michigan Technological University Interview Questions

Michigan Technological University Salaries by Position

Michigan Technological University Opening Jobs