Prepare for and practice interview questions from Georgia State University.

Georgia State University Interview Questions

Georgia State University 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

Georgia State University Salaries by Position

Posting Number: S12547P Working Title: Business Analyst Professional II Department: VPI-Registrar's Office About the University of Georgia: Since our founding in 1785, the University of Georgia has operated as Georgia’s oldest, most comprehensive, and most diversified institution of higher education (https://www.uga.edu/). The proof is in our more than 235 years of academic and professional achievements and our continual commitment to higher education. UGA is currently ranked among the top 20 public universities in U.S. News & World Report. The University’s main campus is located in Athens, approximately 65 miles northeast of Atlanta, with extended campuses in Atlanta, Griffin, Gwinnett, and Tifton. UGA employs approximately 3,000 faculty and more than 7,700 full-time staff. The University’s enrollment exceeds 40,000 students including over 30,000 undergraduates and over 10,000 graduate and professional students. Academic programs reside in 18 schools and colleges, as well as a medical partnership with Augusta University housed on the UGA Health Sciences Campus in Athens. Posting Type: External Retirement Plan: TRS or ORP Employment Type: Employee Benefits Eligibility: Benefits Eligible Full/Part time: Full Time Additional Schedule Information: Monday-Friday, 8:00 a.m.-5:00 p.m. Advertised Salary: $70,000-$80,000+, Commensurate with Experience Posting Date: 08/21/2024 Open until filled: Yes Proposed Starting Date: 10/01/2024 Location of Vacancy: Athens Area EEO Policy Statement: The University of Georgia is an Equal Opportunity/Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, ethnicity, age, genetic information, disability, gender identity, sexual orientation or protected veteran status. Persons needing accommodations or assistance with the accessibility of materials related to this search are encouraged to contact Central HR (hrweb@uga.edu). USG Core Values Statement: The University System of Georgia is comprised of our 26 institutions of higher education and learning, as well as the System Office. Our USG Statement of Core Values are Integrity, Excellence, Accountability, and Respect. These values serve as the foundation for all that we do as an organization, and each USG community member is responsible for demonstrating and upholding these standards. More details on the USG Statement of Core Values and Code of Conduct are available in USG Board Policy 8.2.18.1.2 and can be found online at https://www.usg.edu/policymanual/section8/C224/#p8.2.18_personnel_conduct. Additionally, USG supports Freedom of Expression as stated in Board Policy 6.5 Freedom of Expression and Academic Freedom found online at https://www.usg.edu/policymanual/section6/C2653. Classification Title: IT Systems Support Professional FLSA: Exempt FTE: 1.00 Minimum Qualifications: Requires at least a baccalaureate degree in the field. Please contact your Human Resources office for an evaluation of education/experience in lieu of the required minimum qualifications. Position Summary: The Business Analyst Professional II performs business analyst duties including gathering, documenting, and analyzing business processes and coordinating with functional, cross-functional, and technical teams to develop, test, and implement projects. The Business Analyst Professional II creates project plans, coordinates and leads project meetings, ensures project documentation is up to date, and manages tasks related to projects. Additionally, the Business Analyst Professional II prepares project specifications for developers, coordinates testing with functional stakeholders on campus, functionally approves migrations and upgrades in non-production and production instances, and assists with determining the training materials needed for upgrades and projects. The Business Analyst Professional II also supports the development of operational reports related to the projects as well as the development of APIs or data feeds to other applications approved to receive student information. Knowledge, Skills, Abilities and/or Competencies: <ul><li>Document, communicate, and implement innovative solutions to meet business needs and goals </li><li>Technical aptitude, initiative, creativity, and customer service skills </li><li>Work both independently and with a team on assignments </li><li>Knowledge of, and ability to, apply project management principles </li><li>Ability to deliver high-quality system solution </li><li>Effectively collaborate with users and colleagues and demonstrate effective conflict resolution strategies </li><li>Build connections with the functional and technical staff using effective communication </li><li>Develop business model components such as process modeling (ﬂowcharts), activity diagrams, and use cases </li><li>Understand the software development life cycle </li><li>Understanding of SQL </li><li>Problem-solving and analytical thinking to approach issues logically and systematically </li><li>Strong attention to detail without losing focus </li><li>Written and verbal interpersonal and communication skills </li><li>Quickly adapt to new circumstances, information, and challenges </li><li>Apply critical thinking and professional judgement consistently </li><li>Organizational and time management skills </li><li>Maintain conﬁdentiality of sensitive data </li></ul>Physical Demands: Sit at computer for long periods of time. Is driving a responsibility of this position?: No Is this a Position of Trust?: Yes Does this position have operation, access, or control of financial resources?: No Does this position require a P-Card? : No Is having a P-Card an essential function of this position? : No Does this position have direct interaction or care of children under the age of 18 or direct patient care?: No Does this position have Security Access (e.g., public safety, IT security, personnel records, patient records, or access to chemicals and medications): Yes Credit and P-Card policy: Be advised a credit check will be required for all positions with financial responsibilities. For additional information about the credit check criteria, visit the UGA Credit Background Check website. Background Investigation Policy: Offers of employment are contingent upon completion of a background investigation including, a criminal background check demonstrating your eligibility for employment with the University of Georgia; confirmation of the credentials and employment history reflected in your application materials (including reference checks) as they relate to the job-based requirements of the position applied for; and, if applicable, a satisfactory credit check. You may also be subject to a pre-employment drug test for positions with high-risk responsibilities, if applicable. Please visit the UGA Background Check website. Duties/Responsibilities: Planning/Implementing/Researching Solutions and Projects <ul> <li>Develop and propose solutions based on business processes and identify issues or operational gaps </li><li>Navigate multiple projects and timelines </li><li>Conduct business analysis for projects and solutions </li><li>Provide analysis to identify downstream effects and impacts of decisions related to projects and solutions </li><li>Document and analyze user business processes and solution/project requirements </li><li>Prepare detailed functional speciﬁcations with technical references </li><li>Serve as the liaison between functional users and technical groups </li><li>Collaborate with functional users to align operations and pursue both functional and technical process improvements </li><li>Gather proven solutions from outside groups to offer best practices </li><li>Review changes delivered to upgrades and make necessary recommendations </li><li>Assist with analyzing and resolving system operational issues </li><li>Schedule and monitor system jobs according to operational calendar </li><li>Configuration or scribing of requirements as necessary for vendor solutions </li></ul>Percentage of time: 40 Duties/Responsibilities: Project Management <ul> <li>Provide project plans and timelines for tasks, projects, and solutions </li><li>Plan the rollout of projects, solutions, reports, system upgrades, and enhancements </li><li>Develop and maintain standard project documentation such as project, plans, risk logs, issue logs, decision logs, and meeting agendas and summaries </li><li>Assess the resources needed for projects and plan for upcoming projects and deliverables, accounting for any overlapping projects and deliverable due dates </li><li>Ensure required documentation and deliverables adhere to oﬃce standards and templates </li><li>Perform post-implementation review and analysis to determine any subsequent actions </li></ul>Percentage of time: 30 Duties/Responsibilities: Use Cases, Testing, Validation, and Data Reporting <ul> <li>Identify all possible testing scenarios and design user acceptance test plans and test cases for upgrades, solutions, and projects </li><li>Manage iterative testing process through all environments </li><li>Perform integration, regression, and end-to-end testing for solutions and data feeds </li><li>Facilitate timely approval/sign-off of projects and solutions to central IT </li><li>Use SQL statements to validate data for testing, identify issues in processes, or to provide information for administration </li><li>Develop and deliver quality analysis and data reporting </li><li>Data validation and correction </li></ul>Percentage of time: 20 Duties/Responsibilities: Communication and Training <ul> <li>Develop and give project presentations to faculty, staff, students, and administration </li><li>Develop and maintain in-person and online training materials for faculty, staff, students, and administration related to reporting, projects, and solutions </li><li>Provide project reports for leadership as needed </li><li>Identify and escalate issues and potential project delays </li><li>Create communication plans and email drafts for project and solution deployment </li></ul>Percentage of time: 10 Contact Details: For questions concerning this position or recruitment progression, please refer to the Recruitment Contact listed below. Recruitment Contact Name: Sara Roberts Recruitment Contact Email: sroberts11@uga.edu

Posting Number: S01837P Working Title: Research Engineer I - NMI Department: VetMed-Small Animal Med & Surg About the University of Georgia: Since our founding in 1785, the University of Georgia has operated as Georgia’s oldest, most comprehensive, and most diversified institution of higher education (https://www.uga.edu/). The proof is in our more than 235 years of academic and professional achievements and our continual commitment to higher education. UGA is currently ranked among the top 20 public universities in U.S. News & World Report. The University’s main campus is located in Athens, approximately 65 miles northeast of Atlanta, with extended campuses in Atlanta, Griffin, Gwinnett, and Tifton. UGA employs approximately 3,000 faculty and more than 7,700 full-time staff. The University’s enrollment exceeds 40,000 students including over 30,000 undergraduates and over 10,000 graduate and professional students. Academic programs reside in 18 schools and colleges, as well as a medical partnership with Augusta University housed on the UGA Health Sciences Campus in Athens. About the College/Unit/Department: The University of Georgia College of Veterinary Medicine, founded in 1946, is dedicated to training future veterinarians, providing services to animal owners and veterinarians, and conducting investigations to improve the health of animals as well as people. The college benefits pets and their owners, food-producing animals, and wildlife by offering the highest quality hospital and diagnostic laboratory services. Equipped with the most technologically advanced facilities located on a university campus, the college is dedicated to safeguarding public health by studying emerging infectious diseases that affect both animal and human health. The College of Veterinary Medicine values all members of the university community, recognizing that differences in experience and culture can only lead to a more well-rounded, accepting academic environment as embodied in our Principles of Community (http://vet.uga.edu/principles-of-community/). Posting Type: External Retirement Plan: TRS or ORP Employment Type: Employee Benefits Eligibility: Benefits Eligible Full/Part time: Full Time Additional Schedule Information: 8 AM – 5 PM; Monday-Friday; occasional nights and weekends Advertised Salary: Commensurate with Experience Posting Date: 09/04/2018 Open until filled: Yes Proposed Starting Date: 09/17/2018 Location of Vacancy: Athens Area EEO Policy Statement: The University of Georgia is an Equal Opportunity/Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, ethnicity, age, genetic information, disability, gender identity, sexual orientation or protected veteran status. USG Core Values Statement: The University System of Georgia is comprised of our 26 institutions of higher education and learning, as well as the System Office. Our USG Statement of Core Values are Integrity, Excellence, Accountability, and Respect. These values serve as the foundation for all that we do as an organization, and each USG community member is responsible for demonstrating and upholding these standards. More details on the USG Statement of Core Values and Code of Conduct are available in USG Board Policy 8.2.18.1.2 and can be found online at https://www.usg.edu/policymanual/section8/C224/#p8.2.18_personnel_conduct. Additionally, USG supports Freedom of Expression as stated in Board Policy 6.5 Freedom of Expression and Academic Freedom found online at https://www.usg.edu/policymanual/section6/C2653. Classification Title: RESEARCH ENGINEER I FLSA: Exempt FTE: 100 Minimum Qualifications: Graduation from an accredited college or university with a bachelor’s degree in agricultural engineering or an equivalent combination of training and experience. Position Summary: We are seeking a Biosystems Engineer to join the Polymer and Coatings Research and Production team within the UGA New Materials Institute. We seek a creative and self-starting engineer and will collaborate with other members of the team to develop and implement commercial biomaterial and bioprocessing applications. Must possess a solid understanding of basic engineering principles and detailed comprehension of Biosystems Engineering techniques and concepts. Must have a working knowledge of bioprocessing and fermentation techniques as well as practical bioprocessing experience. This position will involve significant hands-on laboratory and pilot scale work including physical labor associated with maintenance of large-scale processing equipment. Knowledge, Skills, Abilities and/or Competencies: Knowledge of bioprocess engineering, including bioreactors, microbiology laboratory growth, and evaluation equipment and procedures; Knowledge of production design and extraction/separation of synthesized products; Computer expertise with CAD: Inventor, Multiphysics, and iSee simulation modeling. Physical Demands: “hands-on” manual jobs that may be physically exerting. Is driving a responsibility of this position?: No Does this position have operation, access, or control of financial resources?: No Does this position require a P-Card? : No Is having a P-Card an essential function of this position? : No Credit and P-Card policy: Be advised a credit check will be required for all positions with financial responsibilities. For additional information about the credit check criteria, visit the UGA Credit Background Check website. Background Investigation Policy: Offers of employment are contingent upon completion of a background investigation including, a criminal background check demonstrating your eligibility for employment with the University of Georgia; confirmation of the credentials and employment history reflected in your application materials (including reference checks) as they relate to the job-based requirements of the position applied for; and, if applicable, a satisfactory credit check. You may also be subject to a pre-employment drug test for positions with high-risk responsibilities, if applicable. Please visit the UGA Background Check website. Duties/Responsibilities: Create and implement process design strategies for bioprocessing and fermentation systems. Percentage of time: 40 Duties/Responsibilities: Maintain bioprocessing equipment. Percentage of time: 40 Duties/Responsibilities: Coordinate with teammates (including non-UGA contributors to the research projects) on best equipment and procedures to enable low cost, high productivity research and manufacturing capability using developed organism and techniques. Percentage of time: 20

Posting Number: S12513P Working Title: Business Analyst Professional Department: VPI-Registrar's Office About the University of Georgia: Since our founding in 1785, the University of Georgia has operated as Georgia’s oldest, most comprehensive, and most diversified institution of higher education (https://www.uga.edu/). The proof is in our more than 235 years of academic and professional achievements and our continual commitment to higher education. UGA is currently ranked among the top 20 public universities in U.S. News & World Report. The University’s main campus is located in Athens, approximately 65 miles northeast of Atlanta, with extended campuses in Atlanta, Griffin, Gwinnett, and Tifton. UGA employs approximately 3,000 faculty and more than 7,700 full-time staff. The University’s enrollment exceeds 40,000 students including over 30,000 undergraduates and over 10,000 graduate and professional students. Academic programs reside in 18 schools and colleges, as well as a medical partnership with Augusta University housed on the UGA Health Sciences Campus in Athens. Posting Type: External Retirement Plan: TRS or ORP Employment Type: Employee Benefits Eligibility: Benefits Eligible Full/Part time: Full Time Additional Schedule Information: Monday-Friday, 8:00 a.m.-5:00 p.m. Advertised Salary: $60,000-$65,000, Commensurate with Experience Posting Date: 08/13/2024 Open until filled: Yes Proposed Starting Date: 09/16/2024 Location of Vacancy: Athens Area EEO Policy Statement: The University of Georgia is an Equal Opportunity/Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, ethnicity, age, genetic information, disability, gender identity, sexual orientation or protected veteran status. Persons needing accommodations or assistance with the accessibility of materials related to this search are encouraged to contact Central HR (hrweb@uga.edu). USG Core Values Statement: The University System of Georgia is comprised of our 26 institutions of higher education and learning, as well as the System Office. Our USG Statement of Core Values are Integrity, Excellence, Accountability, and Respect. These values serve as the foundation for all that we do as an organization, and each USG community member is responsible for demonstrating and upholding these standards. More details on the USG Statement of Core Values and Code of Conduct are available in USG Board Policy 8.2.18.1.2 and can be found online at https://www.usg.edu/policymanual/section8/C224/#p8.2.18_personnel_conduct. Additionally, USG supports Freedom of Expression as stated in Board Policy 6.5 Freedom of Expression and Academic Freedom found online at https://www.usg.edu/policymanual/section6/C2653. Classification Title: IT Systems Support Professional FLSA: Exempt FTE: 1.00 Minimum Qualifications: Requires at least a baccalaureate degree in the field. Please contact your Human Resources office for an evaluation of education/experience in lieu of the required minimum qualifications. Position Summary: The Business Analyst Professional performs business analyst duties including gathering, documenting, and analyzing business processes and coordinating with functional, cross-functional, and technical teams to develop, test, and implement projects. The Business Analyst Professional creates project plans, coordinates and leads project meetings, ensures project documentation is up to date, and manages tasks related to projects. Additionally, the Business Analyst Professional prepares project speciﬁcations for developers, coordinates testing with functional stakeholders on campus, functionally approves migrations and upgrades in non-production and production instances, and assists with determining the training materials needed for upgrades and projects. The Business Analyst Professional also supports the development of operational reports related to the projects as well as the development of APIs or data feeds to other applications approved to receive student information. Knowledge, Skills, Abilities and/or Competencies: <ul><li>Document, communicate, and implement innovative solutions to meet business needs and goals. </li><li>Technical aptitude, initiative, creativity, and customer service skills. </li><li>Work both independently and with a team on assignments. </li><li>Knowledge of, and ability to, apply project management principles. </li><li>Ability to deliver high-quality system solutions. </li><li>Effectively collaborate with users and colleagues and demonstrate effective conflict resolution strategies. </li><li>Build connections with the functional and technical staff using effective communication. </li><li>Develop business model components such as process modeling (ﬂowcharts), activity diagrams, and use cases. </li><li>Understand the software development life cycle. </li><li>Understanding of SQL. </li><li>Problem-solving and analytical thinking to approach issues logically and systematically. </li><li>Strong attention to detail without losing focus. </li><li>Written and verbal interpersonal and communication skills. </li><li>Quickly adapt to new circumstances, information, and challenges. </li><li>Apply critical thinking and professional judgement consistently. </li><li>Organizational and time management skills. </li><li>Maintain conﬁdentiality of sensitive data. </li></ul>Physical Demands: <ul><li>Sit for long period of time at a computer. </li> <li>Travel across campus. </li></ul>Is driving a responsibility of this position?: No Is this a Position of Trust?: Yes Does this position have operation, access, or control of financial resources?: No Does this position require a P-Card? : No Is having a P-Card an essential function of this position? : No Does this position have direct interaction or care of children under the age of 18 or direct patient care?: No Does this position have Security Access (e.g., public safety, IT security, personnel records, patient records, or access to chemicals and medications): Yes Credit and P-Card policy: Be advised a credit check will be required for all positions with financial responsibilities. For additional information about the credit check criteria, visit the UGA Credit Background Check website. Background Investigation Policy: Offers of employment are contingent upon completion of a background investigation including, a criminal background check demonstrating your eligibility for employment with the University of Georgia; confirmation of the credentials and employment history reflected in your application materials (including reference checks) as they relate to the job-based requirements of the position applied for; and, if applicable, a satisfactory credit check. You may also be subject to a pre-employment drug test for positions with high-risk responsibilities, if applicable. Please visit the UGA Background Check website. Duties/Responsibilities: Planning/Implementing/Researching Solutions and Projects <ul> <li>Develop and propose solutions based on business processes and identify issues or operational gaps. </li><li>Navigate multiple projects and timelines. </li><li>Conduct business analysis for projects and solutions. </li><li>Provide analysis to identify downstream effects and impacts of decisions related to projects and solutions. </li><li>Document and analyze user business processes and solution/project requirements. </li><li>Prepare detailed functional speciﬁcations with technical references. </li><li>Serve as the liaison between functional users and technical groups. </li><li>Collaborate with functional users to align operations and pursue both functional and technical process improvements. </li><li>Gather proven solutions from outside groups to offer best practices. </li><li>Review changes delivered to upgrades and make necessary recommendations. </li><li>Assist with analyzing and resolving system operational issues. </li><li>Schedule and monitor system jobs according to operational calendar. </li><li>Configuration or scribing of requirements as necessary for vendor solutions. </li></ul>Percentage of time: 40 Duties/Responsibilities: Project Management <ul> <li>Provide project plans and timelines for tasks, projects, and solutions. </li><li>Plan the rollout of projects, solutions, reports, system upgrades, and enhancements. </li><li>Develop and maintain standard project documentation such as project plans, risk logs, issue logs, decision logs, and meeting agendas and summaries. </li><li>Assess the resources needed for projects and plan for upcoming projects and deliverables, accounting for any overlapping projects and deliverable due dates. </li><li>Ensure required documentation and deliverables adhere to oﬃce standards and templates. </li><li>Perform post-implementation review and analysis to determine any subsequent actions. </li></ul>Percentage of time: 30 Duties/Responsibilities: Use Cases, Testing, Validation, and Data Reporting <ul> <li>Identify all possible testing scenarios and design user acceptance test plans and test cases for upgrades, solutions, and projects. </li><li>Manage iterative testing process through all environments. </li><li>Perform integration, regression, and end-to-end testing for solutions, projects, reports, and data feeds. </li><li>Facilitate timely approval/sign-off of projects and solutions to central IT. </li><li>Use SQL statements to validate data for testing, identify issues in processes, or to provide information for administration. </li><li>Develop and deliver quality analysis and data reporting. </li><li>Data validation and correction. </li></ul>Percentage of time: 20 Duties/Responsibilities: Communication and Training <ul> <li>Develop and give project presentations to faculty, staff, students, and administration. </li><li>Develop and maintain in-person and online training materials for faculty, staff, students, and administration related to reporting, projects, and solutions. </li><li>Provide project reports for leadership as needed. </li><li>Identify and escalate issues and potential project delays. </li><li>Create communication plans and email drafts for project and solution deployment. </li></ul>Percentage of time: 10 Contact Details: For questions concerning this position or recruitment progression, please refer to the Recruitment Contact listed below. Recruitment Contact Name: Sara Roberts Recruitment Contact Email: sroberts11@uga.edu

Georgia State University Interview Questions

Georgia State University Interview Guides

Georgia State University Interview Questions

Georgia State University Salaries by Position

Georgia State University Opening Jobs