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

Agoda Data Analyst Interview Guide

Getting ready for an Data Analyst interview at Agoda? The Agoda Data Analyst interview span across 10 to 12 different question topics. In preparing for the interview:
<ul>
<li>Know what skills are necessary for Agoda Data Analyst roles.</li>
<li>Gain insights into the Data Analyst interview process at Agoda.</li>
<li>Practice real Agoda 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 Agoda Data Analyst interview.


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

- Know what skills are necessary for Agoda Data Analyst roles.
- Gain insights into the Data Analyst interview process at Agoda.
- Practice real Agoda 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 Agoda Data Analyst interview.
        

Overview

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.

Agoda Data Analyst Interview Process

Machine Learning

Regularization and Validation

Xgboost vs Random Forest

Statistics

P-value to a Layman

A/B Testing

Button AB Test

Probability

Random Seed Function

You have a function that outputs a random integer between a minimum value, $N$, and a maximum value, $M$. Call this function $X$.

Take the output from the random integer function and place it into another random function as the max value with the same min value $N$. This second function you can call $Y$.

<ol>
<li>What would the distribution of the samples look like?</li>

<li>What would be the expected value?</li>
</ol>

Given a function that outputs a random integer between a min value N and a max value M, and then uses the output as the max value for a second function with the same min N, what is the expected value?

Given a function that outputs a random integer between a min value N and a max value M, and then uses the output as the max value for a second function with the same min N, what is the expected value?

Random Seed Function I

What does the Law of Iterated Expectation state for two random variables X and Y?

What does the Law of Iterated Expectation state for two random variables X and Y?

Random Seed Function II

Let’s say your team at Spotify wants to determine if a recently launched feature, curated playlists, has increased user engagement. However Spotify launched the feature without an A/B test.

How would you measure the effect of curated playlists on user engagement?

How would you establish causal inference to measure the effect of curated playlists on engagement without A/B?

Causal Inference Without A/B

You’re a data analyst working for Burlington studying customer behavior during the annual Black Friday shopping spree. Each customer may visit the store multiple times throughout the day and make several purchases across different product categories. The marketing team wants to understand which customer segments were most engaged.

Write a SQL query to compute the following metrics for each product category:

<ol>
<li>Total number of unique customers who purchased from that category</li>
<li>Average spend per customer (rounded to 2 decimal places)</li>
<li>Percentage of customers who made more than one purchase in that category (rounded to 2 decimal places)</li>
</ol>

Sort the final results in descending order by average spend per customer.

Notes:

<ul>
<li>A “purchase” means a single row in the purchases table.</li>
<li>A customer who buys multiple items in one visit still counts as multiple purchases.</li>
<li>If a customer purchased from a category only once, they should not count toward the “multiple purchase” percentage.</li>
<li>Every category present in the purchases table should appear in the output.</li>
</ul>

Schema

Input

<code>purchases</code> table

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

<tbody>
<tr>
<td>purchase_id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>customer_id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>category</td>
<td>VARCHAR</td>
</tr>

<tr>
<td>amount</td>
<td>DECIMAL</td>
</tr>

<tr>
<td>purchase_time</td>
<td>DATETIME</td>
</tr>
</tbody>
</table>
Output

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

<tbody>
<tr>
<td>category</td>
<td>VARCHAR</td>
</tr>

<tr>
<td>unique_customers</td>
<td>INTEGER</td>
</tr>

<tr>
<td>avg_spend_per_customer</td>
<td>DECIMAL</td>
</tr>

<tr>
<td>pct_multi_purchase_customers</td>
<td>DECIMAL</td>
</tr>
</tbody>
</table>
Example

Input

<code>purchases</code> table

<table>
<thead>
<tr>
<th>purchase_id</th>
<th>customer_id</th>
<th>category</th>
<th>amount</th>
<th>purchase_time</th>
</tr>
</thead>

<tbody>
<tr>
<td>1</td>
<td>101</td>
<td>Electronics</td>
<td>120</td>
<td>2025-11-28 09:10:00</td>
</tr>

<tr>
<td>2</td>
<td>101</td>
<td>Electronics</td>
<td>80</td>
<td>2025-11-28 10:00:00</td>
</tr>

<tr>
<td>3</td>
<td>102</td>
<td>Clothing</td>
<td>40</td>
<td>2025-11-28 11:15:00</td>
</tr>

<tr>
<td>4</td>
<td>103</td>
<td>Electronics</td>
<td>300</td>
<td>2025-11-28 13:30:00</td>
</tr>

<tr>
<td>5</td>
<td>102</td>
<td>Electronics</td>
<td>150</td>
<td>2025-11-28 14:10:00</td>
</tr>

<tr>
<td>6</td>
<td>102</td>
<td>Clothing</td>
<td>10</td>
<td>2025-11-28 16:20:00</td>
</tr>

<tr>
<td>7</td>
<td>103</td>
<td>Clothing</td>
<td>50</td>
<td>2025-11-28 17:20:00</td>
</tr>
</tbody>
</table>
Output

<table>
<thead>
<tr>
<th>category</th>
<th>unique_customers</th>
<th>avg_spend_per_customer</th>
<th>pct_multi_purchase_customers</th>
</tr>
</thead>

<tbody>
<tr>
<td>Electronics</td>
<td>3</td>
<td>216.67</td>
<td>33.33</td>
</tr>

<tr>
<td>Clothing</td>
<td>2</td>
<td>50.00</td>
<td>50.00</td>
</tr>
</tbody>
</table>
Explanation

For Electronics, there are three unique customers: 101, 102, and 103. Their spend amounts are 200 for customer 101 (120 + 80), 150 for customer 102, and 300 for customer 103, giving an average spend of 216.67. Only customer 101 made more than one purchase, so the multi-purchase rate is 33.33%.

For Clothing, there are two unique customers: 102 and 103. Customer 102 spent a total of 50 (40 + 10), while customer 103 spent 50, resulting in an average of 50.00. Customer 102 is the only one with multiple purchases, leading to a multi-purchase rate of 50.00%.

Write a SQL query to compute metrics for each product category.

Black Friday Shopping Spree

Agoda Data Analyst Interview Questions

<div><h2>Job Opportunity</h2>In this role, you will play a pivotal part in supporting our government customer in state-based exchange oversight. This role requires project coordination with hands-on data analytics and centers around delivering timely, accurate insights across multiple workstreams that inform program decisions. The ideal candidate understands policy and process methodologies and will work closely with CMS stakeholders to support initiatives based on business needs and innovation opportunities. Success in this role will also depend on your ability to communicate effectively, adapt to changing requirements, and deliver high-quality outputs with precision. If you are a continuous learner and thrive in a dynamic, fast-paced environment, this opportunity is an excellent fit for you.Key Responsibilities:<ul><li>Collect, analyze, and organize information and data</li><li>Gather and document requirements</li><li>Develop, update, and maintain detailed working instructions and SOPs</li><li>Take detailed meeting notes using plain language and active voice and monitor action items</li><li>Manage communication, coordination and track the progress and performance of tasks according to the project schedule</li><li>Document and track project Risks, Issues and Actions, and Lessons Learned, and Process Improvements</li><li>Maintain an organized repository of project information and data on the project and customer SharePoint sites, including use of workflows and dashboards</li><li>Develop and adhere to project plans and provide regular status updates</li><li>Ensure project remains compliant with all policy, processes, and guidelines</li><li>Collect, clean, and analyze health-insurance data for reporting and decision making</li><li>Support grant applications and reporting with tracking, training, supporting documentation</li><li>Assist customers with research, data summaries, and impact assessments</li><li>Communication with internal and external teams and stakeholders</li><li>Lead team members and stakeholders to anticipate and manage changes to multiple projects, such as but not limited to, technical requirements, business requirements, and schedule</li><li>Drive innovation and work proactively</li></ul>Required Minimum Qualifications:<ul><li>Bachelor's Degree (Public Health or related field preferred) or equivalent OR 4 years' relevant experience in lieu of degree.</li><li>Minimum 2 years' relevant experience or 6 years' relevant experience without a degree.</li><li>Proficiency with Microsoft Suite (PowerPoint, Excel, Word)</li><li>Attention to detail and commitment to high-quality</li><li>Ability to utilize SharePoint and Excel as the primary means for reporting</li><li>Working knowledge of Tableau reporting and Power BI</li><li>Analytical problem-solver</li><li>Continuous learner</li><li>Excellent verbal and written communication skills (customer facing interactions)</li><li>Adaptability in expectations and requirements from the customer.</li><li>Must be a US Citizen and a resident of the US for at least the last 3 years.</li></ul>Preferred Qualifications:<ul><li>CAPM or PMP</li><li>Centers for Medicare & Medicaid Services experience</li><li>State-based or Federally Facilitated Health Insurance Exchange experience</li><li>Policy and rulemaking experience desirable</li><li>Grants experience</li><li>Customer relationship management experience is a plus</li><li>Excellent SharePoint skills</li></ul>Compensation Ranges: Compensation ranges for ASM Research positions vary depending on multiple factors; including but not limited to, location, skill set, level of education, certifications, client requirements, contract-specific affordability, government clearance and investigation level, and years of experience. The compensation displayed for this role is a general guideline based on these factors and is unique to each role. Monetary compensation is one component of ASM's overall compensation and benefits package for employees.EEO Requirements: It is the policy of ASM that an individual's race, color, religion, sex, disability, age, gender identity, veteran status, sexual orientation or national origin are not and will not be considered in any personnel or management decisions. We affirm our commitment to these fundamental policies. All recruiting, hiring, training, and promoting for all job classifications is done without regard to race, color, religion, sex, veteran status, disability, gender identity, or age. All decisions on employment are made to abide by the principle of equal employment.Physical Requirements: The physical requirements described in "Knowledge, Skills and Abilities" above are representative of those which must be met by an employee to successfully perform the primary functions of this job. Reasonable accommodations may be made to enable individuals with qualifying disabilities, who are otherwise qualified, to perform the primary functions.Disclaimer: The preceding job description has been designed to indicate the general nature and level of work performed by employees within this classification. It is not designed to contain or be interpreted as a comprehensive inventory of all duties, responsibilities and qualifications required of employees assigned to this job.</div>

Company DescriptionNxtEverest is a digital startup based in Silvassa, specializing in providing IT services and consulting. Our diverse clientele includes technology, furniture and home building companies. We work closely with clients across the US and India to deliver innovative digital solutions. Role Description This is a full-time on-site role for a Data Analyst at NxtEverest in Silvassa. The Data Analyst will be responsible for analyzing data, creating data models, and communicating insights to internal teams and clients. The day-to-day tasks will involve utilizing analytical skills, data analytics, statistics, and data modeling to support business decisions and strategies. Qualifications <ul><li>Analytical Skills, Data Analytics, and Statistics</li><li>Strong Communication skills</li><li>Data Modeling expertise</li><li>Proficiency in relevant statistical tools and software</li><li>Attention to detail and problem-solving abilities</li><li>Bachelor's degree in Data Science, Statistics, Computer Science, or related field</li><li>3+ Experience in a similar role or industry is a plus</li></ul>

<h3>Job Description</h3><div>Job Description<div>Company Description Integres, LLC is a Service-Disabled Veteran Owned Small Business (SDVOSB) which was established to provide high quality, insightful, agile information technology-based solutions to its customers. Integrity is a foundational element of everything we strive to do. We seek to develop solutions which respond to the evolving challenges that today’s organizations face using our own unique combination of industry best practices, and evolving techniques and technologies. We started Integres with the intent of building "a company with a soul". As such, we take a servant-leadership approach as the long-term strategy for our success. We are cultivating a corporate family culture which demands excellence and accountability while putting a premium on work/life balance. We empower and support our employees to contribute to achieving our corporate goals by interacting with our customers as true partners, rather than treating their engagement as just another job. We seek to be good corporate citizens and encourage and promote employee participation in community and volunteer work.Job Description The Data Analyst leads complex analytical projects and delivers data-driven insights related to compliance, oversight, and trend analysis. This role involves advanced data research, integration of multiple data sources, and expert analysis to support personnel vetting and security operations.Key Responsibilities<ul><li>Provide analytical leadership and guidance on compliance, oversight, and trend reporting</li><li>Perform highly complex data analysis, including merging and reconciling data from multiple databases</li><li>Apply subject matter expertise in personnel vetting and security disciplines to analyze data within enterprise systems</li><li>Conduct data quality assessments, data linkage, analysis, and interpretation</li><li>Design and develop programs to manage, validate, and maintain data integrity</li><li>Create reports, dashboards, visualizations, and presentations for stakeholders</li><li>Perform statistical analysis, including descriptive analytics, predictive analysis, and regression modeling</li><li>Use advanced analytic techniques such as data cleaning, literature reviews, and secondary data analysis</li><li>Utilize tools such as Salesforce, Power BI, SQL, and other analytical platforms as appropriate</li></ul>Qualifications <ul><li>5+ years of experience working with enterprise systems, including:<ul><li>Salesforce (VA-CABS)</li><li>Oracle</li><li>PeopleSoft (HR Smart)</li><li>USAStaffing</li><li>USAccess</li><li>IT Account Provisioning and Deprovisioning systems</li></ul></li></ul>Education<ul><li>Bachelor’s Degree (required)</li></ul> Additional Information Integres offers competitive salaries bolstered by a comprehensive benefits package, which provides safety and security for our employees and their families. Our generous benefits package includes<ul><li>Healthcare and Insurance: medical, dental, vision, short- and long-term disability protection, basic life and AD&D insurance</li><li>401(k) Savings Plan</li><li>Accrued Paid Time Off (PTO)</li><li>Employee Recognition and Rewards</li><li>Employee Referral Bonuses</li></ul>Integres is an equal opportunity affirmative-action employer.  We encourage Minority/Female/Protected Veteran/Disabled applicants to apply.  Integres, LLC proactively fulfills its role as an equal opportunity employer.  We do not discriminate against any employee or applicant for employment because of race, color, sex, religion, age, sexual orientation, gender identity and expression, national origin, marital status, physical or mental disability, status as a Disabled Veteran, Recently Separated Veteran, Active Duty Wartime, or Campaign Badge Veteran, Armed Forces services Medal, or any other characteristic protected by law.All your information will be kept confidential according to EEO guidelines.</div></div>

PRODUCT DATA ANALYSTUp to £55,000 + benefitsLONDON – HYBRID (2 DAYS A WEEK IN OFFICE) Please note: you must be a UK resident with full right to work ABOUT THE BUSINESSThis is a large, global media organisation operating across North America, Europe, and the Middle East, with a strong presence in London. The business combines proprietary technology with large-scale media and publishing operations, reaching millions of users every month across multiple platforms. The organisation operates across two core areas:<ul><li>Technology, providing the infrastructure required to run high-traffic content platforms, including content management systems and advertising technology.</li><li>Media & Publishing, which focuses on producing and monetising premium sports and fan-focused content across a portfolio of major digital brands.</li></ul>This role sits firmly within the Media & Publishing arm, supporting high-traffic websites and content networks monetised primarily through advertising, sponsorship, and emerging subscription models. As the business continues to explore registration walls, premium content, and audience monetisation strategies, analytics plays a central role in shaping commercial and product decisions. THE TEAMYou’ll join a close-knit analytics and data team of around 10 people working across publishing, audience, and technology initiatives. The team includes analysts, data engineering, and data science, working closely with product, editorial, and commercial stakeholders. The environment is fast-paced, collaborative, and still evolving, offering scope to influence how analytics is embedded across the publishing organisation. THE ROLEThis Product Data Analyst role is focused on understanding audience behaviour, engagement, and monetisation across large-scale media platforms. You’ll play a key role in shaping how users interact with content — from registration walls and recirculation strategies to experimentation, forecasting, and evaluating new initiatives such as AI-driven content enhancements. The role combines hands-on analysis with stakeholder management, requiring someone who can confidently challenge assumptions, manage expectations, and translate data into clear commercial recommendations. KEY RESPONSIBILITIESAudience & Engagement Analytics<ul><li>Analyse and optimise registration walls, including their impact on revenue, engagement, and audience understanding</li><li>Develop approaches to capturing user interests and preferences to improve relevance and personalisation</li><li>Own recirculation analysis, understanding how users move through content once on site</li></ul>Experimentation & Optimisation<ul><li>Design and analyse A/B tests across navigation, banners, “what to read next”, and internal linking</li><li>Evaluate what drives deeper engagement, longer dwell time, and repeat visits</li><li>Partner with product and editorial teams to embed learnings into site strategy</li></ul>Commercial & Strategic Analytics<ul><li>Support advertising and monetisation decisions through audience and behavioural insights</li><li>Contribute to forecasting website traffic and audience growth</li><li>Evaluate the impact of new initiatives, including AI-driven features such as content summarisation</li></ul>Cross-Business Support<ul><li>Work flexibly across different areas of the publishing organisation as priorities evolve</li><li>Communicate insights clearly to stakeholders with varying levels of data literacy</li><li>Push back where necessary, managing expectations and advocating for data-led decision making</li></ul> TECH STACK<ul><li>Cloud-based data warehouse (GCP)</li><li>SQL – strong, hands-on capability required</li><li>Google Analytics for tagging and behavioural analysis</li><li>Python (nice to have, not essential)</li></ul> SKILLS & EXPERIENCE REQUIREDEssential<ul><li>Strong experience working with large-scale datasets</li><li>Advanced SQL skills, including writing complex queries</li><li>Experience analysing digital audience behaviour and engagement</li><li>Confidence working in fast-moving environments with evolving priorities</li><li>Strong stakeholder management skills, with the ability to challenge and influence</li></ul>Nice to Have<ul><li>Background in media, publishing, or agency environments</li><li>Experience with experimentation and A/B testing</li><li>Exposure to forecasting or advanced analytical techniques</li><li>Experience using Python for analysis</li></ul> WHY APPLY?<ul><li>Join a global media organisation with massive audience reach</li><li>Work on high-traffic, well-known publishing platforms</li><li>Play a central role in shaping audience and monetisation strategy</li><li>Enjoy flexible working with genuine autonomy</li><li>Be part of a collaborative, growing analytics function with room to influence</li></ul>

<div><h2>Engineer - Automation Engineering Control System Data Analyst</h2>At Lilly, we unite caring with discovery to make life better for people around the world. We are a global healthcare leader headquartered in Indianapolis, Indiana. Our employees around the world work to discover and bring life-changing medicines to those who need them, improve the understanding and management of disease, and give back to our communities through philanthropy and volunteerism. We give our best effort to our work, and we put people first. We're looking for people who are determined to make life better for people around the world.Lilly recently announced a $4.5 billion investment to create the Lilly Medicine Foundry, a new center for advanced manufacturing and drug development. The first-ever facility of its kind, combining research and manufacturing in a single location, the Medicine Foundry will allow Lilly to further develop innovative solutions to optimize manufacturing processes and increase capacity for clinical trial medicines, while also reducing costs and environmental impact.The Engineer-Automation Engineering Control System Data Analyst, is a technical individual contributor for the Foundry Automation Engineering Team. This individual will be responsible for providing data engineering and analytics solutions for The Foundry Automation Engineering organization. This role in collaboration with the Automation Engineers and System Administrators will maintain, configure, and troubleshoot the different Automation Control Systems and interfaces supporting the data historization and analytics for the Foundry. This role will be involved in the support of the daily operations of the Foundry and will contribute to the operations, productivity and development of reliable and compliant control applications and systems used in the manufacturing at Foundry. Additionally, the Engineer partners to influence and implement within the process control organization and across functional disciplines to support the process control technical agenda, business plan priorities, and compliance objectives.In the project delivery phase and startup phase of the project (startup expected 2025 to 2028), engineering roles will be fluid and dynamic as we endeavor to support the project delivery, build a new organization, develop and implement the necessary systems and business processes required to support GMP operations, and build the site culture. This will require significant collaboration, creativity and resilience as the site grows to a full scale GMP manufacturing through start up.<h3>Responsibilities</h3>Key Objectives/Deliverables:<ul><li>Provide/Support input to design decisions regarding development and integration of Automation Data Analytics systems and overall Foundry Data Analytics initiatives</li><li>Lead development and implementation of analytics strategies and tools for metrics, visualization and dashboards based on complex user requirements across multiple platforms and functional areas</li><li>Interface with the Automation teams and the user groups to develop requirements and designs to meet the business needs.</li><li>Promote the use of data analytics to support achievement of site business goals including promoting awareness and training on data analytics tools and techniques across the Automation Engineering organization</li><li>Support qualification and delivery of Automation Servers, Network and Infrastructure and applications</li><li>Support the Process Control Validation Plan, CSV, Quality Documents, SOP's and Audit Readiness</li><li>Support the execution and creation, review, and approval of documentation associated with procedure-driven compliance activities such as periodic reviews and application recovery process as part of business continuity initiatives</li><li>Support key business processes such as audit, investigation and CAPA</li><li>Monitor, Administer and optimize Automation Quality deliverables (Incidents, Actions, Deviations, Resolutions)</li><li>Act as a system owner for the electronic testing system (Kneat, ALM, Valgenesis) managing CSV document relating to automation systems</li><li>Working experience administering relational databases with RDBMS tools such as Microsoft SQL Server Management Studio. Basic to intermediate competency with SQL, PowerBI and software development applications</li><li>Experience with data flows and interfaces associated with instrumentation and system integration protocols a plus.</li><li>Provide support for computer system data architecture and data integrity for automation systems across the site including:</li><ul><li>Foundry Configuration Management Database (ServiceNow), QMS (Veeva)</li><li>Process Automation Systems (DCS, SCADA, BMS, MES, Historian)</li><li>Data Historian (DeltaV Historian, FT Historian, Metasys Historian, Aveva PI, Ignition, WIN911)</li><li>LMS (SuccessFactors)</li></ul><li>Ensure compliance with regulatory requirements and industry standards (GAMP, 21 CFR Part 11, Data Integrity) and corporate Lilly quality policies and procedures</li><li>Maintain validation documentation, such as validation plans and summary reports</li><li>Provide training to personnel on CSV principles, procedures and best practices Operational Excellence</li><li>Technically collaborate with Site Area leads and System Integrator including Functional Requirements, Design Specifications, DCS Application Software, Test Specifications to ensure Data Historization and System architecture is considered.</li><li>Provide periodic status updates to Automation Engineering Management</li><li>Work with Engineering, Operations and many cross functional groups to trouble shoot issues, coordinate changes with data historian systems in line with site change control procedures and site standards, responding to system events and performing routine system maintenance checks</li><li>Lead the interfacing of cross functional systems such as Historians, QMS, LMS, CMDB, CMMS, ITSM</li><li>Develop standard operating procedures, work instructions and other job aids to ensure the appropriate level of documentation is in place to design, operate, organize, maintain and optimize the Foundry Configuration Management Database (ServiceNow)</li><li>Identify, track, and report key indicators of functional performance</li><li>Organize, document and manage knowledge base for troubleshooting applications following templates regarding problem, traceability, accountability, and resolution</li><li>Support and implement CSV and quality strategies for control systems in collaboration with Site Quality organization</li><li>Promote the use of automation and analytics to improve productivity, operational efficiency and compliance</li><li>Develop a 'network' of corporate contacts and leveraging corporate expertise when needed Organizational Capability</li><li>In coordination with automation and compliance consultants, set and reinforce standards for appropriate rigor in automation work products.</li><li>Be a fully active member of the engineering team in running the plant, including participation on management sub-teams.</li></ul><h3>Basic Requirements</h3>Minimum B.S. in IT, Engineering or related discipline and 3+ years' experience in Computerized System Validation and Data Analytics, preferably in pharmaceutical manufacturing.<h3>Additional Preferences</h3>3+ years working experience in Biopharma engineering, operations, or manufacturing. Knowledge of GMP regulatory requirements, computer system validation, execution and data integrity Experience in design, development, commissioning and qualification of highly automated greenfield manufacturing sites utilizing SCADA, DCS, MES, LIMS, Power BI, QMS and Site Historian systems (DeltaV, Rockwell, Syncade, LabVantage, Veeva, Analysis tools, Aveva PI). Experience in design and development of data analysis and data contextualization to support site functions and metrics. Ability to work in a matrix organization within the department and cross functionally and demonstrate key interpersonal skills. Ability to ensure appropriate technical depth and rigor with departmental technical deliverables. Ability to make decisions independently and to network with others as appropriate. Ability to work with key network and enterprise partners in utilizing new technology in data analytics and enterprise integration Ability to influence peers and business partners<h3>Other Information</h3>Initial location at Lilly Technology Center, Indianapolis. Permanent location at the new Lilly Medicines Foundry in Lebanon, Indiana. Lilly is dedicated to helping individuals with disabilities to actively engage in the workforce, ensuring equal opportunities when vying for positions. If you require accommodation to submit a resume for a position at Lilly, please complete the accommodation request form for further assistance. Please note this is for individuals to request an accommodation as part of the application process and any other correspondence will not receive a response. Lilly is proud to be an EEO Employer and does not discriminate on the basis of age, race, color, religion, gender identity, sex, gender expression, sexual orientation, genetic information, ancestry, national origin, protected veteran status, disability, or any other legally protected status. Our employee resource groups (ERGs) offer strong support networks for their members and are open to all employees. Our current groups include: Africa, Middle East, Central Asia Network, Black Employees at Lilly, Chinese Culture Network, Japanese International Leadership Network (JILN), Lilly India Network, Organization of Latinx at Lilly (OLA), PRIDE (LGBTQ+ Allies), Veterans Leadership Network (VLN), Women's Initiative for Leading at Lilly (WILL), enAble (for people with disabilities). Learn more about all of our groups. Actual compensation will depend on a candidate's education, experience, skills, and geographic location. The anticipated wage for this position is $66,000 - $171,600 Full-time equivalent employees also will be eligible for a company bonus (depending, in part, on company and individual performance). In addition, Lilly offers a comprehensive benefit program to eligible employees, including eligibility to participate in a company-sponsored 401(k); pension; vacation benefits; eligibility for medical, dental, vision and prescription drug benefits; flexible benefits (e.g., healthcare and/or dependent</div>

SENIOR DATA ANALYST - 8 MONTH FTC£60,000 (pro rata) LONDON – OFFICE-LED (4 DAYS A WEEK IN OFFICE) Please note, you must be a UK resident with full right to work ABOUT THE BUSINESSThis leading UK creative advertising agency is known for delivering highly awarded, culture-defining campaigns for some of the world’s biggest consumer brands. Operating at the intersection of creative, strategy, data, and performance, the agency uses insight and analytics to shape big creative ideas rather than treating data as a standalone function. The focus is on long-term client partnerships, not short-term campaign delivery. The culture is fast-paced, ambitious, and collaborative, with high expectations around thinking quality, clarity of communication, and client impact. This is an environment where data plays a central role in influencing senior decision-making. THE TEAMYou’ll join an established data and insight function embedded closely with strategy, performance, platform, and account management teams. The team works at the heart of client relationships, supporting major global accounts and helping shape campaign direction through insight. This is a highly visible team within the agency, trusted by senior stakeholders and expected to operate with confidence, autonomy, and commercial awareness. THE ROLEThis is a senior, client-facing analytical role focused on delivering clear, commercially relevant insight to high-profile clients. Sitting between data, campaigns, and client teams, you’ll act as a trusted analytical partner, translating complex performance and web data into compelling, actionable stories. The role is heavily weighted toward insight generation, reporting, and senior stakeholder engagement, with frequent client meetings and a strong emphasis on communication. You’ll report into the Head of Data & Insight and support the development of more junior analysts within the team. CLIENT SPLIT<ul><li>Approximately 60% on a priority automotive client</li><li>Approximately 40% across other major agency clients</li></ul>The priority account requires regular engagement with senior client stakeholders and represents the core focus of the role. NATURE OF THE ROLEThis is a fast-moving, demanding role where success is built on trust, clarity of insight, and strong relationships. Key characteristics include:<ul><li>Heavy reporting and insight generation</li><li>Senior client meetings at least three times per week</li><li>High expectation to explain data clearly and confidently</li><li>Fast-paced agency environment with demanding clients</li></ul>Insight typically covers:<ul><li>Post-campaign analysis</li><li>Performance optimisation recommendations</li><li>Trading, forecasting, and forward-looking commentary</li></ul> KEY RESPONSIBILITIESPerformance Marketing & Insight<ul><li>Lead analysis and reporting across performance marketing and web data</li><li>Translate complex datasets into clear commercial narratives</li><li>Provide optimisation recommendations based on performance trends</li></ul>Client Leadership<ul><li>Act as a trusted analytical partner to senior client stakeholders</li><li>Confidently present insight, challenge thinking where needed, and guide decision-making</li><li>Support campaign planning, trading activity, and ad hoc client requests</li></ul>Internal Collaboration & Development<ul><li>Work closely with strategy, platform, and account teams</li><li>Provide day-to-day analytical support to account teams</li><li>Support and help develop junior analysts within the data function</li></ul> DATA EXPOSUREData includes:<ul><li>Performance marketing data</li><li>Web and conversion metrics</li><li>Customer behaviour data</li><li>Forecasting and trading analysis</li></ul> SKILLS & EXPERIENCE REQUIREDMust Have<ul><li>Strong Excel skills</li><li>Agency background</li><li>Experience working with performance marketing data</li><li>Confident, outgoing communicator</li><li>Comfortable presenting to senior clients</li><li>Willing to give opinions and challenge constructively</li></ul>Nice to Have<ul><li>Experience in retail, automotive, or similarly fast-paced sectors</li></ul>

<h3>Job Description</h3><div>Job Description<div><div>Planet Technologies, the Nation’s leading Microsoft services provider to the public sector, is looking for a highly motivated individual to join our growing team as Data Analyst. In this role, you will be supporting impactful projects that make a difference for our country. </div><div> </div><div>This role is for a junior level data analyst who will conduct analysis on gathered data for solution implementation. They bridge the gap between the business need and the technical solution translating requirements into actionable plans. They are flexible and participates in ad hoc assignments that meet the need of the internal stakeholders. </div>Responsibilities<ul><li>Monitors and updates customer created JIRA ticket requests (Gateway, CloudSec, Close account requests etc.). </li><li>Provides high-level status update to leadership on unit programs with the input of the stakeholders </li><li>Engages internal and external stakeholder to manage expectations and ensure data is not only timely but accurate </li><li>Works on ad-hoc assignments to include assistance in Cloud Roundtables, Virtual Academy training creations, and communications </li><li>Possess a strong background in Microsoft suite of tools contributing to the design and implementation of deliverables </li><li>Participates in project planning, after action reporting and testing to provide successful project delivery </li><li>Communicates and engage with external stakeholders by facilitating meetings and presenting findings in a clear and concise manner </li></ul>Qualifications<ul><li>Minimum of 1+ years’ experience recommended. In absence of years of experience, certifications or past work may be used to show the level of experience needed to perform at this level. </li><li>Experience with JIRA Ticket requests, Gateway and CloudSec</li><li>Knowledge of Cloud Roundtables, Virtual Academy training</li><li>Strong knowledge of Microsoft tools</li><li>Previous experience in project planning, design and implementation of deliverables that have resulted in successful project delivery</li><li>Ability to work on site in DC five days a week</li><li>Ability to hold and maintain a Top Secret clearance</li></ul><div>Planet Technologies is the leading provider of Microsoft Consulting Services to public sector and commercial organizations. Planet has significant experience in deploying business intelligence, cloud services, unified communications, and systems management with an emphasis building, deploying, and managing custom solutions that transform the business operations of federal government agencies. </div><div>Planet Technologies does not discriminate in employment opportunities, terms and conditions of employment, or practices. All qualified applicants will receive consideration for employment without regard to race, age, gender, religious or political beliefs, national origin or heritage, disability, sexual orientation, protected veteran status, or any characteristic protected by law. Federal Agency Clearance Requirements may require up to a 10-year background investigation - US Citizenship (clearable) is required. </div><div> </div><div>Salaries for Junior Data Analysts at Planet Technologies range from $80,000 and $110,000. Several factors will impact final pay offered to a successful candidate including but not limited to the type and years of experience within the job, clearance level, the type of years and experience within the industry, education, training, etc. </div><div> </div><div>Visit www.go-planet.com to learn more about us. Details about our benefits can be found here Planet Technologies Benefit Guide 2025-2026 </div>We may use artificial intelligence (AI) tools to support parts of the hiring process, such as reviewing applications, analyzing resumes, or assessing responses. These tools assist our recruitment team but do not replace human judgment. Final hiring decisions are ultimately made by humans. If you would like more information about how your data is processed, please contact us.</div></div>

<h3>Job Description</h3><div>Job Description<div>COMPANY: Canoe IntelligenceWEBSITE: https://canoeintelligence.com/TITLE: Sr. Data Analyst, Private MarketsLOCATION: New York City (hybrid) or Fully Remote in the United StatesSALARY: $140,000 - $160,000 + Bonus and Equity (based on NYC, will be adjusted for geo)The Role:You are the industry veteran who will define the logic for the next frontier of Private Markets AI. Canoe has already built the proprietary technology that serves as the industry standard for automated data extraction. We have the foundation, the clients, and the engine. Now, we are expanding our capabilities to handle the "fun stuff"—the extreme nuance, the edge cases, and the deep complexity of the private markets ecosystem.We are looking for a business leader with deep technical instincts to take our AI from "foundational" to "expert." In this role, you will leverage your years of experience to construct the data extraction strategies for the industry’s most challenging documents. You will bridge the gap between Limited Partner (LP) reporting needs and machine learning, ensuring our models evolve to handle the full weight of private market complexity.What You’ll Do:Strategic Expansion & Model Development:<ul><li>Construct the "Next-Gen" Playbook: Design the comprehensive data extraction rules for complex LP documents (Capital Account Statements, PCAPs, Call/Distribution Notices). You will move beyond standard mappings to define how our system handles high-complexity scenarios at scale.</li><li>Drive AI Evolution: We aren't starting from scratch—we are leveling up. You will analyze model performance on intricate data sets and provide the "human intelligence" needed to retrain our system for higher accuracy and deeper granularity.</li><li>Curate High-Fidelity Training Data: Personally analyze and annotate complex, proprietary documents to define the "Ground Truth." Your deep markup of these documents will serve as the gold standard that our engineering teams and models aim to replicate. </li></ul>Expert Intervention & Logic Definition:<ul><li>Complex Data Intervention: Serve as the final escalation point for data integrity. When the automated logic encounters a new or difficult fund structure, you will step in to resolve the breakage, ensuring the data balances and the output is client-ready.</li><li>Codify Financial Logic: Translate abstract accounting concepts (e.g., recallable capital nuances, equalization adjustments, multi-tier waterfalls) into systematic rules that our product team can implement.</li><li>Research & Discovery: Proactively identify new reporting trends and asset class variations. You will research how these new instruments should be captured and define the schema before they ever hit our automated production lines.What We’re Looking For: </li></ul>Client & Market Leadership:<ul><li>Client-Facing Authority: Act as a trusted advisor to our clients. You will demonstrate our deep understanding of their data challenges and articulate how our technology navigates the complexities of their specific portfolios.</li><li>Cross-Functional Partnership: Work hand-in-glove with Product and Engineering. You bring the "Business Logic," they bring the code. Together, you will build the future of private markets data.4–7 years experience in private markets financial analysis, fund operations, or fund administration roles. </li></ul>What we're looking for:<ul><li>Experience: 7+ years of rigorous experience in private markets, specifically within an LP, Fund of Funds, Family Office, or Fund Administrator.</li><li>Deep Domain Fluency: You have spent your career analyzing Fund and Investor-level data. You understand the "why" behind every number on a Capital Call and the relationship between financial statements and investor reporting.</li><li>A Builder’s Mindset: You are looking for a role where your industry knowledge helps build a product. You are excited by the prospect of taking a manual, messy industry problem and solving it with systemic logic.</li><li>Technical Instincts: You are a business person who understands data structures. You may not write software, but you understand how to organize data, identify patterns, and define strict logic rules.</li><li>Uncompromising Standards: You know what "audit-ready" looks like. You are willing to dive into the weeds of the data to ensure our AI is learning the right lessons, refusing to compromise on precision.</li></ul>What You’ll Get:<ul><li>Medical, dental, vision benefits </li><li>Flexible PTO </li><li>401(k) </li><li>Flexible work from home policy </li><li>Home office stipend </li><li>Employee Assistance Program </li><li>Gym/Wifi reimbursement </li><li>Education assistance </li><li>Parental Leave</li></ul><ul><li></li></ul>Our Values:<ul><li>Client First —> Listen, and deliver client-centric solutions</li><li>Be An Owner —> Take initiative, improve situations, drive positive outcomes</li><li>Excellence —> Always set the highest standard for yourself and others</li><li>Win Together —> 1 + 1 = 3</li></ul>Who We Are:Canoe is reimagining alternative investment data processes for hundreds of leading institutional investors, capital allocators, asset servicing firms and wealth managers. By combining industry expertise with the most sophisticated data capture technologies, Canoe’s technology automates the highly-frustrating, time-consuming, and costly manual workflows related to alternative investment document and data management, extraction and delivery. With Canoe, clients can refocus capital and human resources on business performance and growth, increase efficiency, and gain deeper access to their data. Canoe’s AI-driven platform was developed in 2013 for Portage Partners LLC, a private investment firm.Canoe is an equal opportunity employer. All aspects of employment including the decision to hire, promote, discipline, or discharge, will be based on merit, competence, performance, and business needs. We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, veteran status, or any other status protected under federal, state, or local law.</div></div>

<h3>Job Description</h3><div>Job Description<div>Company Description Ulbrich was established in 1924 and is family-owned and privately held.  An international corporation with subsidiaries located in the US, Mexico, Germany and Austria. Ulbrich employs over 700 people worldwide. At Ulbrich, we are Improving Lives with More Than Metal. We work hard for each other, our families, and the communities we live in.  The respect and integrity of Ulbrich team members, dedication to their professions, collaborative participation in lean, and ensuring that safety comes first, has created a culture that has a positive impact on the lives of many. We connect with the world through our responsibility to produce critical products that benefit mankind.  The Ulbrich culture is guided by a set of shared values we call Our Core Tenets.  The tenets we live by each day are Continuous Improvement, Quality Commitment, Family Values, Total Company Involvement, and Customer Responsiveness. Through practicing these shared values, we drive profitable growth and success.Come join the Ulbrich team and become part of a greater purpose and a promising future!Job Description Ulbrich Stainless Steels and Special Metals Inc. is looking for a detail-oriented Power BI Developer/Data Analyst. This entry-level role based at our corporate headquarters in North Haven, CT is ideal for individuals passionate about data visualization, analytics, and business intelligence. You will work closely with business stakeholders to transform raw data into actionable insights using Power BI and other analytical tools.Responsibilities include:<ul><li>Develop and maintain Power BI Dashboards and reports to support business decision-making;</li><li>Perform data cleaning, transformation and modeling to prepare datasets for analysis;</li><li>Collaborate with business teams to understand requirements and translate them into effective visualizations;</li><li>Monitor and optimize report performance and implement best practices for BI solutions;</li><li>Assist in ad-hoc data analysis and generate insights to support operation and strategic initiatives; and</li><li>Document process, data models, and report standards for future reference.</li></ul>Qualifications <ul><li>0-2 years of experience in information systems</li><li>Bachelor's  degree in Computer Science, Information Systems or Data Analytics</li><li>Basic knowledge of Power BI (or similar BI tool) and data visualization principles</li><li>Strong analytical and problem-solving skills with attention to detail</li><li>Proficiency in Microsoft Excel (pivot tables, formulas, charts)</li><li>Understanding of ETL process and data warehousing concepts</li><li>Exposure to DAX and Power Query in Power BI is a plus</li><li>Good communication skills and ability to work collaboratively in a team environment</li></ul> Additional Information This position offers competitive salary and benefits and the opportunity to expand your skills within a company that offers both a diverse workforce and a welcoming company culture. Ulbrich is an Equal Opportunity Employer.</div></div>

<div><h2>Kratos Program Control Data Analyst/Power BI Specialist</h2>Kratos is seeking a dynamic Program Control Data Analyst/Power BI Specialist to join our team. This role combines expertise in program planning, financial control, variance analysis, and data analytics to support complex government contracts. The ideal candidate will be adept in Federal procurement and program types (e.g., CPAF, CPFF, FFP, T&M, IDIQs) and possess skills in Power BI for developing insightful dashboards and reports. Additionally, expertise in SQL servers, PowerApps, SharePoint, and AI for creating and maintaining workflows is highly desired.Key Responsibilities:<ul><li>Interface with program managers, finance, accounting, contracts, subcontracts, and procurement teams to address operational issues effectively.</li><li>Prepare financial deliverables and internal/external reports, including Annual Operating Plans (AOP), monthly forecasts, and Estimates-At-Complete (EACs).</li><li>Develop and manage program budgets (spend plans) and analyze funding profiles and financial variances.</li><li>Conduct cost, schedule, and contract performance variance analysis.</li><li>Review, track, and approve customer invoices and backup documentation.</li><li>Support Request for Proposals (RFPs), prepare pricing models, and perform cost analysis.</li><li>Manage subcontractor costs, accruals, purchase requisitions, travel expenses, and invoice approvals.</li></ul>Power BI Reporting, Data Analysis, and Workflow Automation:<ul><li>Collaborate across departments to gather, model, and analyze data.</li><li>Develop, design, and maintain Power BI dashboards and reports for actionable insights.</li><li>Optimize data models to ensure efficient data retrieval and analysis.</li><li>Document methodologies, processes, and findings comprehensively for future reference.</li><li>Ensure data accuracy, consistency, security, and governance across reports and dashboards.</li><li>Integrate Power BI with data sources, including databases, cloud services, and APIs.</li><li>Utilize SQL servers and other methods for efficient data retrieval and management.</li><li>Develop and maintain workflows using PowerApps, SharePoint, and AI tools.</li><li>Ensure the sustainability and efficiency of automated workflows.</li></ul>Required Experience:<ul><li>Bachelor's degree in finance, Accounting, Business, Data Analytics, Computer Science, or a related field.</li><li>Minimum of 3 years of relevant experience in Federal government contracting.</li><li>Expertise in program control, finance, cost estimating, and financial analysis.</li><li>Strong knowledge of Power BI and data visualization best practices.</li><li>Proficient in MS Office Suite (Excel, Word, PowerPoint).</li><li>Experience working with SQL servers and other data retrieval tools.</li><li>Experience with PowerApps, SharePoint, and AI for workflow creation and maintenance.</li><li>US Citizenship is required.</li></ul>Desired Skills:<ul><li>Familiarity with Costpoint and Cognos reporting tools.</li><li>Ability to obtain a Secret clearance.</li><li>Strong organizational and communication skills.</li><li>Ability to work independently, prioritize tasks, and meet deadlines.</li><li>Experience documenting technical specifications and communicating findings to diverse audiences.</li></ul>Kratos Defense is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, pregnancy, genetic information, disability, status as a protected veteran, or any other protected category under applicable federal, state, and local laws.Disability Accessibility Accommodation: If you require an accommodation to navigate or apply to our careers site, please send your request to HRAccessibility@kratosdefense.com or call 858-964-2916. Any inquires not related to requesting an accommodation will be discarded.Pay Transparency: The company will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. Job Applicant Privacy Notice: For applicants in the EU and California residents, please review our privacy notice.</div>

Agoda Data Analyst Interview Questions + Guide in 2025

Overview

Agoda Data Analyst Interview Process

Agoda Data Analyst Interview Questions

Agoda Data Analyst Jobs

Question	Topic	Difficulty	Ask Chance
Random Seed Function	Probability	Medium	Very High
Causal Inference Without A/B	A/B Testing	Medium	High
Black Friday Shopping Spree	SQL	Medium	High