Prepare for and practice interview questions from Utah State University.

Utah State University Interview Questions

Utah State University Interview Guides

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

<p>How would you assess the validity of the result?</p>


Experiment Validity

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

<p>Write a query to randomly sample a row from this table.</p>

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

<p><code>big_table</code> table</p>

<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

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

<p>The company has been consistently growing new users in the city from January to March.</p>

<p>What are some reasons why the average number of comments per user would be decreasing and what metrics would you look into?</p>


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

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?

Utah State University Salaries by Position

<p>The national SARS-Co. V-2 Targeted Surveillance project in cervids seeks a research assistant to join our project. The position will be hosted at Utah State University, but the person hired will assist with analyses across our 25-site, 9-institution Data Analyst, Research, Analyst, Technology, Education, Data</p>

<p>Data Engineer Requisition ID: 2024-8379  of Openings: 1 Location: US-UT-Logan Category: Other Position Type: Benefited Full-Time Job Classification: Exempt College: Operational Strategy Department: Data & Analytics Advertised Salary: Minimum $85,000; Commensurate with experience, plus excellent benefits Overview Utah State University is seeking an experienced Data Engineer to innovate the strategic use of data and build institutional capacity for evidence-based, data-informed planning, and decision-making. This position will directly influence institutional and student success by providing actionable datasets to faculty, staff, administrators, and students by overseeing the analytics integration at USU. The Office of Data and Analytics is uniquely positioned at the USU to make a difference by providing the data and stories to influence decisions that will impact student experience and outcomes. The Institutional Data Engineer works to design, implement, maintain, and support the USU analytics ecosystem. This includes developing data models, building and maintaining data lakes, warehouses, and lakehouses and analytics environment, and writing scripts for data integration and analysis. This role will work closely and collaboratively with members of the data application development team to define requirements, mine and analyze data, integrate data from various sources, and deploy high-quality data pipelines to support the analytics needs of USU. They will also create and oversee the data models for an automated reporting system. Under the general supervision of the Chief Data and Analytics Officer, the Data Engineer defines and executes an enterprise analytics model strategy and architecture that supports innovative and efficient analytics for the entire university. The position directs future data modeling initiatives to ensure data governance, quality, and accessibility as well as institutional analytics and official reporting. The position will be expected to ask critical questions and optimize current data reporting, warehousing, and analytics processes. The position gathers requirements to develop, deploy and maintain analytics-optimized data warehouse and data integrations. Additionally, the position is responsible for working with business users and subject matter experts to develop processes to monitor and fix data quality and integrity issues. This position is eligible for hybrid work within the state of Utah. Responsibilities Data Engineering: Direct the gathering of requirements from subject matter experts and stakeholders to architect, develop, deploy and maintain the data model within the enterprise data warehouse / lakehouse environments. Monitor, improve and optimize existing data integration jobs. Coordinate the integration of internal and external data sources to optimize reporting and analytics. Work with data stewards throughout the college to understand data and processes for capturing data. Train analysts and users throughout the college on the definitions and use of data. Develop and maintain official reporting processes. Assist in developing and maintaining the college's data dictionary. Work with the business analytics team to optimize analytics, data governance and ensure data quality. Document process, integration jobs and official reporting extracts. Automate recurring processes Team Mentoring and Support: Lead, mentor, and supervise data engineers and their projects. Train and mentor junior data engineers and analysts. Assist data engineering team in gathering project requirements, design, implementation, peer review, and deployment. Manage projects to ensure accurate data is available in a timely manner. Qualifications Minimum Qualifications: Bachelor's degree with at least five (5) years of analytics, data engineering, or information technology experience. Experience with data integration tools. Experience with SQL and Relational Databases. Preferred Qualifications: Master's degree. Experience in higher education Knowledge, Skills, and Abilities: Knowledge of data warehouse systems, relational databases, and data integration. Ability to maintain and optimize data integration processes. Supervision and management skills including directing, mentoring, and training. Experience with database design, and data extraction, loading and transformation. Experience with structured query language (SQL) and some knowledge of Python and PowerShell scripting. Knowledge of data warehouse architecture, design, and optimization. Knowledge of data integration tools and processes. Ability to mentor, and training junior data engineers and analysts. Ability to learn new software tools and processes quickly and efficiently. Experience with project management for data engineering and dev-ops. Experience in quality assurance and validation of data. Effective communication skills and comfort working with different teams within the organization. Ability to accept and give constructive feedback. Ability to communicate effectively and work with a broad range of diverse people, ability, culture, and ethnic background, to maintain good working relationships across the university. Required Documents Along with the online application, please attach: 1. Resume/CV to be uploaded at the beginning of your application in the Candidate Profile under "Resume/CV" 2. Cover Letter to be typed/pasted at the end of your application Document size may not exceed 10 MB. Advertised Salary Minimum $85,000; Commensurate with experience, plus excellent benefits ADA Employees work indoors and are protected from weather and/or contaminants, but not, necessarily, occasional temperature changes. The employee is regularly required to sit and often uses repetitive hand motions. University Highlights The Office of Data and Analytics delivers data-informed decision-support to enhance the USU experience. Lead by the new Chief Data and Analytics Officer, USU is investing in data and analytics as a leap-ahead initiative. This position is part of the new data and analytics strategy to drive innovation and create value for students and the communities we serve. Founded in 1888, Utah State University is Utah's premier land-grant, public service university, with a strong commitment to excellence, access, and inclusion, empowering people to lead successful lives of involvement, innovation, and impact. Utah State provides high-quality education to 27,500-plus students locations throughout the state, including at three residential campuses, eight statewide campuses, and 23 education centers. USU Online educates students from all 50 states and 55 countries. For over 25 years, USU Extension has served and engaged Utahns in all of Utah's counties. As an R1 research institution, Utah State is dedicated to advancing knowledge through research and scholarly activities, providing a high-quality undergraduate and graduate education at an affordable price. Utah State is committed to cultivating a community of inclusive excellence where all perspectives, values, cultures, and identities are acknowledged, welcomed, and valued. We seek to recruit, hire, and retain people from all walks of life who will champion excellence in education, research, discovery, outreach, and service. We believe that promoting a strong sense of community and belonging empowers and engages all members of USU to thrive and be successful. Forbes recognized our commitment to employees when they named Utah State the best employer in Utah in 2023. Learn more about USU. The university provides a Dual Career Assistance Program to support careers for partners who are also seeking employment. Additionally, USU is committed to providing access and reasonable accommodations for individuals with disabilities. To request a reasonable accommodation for a disability, contact the university's ADA Coordinator in the Office of Human Resources at (435) 797-0122 or hrusu.edu. About the Region U.S. News and World Report ranked Utah first for its strong economy, fiscal stability, education, and health care. Outstanding outdoor recreational opportunities abound throughout the state, including five national parks, 43 state parks and recreation areas, and 15 alpine ski resorts. The home of USU's main campus, Logan, is a city of 54,000-plus people in a picturesque mountain valley 80 miles north of Salt Lake City. The Logan metro area claimed the top spot in the Milken Institute's 2022 ranking for best-performing small cities in the nation. updated 04/2024 https://careers-usu.icims.com/jobs/8379/data-engineer/job?in_iframe1 Notice of Non-discrimination In its programs and activities, including in admissions and employment, Utah State University does not discriminate or tolerate discrimination, including harassment, based on race, color, religion, sex, national origin, age, genetic information, sexual orientation, gender identity or expression, disability, status as a protected veteran, or any other status protected by University policy, Title IX, or any other federal, state, or local law. The following individuals have been designated to handle inquiries regarding the application of Title IX and its implementing regulations and/or USUs non-discrimination policies: Executive Director of the Office of Equity Matthew Pinner, discriminationusu.edu, Distance Education Rm. 401, 435-797-1266 Title IX Coordinator Matthew Pinner, titleixusu.edu, Distance Education Rm. 404, 435-797-1266 Mailing address: 5100 Old Main Hill, Logan, Ut 84322 For further information regarding non-discrimination, please visit https://equity.usu.edu/, or contact: U.S. Department of Education, Office of Assistant Secretary for Civil Rights, 800-421-3481, OCRed.gov U.S. Department of Education, Denver Regional Office, 303-844-5695, OCR.Denvered.gov Copyright 2024 Jobelephant.com Inc. All rights reserved. Posted by the FREE value-added recruitment advertising agency jeid-8ef0a32a7537e3408429175885a1624f</p>

Utah State University Interview Questions

Utah State University Interview Guides

Utah State University Interview Questions

Utah State University Salaries by Position

Utah State University Opening Jobs