Prepare for and practice interview questions from Gables Search Group.

Gables Search Group Interview Questions

Gables Search Group 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

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

Gables Search Group Salaries by Position

About the Role: This specific role will have primary responsibilities of managing our portfolio for an identified group of categories, managing the product lifecycle management and P&L performance of these items, including leading the sourcing, product development and commercialization of these items. This dynamic individual is responsible for developing a category roadmap based on prioritized business opportunities, partnering with key stakeholders, and then executing that roadmap through flawless commercialization execution. This role is a unique opportunity to join a new team chartered with developing the foundation and future of sourcing. Reports to the Brands Product Director and is a new role. Responsibilities Include <ul> <li>Develop and then implement short, medium, and long-term category management plans and category sourcing strategies across the business for specificBrands categories.</li> <li>Conduct industry analyses and competitive assessments, modeling opportunities to prioritize white space sales and/or margin opportunities that would drive incremental value to the company.</li> <li>Lead and manage the RFP process for identified Brands categories, partnering with key business owners from start to finish, identifying capable supplier partners, performing market research and benchmarking, and managing the supplier communication process.</li> <li>Lead contract and business term negotiations with suppliers by utilizing a robust strategic sourcing process, focused on should-costs, leveraging advanced scenario modeling, design to value thinking and vertical interference concepts.</li> <li>Develop business recommendations and present them to business leaders for decision-making, including the Purchasing Leadership Team and our Independent Operators network.</li> <li>Execute legal contracts with awarded suppliers, partnering with the legal team on all legal indemnifications and business terms and conditions.</li> <li>Monitor supplier performance, assessing supplier service levels, understanding capacity planning, reviewing innovation pipelines, and pressing for continuous cost improvements.</li> <li>Perform ad hoc category or business analysis and support for stakeholders across the company, becoming a key thought partner with the business.</li> <li>Create and commercialize new products, collaborating with suppliers to ensure products are meeting targeted quality expectations and delivering excellent value to our shoppers and stores.</li> <li>Build financial decks to summarize Brands category performance, cost analysis, and other key financial metrics, including collaborating with finance, purchasing and strategy teams.</li> <li>Utilize clear and insightful data visualizations to build reports and dashboards that facilitate data-driven decision-making across the Brands and Purchasing departments</li> <li>Provide input to the Brands design agency towards a packaging design solution for each responsible category, considering category activity and private label competitive positioning.</li> <li>Review and approve label claim documentation, quality certifications, specifications, plant audit reports, certificates of insurance and other legal or regulatory documents to manage risk for the company.</li> <li>Generate sales and marketing content for planned digital marketing events, including Ads, seasonal events, promotional activities, industry activation and ad hoc Independent Operator needs.</li> <li>Effectively manage the Brands portfolio within assigned departments to ensure comp sales growth and enhanced margin performance while continuing to offer value to our shoppers.</li> </ul> About The Pay <ul> <li>Base Salary Range: $110,000 - $130,000 Annually</li> <li>Annual Bonus Program</li> <li>Equity</li> <li>401(k) Profit Sharing</li> <li>Medical, Dental, Vision & More!</li> <li>Final compensation will be determined based upon experience and skills and may vary based on location.</li> </ul> About You <ul> <li>Bachelor's degree in Marketing, Business, Food Science, Economics or Supply Chain. MBA preferred.</li> <li>10+ years of analytical experience - takes data driven approach to problems with an ability to quickly model financial impacts and identify opportunities. Advanced Excel skills required.</li> <li>7+ years of private label, sourcing and/or product commercialization experience across multiple consumable product categories. Expertise in all aspects of the commercialization process of private label, including legal, quality, regulatory and print production, with experience in grocery retail highly preferred.</li> <li>Action-oriented, self-starter with courage to lead change, and implement operational improvements.</li> <li>Must be familiar with clean-sheeting, should-cost modeling, tolling and developing financial models to reverse engineer the total costs of ownership for consumer-packaged goods.</li> <li>Knowledgeable of category industry activities and risks, including regulatory restrictions and needs, certification standards, brand positioning, claim values and shopper behavior drivers.</li> <li>Collaborative worker, quick to build trusted relationships with internal and external business partners.</li> <li>Possess the ability to multi-task, prioritize, work independently and keep a high level of focus.</li> <li>Excellent interpersonal, written and verbal communication skills, especially in front of peers and executive audiences. Strong PowerPoint skills required.</li> <li>Experience working within a mainframe ERP system a plus as well as multiple data sources.</li> </ul>

Our client is looking to hire 4 IT Business Analysts.These are hybrid positions in Miami. POSITION SUMMARY: The IT Business Analyst will be a crucial member of the IT Project Management Office (PMO), responsible for bridging the gap between business needs and IT solutions. This role involves working closely with stakeholders across the organization to gather, analyze, and document requirements, and to ensure that IT projects are aligned with business goals. The IT Business Analyst will also support the PMO in project planning, execution, and monitoring to ensure successful delivery of IT initiatives. The Business Analyst ensures a competent grasp of business insight and acquires knowledge about the company's functions RESPONSIBILITIES: <ul> <li> Coordinate the analysis and documentation of business and technology requirements to enable Internal and External solution deployments by creating and maintaining detailed documentation including business requirements, project plans, budgeting, functional specifications, process flows, and user stories.</li> <li> Anticipate and understand business expectations and recommend the most appropriate response to complex or ambiguous requirements.</li> <li>Collaborate closely with IT Single Point of Contacts (SPOC), both Internal and External Development teams, and Business Subject Matter Experts to execute interdepartmental projects and ensure delivery is on time and within budget. </li> <li> Familiar with the Software Development Life Cycle and actively participates in every stage of the process. </li> <li>Analyze complex business processes and systems to identify areas for improvement and propose IT solutions.</li> <li> Conducts workshops and presentations to present proposals and obtain approval from stakeholders. </li> <li>Facilitates delivery through demonstrations that communicate and confirm the suggested solutions. </li> <li>Capable of working effectively, independently, and seamlessly across both technical and business sectors. </li> <li>Exhibit organization, efficiency, accuracy, and creativity in all work-related tasks. </li> <li>Quickly detect, monitor, document, and resolve challenges. </li> <li>Actively addresses potential risks and obstacles in projects. </li> <li>Effectively convey information to audiences, regardless of their technical expertise. </li> <li>Adept at managing meetings and delivering presentations to Executive management. </li> <li>Travel might be necessary. </li> </ul> Qualifications: <ul> <li>Bachelor's Degree - Business Administration, Finance, Information Technology or Engineering preferred. </li> <li>At least 5 years of experience in a role such as Business Analyst, Process Engineer, or Business Process Analyst with a track record of success. </li> <li>Strong knowledge of business analysis techniques and methodologies (e.g. BABOK, Agile)</li> </ul> SKILLS: <ul> <li>Should be capable of showing experience in transforming or enhancing a process. </li> </ul> <ul> <li>Possess superior communication and interpersonal skills, along with the capacity to resolve problems effectively. </li> </ul> <ul> <li>Proficiency with various Microsoft programs, skilled in analyzing data sets and assessing process flows, complemented by research and design expertise. </li> </ul> <ul> <li>Exceptional skills in writing and documentation, inclusive of both technical details and business communication. </li> <li>Demonstrated success in collaborating with multidisciplinary teams and overseeing third-party solution deployments. </li> <li>Familiarity with Agile and Waterfall methodologies</li> </ul> Certifications, Licenses, and/or Registration •Relevant certifications (e.g. CBAP, PMP, ITIL) are a plus

must be US Citizens and must be able to obtain a security clearance. Must have debian/drone experience We are seeking a talented Senior Software Engineer to join our team. The ideal candidate will have a strong background in embedded software engineering (particularly Debian-based Linux distributions) or UI development within Qt and will have a background with or personal interest in small unmanned systems (i.e. drones). Our client has several senior software engineering opportunities with various focuses including embedded Linux administration, machine learning, UI development, autopilot software and system architectures. Responsibilities •Develop high-quality software design and architecture for next-generation unmanned systems •Grow to lead a team of junior software engineers to develop products and solutions related to unmanned systems. •Identify, prioritize, and execute tasks in the software development life cycle •Develop tools and applications by producing clean, efficient code •Automate tasks through appropriate tools and scripting •Review and debug code •Perform validation and verification testing •Collaborate with internal teams to fix and improve software Experience The successful candidate would ideally possess the following skills; however, we will consider applicants with only partial skillsets. <ul> <li>Software Engineering: 5 years (Required)</li> <li>Proficiency in C, C++, Qt, .Net and/or Python</li> </ul> •Strong proficiency in embedded Linux, including system, network manager, modem manager, etc. •Familiarity with or strongly expressed interest in open-source autopilot projects and communication protocols (PX4, ArduPilot, ROS, MAVLink, QGroundControl, Mission Planner, etc.) •Experience with ARM architectures, Raspberry Pi, Nvidia Jetson and other embedded platforms preferred •Knowledge of Visual Studio This is an exciting opportunity for a skilled Senior Software Engineer to contribute to cutting-edge projects in fast growing company supporting consumer and defense drone development. Requirements Job applicants must be US Citizens and must be able to obtain a security clearance. Education B.S. Degree in Engineering or Computer Science. Advanced degrees are welcome. Job Type : Full-time Benefits <ul> <li>401(k)</li> <li>Life insurance</li> <li>Paid time off</li> <li>Professional development assistance</li> <li>Relocation assistance</li> <li>Stock options</li> </ul> Schedule <ul> <li>Choose your own hours</li> <li>No weekends</li> </ul> Ability to Relocate <ul> <li>Relocate with an employer provided relocation package (Required)</li> </ul> Willingness to travel <ul> <li>25% (Preferred)</li> </ul>

On-site Clinical Engineering Capital Manager.MUST have qualified experience as a CE Manager and BA Degree:(minimum) 4-10 years' Clinical Engineering manager experience. The Clinical Engineering Capital Manager provides the overall strategic direction, leadership, and operational management for capital technology projects for the hospital facilities and multiple sites to achieve financial and operating objectives set by the overall organization's business plan. The CE Manager will provide leadership and expertise for Clinical Engineering Staff. •Information Services (including network support, disaster recovery), Clinicians (system users including physicians, nurses, technologists, etc.). •Medical system manufacturers/vendors. •Risk management. •Information Services Security. •Procurement/purchasing/materials management, Clinical Engineering •Project Leadership, Equipment Inventory, Hiring & Training, Field Support & Projects Qualifications 1.Baccalaureate degree in Biomedical or Clinical Engineering or related 2.5-10 years' experience in clinical engineering and information systems. 3.Project management and planning skills/experience. 4.Strong communication and team building skills across functional areas. 5.Certification (completed or in process) preferred in one or more of the following: oCertified Clinical Engineer (CCE) oCertified Information Systems Security Professional (CISSP) by (ISC)2 oCisco Certified Network Associate (CCNA) or Network Professional (CCNP) oMicrosoft Certified Systems Administrator (MCSA) or Engineer (MCSE). 6.In-depth knowledge of Joint Commission and other applicable standards and regulations. Responsibilities: 1. Maintains current inventory of networked and integrated medical systems (including catalog of services, features, interconnections). 2. Conducts capital and service contract pre-purchase evaluations, researches vendors and assesses cost of ownership. 3. Coordinates security management process including risk (e.g., criticality and probability) and vulnerability analysis and related documentation associated with interconnected/integrated medical systems. 4. Coordinates with stakeholders a process to prioritize, develop and implement a plan to manage/mitigate identified risks associated with interconnected/integrated medical systems by applying appropriate administrative, physical and technical safeguards. 5. Maintains the integrity of FDA approval for interconnected/integrated medical systems. 6. Works with stakeholders to insure effective deployment, integration, and support of new medical systems into legacy systems and non-medical elements of the organization's information infrastructure. oWorks to ensure systems are deployed into an optimum (i.e., secure & supportive) environment. oContinually reviews system components to determine which are obsolete or otherwise no longer adequately supportable. oPlans for and implements component upgrades/replacement in a timely manner. 7. Identifies and manages appropriate software upgrades, security patches and anti-virus installs for interconnected/integrated medical systems according to industry best practices. 8. Conducts Root Cause Analysis (RCA) and Failure Mode Effects Analysis (FMEA) on incidents involving integrated medical systems and reports findings to appropriate stakeholders for follow-up action. 9. Monitors and adopts industry best practices to ensure integrity, availability & confidentiality of data maintained and transmitted across interconnected and integrated medical systems. 10. Educates stakeholders on security and other implications associated with the proliferation of interconnected and integrated medical technologies. 11. Supervises clinical engineering and other staff as necessary in clinical systems integration and infrastructure support (e.g., hybrid reporting structure, project supervision). 12. Works with stakeholders including Network Support, Disaster Recovery), Clinicians (System Users Including Physicians, Nurses, Technologists, Etc.), Medical System Manufacturers/Vendors, Risk Management, Information Security, Procurement / Purchasing / Materials Management, Clinical Engineering. Knowledge and Physical Requirements •Knowledge of the healthcare industry, including an understanding of hospital operations, alternate care providers or medical equipment manufacturers. •Medical equipment preventive maintenance, repair and handling experience.Able to read and understand technical manuals and electric/pneumatic schematics. •Business and financial management expertise, including ability to manage a budget, assist with contract and account margin maintenance and support district office operations. •Proficient computer skills, including Microsoft Office programs (Word, Excel, PowerPoint). •Strong customer service / relationship skills. •Willing to work flexible hours, including evenings, weekends, and holidays, as well as emergency off-hours as required. •Able to lift and/or push 75 pounds. •Valid US driver's license. •Full Time, 40 Hours/week, Monday - Friday, 8:00am - 4:30pm, Hybrid, onsite as needed per business needs •Travel to Regional Sites required. Applicants are subject to complete background search, motor vehicle records check, and drug screening before hire. Applicants must have a valid US Driver's License and be authorized to work in the US without Visa sponsorship.

We are seeking an experienced and strategic Engineering Manager/Regional Manager to lead and oversee a team of project managers tasked with planning, budgeting, and executing capital projects aimed at expanding facilities and enhancing production lines. This role is pivotal in supporting the Directors of Operations in capital budget development and ensuring the optimal allocation of engineering resources. Key Responsibilities: <ul> <li>Lead and mentor a team of primary project managers to deliver on capital projects from inception to completion.</li> <li>Collaborate with Directors of Operations to establish and manage capital budgets effectively.</li> <li>Oversee all construction activities, ensuring compliance with OSHA regulations and industry standards.</li> <li>Recruit, develop, and manage a skilled technical team with expertise in mechanical, electrical, industrial, and process engineering.</li> <li>Evaluate current processes, identify improvements, and implement changes to enhance quality and reduce costs.</li> <li>Train and develop project managers, trainees, and construction managers in advanced project management techniques.</li> </ul>Qualifications:<ul> <li>Bachelor's degree in Mechanical, Electrical, or equivalent experience.</li> <li>At least 12 years of relevant work experience; additional experience may substitute for formal education.</li> <li>Proven technical expertise in construction, refrigeration, poultry processing equipment, and project management.</li> <li>Demonstrated skills in problem-solving, negotiation, leadership, and schedule management.</li> <li>Willingness to travel frequently to plant and project sites, with up to 20% travel required.</li> </ul>

On-site Clinical Engineering Capital Manager.MUST have qualified experience as a CE Manager and BA Degree:(minimum) 4-10 years' Clinical Engineering manager experience. The Clinical Engineering Capital Manager provides the overall strategic direction, leadership, and operational management for capital technology projects for the hospital facilities and multiple sites to achieve financial and operating objectives set by the overall organization's business plan. The CE Manager will provide leadership and expertise for Clinical Engineering Staff. •Information Services (including network support, disaster recovery), Clinicians (system users including physicians, nurses, technologists, etc.). •Medical system manufacturers/vendors. •Risk management. •Information Services Security. •Procurement/purchasing/materials management, Clinical Engineering •Project Leadership, Equipment Inventory, Hiring & Training, Field Support & Projects Qualifications 1.Baccalaureate degree in Biomedical or Clinical Engineering or related 2.5-10 years' experience in clinical engineering and information systems. 3.Project management and planning skills/experience. 4.Strong communication and team building skills across functional areas. 5.Certification (completed or in process) preferred in one or more of the following: oCertified Clinical Engineer (CCE) oCertified Information Systems Security Professional (CISSP) by (ISC)2 oCisco Certified Network Associate (CCNA) or Network Professional (CCNP) oMicrosoft Certified Systems Administrator (MCSA) or Engineer (MCSE). 6.In-depth knowledge of Joint Commission and other applicable standards and regulations. Responsibilities: 1. Maintains current inventory of networked and integrated medical systems (including catalog of services, features, interconnections). 2. Conducts capital and service contract pre-purchase evaluations, researches vendors and assesses cost of ownership. 3. Coordinates security management process including risk (e.g., criticality and probability) and vulnerability analysis and related documentation associated with interconnected/integrated medical systems. 4. Coordinates with stakeholders a process to prioritize, develop and implement a plan to manage/mitigate identified risks associated with interconnected/integrated medical systems by applying appropriate administrative, physical and technical safeguards. 5. Maintains the integrity of FDA approval for interconnected/integrated medical systems. 6. Works with stakeholders to insure effective deployment, integration, and support of new medical systems into legacy systems and non-medical elements of the organization's information infrastructure. oWorks to ensure systems are deployed into an optimum (i.e., secure & supportive) environment. oContinually reviews system components to determine which are obsolete or otherwise no longer adequately supportable. oPlans for and implements component upgrades/replacement in a timely manner. 7. Identifies and manages appropriate software upgrades, security patches and anti-virus installs for interconnected/integrated medical systems according to industry best practices. 8. Conducts Root Cause Analysis (RCA) and Failure Mode Effects Analysis (FMEA) on incidents involving integrated medical systems and reports findings to appropriate stakeholders for follow-up action. 9. Monitors and adopts industry best practices to ensure integrity, availability & confidentiality of data maintained and transmitted across interconnected and integrated medical systems. 10. Educates stakeholders on security and other implications associated with the proliferation of interconnected and integrated medical technologies. 11. Supervises clinical engineering and other staff as necessary in clinical systems integration and infrastructure support (e.g., hybrid reporting structure, project supervision). 12. Works with stakeholders including Network Support, Disaster Recovery), Clinicians (System Users Including Physicians, Nurses, Technologists, Etc.), Medical System Manufacturers/Vendors, Risk Management, Information Security, Procurement / Purchasing / Materials Management, Clinical Engineering. Knowledge and Physical Requirements •Knowledge of the healthcare industry, including an understanding of hospital operations, alternate care providers or medical equipment manufacturers. •Medical equipment preventive maintenance, repair and handling experience.Able to read and understand technical manuals and electric/pneumatic schematics. •Business and financial management expertise, including ability to manage a budget, assist with contract and account margin maintenance and support district office operations. •Proficient computer skills, including Microsoft Office programs (Word, Excel, PowerPoint). •Strong customer service / relationship skills. •Willing to work flexible hours, including evenings, weekends, and holidays, as well as emergency off-hours as required. •Able to lift and/or push 75 pounds. •Valid US driver's license. •Full Time, 40 Hours/week, Monday - Friday, 8:00am - 4:30pm, Hybrid, onsite as needed per business needs •Travel to Regional Sites required. Applicants are subject to complete background search, motor vehicle records check, and drug screening before hire. Applicants must have a valid US Driver's License and be authorized to work in the US without Visa sponsorship.

Must be a U.S. Citizen due to U.S. government contracts.Employment is contingent upon the successful clearance of a background check. Must have 4 year college degree THE OPPORTUNITY Our client is seeking a full-time Senior Embedded Software Engineer reporting to the Director of Software Engineering on the Software Engineering team. The successful individual in this role will participate in the development of The Clients radios and advanced research projects.This is an opportunity to work on all aspects of the system including device drivers, networking functions and services, encryption, and security features. This position is on a hybrid schedule, a minimum of 3 days onsite per week is expected. On-site days are Mondays, Wednesdays, and Thursdays. The following is a list of at least some of the current essential job functions of the position. Management may assign or reassign duties and responsibilities at any time at its discretion. ROLE AND RESPONSIBILITIES •Implementation of software portion of MAC (Medium Access Control) and mobile ad-hoc networking routing protocols. •Network management software and web interface implementation. •Implementation of different security protocols and encryption algorithms. •Audio streaming and push to talk voice application implementation. •Analyze and improve product security and robustness to meet certain regulatory requirements such as NIST FIPS 140-3 and NIAP Common Criteria. •Implementation of testing software for product performance and reliability testing. •Device driver and board support package development and maintenance for both ARM and RISC-V based systems. •Linux system customization and scripting. REQUIRED QUALIFICATIONS •Minimum Bachelor of Science degree in Electrical Engineering or Computer Science or relevant fields. •5+ years of relevant embedded system software development experience. •Expertise in C programming and experience in Linux kernel driver development. •NOTE - Must be a U.S. Citizen due to U.S. government contracts.Employment is contingent upon the successful clearance of a background check. PREFERRED KNOWLEDGE, SKILLS, AND ABILITIES •Knowledge and experience of different security protocols and encryption algorithms such as suite of CNSA algorithms. •Experience with socket programming and various Internet/Ethernet protocols. •Understanding of MAC and Networking layer of a communication system. •Experience in AMD UltraScale+, MPSoC, and Microchip Polarfire SoC BSP support package development. •IPsec -Internet Protocol Security •Linux Interrupt Service Routine development. $135,000 - $200,000 a year The pay range is NOT a guarantee, is based on market research and peer data, and will vary depending on the candidate's experience and qualifications. NOTE - As a US Federal Contractor, Our Client requires that ALL candidates being considered for employment for any position (regardless of level) MUST be a U.S. Person (permanent resident or citizen).Stricter U.S. Citizen ONLY requirements (needed for some Engineering or R&D roles) will be included in the Required Qualifications section of the posted position.Employment is contingent upon the successful clearance of a background check. This does NOT apply to International positions; only job postings for positions located in the US. Our client is proud to be an equal opportunity employer, and we value diversity. We do not discriminate on the basis of race, color, age, religion or belief, ancestry, national origin, sex (including pregnancy), sexual orientation, gender identity and/or expression, marital, civil union or domestic partnership status, physical or mental disability, protected veteran status, genetic information, political affiliation, or any other factor protected by applicable federal, state, or local laws. We will ensure that individuals with disabilities are provided reasonable accommodation to participate in the job application or interview process, to perform essential job functions, and to receive benefits and privileges of employment. Please contact us to request accommodation.

Gables Search Group Interview Questions

Gables Search Group Interview Guides

Gables Search Group Interview Questions

Gables Search Group Salaries by Position

Gables Search Group Opening Jobs