Prepare for and practice interview questions from Texas Tech University.

Texas Tech University Interview Questions

Texas Tech University Interview Guides

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

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?

Texas Tech University Salaries by Position

Lubbock 
 

 
 
 
 
 
 <h5 class="answer ng-binding jobtitleInJobDetails" tabindex="0">Data Governance Business Analyst</h5>
 
 
 

 
 
 
 38467BR 
 

 
 
 
 Data Management Division 
 

 
 Position Description 
 
 
 The Business Analyst will assist the Data Management Division (DMD) and data governance functions in defining and developing standards, processes, and metrics to advance Texas Tech University's (TTU) Data Governance agenda under the guidance of the Executive Director. Other responsibilities include collecting, analyzing and developing data relative to area, making recommendations and assisting in implementation of projects. Work is performed under general supervision with latitude for independent judgment in accordance with established policies and procedures. 

 
 About the University 
 
 Established in 1923, Texas Tech University is a Carnegie R1 (very high research activity) Doctoral/Research-Extensive, Hispanic Serving, and state-assisted institution. Located on a beautiful 1,850-acre campus in Lubbock, a city in West Texas with a growing metropolitan-area population of over 300,000, the university enrolls over 40,000 students with 33,000 undergraduate and 7,000 graduate students. As the primary research institution in the western two-thirds of the state, Texas Tech University is home to 10 colleges, the Schools of Law and Veterinary Medicine, and the Graduate School. The flagship of the Texas Tech University System, Texas Tech is dedicated to student success by preparing learners to be ethical leaders for a diverse and globally competitive workforce. It is committed to enhancing the cultural and economic development of the state, nation, and world. About Lubbock:Referred to as the "Hub City" because it serves as the educational, cultural, economic, and health care hub of the South Plains region, Lubbock boasts a diverse population and a strong connection to community, history, and land. With a mild climate, highly rated public schools, and a low cost of living, Lubbock is a family-friendly community that is ranked as one of the best places to live in Texas. Lubbock is home to a celebrated and ever-evolving music scene, a vibrant arts community, and is within driving distance of Dallas, Austin, Santa Fe, and other major metropolitan cities. Lubbock's Convention & Visitors Bureau provides a comprehensive overview of the Lubbock community and its resources, programs, events, and histories. 
 

 
 About the Department and/or College 
 
 Through collaboration and coordination with campus partners, the Data Management Division will support all areas of Texas Tech University with the development, execution, and supervision of plans, policies, programs, and practices that deliver, control, protect, and enhance the value of data and information assets throughout their lifecycles. 
 

 
 Major/Essential Functions 
 
 <ul> <li>While limited management oversight may be expected for specific projects, this position is expected to exercise discretion and independent judgment of the following duties: </li><li>Performs mid-level business and systems analysis, including gathering, developing, and documenting user requirements and business cases, assessing business processes, and collaborating with stakeholders for detailed business requirements related to data governance. </li><li>Data asset inventory management including outputs, key data elements, and dependencies to create an enterprise data model that supports business impact analysis and controlled change management. </li><li>Assist the Data Governance Project Manager with Operational activities including coordination and communication with the Data Stewardship Council, Business Data Steward Teams, Data Owners, Data Stewards, and stakeholders including the creation of documentation and other resources to disseminate knowledge across organizational boundaries. </li><li>Collaborate with stakeholders to ensure alignment with Data Governance strategies, support project planning and execution, facilitate best practices, assist in improved data quality, assist in tracking project progress, communicate updates, and provide training and documentation for new data governance policies or systems. </li><li>Collaborate with stakeholders and the Data Governance Project Director to tailor the data literacy program to support the university's mission, and lead data stewardship working groups to foster a data-driven culture at TTU. </li><li>Assist the Data Governance Project Manager with management and oversight of the analytics catalog, metadata and references, and consumption metadata analysis to provide informational resources that can be incorporated into data literacy and used by the Data Governance program to inform decisions. </li><li>Adheres to all appropriate Institutional policies and other relevant internal departmental policies. </li></ul>
 

 
 Required Qualifications 
 
 Bachelor's degree is required plus one year related full-time paid experience OR a combination or related education and/or experience. 
 

 
 Preferred Qualifications 
 
 Required Knowledge, Skills and Abilities <ul><li>Experience with data management principles, data governance, or related role </li><li>Excellent communication and interpersonal skills to collaborate with cross-functional teams and convey complex information to a non-technical audience </li><li>Analytical mindset and attention to detail for evaluating and improving data quality and governance processes </li><li>Knowledge of relevant data privacy regulations (e.g., GDPR, HIPAA) and their impact on data governance practices </li><li>Technical writing experience with the ability to explain complex topics in a way most people can understand. </li><li>Ability to work under pressure and successfully manage multiple overlapping deadlines </li></ul>Preferred Knowledge, Skills and Abilities <ul><li>Strong understanding of data governance principles, data quality management, data privacy, and regulatory compliance </li><li>Familiarity with data management tools, metadata repositories, and data modeling concepts </li><li>Familiarly with enterprise information tools like SQL Server, Power BI, Oracle, etc. </li><li>Understanding of Master Data, Metadata, Reference Data, Data Warehousing, and BI principles and processes including technical architecture </li></ul>
 

 
 Safety Information 
 
 Adherence to robust safety practices and compliance with all applicable health and safety regulations are responsibilities of all TTU employees. 
 

 
 Occasional Duties 
 
 Occasional work outside of normal hours required to meet project deadlines and travel to attend conferences or training. 
 

 
 Does this position work in a research laboratory? 
 
 No 
 

 
 Required Attachments 
 
 Cover Letter, Professional/Personal References, Resume / CV 
 

 
 Optional Attachments 
 
 Recommendation/Referral 
 

 
 Job Type 
 
 Full Time 
 

 
 Pay Basis 
 
 Hourly 
 

 
 Minimum Hire Rate 
 
 20.76 
 

 
 Pay Statement 
 
 Compensation is commensurate upon the qualifications of the individual selected and budgetary guidelines of the hiring department, as well as the institutional pay plan. For additional information, please reference the institutional pay plan by visiting www.depts.ttu.edu/hr/payplan. 
 

 
 Travel Required 
 
 Up to 25% 
 

 
 Shift 
 
 Day 
 

 
 Schedule Details 
 
 8-5 
 

 
 Grant Funded? 
 
 No 
 

 
 Job Group 
 
 Enterprise IT 
 

 
 EEO Statement 
 
 All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, gender expression, national origin, age, disability, genetic information or status as a protected veteran.

Texas Tech University Interview Questions

Texas Tech University Interview Guides

Texas Tech University Interview Questions

Texas Tech University Salaries by Position

Texas Tech University Opening Jobs