The Kayak Data Analyst interview guide, interview questions, salary data, and interview experiences.

Kayak Data Analyst Interview Guide

Getting ready for an Data Analyst interview at Kayak? The Kayak Data Analyst interview span across 10 to 12 different question topics. In preparing for the interview:
<ul>
<li>Know what skills are necessary for Kayak Data Analyst roles.</li>
<li>Gain insights into the Data Analyst interview process at Kayak.</li>
<li>Practice real Kayak Data Analyst interview questions.</li>
</ul>
Interview Query regularly analyzes interview experience data, and we've used that data to produce this guide, with sample interview questions and an overview of the Kayak Data Analyst interview.


Getting ready for an Data Analyst interview at Kayak? The Kayak Data Analyst interview span across 10 to 12 different question topics. In preparing for the interview:

- Know what skills are necessary for Kayak Data Analyst roles.
- Gain insights into the Data Analyst interview process at Kayak.
- Practice real Kayak Data Analyst interview questions.

Interview Query regularly analyzes interview experience data, and we've used that data to produce this guide, with sample interview questions and an overview of the Kayak Data Analyst interview.
        

Overview

Kayak Data Analyst Salary

We've gathered this data from parsing thousands of interview experiences sourced from members.

We've gathered this data from parsing thousands of interview experiences sourced from members.

Kayak Data Analyst Interview Process

As part of the financial management in a large corporation, the CFO wants to review the expenses in all departments for the previous financial year (2022).

Write a SQL query to calculate the total expenditure for each department in 2022. Additionally, for comparison purposes, return the average expense across all departments in 2022.

Note: The output should include the department name, the total expense, and the average expense (rounded to 2 decimal places). The data should be sorted in descending order by total expenditure.

<h3>Example:</h3>

Input:

<code>departments</code> table

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td>id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>name</td>
<td>VARCHAR</td>
</tr>
</tbody>
</table>
<code>expenses</code> table

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td>id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>department_id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>amount</td>
<td>FLOAT</td>
</tr>

<tr>
<td>date</td>
<td>DATE</td>
</tr>
</tbody>
</table>
Output:

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td>department_name</td>
<td>VARCHAR</td>
</tr>

<tr>
<td>total_expense</td>
<td>FLOAT</td>
</tr>

<tr>
<td>average_expense</td>
<td>FLOAT</td>
</tr>
</tbody>
</table>

Calculate total and average expenses for each department.

Department Expenses

The probability that it will rain tomorrow is dependent on whether or not it is raining today and whether or not it rained yesterday.

If it rained yesterday and today, there is a 20% chance it will rain tomorrow. If it rained one of the days, there is a 60% chance it will rain tomorrow. If it rained neither today nor yesterday, there is a 20% chance it will rain tomorrow.

Given that it is raining today and that it rained yesterday, write a function <code>rain_days</code> to calculate the probability that it will rain on the nth day after today.

Example:

Input:

<pre tabindex="0" class="chroma"><code>n=5
</code></pre>

Output:

<pre tabindex="0" class="chroma"><code>def rain_days(n) -&gt; 0.39968
</code></pre>

Given that it is raining today and that it rained yesterday, write a function to calculate the probability that it will rain on the nth day after today.

Rain in N Days

Let’s say that you’re a data scientist at Robinhood. 

How do we measure the launch of Robinhood’s fractional shares program?

Let’s say you are a data scientist at Robinhood.

Robinhood is introducing a program to allow users to buy fractional shares of publically listed companies.

Focusing in on the activity of new users, which of the following metrics would be the LEAST important to keep track of in determining if the program added value to Robinhood’s platform for new users?

Let's say you are a data scientist at Robinhood. 



Robinhood is introducing a program to allow users to buy fractional shares of publically listed companies.



Focusing in on the activity of new users, which of the following metrics would be the LEAST important to keep track of in determining if the program added value to Robinhood's platform for new users?

Fractional Shares Metrics

Fractional Shares

Kayak Data Analyst Interview Questions

KAYAK, part of Booking Holdings (NASDAQ: BKNG), is the world’s leading travel search engine. With billions of queries across our platforms, we help people find their perfect flight, stay, rental car, cruise, or vacation package. We’re also transforming the in-travel experience with our app and new accommodation software. For more information, visit www.KAYAK.com.

As an employee of KAYAK, you will be part of a global network that includes OpenTable and KAYAK's portfolio of metasearch brands including Swoodoo, checkfelix, momondo, Cheapflights, Mundi and HotelsCombined. Many employees are dedicated to one brand, but we all have the benefit of using each others strengths and insights. Together, we're able to help people experience the world through dining and travel.

KAYAK seeks a Senior Product Manager with e-commerce expertise to enhance our travel booking experience for leisure and business products. The ideal candidate has API experience in the travel industry and is dedicated to creating seamless, engaging booking experiences. You will optimize checkout processes, boost partner bookings, and prioritize projects through collaboration.

This role will be required to work from our Cambridge or Concord, MA office at least 3 days per week.

In this role, you will: Be responsible for the booking and servicing experience and roadmap for all platforms (but particularly across our mobile website and apps).
Define and prioritize user problems and needs, accounting for multiple verticals, brands, locales and languages.
Support the expansion of booking and servicing on KAYAK through new suppliers and partners to meet the goals of our leisure and business (K4B) offerings.
Craft feature requirements, weighing impact against goals and technical feasibility.
Become a booking funnel maven, encouraging knowledge of our partner inventory, data and accuracy complexities, payment options, add-ons, drop-off points, until you’re recognized as the chief advocate for how booking on KAYAK offers the most value to travelers and partners.
Build and cultivate positive relationships with both internal and external partners, working closely with them to understand their needs and motivations and design solutions that match user needs and partner interest.
Align team members across the organization around common goals.
Measure and analyze insights from product changes, chasing agreed upon metrics and the opportunities our data, user research and A/B experiment results might reveal.
Work with customer support and UX to collect feedback from and respond to users.
Supervise competitive landscape and stay informed about both travel and e-commerce spaces, especially within Flights, and the latest capabilities across multiple platforms.

Please apply if you have: A consumer-centric attitude and a background in e-commerce or B2C.
Specific experience in working with travel-related APIs and booking flows, with knowledge of New Distribution Capability (NDC) as a plus.
Experience supporting product strategy and collaborating with engineering teams to advocate for user needs and drive solutions.
Familiarity with tailoring development approaches for web and mobile platforms based on use cases and constraints.
Proficiency in data analysis, including running SQL queries and using data to drive focus and team alignment.
Collaboration skills with team members from all levels of the business, across time zones.
Ability to align product opportunities with business goals and support that with thoughtful decisions and clear communication.
Personal experience as a regular traveler, offering firsthand insight into user challenges during trip planning and online booking.
BS degree or equivalent experience required, technical background strongly preferred, MBA or similar experience advantageous.

Benefits And Perks 4 weeks paid vacation
Ability to work from almost anywhere
Day off on your birthday
Generous retirement plans
Amazing health, dental and vision insurance plans
Flexible Spending Accounts
Headspace Subscription
No Meeting Fridays
Drinks, coffee, snacks, games etc.
Weekly catered lunches
Flexible hours
Regular team events/excursions
Universal Paid Parental leave

Diversity and Inclusion We aspire to have a workplace that reflects all of the diverse communities we serve. We know that when we have diverse teams we produce more creative ideas, products, and better outcomes for our team members. OpenTable/KAYAK is proud to be an Equal Opportunity Employer and we welcome and encourage candidates from all backgrounds and experiences to apply for roles on our team. Whoever you are, just be you.

We will ensure that individuals with disabilities are provided reasonable accommodation to participate in the job application or interview process, to perform job responsibilities, and to receive other benefits and privileges of employment. Please contact us to request accommodation.

#J-18808-Ljbffr

This role is 100% on-site in our Carmel, IN office. The Data Analyst’s role is to design data modeling/analysis services used to mine enterprise systems and applications for knowledge and information that enhance business processes. This individual is responsible for assisting in building, deploying, and maintaining data support tools, metadata inventories, and definitions for database file/table creation. The Data Analyst will also assist in the development and operation of the BI/data warehousing practice, including optimizing processes and technologies, and ensuring a high availability BI/data warehouse platform. This individual will participate in defining data standards and warehouse architecture models. KEY RESPONSIBILITIES Strategy & Planning<ul><li>Devise, develop, and deploy required data visualizations and underlying data queries in response to business user needs.</li><li>Maintain appropriate documentation to support usage of visualizations and queries</li><li>In conjunction with data owners and department managers, develop data models and protocols for mining production databases.</li><li>Assist in the development of data management policies and procedures.</li><li>Identify research questions, problem solve using data analysis, and communicate the results to various stakeholders</li><li>Ensure best practices are established for effective problem resolution for a high availability, 24/7, global environment. </li><li>Analyze existing operations and make recommendations for the improvement and growth of the BI/EDW architecture.</li></ul> Operational Management<ul><li>Work with application development staff to coordinate the creation and management of data visualizations and queries.</li><li>Collaborate with unit managers, end users, development staff, and other stakeholders to integrate data management applications with existing systems. </li><li>Provide and apply quality assurance best practices for data analysis services across the organization.</li><li>Develop, implement, and maintain change control and testing processes for modifications to data models.</li><li>Create data definitions for new database file/table development and/or changes to existing ones.</li><li>Develop routines for end users to facilitate best-practice use of data management tools.</li><li>Monitor data management system details within the database, including stored procedures and execution time, and implement efficiency improvements.</li><li>Diagnose and resolve data warehouse access and performance issues.</li></ul> PHYSICAL DEMANDS<ul><li>Must be able to sit or stand for extended periods of time and interact with computers, telephone and other electronic media.</li><li>Overtime hours may be required to meet project deadlines.</li></ul> QUALIFICATIONS<ul><li>Bachelor’s Degree in Information Technology, Computer Science, or a related field required.</li><li>Previous work experience delivering data and business intelligence solutions and integrations with a bias to best leverage existing applications and tools.</li><li>Ability to work independently, as well as part of a team, on multiple projects.</li></ul> PERSONAL ATTRIBUTES<ul><li>Excellent written and oral communication, and decision-making skills.</li><li>Excellent interpersonal skills and desire to work with business users to understand problem areas and formulate a solution.</li><li>Ability to conduct and direct research into IT issues and products as required.</li><li>Self-motivated, self-directed, personally accountable, and operate with a sense of integrity.</li><li>Demonstrate critical thinking and problem-solving skills with ability to effectively prioritize and execute tasks in a high-pressure environment.</li></ul> KNOWLEDGE & EXPERIENCE<ul><li>Strong technical knowledge of data management systems, data warehousing methodology, data quality, data modelling, data governance, analytics, and predictive modeling.</li><li>Extensive knowledge of SQL, data manipulation languages, and Microsoft’s BI suite.</li><li>Experience working in a DevOps environment utilizing techniques such as code versioning (e.g. git), code review and agile software development</li><li>Proven experience in BI/data warehousing planning and development.</li><li>Strong understanding of relational database structures, theories, principles, and practices.</li><li>Hands-on experience with data mining, large-scale data modeling, and business requirements gathering/analysis.</li><li>Experience with data processing flowcharting techniques.</li><li>Proven project management experience.</li></ul>

• Data entry and data analysis experience in a complex environment• Team player with a continuous improvement mindset, keen attention to detail, and excellent time management skills• Self-starter with intellectual curiosity and drive who can proactively identify and prevent potential problems in an ambiguous environment• Strong problem-solving, collaborative and communication skills with the ability to work well under pressure and effectively balance multiple concurrent demands and appropriately prioritize responsibilities• Proficiency in the Microsoft Office suite with the ability to create data models using Microsoft Excel• Discretion and confidentiality regarding sensitive information • Reconciling, entering and updating resource data which received on a weekly and monthly basis• Performing weekly and monthly data validation to ensure data correctness• Uploading and validating business case data• Performing analysis of resource data• Supporting business case level resource management• Supporting capital allocation process• Testing Hilton resource tool changes• Partnering with Business Management, HR, and Finance to support resource-based decisions

This is a contract role for 12 Months in our San Jose Office. Job Overview:We’re looking for a marketing data analyst to join the Demand Generation Activation team in our San Jose office on a 12-month contract. Our team is made up of three functions, data & analytics, marketing automation, and paid media. You’ll be joining our data & analytics function.You will work closely with the other data analysts in our team as well as colleagues in the digital team, developer marketing team and the broader demand generation campaign team. This is an excellent opportunity for a collaborative and eager-to-learn individual looking to grow their marketing and digital data knowledge and abilities by joining a dedicated team with deep expertise.Responsibilities:<ul><li>Adobe Analytics Reporting: Build and maintain reports in Adobe Analytics Workspace to support the marketing department and other digital platform owners.</li><li>Data Integration and Queries: Write SQL queries in Google Cloud Platform’s BigQuery to combine Adobe Analytics web data with other data sources including CRM, email, digital ad channels and social media channels to support cross-channel reporting.</li><li>Audience Segmentation: Use Adobe Analytics or BigQuery to define and set up target audiences based on behavioral traits, user profiles, and account profiles.</li><li>Dashboard Development: Create dashboards using Power BI, integrating data from our data mart (in Google Cloud Platform’s BigQuery) and other relevant sources.</li><li>Communicate insights and findings from your analysis to colleagues, both technical (your data team colleagues) and non-technical marketing colleagues.</li></ul>Required Skills and Experience :<ul><li>Marketing Data Expertise: Familiarity with marketing data (both transactional and digital), including campaign tracking, web activity, CRM data, UTM parameters, and lead generation.</li><li>SQL Proficiency: Writing of SQL queries, creating relationships, and joining data from multiple sources.</li><li>Adobe Analytics Proficiency: Experience with Adobe Analytics Workspace, creating segments, calculated metrics, and understanding core dimensions and measures.</li><li>Dashboard Tools: Experience with Power BI or similar BI tools (e.g., Looker, Tableau) for visualizing and reporting data.</li></ul>“Nice To Have” Skills and Experience :<ul><li>Experience with JavaScript, Python, or R programming.</li><li>Familiarity with API endpoints and webhooks for data activation purposes.</li><li>Familiarity with data modeling in dbt, common table expressions, joins, and groupings.</li><li>Experience creating data pipelines, or familiarity with ETL / ELT processes.</li></ul>

About the Program:People Tech Technology is pleased to offer a comprehensive Data Training Program designed for individuals looking to start a career in data science and analytics. This program aims to equip participants with the essential skills and knowledge required to become proficient data professionals.Key Responsibilities:<ul><li>Training Participation: Attend and actively engage in all training sessions, workshops, and assignments.</li><li>Learning and Development: Utilize training materials, complete exercises, and participate in discussions to deepen understanding of data science and analytics concepts.</li><li>Project Work: Apply learned skills by working on real-world projects and assignments with guidance from experienced mentors.</li><li>Data Analysis: Conduct data cleaning, analysis, and visualization using various tools and techniques.</li><li>Collaboration: Work collaboratively with peers and mentors to foster a productive learning environment.</li><li>Feedback and Improvement: Provide and receive constructive feedback to and from peers and mentors to continually improve skills and program experience.</li></ul>What You Will Learn:<ul><li>Data Fundamentals: Understanding data types, data collection, and data cleaning techniques.</li><li>Statistics and Probability: Basic concepts of statistics and probability used in data analysis.</li><li>Programming for Data Science: Using programming languages such as Python or R for data manipulation and analysis.</li><li>Data Visualization: Creating visualizations using tools like Matplotlib, Seaborn, or Tableau.</li><li>Machine Learning: Introduction to machine learning concepts, algorithms, and model evaluation.</li><li>Big Data Technologies: Understanding big data frameworks like Hadoop and Spark.</li><li>SQL and Databases: Writing SQL queries and understanding database management.</li><li>Data Storytelling: Communicating insights effectively through data storytelling and presentation.</li></ul>Qualifications:<ul><li>Education: Masters in Computer Science, Statistics, Mathematics, Engineering, or a related field (or currently pursuing one).</li><li>Basic Programming Knowledge: Familiarity with basic programming concepts, preferably in any programming language.</li><li>Passion for Data: Demonstrated interest in data science and analytics.</li><li>Analytical Skills: Strong analytical and problem-solving skills.</li><li>Communication Skills: Strong verbal and written communication skills.</li></ul>Preferred Skills (Not Mandatory):<ul><li>Prior Experience with Data: Any prior experience with data analysis or related fields is a plus.</li><li>Knowledge of Statistics: Basic understanding of statistical concepts and methods.</li></ul>Benefits:<ul><li>Hands-on Training: Gain practical experience through real-world projects.</li><li>Mentorship: Receive guidance and support from experienced data professionals.</li><li>Career Opportunities: Potential for full-time employment opportunities upon successful completion of the program.</li><li>Networking: Connect with industry professionals and like-minded peers.</li></ul>

<h3>Job Description</h3><div>Job Description<div>POSITION NO: 201381 POSITION: Data Analyst NATURE OF POSITION: Full-Time (Exempt Administrative, 260 days), 1.0 FTE (This is a grant-funded position) ORGANIZATIONAL RELATIONSHIP:The position of Data Analyst reports to the Director of Institutional Effectiveness and Planning. There are no supervisory duties. PURPOSE/SUMMARY OF JOB:This position is funded through a U.S. Department of Education Hispanic-Serving Institutions Program (STEM) Title III grant (Award # P031C210103) and Title V MI CASA grant (Award #P0315230272). The Data Analyst is responsible for coordinating, managing, and reporting on internal and external data collection and analysis related to grant reporting, institutional research, event participation, and other data of various forms to contribute to the objectives and goals of each grant. Specific activities include assisting with the grant planning and developing processes, preparing reports for grant reporting and internal communication, collaboration with faculty and staff, event participation for planning and review, and data retrieval, analysis, presentation, and communication from a variety of internal and external sources. The Data Analyst will uphold the College's Guiding Principles, and work to actively promote inclusivity, celebrate diversity, and ensure equal opportunities. The position will include work from the MCC Fort Morgan campus, and also have an occasional need to travel. Some remote work may be appropriate based on the business needs and/or work cycle of the position. ESSENTIAL JOB FUNCTIONS:<ol><li>Collaborates closely with other grant and college staff to contribute to efforts on the collection, compilation, and analysis of data, recommend changes, and promote data-informed choices using Banner, Cognos, Navigate, Recruit, Evaluation Kit, and other institutional data systems. (30%)</li><li>Coordinates the development and keeps regular maintenance of grant specific data and methods of data collection and corresponding documentation including but not limited to performance measures for each grant objective, cohort data, and event numbers. (30%)</li><li>Prepare and disseminate appropriate internal communications and conduct trend reporting and analysis as needed to maximize the use of data. (15%)</li><li>Coordinates with grant staff to analyze and review grant initiatives, performances of events, and other projects. (10%)</li><li>Assists in data-oriented sections of the grant Annual Performance Report. (5%)</li><li>Develops and maintains a master calendar and/or schedule for grant/institutional data collection and dissemination processes. Facilitates a process to increase direct access to data by college employees. (5%) </li><li>Other duties as assigned. (3%)</li><li>Based on the functions, this position has been identified as a Campus Security Authority. As a Campus Security Authority, the incumbent in this position is required to report allegations of Clery Act crimes that they become aware of to the Vice President of Student Services at Morgan Community College. Various trainings pertaining to these responsibilities may be required. (1%)</li><li>All MCC employees are responsible for ensuring their work and educational environments are free from illegal discrimination, sexual harassment, and related retaliation. When alleged or suspected discrimination, sexual harassment, or retaliation is experienced or observed by, or made known to, an MCC employee, the employee is responsible for reporting that information to one of the following individuals: the Title IX Coordinator or the Deputy Title IX Coordinator. Attends training pertinent to these responsibilities as required. (1%)</li></ol> REQUIRED QUALIFICATIONS:<ul><li>Bachelor's degree in data analysis, statistical interpretation, research, or related field from a regionally accredited institution. A combination of education and professional level experience performing similar duties to those described for this position may substitute.</li></ul><ul><li>Experience with database management and reporting; ability to examine data to determine outcomes and trends. </li><li>Ability to think critically and diplomatically ascertain information needs</li><li>Strong, self-driven learning ability</li><li>Excellent oral and written communication skills. </li><li>Strong attention to detail. </li><li>Strong interpersonal skills. </li><li>Strong organizational and time management skills. </li><li>Excellent analytical and problem-solving skills. </li><li>Ability to handle multiple tasks and prioritize duties. </li><li>Proficiency in Excel and strong MS Office skills. </li><li>Ability to meet deadlines and to work independently.</li></ul> PREFERRED QUALIFICATIONS:<ul><li>Master's degree in a field related to data analysis, statistical interpretation, research, or related field. </li><li>Experience in higher education. </li><li>Experience with one or more of the institutional data systems including but not limited to Banner, Cognos, Navigate, Recruit, Evaluation Kit, etc. </li></ul> RESPONSIBILITY AND DECISION MAKING:This position performs data extraction, analysis, and institutional support using a variety of programs to track measures and communicate with the grant directors and other needed parties. The day-to-day operations include problem solving, analyzing, and coordinating data that are used in the operation and reporting of the grant. This position will consistently exercise discretion and equity and apply analytical skills to the performance of advanced work/daily duties. This position works with staff and faculty from across the institution. There are no supervisory responsibilities. Job Posted by ApplicantPro </div></div>

Title: Clinical Safety Analytics Associate (Data Analyst)Location: Princeton New Jersey 08540 (Hybrid)Duration: 6+ Months Must Have List:<ul><li>4+ years of Data Analyst experience</li><li>Intermediate to Advanced skills with Tableau or Qlik</li><li>Extensive experience with SQL and Python or R or SAS</li><li>Strong communication skills</li><li>Biopharma experience preferred</li><li>Bachelor's or Master's (preferred) degree in a relevant field, such as Biostatistics, Analytics, Engineering or related discipline.</li></ul> Summary:<ul><li>Clinical Safety Analytics Associate will play a critical role within the PV CoE. This position focuses on assisting with analyzing data and deriving insights from clinical and safety data sources to generate evidence and support decision making across the organization.</li><li>The Associate will leverage a variety of analytics and visualization techniques to contribute to research, clinical development, drug safety and post-marketing activities.</li></ul> Roles & Responsibilities<ul><li>Collaborates and works closely with cross-functional teams, including data analysts/engineers and business stakeholders, to understand their needs and gather requirements</li><li>Cleans, transforms and pre-processes data to ensure data quality, consistency and compatibility for analysis</li><li>Develops and implements data analysis plans to answer clinical and safety questions</li><li>Applies analytical and/or statistical techniques to analyze data and generate insights on safety questions</li><li>Visualizes data and results to share insights with technical and non-technical cross-functional stakeholders</li><li>Interprets and communicates findings through reports, presentations and visualizations</li><li>Stays up to date and compliant with the regulatory landscape related to drug safety and data analyses</li><li>Works closely with PV CoE and other stakeholders, sharing knowledge and best practices within the broader safety and analytics teams</li></ul> Skills & Competencies<ul><li>Strong understanding of data sources, such as clinical trial data, electronic health records, and other healthcare databases</li><li>Proficiency in data pre-processing, cleaning and transformation techniques to ensure data quality and compatibility for analysis</li><li>Knowledge of relevant analytical and statistical methodologies, such as regression analysis, survival analysis etc.</li><li>Excellent problem-solving skills and the ability to derive meaningful insights from complex real-world data sets</li><li>Excellent communication and presentation skills to effectively convey complex concepts and findings</li><li>Ability to work collaboratively in cross-functional teams and manage multiple projects simultaneously</li><li>Strong attention to detail and accuracy in data analysis and interpretation</li></ul> Experience<ul><li>Bachelor's or Master's (preferred) degree in a relevant field, such as Biostatistics, Analytics, Engineering or related discipline.</li><li>Minimum of 3-5 years of experience in data analysis, statistical modeling, and data visualization, preferably within the biopharma or healthcare industry.</li><li>Experience applying statistical and analytical techniques, to analyze real world data</li><li>Experience with Python or R or SAS and SQL required</li><li>Working knowledge of visualization tools, such as Tableau or Power BI</li><li>Experience or familiarity with the biopharma industry</li></ul>

Position: Data ConsultantsPay Rate: $47.83Duration: 1 YEARLocation: Charlotte, NC Must Haves: <ul><li>Advanced, expert Excel skills is mandatory (5+ years)</li><li>Moderate-to-advanced SQL skills is also mandatory (5+ years)</li><li>Data mining experience (7+ years)</li><li>Analytics experience – dissect, distill, and simplify data (7+ years)</li></ul> Day to Day:The role provides critical end to end production support of metric reporting routines. The reports/dashboards are shared with senior executives within and outside of the organization to drive proper risk culture and business strategy. Given the level of the audience, report dashboards and executive summaries must be pristine and error free. Data analytics responsibilities may include, and are not limited to, trending analysis, and success analytics to identify areas of discrepancy and possible at-risk controls. The work includes data mining, data aggregation, business metrics, SPI inventory output analysis, risk program metrics analysis, and performance/milestone analytics. Success measures for this role include:<ul><li>Consistent, timely delivery of reporting requirements using existing macros and code</li><li>Proactive identification of code or macro breaks</li><li>Successful application of macro/code fixes and creation</li><li>Demonstrated ability capture, manipulate and clean data from multiple sources and systems of record</li><li>Applied critical eye to catch errors or discrepancies</li><li>Reliable application of advanced Excel and SQL skills to produce reporting in an efficient, timesaving manner</li><li>Ability to remain nimble and positive when priorities change and Adhoc needs arise</li><li>Shows a sense of urgency and attention to detail as standard work practice</li><li>Strong collaboration</li><li>Significant attention to detail</li><li>Effective prioritization of workbench deliverables</li><li>Timely follow-up on reporting requests and questions</li><li>Experience working in a highly regulated industry or financial institution</li><li>Has previously interacted with senior level managers</li><li>Created dashboard reports or analytics</li></ul>

Kayak Data Analyst Interview Guide

Overview

Kayak Data Analyst Salary

Kayak Data Analyst Interview Process

Kayak Data Analyst Interview Questions

Kayak Data Analyst Jobs