Prepare for and practice interview questions from Shine.

Shine Interview Questions

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

Shine Salaries by Position

At Nari Technologies, we harness the power of data-driven insights to revolutionize media buying. Founded in London, we have recently secured funding and are rapidly expanding our footprint across North America. Collaboration is at the heart of our philosophy. We believe in building strong partnerships, working hand-in-hand with our clients to achieve their goals. Join us on this exciting journey, where your vision meets our expertise. Together, let's create meaningful connections and drive the industry forward in the ever-evolving world of advertising. About the role We are looking for a proactive Junior Business Analyst to join our growing team. In this role, you will support the analysis of business processes, identify improvement opportunities, and contribute to strategic initiatives. You will work closely with various departments to gather requirements and help translate them into actionable insights. Responsibilities * Assist in gathering and documenting business requirements from stakeholders. * Analyze existing business processes to identify areas for improvement. * Support the development of project plans and timelines. * Create reports and presentations to communicate findings and recommendations. * Collaborate with cross-functional teams to ensure alignment on project goals. * Participate in meetings to gather feedback and update stakeholders on project progress. * Help maintain project documentation and track key performance indicators (KPIs). Qualifications * Bachelor's degree in Business Administration, Management, or a related field. * Strong analytical and problem-solving skills. * Excellent communication and interpersonal abilities. * Proficiency in Microsoft Office Suite (Excel, PowerPoint, Word); experience with project management tools is a plus. * Familiarity with data analysis and visualization tools (e.g., Tableau, Power BI) is beneficial. * A detail-oriented mindset and ability to work independently as well as collaboratively. Benefits 401(k) Retirement Plan: Secure your future with our competitive retirement savings plan. Health Insurance: Comprehensive medical, dental, and vision coverage to keep you and your family healthy. Hybrid Workplace: Enjoy flexibility with a hybrid work model, combining remote work and office collaboration. Extra Days Off: Additional days off to recharge and pursue personal interests. Gym Memberships: Stay active and healthy with subsidized gym memberships or wellness stipends. Employee Stock Options: Participate in our growth with stock options for eligible employees. Flexible Hours: Work according to your schedule with flexible hours that accommodate your life outside of work. Disclaimer We believe in the power of diversity to drive innovation and foster a culture of inclusion. We welcome applicants from all backgrounds, experiences, and perspectives. We are committed to creating an inclusive environment where everyone feels valued and has the opportunity to contribute their best work towards our mission of sustainable logistics solutions. We encourage individuals of all races, ethnicities, genders, ages, abilities, and sexual orientations to apply. Join us in shaping the future of logistics with your unique perspective and skills.

Job Type Full-time Description SHINE Technologies is seeking an Instruments and Controls (I&C) / Electrical Engineering Manager to oversee the design, development, procurement, and testing of systems used to control and monitor processes, as well as provide power for our new medical isotope production facility. This position works as part of a collaborative team that oversees the design of the control systems and selects instruments and equipment for the SHINE facility. SHINE engineers are designing systems that will produce isotopes to help diagnose heart disease, treat cancer, and take us another step closer to clean energy. Areas of responsibility for this position includes leading with the team to determine control strategies, design of control system hardware and software, instrument selection, and electrical power distribution for the molybdenum-99 production facility. The team will need to work with procurement, vendors, and the construction team to procure, install, and test the I&C/electrical equipment. In addition, the team works with the licensing team to maintain the accuracy of the I&C/electrical licensing basis. Currently, the designs for the Molybdenum-99 production facility electrical systems and instruments are nearly complete, while there will be more design on the control systems and cable routing. This role will thus be focused on the design of the aforementioned items as well as vendor/construction management, commissioning, turnover to operations, and operations support of all I&C/Electrical scope. Duties and Responsibilities: Specific duties and responsibilities include, but are not limited to: <ul><li>Hire, manage, review, and lead a team of highly skilled I&C/electrical engineers focused on the control systems, instruments, and power supply design and install of the SHINE molybdenum-99 production plant.</li><li>Oversee the I&C/electrical schedule and budget alongside the Project Management and Finance teams.</li><li>Lead the interfaces between stakeholders and the I&C team.</li><li>Mentor engineers in the technology, decision making, and ownership of the I&C equipment that they are responsible for.</li><li>Maintains the group budget and schedule, maintaining a detailed plan to accurately predict milestones and resource loading. </li><li>Drive decisions on vendor requests, changes, and updates to equipment and programming.</li><li>Ensure the team is sufficiently staffed and skilled to </li><li>Oversee the development of digital and analog control systems, including distributed control systems (DCS), programmable logic controllers (PLC), and data acquisition systems (DAQ), by performing reviews of vendor deliverables.</li><li>Work with vendors and construction to oversee installation of systems to provide power to plant equipment via the normal power supply and the uninterruptible power supply.</li><li>Work collaboratively with other engineering disciplines to select instruments to measure process variables in the process systems in the SHINE facility. </li><li>Update instrument specifications, calculations, and test plans to support the design, new construction, testing, commissioning, in-field troubleshooting and operation of the future SHINE medical isotope production facility.</li><li>Oversee the design and implementation of instrument/electrical cable routing, conduit and raceway design, installation drawings, and loop diagrams.</li><li>Assist in the commissioning, turnover to Operations, and subsequent support of I&C/Electrical systems.</li></ul> Requirements <ul><li>Bachelor's degree in electrical engineering, nuclear engineering, or related technical discipline.</li><li>Experience in Project Management including creation of schedules and budgets.</li><li>10+ years of experience in instruments and controls.</li><li>Working knowledge of electrical power distribution for normal and uninterruptible power for commercial level power systems (e.g. 120VAC, 480V 3 phase, DC, etc.).</li><li>Ability to lead, motivate, coach, and inspire a group of highly skilled engineers in a fast-paced startup environment.</li><li>Confidence to make decisions on technical issues and the aptitude to push decision making down to the responsible engineers.</li><li>Ability to manage multiple projects/activities, prioritizing them in a way that contributes most to Company success.</li><li>Experience in personnel management.</li><li>Direct and open communication style, showing respect to all individuals and their ideas.</li><li>Experience working in a highly regulated environment such as the nuclear power industry or similar.</li></ul> Eligibility for employment is conditioned on the applicant's ability to qualify for access to information subject to U.S. Export Controls. Additionally, applicant's eligibility may be conditioned based upon meeting the Nuclear Regulatory Commission requirements for access to Safeguards Information, which typically requires a pre-employment drug screen, fingerprinting and criminal background check. SHINE values diversity in all its forms as a critical component of innovation, which is fundamental to our success. Every member of the SHINE community benefits from the talents and experiences of our peers, from the mutual respect we exercise, and from the responsibility we take for our actions. SHINE Technologies is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or veteran status. Pay Transparency Policy Employee Rights Under the NLRA Equal Opportunity Employment E-Verify

Shine Interview Questions

Shine Interview Guides

Shine Interview Questions

Shine Salaries by Position

Shine Opening Jobs