Prepare for and practice interview questions from State of florida.

State of florida Interview Questions

State of florida 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?

State of florida Salaries by Position

This position is responsible for the development and production of Florida Lottery games and promotions. The Product Manager researches product ideas, develops annual launch schedules, manages all production stages of the launch process and analyzes Product Manager, Manager, Product Development, Product Management, Research, Sales, Business Services

Requisition No: 839728 Agency: Department of Lottery Working Title: PRODUCT MANAGER - 36000172 Pay Plan: Lottery Exempt Serv Position Number: 36000172 Salary: $57,000.00 - $63,000.00 Posting Closing Date: 11/29/2024 Total Compensation Estimator Tool PRODUCT MANAGER FLORIDA DEPARTMENT OF THE LOTTERY - DIVISION OF PRODUCT & SALES *Open Competitive Opportunity* AGENCY BENEFITS: If hired, as employee of the Florida Lottery, you will be provided the benefits listed below: <ul> <li>Approximately 97.5% of the premium for health insurance <ul> <li>Individual (~$8/month) or Family (~$30/month)</li> </ul> </li> <li>100% of the premium for individual or family dental insurance</li> <li>100% of the premium for basic life insurance</li> <li>Employer contributions to the Pension Plan or Investment Plan; contribution levels will vary based upon Pay Plans.</li></ul> GENERAL POSITION DESCRIPTION: This position is responsible for the development and production of Florida Lottery games and promotions. The Product Manager researches product ideas, develops annual launch schedules, manages all production stages of the launch process and analyzes the game performance throughout the product lifecycle. ESSENTIAL DUTIES: <ul> <li>Each employee is expected to be knowledgeable of the Lottery's Responsible Gaming program, including the No Underage Play and Play Within Your Means messaging, and will ensure retailers and players are aware of the program and provided information, as necessary.</li> <li>Manages the development of new and innovative Draw games and promotions for introduction into the Florida market.</li> <li>Develops reporting and data analysis that provides clear and actionable insights in the areas of sales, product management, and promotions.</li> <li>Maintains full understanding of the Florida Lottery game portfolio, including prize structure development and game portfolio management.</li> <li>Participates in long-term, strategic plan development discussions, with ability to articulate information on results of game and promotion performance, review analytical and forecasting data prepared to support initiatives discussed, and make knowledgeable, fact-based recommendations that can be incorporated into marketing and business development plans.</li> <li>Reviews and evaluates new gaming and product suggestions from vendors, Lottery players, and other sources to determine the appeal, impact and feasibility for product development.</li> <li>Develops annual product plans to achieve annual sales goals and maintain a sufficient variety of Lottery products to reach each segment of the player market.</li> <li>Forecasts the potential sales performance based on market research.</li> <li>Manages contracts with vendors and licensed properties, coordinates the launch activities and monitors sales.</li> <li>Works with Research to develop annual plans for product research, attend focus groups and other research activities.</li> <li>Acts as project manager and develops detailed action plans to ensure the smooth implementation and introduction of new games into the marketplace.</li> <li>Works closely with Lottery Marketing, Communications, Security and Information Resources to develop advertising campaigns, websites, in-store signage, and player/retailer materials to promote and educate the public about Lottery offerings, and with other Lottery divisions to ensure support functions for Lottery play, such as: security, game administration operations, claims processing and prize fulfillment requirements are being met.</li> <li>Conducts a thorough business analysis of potential new games and promotions. Develops product and promotion briefs identifying key features, product positioning, market analysis and research and other relevant details.</li> <li>Analyzes game and promotions by tracking awareness, participation, sales and performance compared to historical data and market and economic factors. Creates reports and communicates findings to management.</li> <li>Responds to public records requests for information. </li> <li>Perform special projects and additional duties as assigned and directed by the Senior Product Manager, Director or Product and/or Deputy Secretary of Product and Sales.</li> <li>Attendance is an essential function of this position. </li></ul> Knowledge, Skills, and Abilities: <ul> <li>Knowledge of sales and marketing principles and practices. </li> <li>Knowledge of the lottery products and games.</li> <li>Ability to establish and maintain effective working relationships with others. </li> <li>Ability to communicate effectively both verbally and in writing.</li> <li>Ability to develop in-depth project plans and oversee implementation of such plans.</li> <li>Ability to analyze and evaluate complex statistical and other data, and draw conclusions based on the data.</li> <li>Skill in Microsoft Office.</li> <li>Skill in making presentation. </li> <li>Skill in data analysis.</li></ul> Other job-related requirements for this position A bachelor's degree from an accredited college or university in Business Administration, Finance, Research, Marketing, Advertising, Communications, or a closely related field of study and two (2) years of professional sales, marketing, or advertising experience. A master's degree from an accredited college or university in Business Administration, Finance, Research, Marketing, Advertising, Communications, or a closely related field of study may substitute for one (1) year of the required work experience. Professional or non-professional work experience as described above may substitute for the required college education. Combinations of college course work in the disciplines specified above and experience may be substituted for the required college education. College course work will be considered equivalent of experience at the rate of thirty (30) semester or forty-five (45) quarter hours on a year for year basis. A maximum of three (3) years of college course work may be substituted. Successful passing of a criminal background check (state, local, and national) is required). Maintains strict confidentiality of information learned while working with the Florida Lottery, whether learned through assigned duties or through working with other units. The types of confidential information may include, but are not limited to, payroll information, budget matters, policy decisions, tax matters, employee disciplinary issues, and other personnel data. Statutes establishing or defining work performed Chapter 24, Florida Statutes The State of Florida is an Equal Opportunity Employer/Affirmative Action Employer, and does not tolerate discrimination or violence in the workplace. Candidates requiring a reasonable accommodation, as defined by the Americans with Disabilities Act, must notify the agency hiring authority and/or People First Service Center (1-866-663-4735). Notification to the hiring authority must be made in advance to allow sufficient time to provide the accommodation. The State of Florida supports a Drug-Free workplace. All employees are subject to reasonable suspicion drug testing in accordance with Section 112.0455, F.S., Drug-Free Workplace Act. VETERANS' PREFERENCE. Pursuant to Chapter 295, Florida Statutes, candidates eligible for Veterans' Preference will receive preference in employment for Career Service vacancies and are encouraged to apply. Certain service members may be eligible to receive waivers for postsecondary educational requirements. Candidates claiming Veterans' Preference must attach supporting documentation with each submission that includes character of service (for example, DD Form 214 Member Copy #4) along with any other documentation as required by Rule 55A-7, Florida Administrative Code. Veterans' Preference documentation requirements are available by clicking here. All documentation is due by the close of the vacancy announcement. Location:

State of florida Interview Questions

State of florida Interview Guides

State of florida Interview Questions

State of florida Salaries by Position

State of florida Opening Jobs