Prepare for and practice interview questions from Aeg.

Aeg Interview Questions

Aeg 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

In an A/B test, how can you check if assignment to the various buckets was truly random?

In an A/B test, which of the following is a common method to determine if the assignment to the test groups was truly random?

In an A/B test, which of the following is a common method to determine if the assignment to the test groups was truly random?

Random Bucketing

Aeg Salaries by Position

In order to be considered for this role, after clicking "Apply Now" above and being redirected, you must fully complete the application process on the follow-up screen. The Utah Hockey Club is seeking a Digital Product Manager to oversee digital products and drive fan engagement, experiences and enhancements for our fans through our digital platforms. This role will oversee app, website, sms, and email platforms. The ideal candidate should have experience working within existing app and web environments and have experience implementing customer-facing digital solutions across web, mobile, and apps. Prior experience working with professional sports teams or athletes is highly preferred. This position is based in Salt Lake City, Utah, and reports directly to the Director of Marketing DUTIES & RESPONSIBILITIES: <ul> <li>Collaborate with marketing leadership, key stakeholders, and users across the Utah </li><li>Hockey Club to define the product vision, strategy, features, and prioritization. </li><li>Lead the ongoing development and execution of the product roadmap for the Utah Hockey Club's apps and digital platforms. </li><li>Work with cross-functional teams, including but not limited to Marketing, Business Analytics, Ticketing, New Business, Corporate Partnerships, and Game Presentation on utilization, optimization, and activations. </li><li>Track and report on product performance, helping evaluate future investments and growth opportunities. </li><li>Manage the functional design process by integrating a deep understanding of user needs and technical capabilities. </li><li>Translate the product roadmap into clear product requirements, including features, user stories, and test acceptance criteria. </li><li>Play a key role in defining user experience strategies for users, including fans and partners </li><li>Establish workflows for efficient management and deployment of digital product updates </li><li>Be flexible and adaptable in a fast-paced, dynamic environment to continuously assess the business needs, refine priorities, outline milestones and deliverables, and identify risks and opportunities </li><li>Protect the reputation of the company </li><li>Exemplify the Utah Jazz mission and values: transparent, all in, community obsessed, one team, and scrappy </li><li>Accept other duties, as assigned </li></ul>COMPETENCIES: <ul> <li>Collaborative </li><li>Effective communication </li><li>Customer focused </li><li>Quality decision making </li><li>Able to manage complexity </li></ul>QUALIFICATIONS: <ul> <li>Bachelor's Degree </li><li>Three years digital product work experience (sports or entertainment preferred) </li></ul>PHYSICAL DEMANDS: <ul> <li>This person must be able to communicate and express themselves both written and verbally. </li><li>This person must be able to observe, inspect, estimate and assess. </li><li>This person must be able to sit, stand, bend, walk, and climb stairs for long periods of time. </li><li>This person must be able to lift 20 lbs. </li></ul> The Utah Hockey League provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, and training. 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 other benefits and privileges of employment. Please contact us at recruiting@utahjazz.com to request accommodation. Note: The need may arise to revise, supplement, or rescind portions of this job description, and the Utah Hockey League reserves the right to do so at any time. Employees shall be required to meet the qualifications and perform the duties of any revised job description

Ticket Operations & Analytics Manager Reports to: Vice President, Ticket Sales & Service Location: Hillsboro, OR Full Time/Permanent ***Applications will close on November 30th; Interviews will be scheduled throughout December 2024 until filled. About the Hops The Hillsboro Hops are a single-A affiliate of the Arizona Diamondbacks. Located in Hillsboro, Oregon, approximately 15 miles west of Portland. The Hops currently play at Hillsboro Ballpark but are in the middle of major construction of a brand new ballpark in partnership with the City of Hillsboro. The world class entertainment venue will open in time for the 2026 baseball season and will host a full season of High A baseball, but concerts, community events and more. They have won three (3) Championship Titles since 2013 and were awarded the Bob Freitas Award in 2017, given to the best operators in Minor League Baseball. RoleThe Ticket Operations & Analytics Manager will be responsible for maintaining and managing the Hops' ticketing system (ProVenue), overseeing the Box Office on event days, and identifying key metrics from ticket sales data to help drive future revenue. General Responsibilities <ul> <li>Act as primary liaison regarding upkeep and maintenance of the Hops ticketing system, ProVenue (Tickets.Com) in addition to GiveX, FEVO, and other ticketing programs. </li><li>Master the administration and back-end management of the ticketing system software and demonstrate skills in processing and reconciling all sales transactions. </li> <li>Assist with maintenance and selection of CRM - including annual set up of relevant products, updates to pricing, maintenance of interactions with other programs, and all other items required to ensure all sales/customer data are accurate and meet the needs of all departments of the organization. </li><li>Provide relevant training to other departments on CRM and ticket systems as needed. </li><li>Utilize the ticket system to provide detailed financial records and reconciliation for all ticket sales on a daily, seasonal, and yearly schedule. </li><li>Maintain care of ticket office equipment including hardware, software, and supplies. </li><li>Provide game-day support in ticket resolution, customer service, and will call. </li><li>Manage loaded value tickets, vouchers, and finances related to store value tickets. </li><li>Manage event access control, make sure all scanners and equipment are operational and properly set, and provide accurate information. </li><li>Design and develop ticket stock and related items, negotiate ticket printing services with providers. </li><li>Monitor all seat inventory including holds to maximize ticket sales revenue. </li> <li>Ensure online functionalities for all sales links and online account management for ticket holders. </li><li>Coordinate digital ticket distribution for all tickets including season ticket plans, suites, sponsors, individuals, players, and complimentary accounts. </li><li>Work with the VP of Ticket Sales to help establish the annual ticket sales budget and ongoing reports to support ticket sales in meeting annual goals. </li> <li>Provide daily ticket sales reports to management and provide data to the sales team for blasts and call lists. </li> <li>Prepare accurate required ticket sales reports for MLB. </li><li>Oversee all complimentary ticket requests, which involves processing all staff requests, and VIPs, preparing complimentary ticket allotments, and processing all ticket requests and player/umpire tickets. </li><li>Facilitate data collection through the ticketing system, including data needed for purchases, traits for buyers, and merging data with outside sources, while keeping data current in the CRM system. </li> <li>Identify key metrics that will help drive sales revenue and attendance. </li><li>Work closely with the Sales and Marketing teams in developing new outreach strategies and targeted campaigns. </li><li>Fulfill specific database requests from both the management team and the sales team regarding renewals, ticket sales, campaign tracking, and other initiatives. </li><li>Collect, cleanse, and analyze data through in-stadium data capture. </li></ul>Required Qualifications <ul> <li>Minimum of bachelor's degree, preferably in Sports Management, Accounting, Analytics, or related field. </li><li>At least two years prior ticket office or customer relations experience preferred. </li><li>Able to work flexible hours including nights, holidays, and weekends, including Hops home games with additional hours included for office work. </li></ul>Compensation Salaried; $55,000/yr, plus bonus structure (when eligible). Flex time throughout the season. Benefits include paid vacation, Simple IRA plan, and medical and dental insurance/coverage. Organization Goals The Hillsboro Hops commit to enhancing the quality of life for the residents and businesses of the Portland-Metro area by providing affordable, family entertainment while developing baseball professionals. This will be achieved by: <ul> <li>Taking a leadership role in the community </li><li>Operating a fiscally responsible and sustainable business </li><li>Maintaining reasonable prices </li><li>Providing unique and memorable experiences </li></ul> Job Questions: <ol> <li>What ticketing system(s) do you have experience working with? </li><li>How many years of experience with ticketing systems? </li></ol>We are an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, national origin, sex, sexual orientation, age, disability, gender identity, marital or veteran status, or any other protected class. Job Questions: <ol> <li>What ticketing system(s) do you have experience working with? </li><li>How many years of experience do you have with ticketing systems? </li> </ol>

In order to be considered for this role, after clicking "Apply Now" above and being redirected, you must fully complete the application process on the follow-up screen. Overview The Engineering Manager will supervise, direct, plan, schedule, and monitor all building maintenance programs and monitor special projects related to facility systems (i.e., mechanical, electrical, and plumbing - "M.E.P."), structural repairs/changes, grounds repairs/changes. This role will pay a salary of $60,000 to $75,000. For FT roles: Benefits: Health, Dental and Vision insurance, 401(k) savings plan, 401(k) matching, and paid time off (vacation days, sick days, and 12 holidays) This position will remain open until Dec 31, 2024. Responsibilities <ul> <li>Effectively manage full-time and part-time engineering and maintenance staff including; managing performance, ensuring quality of work, motivating, training and developing staff, and creating cohesion for a harmonious work and team environment. </li><li>Properly schedule full-time and part-time staff to cover facility operating hours in an efficient and effective manner. </li><li>Assign specific work tasks and monitor progress as to timeliness and quality of results. </li> <li>Develop training programs that ensure that all staff members are proficient in operating and maintaining all related building M.E.P. systems. </li> <li>Manage, operate, monitor, repair and maintain the facility's audio-visual, environmental controls, emergency power, electrical, HVAC and lighting systems as required for the safe and efficient operation of the facility. </li> <li>Attend weekly staff meetings. Develop and maintain effective working relationships with other Moody Center departments. </li><li>Develop, implement, document, and maintain effective facility maintenance policies, procedures, and programs. To include P.M. software program tracking - HVAC systems and equipment, electrical systems and equipment, refrigeration systems and equipment, kitchen systems and equipment, structural systems, facility hardware systems and equipment, and facility material handling and specialty equipment. </li> <li>Oversee and provide cause for proper control and care of M.E.P. inventories of supplies, spare parts, shop tools and equipment. Oversee and provide cause for proper maintenance shop(s) conditions to be maintained to safe working conditions, safe working procedures, and in a clean and orderly work environment. </li><li>Oversee related contracted maintenance agreements. Develop bid specifications, renew agreements, and manage all other related items to ensure that acceptable and quality performance levels are achieved. </li><li>Rotate with other facility personnel to function as Manager on Duty (MOD), who maintains total responsibility and authority over all clients, staff personnel, patrons, security, and safety in assigned buildings. Responsibilities include but not limited to making sure contractual agreements are met and clients' event requirements and changes have been made in a timely fashion.On-duty staff/subcontractors ultimately report to the MOD through any Managers or Supervisors who are present during the event. </li> <li>Frequent bending, lifting 50+ pounds, sitting, exposure to multiple external elements, extensive walking through the building. </li></ul>Qualifications The qualifications listed below represent the credentials necessary to perform the essential functions of this position. To be successful in this position, an individual must be able to perform each essential duty satisfactorily. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions. <ul><li>High School diploma or GED and two (2) year degree or certificate of completion in any or all the fields of HVAC., electrical, or refrigeration from an advanced technical support school, institution, or related association </li> <li>3-5 years related experience in the public assembly industry (stadiums, arenas, and/or or convention centers) preferred or equivalent combination of education and experience. </li> <li>Demonstrate knowledge in operational procedures, facility capabilities, industry terminology, event-related services, and technical requirements for the types of events anticipated at the facility. </li> <li>Knowledge of methods, techniques, and procedures to repair and maintain all mechanical, electrical and event-related equipment. </li> <li>Understand and guarantee that all laws, building codes, ordinances, policies, procedures, risk management and emergency procedures are followed - this includes local and state. </li> <li>Possess skills and experience in supervising/training personnel. </li> <li>Experience with budget preparation and purchasing. </li><li>Possess any licenses, certificates or training required by local, state, or national authorities for the operations of the equipment found in the facility. </li> <li>Have basic understanding and working knowledge of commercial refrigeration. </li> <li>Have basic understanding and working knowledge of chemicals and water treatment. </li> <li>Respond to routine, precautionary and emergency alarms from building automation and life safety systems.Follow and adhere to all safety precautions and procedures. </li> <li>Read and comprehend blueprints, drawings, and other related materials. </li> <li>Meet the physical demands of this job, which include being able to get in and around the facility (requires personal mobility), lifting, carrying, moving, climbing, working from various heights, and moderate to loud noises. </li> <li>Experience with operating large-scale events in a stadium or concert setting of a similar size (15,000+ seats) is highly desirable. </li> </ul>Working Conditions: <ul><li>Minimal Travel (< 10% travel): May be required to travel. Trips may require air travel and/or overnight stay away from home for one or more nights. </li> <li>Must be able to work a flexible schedule inclusive of weekends, nights and holidays required </li> </ul>

In order to be considered for this role, after clicking "Apply Now" above and being redirected, you must fully complete the application process on the follow-up screen. Job Title:Research Scientist Intern Department: Hockey Strategy and Analytics Reports to: Senior Research Scientist Duration: 10 weeks (June to August 2025) **All internships roles will require you to be in-office at the United Center and we do not provide any relocation or housing assistance** Perks and Benefits: FREE: breakfast, lunch, parking, on-site gym and training classes, casual dress environment, social events, volunteer opportunities, and focused learning and development. What It's Like Working Here: The Chicago Blackhawks experience isn't just on the ice.Our office, located in the United Center, promotes a fun, engaging, fast-paced and collaborative atmosphere where we can celebrate both hockey and each other.Our commitment to curating an environment where all individuals feel empowered to bring their best self to work each day can be seen throughout our organization.Whether you are a job seeker looking to join the organization, a current member of our amazing team, or someone looking to help support our mission, our goal is the same - to reimagine the potential of hockey through memorable, inclusive experiences. The Top Shelf: The Chicago Blackhawks are hiring a Research Scientist Intern to conduct foundational research at the intersection of Artificial Intelligence and ice hockey. This position will work in close collaboration across the Hockey Strategy and Analytics group with Research Scientists, Data Scientists, and Software Engineers. How You'll Contribute: <ul><li>Produce research at the intersection of Artificial Intelligence and sports, specifically related to multiagent systems and reinforcement learning with in-game data </li><li>Develop deep learning models in Python that build on the Blackhawks' existing infrastructure </li><li>Build Python and SQL pipelines to process and load data from external vendors and internal models </li><li>Work with software engineers to design and build front-end tools that make models available to internal stakeholders </li></ul> Player Stats and Qualifications: <ul><li>Currently pursuing a Bachelor's, Master's, or PhD Degree in Computer Science, Data Science, Statistics, Engineering, or other quantitative field of study </li><li>Familiarity with Python, Java, C++ or other object-oriented programming language </li><li>Knowledge of computer science fundamentals including data structures </li><li>Preferably knowledge and curiosity with concepts related to multiagent systems, reinforcement learning, game theory, or other areas of Artificial Intelligence </li><li>Preferably knowledge with deep learning concepts and experience with libraries such as Tensorflow and PyTorch </li><li>Demonstrable project and research experience through coursework, personal projects, prior internships, or publications </li><li>Ability to address, adapt to, and overcome challenges in a fast-paced, dynamic environment </li><li>Demonstrated aptitude for driving results </li><li>High attention to detail </li><li>Demonstrates Chicago Blackhawks core values of integrity, curiosity, empathy, collaboration, and originality </li></ul> The Team: The Chicago Blackhawks started their journey as one of the NHL's "Original Six" professional ice hockey teams in 1926.Members of the Central Division in the NHL's Western Conference and six-time Stanley Cup Champions (1934, 1938, 1961, 2010, 2013, 2015), the team calls the United Center home. The Chicago Blackhawks proudly show up every day to make Chicago Proud and reimagine the potential of hockey.At its core, the team and greater organization uphold its mission through its core values centered around integrity, curiosity, empathy, collaboration, and originality.They are fiercely dedicated to evolving and delivering new and legendary fan experiences and captivating new and diverse audiences, both on and off the ice.As part of their unwavering commitment to drive impact and purpose in the Chicago community, the organization opened the Fifth Third Arena (the team's official practice facility and community space for youth hockey development), continues to make expansions to the Chicago Blackhawks Foundation, and acquired the AHL team the Rockford IceHogs. The Chicago Blackhawks continue to grow in its commitments to honor and celebrate Black Hawk's legacy by offering our platforms, making meaningful contributions, collaborating with Native American people, and reimagining ways to support the many Native American people and communities they live amongst and alongside. They engage in this work through their formal partnership with Black Hawk's ancestral tribe, the Sac and Fox Nation of Oklahoma, which the tribe established with the Chicago Blackhawks in 2021. The Chicago Blackhawks is an equal opportunity employer that values diversity at all levels.All individuals, regardless of personal characteristics, are encouraged to apply.All qualified applications will receive consideration for employment without regard to gender, race, religion or religious creed, color, gender identity, gender expression, national origin, ancestry, physical or mental disability, medical condition, marital status, registered domestic partner status, age, sexual orientation, military or veteran status, or any other basis protected by federal, state, local law, ordinance, or regulation and will not be discriminated against on these bases.

Nashville SC is looking for highly motivated college students interested in being a part of the Major League Soccer team in Nashville. The ideal candidates will demonstrate initiative, the ability to multi-task, a willingness to learn and a positive attitude. Please apply at https://nashvillesoccerclub-cfcrk.formstack.com/forms/internship_application. DUTIES & RESPONSIBILITIES: <ul><li>Assist in the development of strategic, well-educated ideations and conceptual plans to produce business solutions, including key performance indicators and measurement strategies </li><li>Develop key reports, dashboards, and analyses to be utilized in the daily management of the business</li><li>Work with our Data Engineer to learn new data retrieval techniques and maintain current processes </li><li>Assist in Salesforce maintenance, including contact and account creation and removing duplicate records </li><li>Assist in daily data hygiene maintenance to ensure good data integrity throughout numerous data sources</li><li>Complete ad-hoc projects and reports to address specific business questions and produce action-based insights</li><li>Research industry-leading practices to provide analyses, insights, and innovation</li></ul> DESIRED QUALIFICATIONS: <ul><li>Strong communication skills and willingness to learn</li><li>Energetic and passionate when it comes to using data to solve real business problems</li><li>Ability to work independently and as part of a team</li><li>Computer proficient in Microsoft Word, Excel, and PowerPoint</li><li>Experience with a programming language (Python, R, SQL, etc.) </li><li>Visualization skillsets preferred (Tableau, PowerBI, etc.)</li></ul> REQUIREMENTS: <ul><li>Enrolled in an undergraduate or graduate program AND eligible for college credit</li><li>Area of Study: Finance, Mathematics, Computer Science, Business, Economics, Operations Research, Statistics, Engineering, Sports Management, or related field</li><li>Available to be in Nashville office 20-25 hours per week during normal business hours</li></ul> Please apply at https://nashvillesoccerclub-cfcrk.formstack.com/forms/internship_application. We are an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, national origin, sex, sexual orientation, age, disability, gender identity, marital or veteran status, or any other protected class.

In order to be considered for this role, after clicking "Apply Now" above and being redirected, you must fully complete the application process on the follow-up screen. Department:Ballpark Operations Reports to:Assistant General Manager - Ballpark Operations Classification: Full-Time/Exempt Summary/Objective The Manager, Facilities (Engineering) is responsible for CACTI Park of the Palm Beaches physical plant, ensuring the optimal functioning of building systems, including mechanical, electrical, fire/life safety, elevator and other services. The Manager will perform and/or oversee preventative maintenance tasks and repairs on HVAC, electrical, fire/life equipment, stadium sound, scoreboard, lighting, IT infrastructure, pool/spa and other systems. This position will be responsible for identifying and selecting qualified vendors; preparing and administering service contracts; and managing maintenance projects and repairs. Manager should have the ability to perform the installation, repair and operation where required/possible. Essential Functions & Responsibilities Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. <ul> <li>HVAC maintenance and repair.</li> <li>Selection and oversight of electricians and electrical projects.</li> <li>Plans, organizes and executes proper maintenance of all mechanical, electrical, fire/life equipment and systems, and elevators.</li> <li>Establishes effective communication with all internal and external stakeholders to ensure issues are identified and resolved effectively.</li> <li>Ensures that preventive maintenance procedures are carried out on a scheduled basis and completes maintenance records for all equipment.</li> <li>Recommends replacement of equipment whenever necessary and evaluates new equipment for its durability and values.</li> <li>Ensures functionality of electronic systems on fields, including scoreboards and press box.</li> <li>Perform a wide variety of work tasks, including but not limited to, concrete repair, fence repair, floor repair, wall/drywall repair, ceiling repair, door repair, caulking, welding, hanging signs/banners, painting, lighting, cleaning, pressure washing, etc.</li> <li>Conduct daily, weekly and monthly inspections of all assigned areas.</li> <li>Maintains records of completed maintenance and repair work.</li> <li>Attends regular meetings with Assistant GM - Ballpark Operations and other key staff to prioritize maintenance needs.</li> <li>Assists with the preparation of the annual department budget.</li> <li>Other duties as assigned.</li> </ul> Education and/or Experience & Skills Required <ul> <li>Associate degree in construction technology or related field.</li> <li>Facilities engineer experience (5 years) in stadium, office or commercial building.</li> <li>Knowledge of occupational hazards and safety precautions involved with the maintenance, repair, and operation of buildings, grounds, and operating systems.</li> <li>Contributes to a motivating, rewarding, and productive work culture that promotes continuous learning.</li> <li>Ability to effectively interact with staff, tenants, department heads and officials, the public, and contract services providers.</li> <li>Ability to communicate effectively, both orally and in writing.</li> <li>Responsible, organized and detail oriented.</li> <li>Must pass criminal background check.</li> </ul> Preferred <ul> <li>Experience with iPaaS solutions (e.g., Informatica Cloud)</li> <li>Experience with Azure environment/toolsets (e.g., blob storage, SQL DW)</li> <li>Experience executing an ELT model for cloud data warehousing</li> <li>Familiarity with utilizing data from REST APIs and Amazon S3</li> <li>Experience with visualization toolsets (e.g., PowerBI, Spotfire, Tableau)</li> </ul> Work Environment This job operates both in an outdoor and office setting depending on the nature of work. This role routinely uses standard office equipment such as computers, phones and photocopiers. The noise level is usually moderate but can be loud within the stadium environment. Physical Demands Work requires sufficient physical strength, agility, endurance, dexterity and hand-eye-foot coordination to perform all essential duties. Work requires sitting for long periods of time, standing and walking, and kneeling, crawling, bending, climbing stairs and ladders. Work may expose the employee to potential severe weather, chemical hazards, biological hazards; and physical hazards. Work requires the use of safety clothing and equipment, and compliance with safety rules and procedures, as needed. Position Type and Expected Hours of Work This is a full-time position, and hours of work and days are Monday through Friday, 8:30 a.m. to 5 p.m. Ability to work a flexible schedule, including extended hours, evenings, weekends and holidays. May be called after regular working hours to respond to emergency maintenance and repair needs. Travel Rare travel may be expected for this position. Other Duties Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities and activities may change at any time with or without notice. We are an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability status, protected veteran status, or any other characteristic protected by law. EOE/M/F/Vet/Disability Experience Preferred <ul><li>4 </li> </ul>

Aeg Interview Questions

Aeg Interview Guides

Aeg Interview Questions

Aeg Salaries by Position

Aeg Opening Jobs