Prepare for and practice interview questions from Bright Horizons.

Bright Horizons Interview Questions

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

You are testing hundreds of hypotheses with many t-tests. What considerations should be made?

What is a key disadvantage of the F-test when compared to multiple t-tests?

What is a key disadvantage of the F-test when compared to multiple t-tests?

Hundreds of Hypotheses

You are testing hundreds of hypotheses with many t-tests. What considerations should be made?

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

Bright Horizons Salaries by Position

Bright Horizons is seeking a seasoned Product Manager to expand our Enterprise Product team to build out products that impact across all our business lines. Come be part of a dynamic, fast-growing product team, and a passionate organization focused on making life easier for working families.
If you are dynamic, high-energy, with a sound business acumen, and have a passion for building innovative software then you will be an amazing fit! You would draw on results from user research, customer feedback, and business impact metrics, using strong business, technical, and problem-solving skills to create a strong product roadmap. Ideally, you are someone who thrives in a fast-paced environment, loves solving complex problems, and is passionate about working on products that help to make life easier for working parents. You are someone with a proven track record of being able to uncover product opportunities, propose solutions, plan, and deliver. In this role, you will interact regularly with cross-functional teams and stakeholders and you can communicate succinctly and effectively.
What you will be doing: In this high-impact role, you will own the product strategy and roadmap for our Enterprise data products, used by all our lines of business benefit products.

Use a customer-first mindset in building a robust prioritized product roadmap, translating market, business & customer requests.

Collaborate with Engineering & stakeholders to communicate & drive product vision, and define and refine product needs.

Manage the product lifecycle from idea generation, research, and requirements to product delivery, adoption, and feedback.

Gain exposure across the entire business and communicate effectively across the organization with leadership to ensure business and customer goals are met.

Utilize data to understand customer needs and behaviors as well as gain valuable insights into what your audience needs are and how best to reach them through our marketing efforts.

Conduct competitive research, market research, and work with the design team on creating wireframes and prototypes and validate with usability testing

Serve as a cross-organizational product leader and collaborate effectively with internal Bright Horizons colleagues & stakeholders to continue driving & delivering impact.

What you will bring to the team:
5+ years of product management experience.

Experience building B2B or B2C, SaaS-based products.

Demonstrated experience with agile and agile tools – Jira, ADO.

Ability to understand and discuss technical concepts, manage tradeoffs, and evaluate ambiguous new ideas.

Demonstrated data-driven product leadership measuring success outcomes using product analytic tools – Pendo, GA, etc.

Strong collaboration skills that allow you to work with both technical and non-technical teams and work across large stakeholder groups.

Demonstrated ability to work independently, autonomously, and cross-functionally .

Proven results delivering high quality, customer-driven products, on time.

Exceptional decision-making, prioritization, and time management skills.

Strong written and verbal communication skills.

Adaptability to work in a fast-paced and constantly changing environment.

Bachelor's degree is required.

Preferred Qualification:
Experience with building customer 360 views of a user/customer profile from internal and external sources using an MDM/CDP product.

Managed healthcare, benefits, and/or outsourcing service experience.

Experience with SAFe (Scaled Agile Framework).

Mentor product managers and manage vendors and partners.

Technical background desirable.

The range of compensation listed here or that may be discussed in the interview process is what Bright Horizons in good faith anticipates offering for this job opening. Actual compensation offers will depend on a variety of factors including experience, education and training, certifications, geography, and other relevant business or organizational factors.
Life at Bright Horizons: Our home office employees support all facets of our business — and no matter which department you join, you’ll be part of a passionate team doing work that makes a difference in the lives of children and families.
Our people are the heart of our company. Because we’re as committed to our own employees as we are to the clients we serve, our collaborative workplaces are designed to grow careers and support personal lives. Here, you’ll find traditional perks (health insurance, 401(k), PTO, and flex spending) plus childcare discounts, education assistance, and so much more. Join us to experience how we support our people to realize their passion, possibilities, and purpose both at work and at home. All in a workplace where you can be you. Come build a brighter future with us.
HAVING TECHNICAL ISSUES WITH YOUR APPLICATION?
Contact us at bhrecruit@brighthorizons.com or 855-877-6866
Bright Horizons is dedicated to creating a workforce that promotes and supports diversity and inclusion. We provide equal employment opportunities to all individuals without discrimination. Bright Horizons complies with the laws and regulations set forth in the following EEO is the Law Poster: EEO – English and EEO – Spanish along with information on the Family and Medical Leave Act (FMLA) and Employee Polygraph Protection Act (EPPA) .
Applicants requiring a reasonable accommodation for any part of the application and hiring process should contact the recruitment helpdesk at 855-877-6866 or bhrecruit@brighthorizons.com . Determinations on requests for reasonable accommodation will be made on a case-by-case basis.

#J-18808-Ljbffr

Bright Horizons is seeking a seasoned Product Manager to expand our Enterprise Product team to build out products that impact across all our business lines. Come be part of a dynamic, fast-growing product team, and a passionate organization focused on making life easier for working families. If you are dynamic, high-energy, with a sound business acumen, and have a passion for building innovative software then you will be an amazing fit! You would draw on results from user research, customer feedback, and business impact metrics, using strong business, technical, and problem-solving skills to create a strong product roadmap. Ideally, you are someone who thrives in a fast-paced environment, loves solving complex problems, and is passionate about working on products that help to make life easier for working parents. You are someone with a proven track record of being able to uncover product opportunities, propose solutions, plan, and deliver. In this role, you will interact regularly with cross-functional teams and stakeholders and you can communicate succinctly and effectively. **What you will be doing:** + In this high-impact role, you will own the product strategy and roadmap for our Enterprise data products, used by all our lines of business benefit products. + Use a customer-first mindset in building a robust prioritized product roadmap, translating market, business & customer requests. + Collaborate with Engineering & stakeholders to communicate & drive product vision, and define and refine product needs. + Manage the product lifecycle from idea generation, research, and requirements to product delivery, adoption, and feedback. + Gain exposure across the entire business and communicate effectively across the organization with leadership to ensure business and customer goals are met. + Utilize data to understand customer needs and behaviors as well as gain valuable insights into what your audience needs are and how best to reach them through our marketing efforts. + Conduct competitive research, market research, and work with the design team on creating wireframes and prototypes and validate with usability testing + Serve as a cross-organizational product leader and collaborate effectively with internal Bright Horizons colleagues & stakeholders to continue driving & delivering impact. **What you will bring to the team:** + 5+ years of product management experience. + Experience building B2B or B2C, SaaS-based products. + Demonstrated experience with agile and agile tools Jira, ADO. + Ability to understand and discuss technical concepts, manage tradeoffs, and evaluate ambiguous new ideas. + Demonstrated data-driven product leadership measuring success outcomes using product analytic tools Pendo, GA, etc. + Strong collaboration skills that allow you to work with both technical and non-technical teams and work across large stakeholder groups. + Demonstrated ability to work independently, autonomously, and cross-functionally. + Proven results delivering high quality, customer-driven products, on time. + Exceptional decision-making, prioritization, and time management skills. + Strong written and verbal communication skills. + Adaptability to work in a fast-paced and constantly changing environment. + Bachelor's degree is required. **Preferred Qualification:** + Experience with building customer 360 views of a user/customer profile from internal and external sources using an MDM/CDP product. + Managed healthcare, benefits, and/or outsourcing service experience. + Experience with SAFe (Scaled Agile Framework). + Mentor product managers and manage vendors and partners. + Technical background desirable. The range of compensation listed here or that may be discussed in the interview process is what Bright Horizons in good faith anticipates offering for this job opening. Actual compensation offers will depend on a variety of factors including experience, education and training, certifications, geography, and other relevant business or organizational factors. **Life at Bright Horizons:** Our home office employees support all facets of our business and no matter which department you join, youll be part of a passionate team doing work that makes a difference in the lives of children and families. Our people are the heart of our company. Because were as committed to our own employees as we are to the clients we serve, our collaborative workplaces are designed to grow careers and support personal lives. Here, youll find traditional perks (health insurance, 401(k), PTO, and flex spending) plus childcare discounts, education assistance, and so much more. Join us to experience how we support our people to realize their passion, possibilities, and purpose both at work and at home. All in a workplace where you can be you. Come build a brighter future with us. HAVING TECHNICAL ISSUES WITH YOUR APPLICATION? Contact us at bhrecruit@brighthorizons.com or 855-877-6866 Bright Horizons is dedicated to creating a workforce that promotes and supports diversity and inclusion. We provide equal employment opportunities to all individuals without discrimination. Bright Horizons complies with the laws and regulations set forth in the following EEO is the Law Poster: EEO English (https://www.dol.gov/ofccp/regs/compliance/posters/pdf/eeopost.pdf) and EEO Spanish (https://www.dol.gov/ofccp/regs/compliance/posters/pdf/eeosp.pdf) along with information on the Family and Medical Leave Act (FMLA) (https://www.dol.gov/whd/regs/compliance/posters/fmlaen.pdf) and Employee Polygraph Protection Act (EPPA) (https://www.dol.gov/whd/regs/compliance/posters/eppac.pdf) . Applicants requiring a reasonable accommodation for any part of the application and hiring process should contact the recruitment helpdesk at 855-877-6866 or bhrecruit@brighthorizons.com . Determinations on requests for reasonable accommodation will be made on a case-by-case basis. **Passion, Potential, and Possibilities** All three await you in a **Bright Horizons** career. Whether you work in one of our child care centers, a corporate office, or a familys home, youll be part of a company named 20 times as one of FORTUNEs 100 Best Companies to Work For. (https://youtu.be/IkTDOR2cFHA) ???????Join a team driven to make a difference, one child, one family, and one organization at a time. _Come build a brighter future with us_ .

Do you enjoy solving complex business problems, designing, and building Database solutions in a collaborative, fast-paced, inclusive, and agile environment? We are seeking a Data Warehouse/Business Intelligence Developer to join the growing Bright Horizons Enterprise Data & Analytics team. Bright Horizons is a leading global education and care company. The data team centered around the mission of providing a best-in-class experience for our products and customers. This team is primarily focused on data engineering to support our Product teams and Enterprise teams including our clients and vendors. This position focuses on supporting Datawarehouse platform and requires strong technical skills and a bias toward collaboration. What you will be doing: The Data Engineer will be primarily responsible for building/updating existing Data Warehouse. The DW/BI Developer will play a key role in the data analysis and new development efforts and is also responsible for the day-to-day support of the BH's backend databases. The responsibilities related to this role include operational support for all ETL and data processes, internal reports/ dashboards and external client facing reports, systems and applications including the BH's data warehouse. The Data Engineer will coordinate with various teams, including Application Development and System Engineering to design stable and reliable databases and ETL processes. The developer is expected to assist and contribute towards the migration of SQL Datawarehouse to Cloud Datawarehouse (Snowflake). <ul><li>Design, develop and implement robust and efficient data pipelines (ETLs) to integrate data from a variety of sources into Data Warehouse to support key business partners.</li><li>Understand the business requirements, functional specs and translate them into technical solutions.</li><li>Work with product owners, product managers, and software engineers; lead your squad to implement high-quality, production-grade data pipelines and ETL processes.</li><li>Create and maintain documentation including procedures, best practices, user guides, schema, physical layout and data flows, object references, data dictionary, repository, and so on.</li><li>Strong debugging skills to provide production support with the ability to easily and quickly read and modify existing code and maintain existing systems by researching and trouble-shooting any issues/problems in a timely manner.</li><li>Review test scripts as part of all functional specifications to ensure that testing occurs to meet all business requirements including all process components as well as client, center, and program configurations.</li><li>Performance tuning and optimization and supporting scheduled ETL jobs on daily basis.</li><li>Contribute and support the existing Datawarehouse to Snowflake cloud Datawarehouse.</li><li>Able to work on data pipelines and modern ways of automating data pipeline using cloud-based testing and clearly document implementations.</li><li>Coordinate and collaborate with dependent infrastructure and Azure services to implement Snowflake integration with services, such as Azure Data Lake Storage.</li></ul> What we hope you will bring to this role: <ul><li>This position needs to possess the ability to act quickly with independent thinking and sound judgment.</li><li>Most of the work will be under minimal supervision, with independent judgment.</li><li>Ability to make required and immediate decisions and escalate complex issues as needed.</li><li>Bachelor's Degree or higher in Engineering, Technology or related field experience required.</li><li>5+ years of experience in Microsoft SQL Server Environment with ETL development and BI Reporting tools and visualizations.</li><li>Expertise in designing ETL frameworks with 3-5 years of hands-on experience in implementing several aspects of data pipelines including ingestion, transformation, data quality checks, monitoring, alerts, notifications etc.</li><li>5+ years of experience in SQL queries, SQL Server BI Stack (SSIS, SSRS & SSAS). Experience in Qlik/Power BI is a plus.</li><li>1+ years of experience in Informatica IDMC Cloud Data Integration (CDI).</li><li>3+ years' experience of data warehouse design (e.g. dimensional modeling)</li><li>Good understanding of enterprise data management concepts (Data Governance, Data Engineering, Data Science, Data Lake, Data Warehouse, Data Sharing, Data Applications)</li><li>Experience with Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools.</li><li>Ability to effectively prioritize and execute tasks in a high-pressure environment and react to project adjustments and alterations promptly and efficiently. An analytical mind with a problem-solving aptitude</li><li>Experience working with code repositories and continuous integration.</li><li>Experience working with cloud data warehousing technologies such as Snowflake (preferred) and BigQuery.</li><li>Familiarity in Data Migration to Snowflake cloud data warehouse.</li><li>Familiarity with Snowflake Snowpipes, Snow Tasks, Airflow, Secure Data Sharing, and dynamic data masking.</li><li>Experience with cloud services on Microsoft Azure.</li><li>Excellent verbal and written communication skills</li><li>Collaboration with both onshore and offshore development teams</li><li>Preferred skills: Qlik Sense/Power BI, Airflow, Informatica IDMC (CDI, MI) & GCP BigQuery</li></ul> **This is a Newton, MA Hybrid position. The range of compensation listed here or that may be discussed in the interview process is what Bright Horizons in good faith anticipates offering for this job opening. Actual compensation offers will depend on a variety of factors including experience, education and training, certifications, geography, and other relevant business or organizational factors. Life at Bright Horizons: Our home office employees support all facets of our business - and no matter which department you join, you'll be part of a passionate team doing work that makes a difference in the lives of children and families. Our people are the heart of our company. Because we're as committed to our own employees as we are to the clients we serve, our collaborative workplaces are designed to grow careers and support personal lives. Here, you'll find traditional perks (health insurance, 401(k), PTO, and flex spending) plus childcare discounts, education assistance, and so much more. Join us to experience how we support our people to realize their passion, possibilities, and purpose both at work and at home. All in a workplace where you can be you. Come build a brighter future with us. HAVING TECHNICAL ISSUES WITH YOUR APPLICATION? Contact us at bhrecruit@brighthorizons.com or 855-877-6866 Bright Horizons is dedicated to creating a workforce that promotes and supports diversity and inclusion. We provide equal employment opportunities to all individuals without discrimination. Bright Horizons complies with the laws and regulations set forth in the following EEO is the Law Poster: EEO - English and EEO - Spanish along with information on the Family and Medical Leave Act (FMLA) and Employee Polygraph Protection Act (EPPA). Applicants requiring a reasonable accommodation for any part of the application and hiring process should contact the recruitment helpdesk at 855-877-6866 or bhrecruit@brighthorizons.com. Determinations on requests for reasonable accommodation will be made on a case-by-case basis.

Bright Horizons Interview Questions

Bright Horizons Interview Guides

Bright Horizons Interview Questions

Bright Horizons Salaries by Position

Bright Horizons Opening Jobs