Prepare for and practice interview questions from Sunnova.

Sunnova Interview Questions

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

Sunnova Salaries by Position

<p>Senior IT Business Analyst Brief Description of Sunnova Sunnova is a different kind of Power Company, offering solar and storage services to homeowners within the United States and its territories through our network of local solar dealers and solar standard community homebuilders. Our mission is to Power Energy IndependenceTM and change the energy industry. At Sunnova, we believe in achieving more by working together; our diverse workforce allows an inclusive and innovative culture to power our long-term growth. Our people focus on thinking beyond traditional limits - and to do that, we need the creativity and energy of every person. Come be a part of the fastest growing segment of the energy industry The Senior IT Business Analyst Position Sunnova Energy is currently searching for a Sr IT Business Analyst, responsible for required documentation related to IT projects and enhancement requests in coordination with business users, management, other IT resources and/or vendors. This individual will also work closely with business partners and IT team members, especially the assigned Project Manager, in an Agile environment to support the on-time, on-budget delivery of changes. May work on projects of large scope that involve multiple departments or have companywide impact. Senior IT Business Analyst Responsibilities Leads business requirement identification for assigned projects and targeted workstreams/functional areas, including cross-referencing requirements articulated by multiple business areas Establishes and maintains effective working relationships with business contacts, IT departments, and vendors; ensures effective communication and relationships between stakeholders and IT team members are maintained Works closely with developers to clarify requirements, capture assumptions, and identify impacts to business processes Applies knowledge of supported business areas to identify opportunities for process integration and refinement within IT and across business units Assists QA Analysts in the development of testing strategy and schedule; may help test execution as required to aid in delivery of a quality product, designed for user acceptance and adoption. Facilitates process analysis and improvement initiatives with appropriate stakeholders and coordinates any approved process changes or improvement initiatives. Performs data analysis, identifying gaps and potential pitfalls related to business requirements and production issues; recommends improvements or additional requirements within assigned business area; provides data analysis support to other business analysts and scrum masters on cross-team projects. Reports to Solution Architect Minimum Requirements Bachelor's degree or equivalent work experience 4 years' experience in business or systems analysis 2 years' experience specifically working in IT in a business analyst capacity 2 years' experience with data analysis tools such as SQL Ability to mentor and coach others Experience managing people Preferred Qualifications Experience with business or systems analysis in Salesforce Training material development experience Experience testing IT changes Additional Knowledge, Skills and Abilities Strong written and verbal communication skills Strong problem solving and critical thinking BI Skills - data analysis, reporting Microsoft Excel - modeling, analysis, pivot tables, formulas Working conditions Open office environment Schedule needs are flexible to needs of the business and may require weekend or evening availability to support software releases Location: Houston, TX and/or Remote Benefits Sunnova offers a generous employee reward package that includes: Comprehensive benefits Competitive compensation & annual bonus Paid time off, including 10 holidays and Paid Parental Leave Cell phone allowance for many roles Free access to onsite fitness center in Houston and/or discounted fitness memberships through health provider Complimentary garage parking in Houston</p>

Sunnova Interview Questions

Sunnova Interview Guides

Sunnova Interview Questions

Sunnova Salaries by Position

Sunnova Opening Jobs