Prepare for and practice interview questions from Success Academy Charter Schools.

Success Academy Charter Schools Interview Questions

Success Academy Charter Schools 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

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?

Success Academy Charter Schools Salaries by Position

Thanks for your interest in Success Academy! Running the largest, fastest-growing, and highest-performing network of public charter schools in New York City takes a village - families, children, teachers, staff and faculty, advocates and supporters alike. We would love to welcome you to our community! We work tirelessly every day to ensure each child in NYC has access to a fun, rigorous, whole-child education regardless of zip code or economic status. When you join SA, you play a part in giving every student who walks through the doors of one of our 53 schools in NYC a fair shot at reaching his or her potential. Job DescriptionAs the fastest growing, highest-performing charter school network in New York State, Success Academy is reimagining K-12 public education. Nationally recognized for our innovative, whole-child school model and outstanding academic results, Success Academy educators are empowering children from all backgrounds with the knowledge, skills, and self-belief to succeed in college and in life. We now need a results-driven Senior Data Analyst to join our Enterprise Data & Analytics team. DepartmentThe Technology Division at Success Academy is the chief provider of technology infrastructure, application services, security, and support. The Division partners with teams across the organization to equip students, teachers, leaders, and staff with the innovative technology tools and know-how necessary to achieve academic and operational excellence. The Enterprise Data and Analytics department’s purpose is to build a healthy data and technology culture. By focusing on the concrete educational outcomes we are trying to accomplish in our schools, the team develops technical and organizational systems that are user-friendly, scalable, and flexible. The department is responsible for all reporting, analytics, data infrastructure, training, and evangelization. This new Senior Data Analyst role will be a key contributor to our mission of driving innovation and democratizing data across the organization. Reporting to the Leader of Enterprise Data & Analytics, this role will be responsible for building dashboards in data visualization tools, querying an AWS data warehouse to build insights to support stakeholders, and code SQL data models in dbt. Key responsibilities include:<ul><li>Deliver and communicate data-driven insights and reports to stakeholders by querying an Amazon Redshift data warehouse using SQL. </li><li>Build and maintain SQL-based transformations in dbt for new and existing use cases. </li><li>Develop and maintain Looker dashboards that are viewed by senior leadership and operation groups across the school network. </li><li>Work closely with school operations and management teams across the network to help capture business requirements and translate those requirements into SQL code. </li><li>Collaborate with data engineers to build transformed datasets for reporting needs. </li></ul>A successful applicant will have the following experiences and education:Required Qualifications<ul><li>Bachelor’s Degree in a technical field like Math, Engineering, Computer Science, or Information Technology and/or experience in data analytics. </li><li>Ability to easily code complex SQL queries from scratch, having done so for at least 4 years. </li><li>Hands-on experience in reporting and data visualization tools such as Looker, Tableau, PowerBI or other BI tools. </li><li>Strong communication skills, capable of explaining complex data models and dashboards in a concise and digestible manner. </li><li>Ability to multitask in a fast-paced environment. </li><li>SQL coding experience in dbt and/or LookML coding is a plus. </li></ul>To join our team, please upload a cover letter and resume that outlines your candidacy. Your cover letter should explain in detail your qualifications for the position. Resumes without cover letters will not be reviewed. Success Academy Charter Schools is an equal opportunity employer and actively encourages applications from people of all backgrounds. Compensation is competitive and commensurate with experience. Success Academy offers a full benefits program and opportunities for professional growth. Compensation Range$110,000.00 - $125,000.00 Exact compensation may vary based on skills and experience. Already an employee of Success Academies? Please go to your Okta Dashboard> Workday> Applications> Career to apply via our Internal Careers page. We are an equal opportunity employer and value diversity at our organization. We do not discriminate on the basis of race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status. We actively seek applications from people of all backgrounds to strengthen our community and the perspectives needed to flourish in a multicultural world. Success Academy offers a full benefits program and opportunities for professional growth. Learn more about our philosophy, benefits, and team at https://jobs.successacademies.org/working-here/ . Success Academy Charter Schools does not offer employment-based immigration sponsorship.

Thanks for your interest in Success Academy! Running the largest, fastest-growing, and highest-performing network of public charter schools in New York City takes a village - families, children, teachers, staff and faculty, advocates and supporters alike. We would love to welcome you to our community! We work tirelessly every day to ensure each child in NYC has access to a fun, rigorous, whole-child education regardless of zip code or economic status. When you join SA, you play a part in giving every student who walks through the doors of one of our 53 schools in NYC a fair shot at reaching his or her potential. Job DescriptionAs the fastest growing, highest-performing charter school network in New York State, Success Academy is reimagining K-12 public education. Nationally recognized for our innovative, whole-child school model and outstanding academic results, Success Academy educators are empowering children from all backgrounds with the knowledge, skills, and self-belief to succeed in college and in life. We now need a results-driven Data Scientist to join our Enterprise Data & Analytics team. DepartmentThe Technology Division at Success Academy is the chief provider of technology infrastructure, application services, security, and support. The Division partners with teams across the organization to equip students, teachers, leaders, and staff with the innovative technology tools and know-how necessary to achieve academic and operational excellence. As a Data Scientist at Success Academy, you will be a key contributor to our mission of driving innovation and democratizing data across the organization. Reporting to the Leader of Data Science, you will partner with stakeholders to understand objectives and leverage data to identify opportunities and drive strategy. Key responsibilities include: <ul><li>Provide quantitative support, market understanding, and a strategic perspective to our partners throughout the organization </li><li>Demonstrate analytical expertise and thought leadership with quantitative analyses to help Success Academy make better decisions </li><li>Identify and measure success of efforts through goal setting, forecasting, and monitoring of key metrics to understand trends </li><li>Define, understand, and test opportunities and levers to improve operations through insights and recommendations </li></ul>A successful applicant will have the following experiences and education: Qualifications<ul><li>Degree in a technical field like Math, Statistics, Computer Science, Data Science, Artificial Intelligence, Engineering, Operations Research, or Physics. Graduate degree preferred. </li><li>At least 3 years of experience working within a corporation or consumer-focused environment in a Data Science capacity </li><li>Strong presentation and data visualization skills to communicate data analysis in compelling ways </li><li>Proficient data wrangler with strong technical skills in SQL. Preferably also proficient in a fast prototyping language (either Python or R) </li><li>Understands when analytical sophistication is required and when an Excel projection will be best </li><li>Proven expertise in data science and analytics, probability and statistics, time-series analysis, pattern recognition, optimization, and/or predictive modeling </li><li>Ability to lead projects independently and communicate effectively across the organization </li><li>Ability to collaborate with data analysts, software engineers, business partners and other stakeholders and act as an evangelist for data science/analytics principles and practices </li></ul>Success Academy Charter Schools is an equal opportunity employer and actively encourages applications from people of all backgrounds. Compensation is competitive and commensurate with experience. Success Academy offers a full benefits program and opportunities for professional growth. Compensation RangeAnnual Salary: $120,000.00 - $140,000.00 Exact compensation may vary based on skills and experience. Already an employee of Success Academies? Please go to your Okta Dashboard> Workday> Applications> Career to apply via our Internal Careers page. We are an equal opportunity employer and value diversity at our organization. We do not discriminate on the basis of race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status. We actively seek applications from people of all backgrounds to strengthen our community and the perspectives needed to flourish in a multicultural world. Success Academy offers a full benefits program and opportunities for professional growth. Learn more about our philosophy, benefits, and team at https://jobs.successacademies.org/working-here/ . Success Academy Charter Schools does not offer employment-based immigration sponsorship.

Success Academy Charter Schools Interview Questions

Success Academy Charter Schools Interview Guides

Success Academy Charter Schools Interview Questions

Success Academy Charter Schools Salaries by Position

Success Academy Charter Schools Opening Jobs