Prepare for and practice interview questions from Averity.

Averity Interview Questions

Averity 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

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?

Averity Salaries by Position

We are looking for a Senior Software Engineer who is an expert in Python Development to join an early stage startup in accelerated growth mode. Who are we? We are an educational organization utilizing data to change the learning landscape and improve the advancement of fundamental education at the individual level. What is the job? We need a Senior Software Engineer who is an expert in Python who can join our team to advance our engineering systems in a number of different capacities. First and foremost we need someone who can incrementally advance our systems over time while maintaining the current capabilities. You will be responsible for designing, coding, updating, and implementing solutions. The core systems you will work on involve complex back-end data processing and automation.. It is imperative you have a strong understanding of Data and are capable of implementing robust data and pipeline automation solutions to improve efficiency. While the majority of your work will focus on the back-end, there will be front-end aspects of the role as well. This includes advancements to our UI creating a seamless end user experience. We are a small team and we are growing at a rapid pace. It is important to advance our engineering processes and tooling to provide the capabilities necessary to handle the evolution of our business. What skill-set is required to be successful? <ul><li>You are Senior level software engineer who brings 7+ years of production level experience</li><li>Expertise with Python developing back-end solutions and tooling</li><li>Experience developing robust data solutions including pipelining and automation</li><li>3rd Party API integrations</li><li>REST API development</li><li>Experience in both REST and GraphQL is ideal</li><li>Git for Version Control</li><li>Experience working on front-end in Typescript and React</li></ul> What is in it for you? This is an opportunity to join an extremely fast paced organization that is highly mission driven in the advancement of American Youth Education. Your work will directly impact education at the individual level. In addition we have 100% revenue growth year over year for the last five years. We offer a highly competitive compensation and benefits package that includes: <ul><li>Base Salary up to $190,000</li><li>Unlimited PTO</li><li>Medical, Dental, Vision</li><li>100% remote working environment working in the EST Time Zone</li><li>Childcare service memberships and much more!</li></ul> Please apply now for immediate consideration, we are reviewing profiles and setting up interviews ASAP. At this time we are only capable of supporting US Citizens and Green Card holders. Please no 3rd applications at this time.

We are looking for a Lead Full-Stack Software Engineer who is an expert in Javascript/Typescript to join our team in New York City. If that sounds like you and want to get in on the ground floor of an innovative funded startup, then check this out! Who are we? We are an early stage generative AI startup headquartered in NYC focused on disrupting and transforming the global recruitment landscape. What is the job? You will join the CEO, Director of Sales, and Director of Operations in a hybrid capacity in the New York City office as the first Engineering hire in the US. Working closely with the CTO you will take on a number of responsibilities including hands-on development and technical leadership surrounding our offshore development teams. This includes code reviews and overseeing the core development processes. Your core development responsibilities will include full-stack Javascript/Typescript development of our Generative AI HR platform and tooling. You will touch all aspects of the stack including Front-End (React), Back-End (Node/Nest), as well as portions of the AI. From a leadership perspective you will ensure all functions are merged into a cohesive codebase. What are the requirements for the role? <ul><li>Technical Leadership - developing and overseeing technical projects from start to finish</li><li>10+ years of Hands-on Engineering experience</li><li>Experience with code reviews, establishing best practices, and improving engineering standards</li><li>In-depth knowledge of architecture and system design</li><li>Expertise in Javascript, Typescript, React, and Nest.js</li><li>Database experience utilizing MongoDB and Prisma</li><li>Knowledge of DevOps and the deployment of new applications and features</li></ul> What is in it for you? This is an opportunity to get in on the ground floor of an early stage funded startup with high and fast growth potential. We are offering an excellent fully comprehensive compensation and benefits package that includes: <ul><li>Base Salary: Up to $220,000 DOE</li><li>Excellent Equity Package</li><li>Performance based bonus incentives</li><li>Medical, Dental, Vision, 401k, Unlimited PTO, and much more!</li></ul> This is a Hybrid role in New York City on-site 3 days a week. We are reviewing resumes and setting up screens ASAP. Please apply today for immediate consideration, we reviewing

How would you like to become a Data/MLOps Engineer at an AI-centric performance management tech company? This is a fully remote role (and always will be) that is a high priority to fill. What's the Job? As one of our Data/MLOps Engineers, you'll be working with other experienced and high-performing engineers/data professionals on our Data Ingestion team (currently a team of 6). Initially, you will continue the work we have started on building our new Data Warehouse, migrating from Redshift to Snowflake, and pipelining all our product data into it. You'll then help develop the MLOps infrastructure, which is the next phase of our development. We currently have two AI/ML models in production and are looking to host our own LLMs in the future. Ideal candidates are Data Engineers with an interest in MLOps, or MLEs/MLOps Engineers who are open to doing the initial Data Engineering work, knowing the role will become more MLOps-focused in the future. We highly value flexible engineers who can work across all data-related aspects of engineering. We primarily use Python, SQL, Snowflake (migrating from Redshift), Airflow, dbt, Databricks, and Kafka. This is a fully remote position and always will be. There won't be any sudden back-to-office announcements. We officially bring the Engineering team together once every six months, and some of the engineers meet sporadically at their convenience (for example, we have several engineers in the NYC area). Who Are We? We are using AI to create the pinnacle of performance management platforms. As part of our Data Ingestion team, you'll play a crucial role in ensuring the data we need is primed for AI-driven insights. We are a remote-first company, and this is a fully remote position. What Skills Do I Need? <ul><li>Experience building data pipelines and data warehouses using Python, SQL, dbt, Airflow, and Snowflake.</li><li>Experience building machine learning model infrastructure for deployed models.</li><li>Experience working in cross-functional teams, including Data Engineers, Data Scientists, Software Engineers, etc.</li><li>Strong plus if you have built APIs for Slack/chatbots, used the Databricks platform, and have experience with event-driven systems using Kafka.</li></ul> Compensation: <ul><li>$150,000 Base Salary</li><li>Equity</li><li>Bonus Eligible</li><li>401(k) with matching</li><li>Full Benefits (Health, Dental, Vision)</li><li>Loads of other perks (too many to name)</li><li>Fully Remote</li></ul>

How would you like to be a Full-Stack Data Engineer at an NYC hedge fund that continually outperforms the market and has doubled its AUM in under 2 years! What's The Job? As our new Full-Stack Data Engineer, you will join a senior engineer with decades of experience in our space and a risk analyst who will be your team's liaison to the traders/portfolio managers. You'll own our data and databases and spearhead new integration projects on the roadmap. You need to know SQL and databases well, along with programming capabilities in Python or C#. A prominent project you will work on is to help us build the infrastructure for our intra-day pricing systems. This is a highly visible role. The company is 33 teammates strong and looking to grow further by the end of the year. You'll get to interact closely with everyone, including the partners. This is a position great for someone who has a keen interest in the asset management space and wants to be an integral part of a high-performing shop. Who Are We? We have over a decade of success in asset management, and we currently have approximately $10B AUM entrusted to us. We focus on liquid credit markets. We just moved to a new office in Union Square, and while our traders are in the office 5 days a week, you and other engineers can operate on a hybrid schedule (2-3 days a week in the office). There is no requirement for you to be in the office 5 days a week, but you are welcome to be if you prefer. What Skills Do You Need? <ul><li>Hands-on experience with SQL, Postgres, etc., and know databases (on-prem) inside out</li><li>Experience with Redis or other in-memory databases</li><li>Experience with time-series databases</li><li>Proficiency in Python or C# for programming</li><li>Docker</li><li>Good communication skills to explain technical concepts to non-technical teammates</li><li>Minimum of 3 years of professional experience</li><li>Ideally, you have experience in corporate credit, bonds, derivatives, etc.</li></ul> Compensation: <ul><li>$140,000 - $160,000 Base Salary</li><li>Yearly Discretionary Bonus</li><li>401(k)</li><li>Full Benefits - 100% of premiums covered</li></ul> What's In It For You? This is a great opportunity for a talented Full-Stack Data Engineer to make their mark at a high-performing company where your efforts will be rewarded significantly. If you want to be part of a small dynamic team, paving the data journey for the entire company and seeing tangible business outcomes and rewards at the end of it, this is for you. While you don't need experience in the asset management world for this position, if you have a keen interest in financial markets, this position will excite you as you'll get to interact closely with the traders and portfolio managers on a daily basis.

Join Us as a Staff Data Scientist at the Forefront of Digital Marketing Content Creation Overview : Are you passionate about leveraging data to drive business success? We're seeking a talented Staff Data Scientist to spearhead projects and drive innovation in our dynamic environment. As a key member of our team, you'll have the opportunity to develop cutting-edge machine learning models, optimize ad performance, forecast trends, and much more. If you thrive in a collaborative environment and are ready to make a significant impact, we want to hear from you. Responsibilities : Lead end-to-end development of machine learning models, from conception to deployment, addressing diverse challenges such as ad performance optimization, overall account health assessment, forecasting, and clustering. Collaborate closely with the Head of Data and CTO to align data science initiatives with organizational goals and strategies. Mentor and support the growth of junior Data Scientists/Analysts, fostering a culture of continuous learning and professional development. About Us: We're at the forefront of the digital marketing landscape, combining unparalleled expertise in digital marketing with innovative content creation strategies. Trusted by world-renowned brands, we empower our clients to stand out from the competition through creative and impactful marketing solutions. Conveniently located in Long Island City, our office offers a hybrid work model, providing flexibility and a vibrant work environment. Requirements: Proven experience as a Data Scientist, with a track record of successfully translating projects from proof of concept to production, driving consistent and substantial revenue growth. Proficiency in developing machine learning models from scratch using Python, along with expertise in key libraries and frameworks such as TensorFlow and PyTorch. Strong communication skills, with the ability to effectively convey complex data insights to non-technical stakeholders, including C-suite executives, and demonstrate the positive impact on business outcomes. Master's or PhD in relevant field. Compensation / Benefits: Competitive compensation package, including a base salary bonus of up to $200,000. Comprehensive benefits package, including health, dental, and vision coverage. 401(k) plan with matching contributions, supporting your long-term financial goals.

ML Ops/Python Data Engineer - Data Ingestion Team We are transforming HR data into actionable insights through AI and machine learning, enabling organizations to improve performance, engagement, and retention. The Data Ingestion Team plays a critical role in ensuring that our data platform is robust, scalable, and prepared for the future of AI-driven insights. As an ML Ops/Python Data Engineer, you will work closely with data engineers, data scientists, and software engineers to build and maintain the infrastructure that powers our machine learning models and data ingestion systems. You'll collaborate on designing, deploying, and refining data pipelines, chatbots for Slack, and various API integrations, ensuring seamless interaction between systems and supporting AI and ML initiatives. Key Responsibilities: <ul><li>Develop and maintain data pipelines using Python, DBT, Airflow, and Redshift, with a focus on scalability and efficiency. Explore and potentially integrate Snowflake for future data storage solutions.</li><li>Work on building chatbots and data engines that leverage APIs, particularly for Slack, enabling dynamic and real-time data interaction.</li><li>Collaborate with cross-functional teams, including data engineers, data scientists, and software engineers, to train, deploy, and maintain ML models.</li><li>Design and implement data platforms, focusing on scalability, efficient decision-making, and seamless system integration.</li><li>Contribute to both the ML Engineering/ML Ops efforts, ensuring the proper deployment and lifecycle management of models.</li><li>Work closely with the DevOps team to integrate Kafka for event-driven architecture, with a focus on triggers and events that track units of action across the board.</li><li>Collaborate with product teams to define and evolve platform features, ensuring a product-oriented approach that meets client needs.</li><li>Provide input on system design and decision-making processes, especially as the team shifts toward a more AI-focused roadmap over the next 6 months.</li></ul> Requirements: <ul><li>Mid to Senior-level experience in Python development, with a focus on data engineering, API integrations, and ML Ops.</li><li>Experience with data platforms and pipelines using tools such as DBT, Airflow, Redshift, and potentially Snowflake.</li><li>Familiarity with Databricks for machine learning and data processing.</li><li>Strong understanding of system design and decision-making in a data-driven environment.</li><li>Experience working with event-driven systems, particularly using Kafka.</li></ul>

Averity Interview Questions

Averity Interview Guides

Averity Interview Questions

Averity Salaries by Position

Averity Opening Jobs