Prepare for and practice interview questions from Nleague.

Nleague Interview Questions

Nleague 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

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

Nleague Salaries by Position

Job ID: 58692 Business Analyst Jr Client: State of Connecticut Department of Education Duration: 12 Months Location: Nashville, Tennessee 37243-0000 <ul> <li>Provides first level contact and issue resolution for data submission errors for the State's Education Information System (EIS) and Tennessee Investment in Student Achievement (TISA).</li> <li>The position involves responding to questions and issues as reported by multiple application users, learning the established procedures for support, and recording issues on an incident tracking system in a timely manner. </li> <li>Response to these issues includes troubleshooting the incident cause and resolution or escalation. The employee will work with the manager and project team to discuss trends, documentation, and improvements necessary to improve support. </li> <li>The employee will work relatively independently with users. The employee must learn the Department's Educational Information System and the five integrated student information systems that the districts in Tennessee use for their data collection. </li> <li>Key competencies include excellent verbal and written communication skills, as well as, outstanding customer service skills. </li> <li>The position is primarily remote, but will require a quarterly meeting in the Nashville office.</li> </ul> Top three skills: <ul> <li>Excellent customer support and communication skills </li> <li>Technical troubleshooting and solutioning skills </li> <li>Ability to work in fast pace environment</li> </ul>

<h3>Job Description</h3><div>Job Description<div>Job ID: 58692Business Analyst JrClient: State of Connecticut Department of EducationDuration: 12+ MonthsLocation: Nashville, Tennessee 37243-0000<ul><li>Provides first level contact and issue resolution for data submission errors for the State's Education Information System (EIS) and Tennessee Investment in Student Achievement (TISA).</li><li>The position involves responding to questions and issues as reported by multiple application users, learning the established procedures for support, and recording issues on an incident tracking system in a timely manner. </li><li>Response to these issues includes troubleshooting the incident cause and resolution or escalation. The employee will work with the manager and project team to discuss trends, documentation, and improvements necessary to improve support. </li><li>The employee will work relatively independently with users. The employee must learn the Department's Educational Information System and the five integrated student information systems that the districts in Tennessee use for their data collection. </li><li>Key competencies include excellent verbal and written communication skills, as well as, outstanding customer service skills. </li><li>The position is primarily remote, but will require a quarterly meeting in the Nashville office.</li></ul>Top three skills: <ul><li>Excellent customer support and communication skills </li><li>Technical troubleshooting and solutioning skills </li><li>Ability to work in fast pace environment</li></ul></div></div>

Job ID: 58692 Business Analyst Jr Client: State of Connecticut Department of Education Duration: 12 Months Location: Nashville, Tennessee 37243-0000 <ul> <li>Provides first level contact and issue resolution for data submission errors for the State's Education Information System (EIS) and Tennessee Investment in Student Achievement (TISA).</li> <li>The position involves responding to questions and issues as reported by multiple application users, learning the established procedures for support, and recording issues on an incident tracking system in a timely manner. </li> <li>Response to these issues includes troubleshooting the incident cause and resolution or escalation. The employee will work with the manager and project team to discuss trends, documentation, and improvements necessary to improve support. </li> <li>The employee will work relatively independently with users. The employee must learn the Department's Educational Information System and the five integrated student information systems that the districts in Tennessee use for their data collection. </li> <li>Key competencies include excellent verbal and written communication skills, as well as, outstanding customer service skills. </li> <li>The position is primarily remote, but will require a quarterly meeting in the Nashville office.</li> </ul> Top three skills: <ul> <li>Excellent customer support and communication skills </li> <li>Technical troubleshooting and solutioning skills </li> <li>Ability to work in fast pace environment</li> </ul>

<h3>Job Description</h3><div>Job Description<div>Job ID: 8177876Business AnalystClient: Governor's Office of Information TechnologyLocation: Denver, CO RemoteDuration: 12+ MonthsConduct interviews with the CDPS IT organization to gather detailed information.<ul><li>Comply with law enforcement policies</li><li>Experience leading and conducting interviews with diverse IT stakeholders.</li><li>Proficiency in documenting and diagramming IT environments.</li><li>Awareness of CMDB and application portfolio management tools.</li><li>Ability to complete CJIS onboarding and fingerprinting.</li><li>Assist the OIT Portfolio Manager during the initial stages of project initiation, including discovery and initiation phases.</li><li>Collaborate with project stakeholders to develop requirements and support solution engineering in defining and planning project initiatives.</li><li>Limit the time spent on high-level estimates and impact assessments to no more than 15 hours during the Gate 0: project rationalization phase.</li><li>Leading project initiation phases.</li><li>Interfacing with stakeholders to understand business cases and solicit requirements.</li><li>Consulting with solution engineers to align requirements clearly.</li></ul>QUALIFICATIONS: <ul><li>A bachelor's degree in business IT / Computer Science or a related field is standard, Agile, Business analysis, Data analysis skills, Jira, Microsoft Excel, Proven experience in eliciting requirements and testing, Solid experience in writing SQL queries, Basic knowledge in generating process documentation. </li></ul>Duties and Responsibilities: <ul><li>Gather business requirements from users and translate into functional and technical specifications Document business processes and provide best practices recommendations Work as a liaison between the business and IT (QA, test, developers) Translate business needs into effective requirements statements Assess the business impact of requested and ongoing systems improvements Participate on project teams to ensure that implementation satisfies the business need and maximizes process and system integration Participates in enterprise-level project teams to identify and implement process and system improvements. </li><li>Works with stakeholders to identify improvements and assess their relative priority Determines the appropriate course of action for new requests: immediate resolution through existing functionality, </li><li>support request for quick implementation, or as part of a larger project Utilize experience in business processes for IT systems; business case development; requirements gathering; gap analysis; process mapping; solution design; and support Actively manages customer expectations and communicates status of pending projects Tracks backlog of requests and works with customer to incorporate these into subsequent projects based on priority Proven ability to take complex business requirements translating those requirements into functional requirements</li></ul>Requirements: <ul><li>Bachelors degree 7 years experience as business analyst focused on enterprise applications and IT systems Business process expertise desired in the areas of Accounting and Billing, Finance/Controlling, HR/Benefits/Payroll, Procurement, Contract Management, Quality Assurance, Legal/Regulatory Experience in business case development, requirements gathering and definition, gap analysis, process mapping, solution design Ability to handle multiple projects simultaneously in a dynamic, deadline-oriented environment Proven success as a business analyst, with demonstrated ability to facilitate discussion and build consensus Ability to produce quality requirements documents, process maps, use case diagrams. </li><li>Ability to use various tools such as Visio and power point to graphically represent work flow diagrams, process flow and other information gathered.</li></ul></div></div>

<h3>Job Description</h3><div>Job Description<div>Job Id: 743473Position: Business Analyst 4Department: VDOT Location: 87 Deacon Road Fredericksburg, VA 22405Duration: 10+ Months<ul><li>Support of the fiscal, budgetary, and accounting operations for AMD. Plans organizes, develops, maintains, and coordinates the development and implementation of fiscal operations, processes, policies, and procedures for the MN program.</li><li>Support the development of the annual agency's MN budget and review statewide expenditure and spending plan data. Will perform monthly program/project expense analysis and assist with the review and analysis of MN expenditures and budgets. </li><li>Will be responsible for supporting executive decision-making and presenting the financial aspects of projects to senior management. </li><li>Requires understanding of budgeting and accounting with the ability to analyze complex business problems and recommend solutions.</li><li>Participate in the development and maintenance of performance metrics, measurements, methods, and targets to promote financial accountability and assist in identifying performance improvement opportunities. </li><li>Provide good customer service to internal team members and external customers. Use comprehensive analytical skills (Excel, MS Word), be an effective communicator, and be self-motivated and show initiative while accomplishing the task at hand.</li><li>Provide guidance and support to internal stakeholders on contract-related matters to ensure compliance with contract requirements, monitor contractor performance and payment, resolve disputes and contractual issues, develop and manage relationships with external contractors, and organize and manage contractual documents.</li></ul></div></div>

<h3>Job Description</h3><div>Job Description<div>Job ID: 743028Business AnalystClient: State of Virginia Department of TransportationDuration: 12-to-18-month contract Hybrid: 3 days per week required on siteLocation: Richmond, VA In-person interviewJob Summary:<ul><li>5+ years of BA Experience in IT project. IT software/application project experience required</li><li>Work with internal staff to optimize processes and improve quality for the design, development and maintenance of VDOT Software Systems.</li><li>Learn and understand the operational systems. Consult with business teams and technical teams to develop requirements for improvements to systems. </li><li>Translate requirements into technical specifications to be used by technical teams to develop system modifications. </li><li>Prepare diagrams explaining the modifications so that both technical staff and executive management can visualize and understand what must be done. </li><li>Propose alternative solutions that balance cost and benefit. Assure business and technical compatibility and performance. </li><li>Drives consistent project delivery through the entire project lifecycle. Tracks and exports project metrics and ensures that the team are practicing Agile principles. </li><li>Must have technical experience in Test Plan/Storyboard/Requirements.</li><li>Must have experience in requirements elicitation, storyboard development, wireframe preparation, test planning, and test execution.</li></ul>Required Skills:<ul><li>Agile Business Analyst; Stong understanding of Scrum concepts and methodologies</li><li>Well versed with Scrum and Agile, Scaled Agile and Kanban methodologies</li><li>Technical experience in organizing and maintaining sprint and product backlogs</li><li>Technical experience translating client and product strategy requirement into application requirements and user stories.</li><li>Ability to analyze and document business and system processes.</li><li>Prior State of VA IT Business Analyst Experience Strongly preferred</li></ul></div></div>

<h3>Job Description</h3><div>Job Description<div>Business Analyst 4 Location: Richmond, VADuration: 12+ MonthsClient: VDOT AMD Job Id: (743503)Business Analyst - Finance Experience Required - Long Term Position - 2 years or LongerSupport of the fiscal, budgetary, and accounting operations for AMD. Plans, organizes, develops, maintains, and coordinates the development and implementation of fiscal operations, processes, policies and procedures for the MN program. Support development of the annual agency's MN budget and reviews statewide expenditure and spend plan data. Will perform monthly program/project expense analysis and assist with the review and analysis of MN expenditures and budgets. Will be responsible for supporting executive decision making and presenting the financial aspects of projects to senior management. Requires understanding budgeting and accounting with the ability to analyze complex business problems and recommend solutions. Participate in the development and maintenance of performance metrics, measurements, methods, and targets to promote financial accountability, and assist in identifying performance improvement opportunities. Provide good customer service to internal team members & external customers, comprehensive analytical skills (Excel, MS Word), being an effective communicator, as well as being self-motivated and showing initiative while accomplishing the task at hand. </div></div>

Nleague Interview Questions

Nleague Interview Guides

Nleague Interview Questions

Nleague Salaries by Position

Nleague Opening Jobs