Prepare for and practice interview questions from Con Edison.

Con Edison Interview Questions

Con Edison Interview Guides

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

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

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

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

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?

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?

Con Edison Salaries by Position

**Required Education/Experience** + Bachelor's Degree in Math, Business, Statistics, Computer Science, Public Policy or a related field is preferred. and at least three years of related work experience or + Master's Degree in Business Administration is preferred. and at least two years of related work experience **Preferred Education/Experience** + Bachelor's Degree in Math, Business, Statistics, Computer Science, Public Policy or a related field is preferred and at least three years of related work experience **Relevant Work Experience** + Experience managing budgets and grants databases (Benevity) Required + Experience developing logic models and impact frameworks for nonprofit programs Required + Strong written and verbal communication skills and experience developing grant portfolio presentations Required + Experience in data modeling and data visualization, analyzing and synthesizing data into narratives for internal and external audiences Required + Demonstrated ability to interpret and present information and ideas clearly and accurately in writing, verbally and through preparation of reports and other materials Required + Ability to work independently and collaboratively in a fast-paced, complex work environment Required + Advanced Excel skills Required **Skills And Abilities** + Promotes information sharing + Develops and delivers effective presentations + Effective interpersonal skills + Strong written and verbal communication skills **Licenses And Certfications** + Driver's License Required **Physical Demands** + Sit or stand to use a keyboard, mouse, and computer for the duration of the workday + Possess manual dexterity and the ability to use hands for the duration of the workday + Ability to read small print and symbols **Additional Physical Demands** + Must be able to respond to Company emergencies by performing a System Emergency Assignment to restore service to our customers. + Must be able and willing to travel within Company service territory, as needed. + Must be flexible in work hours required. EEO Statement: Consolidated Edison Company of New York, Inc. (Con Edison), Orange & Rockland Utilities (O&R), and Consolidated Edison Transmission (CET) are equal opportunity employers. All qualified applicants will receive consideration for employment and will not be discriminated against on the basis of the individuals actual or perceived disability, protected veteran status, race, color, creed, religion, sex, age, national origin, gender, gender identity, gender expression, genetic information, marital status, sexual orientation, citizenship, domestic violence victim status, or any other actual or perceived status protected by law. Technical Difficulty Statement: For technical issues, please contact us at careerconnect@coned.com

Con Edison Interview Questions

Con Edison Interview Guides

Con Edison Interview Questions

Con Edison Salaries by Position

Con Edison Opening Jobs