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

Shopee Data Analyst Interview Guide

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


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

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

A/B Testing

Algorithms

Analytics

Machine Learning

Probability

Product Metrics

Python

Statistics

Shopee Data Analyst Interview Process

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

A/B Testing & Experimentation

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

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>

<h2>Example 1</h2>

<h3>Input</h3>

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

<h3>Output</h3>

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

<h2>Example 2</h2>

<h3>Input</h3>

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

<h3>Output</h3>

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

<h3>Explanation</h3>

Electronics

<ul>
<li>Customers: 101, 102, 103 → 3 unique</li>
<li>Spend per customer:

<ul>
<li>101 → 120 + 80 = 200</li>
<li>102 → 150</li>
<li>103 → 300</li>
<li>Average = (200 + 150 + 300) / 3 = 216.67</li>
</ul></li>
<li>Multi-purchase customers:

<ul>
<li>Only customer 101 has more than one purchase → 1⁄3 = 33.33%</li>
</ul></li>
</ul>

Clothing

<ul>
<li>Customers: 102, 103 → 2 unique</li>
<li>Spend per customer:

<ul>
<li>102 → 40 + 10 = 50</li>
<li>103 → 50</li>
<li>Average = (50 + 50) / 2 = 50.00</li>
</ul></li>
<li>Multi-purchase customers:

<ul>
<li>Customer 102 made 2 purchases</li>
<li>Customer 103 made 1</li>
<li>Multi-purchase rate = 1⁄2 = 50.00%</li>
</ul></li>
</ul>

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

Black Friday Shopping Spree

Shopee Data Analyst Interview Questions

<div><h2>Join Our Team at Hospital for Special Surgery</h2>How you move is why we're here. Now more than ever, our guiding principles are helping us in our search for exceptional talent - candidates who align with our unique workplace culture and who want to maximize the abundant opportunities for growth and success. If this describes you then let's talk! HSS is consistently among the top-ranked hospitals for orthopedics and rheumatology by U.S. News & World Report. As a recipient of the Magnet Award for Nursing Excellence, HSS was the first hospital in New York City to receive the distinguished designation. Whether you are early in your career or an expert in your field, you will find HSS an innovative, supportive and inclusive environment.Working with colleagues who love what they do and are deeply committed to our Mission, you too can be part of our transformation across the enterprise.Regular Full timeDay (United States of America)The base pay scale for this position is $60,000.00 - $91,125.00. In addition, this position will be eligible for additional benefits consistent with the role. The salary of the finalist selected for this role will be determined based on various factors, including but not limited to: scope of role, level of experience, education, accomplishments, internal equity, budget, and subject to Fair Market Value evaluation. The hiring range listed is a good faith determination of potential compensation at the time of this job advertisement and may be modified in the future.<h3>What You Will Be Doing</h3>As part of the Data & Analytics (HSS Data) team and aligned with the Finance vertical, you will own high-impact analysis and automation initiatives that advance budgeting, forecasting, and strategic planning for Regional and Florida Financial Operations. You will develop robust models, build self-service data products and collaborate across finance, operations, and the technology organization to ensure financial activity is accurately reflected, governed, and translated into actionable recommendations.<h3>Key Responsibilities</h3>Financial Planning & Analysis<ul><li>Perform financial modeling and analysis in support of budgets, forecasts, and strategic initiatives.</li><li>Partner with operations and financial planning teams to develop key assumptions for budgets, projections, and scenario analyses.</li><li>Ensure financial activities are accurately reflected in reporting and analytics; reconcile variances and identify drivers.</li><li>Assist in preparing joint venture board agendas and materials with concise narratives and decision-ready exhibits.</li><li>Maintain a current understanding of operational, financial, regulatory, and strategic issues impacting performance.</li></ul>Data, Automation & Reporting<ul><li>Serve as the subject matter expert (SME) on finance processes, data definitions, and reporting requirements within HSS Data.</li><li>Collaborate with data engineers and developers to design, test, and maintain automated workflows, pipelines, and reporting processes.</li><li>Identify and lead automation opportunities to streamline recurring processes and reduce manual reporting.</li><li>Develop and maintain automated dashboards, financial reporting tools, and data products that provide actionable insights.</li><li>Translate business and finance requirements into clear technical specifications for data team colleagues.</li></ul>Stakeholder Partnership & Data Governance<ul><li>Partner across finance, operations, and analytics to align on metrics, definitions, and methodologies.</li><li>Support enterprise data quality, governance, and standardization efforts with a focus on finance and operations data.</li><li>Communicate findings and recommendations through executive-ready visuals, presentations, and summaries.</li></ul><h3>Qualifications & Experience</h3><ul><li>Bachelor's degree required.</li><li>25 years of relevant experience in financial modeling, analysis, or accounting.</li><li>Demonstrated ability to work within complex financial forecasting models and deliver decision-ready insights.</li><li>Experience with data analytics and exposure to automation tools, SQL, BI/visualization platforms, or cloud data environments preferred.</li><li>Knowledge of the hospital/healthcare industry preferred but not required.</li></ul><h3>Knowledge, Skills, and Abilities</h3><ul><li>Strong financial, analytical, and problem-solving skills; able to build efficient models and forecast under multiple scenarios.</li><li>Comfortable working with large datasets; motivated to eliminate manual work through automation.</li><li>Strong collaboration and communication skills with the ability to bridge finance and technical teams.</li><li>Detail-oriented, organized, reliable, and accountable; able to manage multiple projects and meet tight deadlines.</li><li>Quick learner with the ability to adapt to new tools, technologies, and data platforms.</li></ul>Why Join Us?Hospital for Special Surgery is the world's leading academic medical center focused on musculoskeletal care. As a Senior Data Analyst, Financial Operations, you will sit at the intersection of finance, operations, and datamodernizing how HSS plans, measures, and invests. Your work will streamline decisions for joint ventures and outpatient centers and contribute to sustainable growth that supports outstanding patient care within a collaborative, flexible, and inclusive environment.Non-Discrimination PolicyHospital for Special Surgery is committed to providing high quality care and skilled, compassionate, reliable service to our community in a safe and healing environment. Consistent with this commitment, Hospital for Special Surgery provides care, admits, and treats patients and provides all services without regard to age, race, color, creed, ethnicity, religion, national origin, culture, language, physical or mental disability, socioeconomic status, veteran or military status, marital status, sex, sexual orientation, gender identity or expression, or any other basis prohibited by federal, state, or local law or by accreditation standards.</div>

Job Title: Data Analyst – Supply Chain Location: Barrow-In-Furness. We offer a range of hybrid and flexible working arrangements – please speak to your recruiter about the options for this particular role. Occasional travel to other BAE offices across the UK is expected and expensed. Salary: From £37,091 depending on skills and experience What You’ll Be Doing <ul><li>Creating analysis and insight on the performance and behaviour of the supply chain processes, utilising data obtained from a variety of computer systems</li><li>Collaborating with diverse stakeholders across the function, programmes and IM&T to uncover valuable key insights required and optimal data to service it</li><li>Creating insight solutions using Excel, SAP Analytics Cloud and Tableau while developing your expertise in these platforms</li><li>Contributing to Supply Chain Excellence by supporting activities that deliver on People, Process & Technology, ensuring the Supply Chain function is fit for the future </li></ul>Essential Your skills and experiences: <ul><li>Experience generating and publishing insight from corporate data</li><li>Good Excel and general Office application skills</li><li>Good stakeholder management and communication skills, gained within a large, distributed organisation</li><li>Good numerate academic qualifications </li></ul>Desirable <ul><li>Professional Supply Chain qualifications (eg CIPS) or equivalent Supply Chain experience</li><li>Exposure to Modern BI tools such as SAP Analytics Cloud, Tableau or other comparable BI tools </li></ul>Benefits As well as a competitive pension scheme, BAE Systems also offers employee share plans, an extensive range of flexible discounted health, wellbeing and lifestyle benefits, including a green car scheme, private health plans and shopping discounts – you may also be eligible for an annual incentive. The Digital & Data Team Be part of a small, collaborative digital & data team at the heart of Supply Chain Excellence, optimising a submarine supply chain that represents a major share of the UK defence budget. In this fast-paced, commercially driven environment, you’ll work on high‑impact projects, gain exposure to diverse challenges, and enjoy support for your development, including opportunities across the wider BAE Group. We offer relocation support packages across all Submarines roles, subject to meeting eligibility criteria. Why BAE Systems? This is a place where you’ll be able to make a real difference. You’ll be part of an inclusive culture that values diversity of thought, rewards integrity, and merit, and where you’ll be empowered to fulfil your potential. We welcome people from all backgrounds and want to make sure that our recruitment processes are as inclusive as possible. If you have a disability or health condition (for example dyslexia, autism, an anxiety disorder etc.) that may affect your performance in certain assessment types, please speak to your recruiter about potential reasonable adjustments. Please be aware that many roles at BAE Systems are subject to both security and export control restrictions. These restrictions mean that factors such as your nationality, any nationalities you may have previously held, and your place of birth can restrict the roles you are eligible to perform within the organisation. All applicants must as a minimum achieve Baseline Personnel Security Standard. Many roles also require higher levels of National Security Vetting where applicants must typically have 5 to 10 years of continuous residency in the UK depending on the vetting level required for the role, to allow for meaningful security vetting checks. Closing Date: 12th December 2025 We reserve the right to close this vacancy early if we receive sufficient applications for the role. Therefore, if you are interested, please submit your application as early as possible.

<div><h2>Financial Analyst / Data Analyst</h2>Position Type: Full-Time, RemoteWorking Hours: U.S. client business hours (with flexibility for reporting deadlines and project cycles)About the Role:Our client is seeking a Financial Analyst / Data Analyst to build models, analyze performance data, and deliver insights that guide strategy and decision-making. This role requires strong analytical skills, financial acumen, and proficiency with modern data tools. The Analyst serves as a bridge between raw numbers and executive decisions, ensuring reporting is accurate, timely, and actionable.Responsibilities:Financial Modeling:<ul><li>Build and maintain 3-statement models (P&L, balance sheet, cash flow).</li><li>Create scenario and sensitivity analyses to evaluate risks and opportunities.</li><li>Model ROI, IRR, break-even, and valuation scenarios for projects or investments.</li></ul>Data Analysis:<ul><li>Query SQL databases and work with large datasets.</li><li>Clean and transform data using Python, R, or Excel advanced functions.</li><li>Conduct variance analyses to compare actuals vs. budgets/forecasts.</li></ul>Reporting & Dashboards:<ul><li>Prepare monthly management reporting packages and board decks.</li><li>Build KPI dashboards using Tableau, Power BI, or Looker.</li><li>Ensure consistent reporting definitions across finance and operations.</li></ul>Forecasting & Budget Support:<ul><li>Collaborate with FP&A teams to refine budgets and forecasts.</li><li>Incorporate real-time business performance into rolling forecasts.</li></ul>Data Quality & Governance:<ul><li>Validate data sources for accuracy and consistency.</li><li>Document methodologies for transparency and repeatability.</li></ul>Collaboration:<ul><li>Partner with finance, sales, operations, and leadership to align metrics with goals.</li><li>Translate data into clear, actionable insights for non-technical stakeholders.</li></ul>What Makes You a Perfect Fit:<ul><li>Analytical thinker who can turn complex data into simple insights.</li><li>Detail-oriented, with high standards for accuracy.</li><li>Strong communicator equally comfortable with spreadsheets and executive presentations.</li><li>Proactive in identifying trends, risks, and improvement opportunities.</li></ul>Required Experience & Skills (Minimum):<ul><li>2+ years in financial analysis, FP&A, or data analytics.</li><li>Advanced Excel/Google Sheets (pivot tables, INDEX/MATCH, macros).</li><li>Proficiency in SQL for querying and joining datasets.</li><li>Experience preparing variance analyses and management reports.</li></ul>Ideal Experience & Skills:<ul><li>Python or R for advanced analytics and data modeling.</li><li>Experience with BI tools (Tableau, Power BI, Looker).</li><li>Industry background in SaaS, finance, healthcare, or professional services.</li><li>Familiarity with ERP systems (NetSuite, SAP, Oracle) for data extraction.</li></ul>What Does a Typical Day Look Like?A Financial Analyst / Data Analyst's day revolves around turning raw financial and operational data into meaningful insights. You will:<ul><li>Pull and clean data from ERP or SQL sources to prepare daily/weekly reports.</li><li>Update financial models with the latest actuals and run scenario analyses.</li><li>Prepare variance analyses to explain deviations from budget or forecast.</li><li>Build dashboards in BI tools to give leadership real-time visibility into KPIs.</li><li>Collaborate with stakeholders, presenting findings in clear, actionable terms.</li><li>Document assumptions and methodologies so models and analyses are transparent and repeatable.</li></ul>In essence: you ensure decision-makers always have accurate, data-driven insights to guide strategy.Key Metrics for Success (KPIs):<ul><li>Accuracy of forecasts and financial models (variance within 510%).</li><li>Timeliness of monthly/quarterly reporting.</li><li>Reliability and clarity of dashboards delivered to stakeholders.</li><li>Positive feedback from leadership on insights and recommendations.</li><li>Reduced errors and improved data quality across reports.</li></ul>Interview Process:<ol><li>Initial Phone Screen</li><li>Video Interview with Recruiter</li><li>Practical Task (e.g., build a simple financial model or create a sample dashboard from dataset)</li><li>Client Interview with Finance/Operations Leadership</li><li>Offer & Background Verification</li></ol></div>

Broking Insights - Senior Data Analyst Would you like to be part of a growing analytics team looking to drive forward advanced data-driven decision making at the heart of Lloyd’s insurance market? Do you have a passion for analytics, visualization and generating real business impact through communicating value insights? We are seeking a highly skilled Senior Data Analyst to join our forward-thinking broking analytics team. This role combines commercial acumen, deep insurance expertise, and analytical capabilities to deliver actionable insights and optimize decision-making across the organization. The successful candidate will deliver data solutions, standardize reporting practices, scale our Power BI capabilities and enhance analytical capability across departments. Based from our flagship London office, this role comes with Hybrid working. Aon is in the business of better decisions At Aon, we shape decisions for the better to protect and enrich the lives of people around the world. As an organisation, we are united through trust as one inclusive team and we are passionate about helping our colleagues and clients succeed. What The Day Will Look Like <ul><li>Power BI Development: Build scalable data models, optimize performance, and standardize reporting frameworks. </li><li>Collaborate with brokers, operations, and carriers to assess analytics requirements and translate business needs into actionable insights.</li><li>Insurance Market Expertise: Leverage Lloyd’s market knowledge to inform analytics solutions and reporting.</li><li>Utilize deep insurance knowledge to deliver innovative insights </li><li>Data Governance - embed standards and practices to improve data quality </li><li>Liaise with analytics capabilities across departments and co-ordinate to deliver business-centric solutions</li><li>Engage in strategic data transformation projects to provide technical guidance </li><li>Data Engineering & Automation: Develop ETL processes using SQL and Python;</li><li>Implement Power Automate and Power Apps for workflow automation.</li><li>AI & Emerging Technologies: understand how to leverage emerging capabilities </li></ul>How This Opportunity Is Different This is an outstanding opportunity to utilise your data, reporting and technical skills in the Corporate/Commercial world. You'll be joining a welcoming, collaborative and supporting team that is highly valued and respected throughout our firm and your work and output will make a positive impact on the continued success of our London Market broking teams. Aon is a proud advocate of internal mobility and this role will give you the foundations of a flourishing and rewarding career here. Skills And Experience That Will Lead To Success <ul><li>Mandatory: SQL, Power BI - Advanced modelling, optimization, and governance.</li><li>Power Automate / Power Apps - Workflow and app development.</li><li>Excellent communication and data storytelling.</li><li>Strong stakeholder management and influencing skills.</li><li>High commercial awareness and strategic thinking.</li><li>Collaborative and adaptable in a fast-paced environment.</li><li>Proven experience in insurance analytics within the Lloyd’s or London Market.</li><li>Expertise in standardising reporting practices and scalable BI solutions.</li><li>Experience with Microsoft Co-Pilot Studio or similar Agentic AI tooling.</li><li>Familiarity with regulatory compliance and data governance practices.</li><li>Understanding of underwriting principles and performance analytics. </li></ul>How We Support Our Colleagues In addition to our comprehensive benefits package, we encourage an inclusive workforce. Plus, our agile environment allows you to manage your wellbeing and work/life balance, ensuring you can be your best self at Aon. Furthermore, all colleagues enjoy two “Global Wellbeing Days” each year, encouraging you to take time to focus on yourself. We offer a variety of working style solutions for our colleagues as well. Our continuous learning culture inspires and equips you to learn, share and grow, helping you achieve your fullest potential. As a result, at Aon, you are more connected, more relevant, and more valued. Aon values an innovative and inclusive workplace where all colleagues feel empowered to be their authentic selves. Aon is proud to be an equal opportunity workplace. Aon provides equal employment opportunities to all employees and applicants for employment without regard to race, colour, religion, creed, sex, sexual orientation, gender identity, national origin, age, disability, veteran, marital, domestic partner status, or other legally protected status. We welcome applications from all and provide individuals with disabilities with reasonable adjustments to participate in the job application, interview process and to perform essential job functions once onboard. If you would like to learn more about the reasonable accommodations we provide, email ReasonableAccommodations@Aon.com 2555140

JOB TITLE: AWS Data Analyst JOB LOCATION: Newark, NJ (hybrid) WAGE RANGE*: 48.00-51.00 PER HOUR JOB NUMBER: SAIJP00038429 REQUIRED EXPERIENCE:<ul><li>5+ years of experience in data analyst roles</li><li>Proficiency in SQL, Python, or Scala for data transformation and processing.</li><li>Working Knowledge of AWS services</li><li>Experience with SSIS</li></ul><ul><li>Bachelor's degree in Computer Science, Data Engineering, or related field with 5+ years of experience in data analyst roles</li></ul> JOB DESCRIPTION AWS Data Analyst to collecting, cleaning, and interpreting large datasets to find patterns and insights, then communicating these findings to stakeholders through reports and dashboards to drive business decisions The ideal candidate will have strong analytical abilities, proficiency in tools like SQL, Excel, and Python, and excellent communication skills to translate complex data into actionable business strategies. Location: This client is located in central NJ. The candidate must be local and willing to go into the office 2 - 3 days a week. Responsibilities: <ul><li>Extract, clean, and analyze large datasets from multiple sources.</li><li>Write complex SQL queries to retrieve, manipulate, and analyze data efficiently.</li><li>Develop and maintain dashboards and reports for business stakeholders.</li><li>Work with AWS services such as S3, Redshift, Athena, and Glue for data processing and analysis.</li><li>Collaborate with cross-functional teams to understand data requirements and provide actionable insights.</li><li>Ensure data integrity, consistency, and security across various databases.</li></ul>Identify trends, anomalies, and opportunities in data to drive business decisions. Equal opportunity employer as to all protected groups, including protected veterans and individuals with disabilities * While an hourly range is posted for this position, an eventual hourly rate is determined by a comprehensive salary analysis which considers multiple factors including but not limited to: job-related knowledge, skills and qualifications, education and experience as compared to others in the organization doing substantially similar work, if applicable, and market and business considerations. Benefits offered include medical, dental and vision benefits; dependent care flexible spending account; 401(k) plan; voluntary life/short term disability/whole life/term life/accident and critical illness coverage; employee assistance program; sick leave in accordance with regulation. Benefits may be subject to generally applicable eligibility, waiting period, contribution, and other requirements and conditions. Benefits offered are in accordance with applicable federal, state, and local laws and subject to change at TCM's discretion.PDN-a073bad6-55ee-4671-8c8f-4270ca653731

<div><h2>Financial Crime Data Analyst (SQL & Large Data Sets)</h2>Location: Remote (UK-based) Job Type: Full-Time / ContractAbout the Role: We are seeking a highly skilled Financial Crime Data Analyst with a strong command of SQL and experience working with large and complex data sets. The ideal candidate will have a deep understanding of financial crime frameworks, particularly Anti-Money Laundering (AML), Know Your Customer (KYC), and transaction monitoring analytics.In this role, you will work remotely as part of a UK-based team, supporting financial crime investigations through data-driven insights and robust reporting. You'll play a key role in helping to detect, prevent, and report financial crime, contributing to a safer and more compliant financial ecosystem.Key Responsibilities:<ul><li>Write, optimize, and execute advanced SQL queries to extract and analyze large volumes of financial data</li><li>Conduct in-depth analysis of AML, KYC, and transaction monitoring data to identify patterns, trends, and anomalies</li><li>Translate complex datasets into actionable insights, visualizations, and compliance reports</li><li>Collaborate with cross-functional teams, including compliance, risk, and technology, to support ongoing investigations and initiatives</li><li>Ensure data integrity and adhere to data governance and regulatory standards</li><li>Support the development and enhancement of monitoring rules and models based on analytical findings</li></ul>Requirements:<ul><li>Proven expertise in SQL, including performance optimization and handling large-scale datasets</li><li>Background in financial crime analytics (AML, KYC, transaction monitoring, etc.)</li><li>Strong analytical and problem-solving skills with attention to detail</li><li>Ability to interpret regulatory requirements and apply them to data analysis</li><li>Familiarity with UK and international financial crime regulations and data governance best practices</li><li>Experience with data visualization tools (e.g., Power BI, Tableau) is a plus</li></ul>What We Offer:<ul><li>Fully remote role within a supportive UK-based team</li><li>Competitive salary and flexible working hours</li><li>Opportunity to work on high-impact projects in the financial crime domain</li></ul></div>

knowmad mood es una compañía líder en transformación digital que combina el talento y tecnología con la misión de aportar valor a más de 500 clientes. A día de hoy, más de 3000 profesionales, una facturación de 129,2 millones de euros en 2022 y sedes en 7 países como España, Italia, Portugal, Reino Unido, Estado Unidos, Uruguay y Marruecos con casi 30 años de experiencia en el mercado tecnológico. Si eres un apasionado de los Datos y estás buscando nuevos retos profesionales ¡esto te puede interesar! Nuestra Comunidad Tecnológica experta en DATA & ANALYTICS no para de crecer y necesitamos incorporar un Data Engineer Senior para un proyecto en el sector pharma que se ocupará del modelado de datos y la elaboración de dashboards en Tableau a partir de los datos del departamento de Data Operations & Products. Posición 100% remoto, para trabajar desde cualquier punto de España. Requisitos:<ul><li>+4 años de experiencia en sector Data.</li><li>Technologias: SQL, Snowflake, Tableau.</li><li>Skills: modelado de datos, UX and Storytelling. </li><li>Inglés: C1 (Fluido).</li></ul> Responsabilidades:<ul><li>Traducir un requisito complejo de negocio a requisito técnico.</li><li>Modelaje de datos del nuevo requisito a un modelo existente.</li><li>Revisión de código de otros desarrolladores mas juniors.</li></ul> knowmad mood es una compañía donde nos preocupamos por tu persona, tu felicidad, tu bienestar y tu salud.<ul><li>Apostamos por la formación y el desarrollo de carrera.</li><li>Cultura human centric.</li><li>Potenciamos engagement y la escucha activa con las personas.</li><li>Nos preocupamos por la felicidad y el bienestar de las personas.</li></ul><li></li>Work mood:<ul><li>Vacaciones: Descansa para volver con más fuerza, 22 días de vacaciones + 2 días de libre disposición + 24 y 31 de diciembre.</li></ul><li></li>Our mood:Ofrecemos una nueva forma de trabajar más flexible:<ul><li>Flex work: favorecemos una jornada diaria flexible para que tú decidas a tu ritmo cuándo empieza tu vida personal y cuando termina tu jornada laboral.</li><li>Smart working: lo importante es que tú estés bien, tu desarrollo, y la orientación a resultados, no si vienes a la oficina. Por eso no hace falta ni que tengas la oficina cerca, mientras tengas una buena conexión, todo es posible.</li><li>Beneficios y ventajas: destina parte de tu salario a determinados productos como tarjeta de transporte, tarjeta restaurante, cheques guardería, seguro médico o formación. Además disfruta en nuestra plataforma interna de todos los descuentos exclusivos para tu vida fuera de la compañía.</li></ul> knowmad mood nos encargamos de cuidar a nuestras personas y es un lugar fantástico en el que trabajar, convivir y desarrollarte.<ul><li>Nos gusta escucharte: encuesta de felicidad, línea directa CEO, evaluación 360º</li><li>Cuidamos tu bienestar: a través de nuestro programa de bienestar integral centrado en: actividad física, nutrición saludable y equilibrio emocional.</li><li>Y de tu vida: programa de conciliación 24 horas al día y 365 días del año para ti, tu pareja y tu familia: Consultas legales, asistente personal, plan dental, consulta veterinaria, gestor administrativa</li><li>Hacemos equipo: compartimos momentos de diversión, porque sabemos lo importante que es dedicar espacios donde conectar y reírnos más allá de los proyectos y equipos con nuestras actividades de team building: videojuegos online, scape room, ajedrez, etc</li><li>Nos gusta juntarnos: celebramos el verano y la navidad y nos reencontramos en nuestra Santa´s Summer Party y en nuestra Christmas Party.</li></ul> Y si todo esto te parece poco, tenemos ???????????????????????? ???????????????????????????????????? que vamos realizando a lo largo del año. #joinus

<div><h2>Supply Chain Data Analyst, Supervisor</h2>Supervises team applying best standards and practices in Supply Chain and Logistics and monitors team compliance to relevant guidelines. Manages the resolution of inventory, asset, and vendor/suppliers deficiencies. Implements recommendations suggested to streamline current systems to optimize, maintain, and transform current processes, and oversees the creation of research plans to streamline new/existing business operating models according to supply chain future state. Manages the audits of suppliers, conducts corrective actions based on interpreting needs identified from audits, and facilitates business reviews. Facilitates strategic decisions making based on results on utilization, quality, inventory levels, and courier routes for projects, while assessing customer satisfaction levels.Essential Responsibilities:<ul><li>Recommends developmental opportunities for others; builds collaborative, cross-functional relationships. Solicits and acts on performance feedback; provides team members with feedback; and mentors and coaches to drive performance improvement. Pursues professional growth; provides training and development to talent for growth opportunities; supports execution of performance management guidelines and expectations. Implements, adapts, and stays up to date with organizational change, challenges, feedback, best practices and processes. Fosters open dialogue, supports, mentors, engages, and motivates team members on collaboration. Delegates tasks and decisions as appropriate; provides appropriate support, guidance and scope.</li><li>Supervises and coordinates daily activities of designated work team or unit by monitoring the execution and completion of tactical action items and work assignments; ensures all policies and procedures are followed. Aligns team efforts and standards, and measures progress in achieving results; determines and carries out processes and methodologies; resolves escalated issues as appropriate. Develops work plans to meet business priorities and deadlines; coordinates, obtains and distributes resources. Removes obstacles that impact performance; identifies and recommends improvement opportunities; influences teams to execute in alignment with operational objectives.</li><li>Ensures asset accounting by: guiding and providing support, when needed, for the asset approval (e.g., vehicles, medical equipment), transfer, and disposal processes; supervising the dispositions in the accounting system; supervising the compliance with policies and procedures that achieve accountability by proposing strategies for cost reduction for the misuse of assets; and maintaining an ongoing process to identify, evaluate, and implement cost restructuring and cost reductions.</li><li>Ensures ongoing quality customer services by: supervising the resolution of customer issues pertaining to vendors/suppliers reporting, billing, and merchandise while building and managing relationships with key customer; coordinating the resolution of backorder problems, delivery delays, repairs, designing route changes, customer concerns, and returns; supervising product returns and recalls; and reviewing reports (e.g., key metrics, cost and daily analysis) for customers.</li><li>Ensures adequate levels of inventory are maintained by: supervising the resolution of the receipt and distribution of inventory, and developing processes for the transactions and requests for supplies, equipment, and services; reviewing results from quantitative/qualitative analyses to forecast demand to minimize obsolescence or expiration; widely applying strategies for maintaining automated inventory and ordering systems to support inventory reconciliation and supervising routine inventory counts; confirming a wide range of complex reorder levels are updated, maintained, and adhered to so that proper product rotation remains valid, and inventory levels are accurate; and working collaboratively with contacts internal and external to the organization to maintain the inventory control system (e.g., ensure accuracy of product line, proper level of stock, rotation of product, cleanliness of product/carts).</li><li>Maintains and improves supply chain and operations by: supervising wide range of complex activities (i.e., shipping logistics, carrier, and inventory system evaluation) to optimize, maintain, and transform current processes for increased efficiency; developing and supervising research plans to identify new/existing business operating models according to supply chain future state functional and technical design; and, with contacts internal and external to the organization, implementing and monitoring processes to determine end-to-end sourcing, procurement, and logistics.</li><li>Ensures purchasing strategy is consistent with the overall national sourcing strategy by: supervising the processing of purchase requests; supervising the development of purchase standardization, quality, amounts, or equivalency; supervising the resolution of purchase-related problems and identifying and implementing cost savings opportunities, acting as a key contact for suppliers; supervising and recommending order quantities, while also coordinating product evaluations and trials; and coordinating efforts to select new products, disseminating information to the appropriate team, and equipment.</li><li>Provides direct oversight of compliance with state and federal regulations, and company policy/procedures pertaining to purchasing, inventory management, and distribution by: supervising the application of best standards and practices; supervising quotations for new stock and non-standard items, and fulfilling contracts to ensure compliance; implementing ongoing compliance monitoring (e.g., Joint commission, Sarbanes-Oxley [SOX]) and performance management audits to ensure staff performance is consistent with established standards; coordinating corrective action and the resolution of deficiencies as necessary on a timely basis and in accordance with company policy; and supervising the administration of programs of information, data, training, and education for managers/product users on standards programs, product selection, and expected compliance.</li><li>Maintains suppliers/vendors performance and relationships by: supervising the development of audit processes of suppliers/vendors, ensuring they comply with policies and regulations; supervising programs for enabling the onboarding of new suppliers/vendors and supporting contract negotiations with suppliers/vendors; coordinating corrective actions at scale; supervising the resolution of suppliers/vendor issues; and coordinating efforts to broadly improve strategies for meeting operational and cost targets across suppliers/vendors.</li><li>Provides technical analysis and reporting services for others by: coordinating analyses and monitoring results on utilization, quality, inventory levels, and courier routes for a wide range of complex projects; overseeing customer satisfaction levels, rounding member sites on monthly basis to check on open issues and improvement opportunities, and monitoring the implementation of proven quality improvement procedures; evaluating tools, techniques, and assumptions to ensure complex analyses are appropriate to support operational and business decisions; and coordinating reports in response to business needs for selected departments documenting a wide range of complex analytical results.</li></ul>Minimum Qualifications:<ul><li>Minimum two (2) years of experience with databases and spreadsheets.</li><li>Minimum one (1) years of experience in a leadership role with or without direct reports.</li><li>Bachelors degree in Business Administration, Economics, Finance, Material Management, Operations Research, or related field AND minimum four (4) years of experience in purchasing, contracting, negotiations, material management, logistics, finance, or a directly related field OR Minimum seven (7) years of experience in Materials and Inventory Control/Management, Logistics, Finance, Distribution, or a directly related field.</li></ul>Additional Requirements:Preferred Qualifications:<ul><li>One (1) year of experience in healthcare or another heavily regulated industry (e.g., Banking, Manufacturing).</li><li>Two (2) years of experience in project management.</li></ul></div>

<div><h2>Supply Chain Analyst</h2>Comfort starts with our 10,000+ team members across the globe, who are transforming the power of comfort every day. Our employees have the power to change lives, in our homes, work and communities. We foster an inclusive environment while honoring a legacy built on family, where everyone can be themselves. If you are ready to join an industry leading organization where our people are the most important asset, and innovation propels us into the future, you're ready to take your seat at La-Z-Boy Incorporated. WE BELIEVE IN THE TRANSFORMATIONAL POWER OF COMFORTJob Summary:Leverages expertise in data analytics, supply chain management, and business intelligence to provide actionable insights that drive operational efficiency, cost savings, and strategic decision-making. Leads projects that would involve data gathering, business intelligence, report writing and execution. Responsible for analyzing complex supply chain data, identifying trends, and optimizing processes. Collaborates cross-functionally with all Supply Chain teams. Possess strong technical proficiency in data analytics tools, an understanding of Supply Chain processes, and the ability to communicate complex findings in a clear, actionable manner.<h3>Key Responsibilities</h3><ul><li>Analyze and interpret large datasets related to Supply Chain performance</li><li>Develop and implement advanced analytics models to support Supply Chain decision making</li><li>Create and maintain interactive dashboards and reports to monitor key performance indicators (KPIs) and highlight areas for improvement</li><li>Ensure Supply Chain data accuracy and integrity</li><li>Conduct financial and strategic analysis leading to improved decision making, including ad-hoc analysis requests, developing new approaches to analysis, and creation of new reports</li><li>Supports business partners as needed in annual planning processes</li><li>Leads strategic projects that may involve cross-functional groups and teams or engage with external vendors/suppliers. Have the ability to see beyond the basic project and provide strategic direction, raise issues, resolve conflicts are all part of this role. Time management, deadline management and managing deliverables are key for this role.</li><li>Generate and issue recurring reports used in senior or executive management meetings and reviews, potentially as back-up for external reporting. Develop new reports as needed when new analysis is required. Educate other team members on reports and reporting tools.</li><li>Data management / business intelligence - maintaining, updating, upgrading or expanding the data tools used for analysis and projects. If needed, identify new tools and work with team to incorporate them into the business.</li><li>Defines system areas of improvement (E1, RMS, Visibility, Quality, data analytics tools) related to Supply Chain operations. Analyze and plan, provide solutions to management and coordinate implementation with IT. Confident and proven leader in system logic, processes and design</li><li>Support system projects, enhancements and rollouts related to Supply Chain operations. Ability to orchestrate the business side of system enhancements, updates and conversions in a way that has the least impact to normal operation.</li></ul>Scope & Impact:Supports overall Supply Chain business (including the entire RDC network) decision making by providing analysis, data metrics, and tools. This position provides key BI reporting and end-user system support to all Supply Chain teams. Leads "train the trainer" sessions with end-users on newly developed tools and processes. There is limited budgetary responsibility, but with a high level of influence for projects that may be multi-million-dollar range.Minimum Requirements:<ul><li>Bachelor's Degree in Supply Chain, Data Science, Business Analytics or related field with 4-6years of equivalent experience.</li><li>Demonstrated proficiency with business intelligence and data visualization tools.</li><li>Demonstrated ability to solve analytical problems and provide insight under deadlines.</li><li>Strong proficiency in data analytics tools (e.g., Excel, SQL, Power BI)</li><li>Experience with ERP systems (e.g., Oracle, SAP)</li><li>Ability to recognize issues, problems, and process improvements, initiate and make recommendations.</li><li>Self-motivated to solve problems and ability to adapt quickly to changes in priorities.</li><li>Excellent written, presentation, and verbal communication skills.</li><li>Ability to work within a team-based environment on multiple projects at once and collaborate within the organization to gather necessary information.</li><li>Knowledge of management strategies, financial accounting, mergers and acquisitions, supply chain, manufacturing, and retail operations.</li><li>Project management skills to drive change across organization and accomplish stated goals.</li><li>Travel Required: Up to 10%</li></ul>Preferred Requirements:<ul><li>ASCM (APICS) or equivalent certification</li><li>Microsoft Power BI certification</li><li>Proficiency with Microsoft Power BI, Domo, and SAP Business Objects</li><li>Experience with Oracle JD Edwards E1</li><li>Experience with database software (e.g., Snowflake, Microsoft SQL Server)</li><li>Local to the Monroe, MI area</li></ul>Supervisory Responsibilities: NonePhysical Demands/Work Environment:Office environment/no specific or unusual physical environmental demands.Other Duties:Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the incumbent for this job. Duties, responsibilities and activities may change at any time with or without notice.Additional Job Description:Weekly Hours: 40Benefits for Employees in the US:Benefit offerings to employee and their families include: Medical, Vision, Dental and Basic Life Insurance available 401k retirement plan with company match of up to 6%. Paid time off includes: 9-11 paid holidays each year, two weeks' prorated vacation as a new hire and either personal time (non-exempt only) or state mandated sick time.At La-Z-Boy Incorporated, we're an equal opportunity employer. We understand that our employees' diverse backgrounds, experiences, perspectives, and viewpoints add value to our ability to create and deliver the best possible service, quality products, and is of upmost importance as we work together to build comfort. All applicants will be considered for employment without attention to race, color, religion, sex, sexual orientation, gender identity, national origin, veteran or disability status.We are committed to fostering an environment in which all employees feel valued, included, and empowered to do their best work and bring great ideas to the table. If you are a qualified individual that may need a change or adjustment to the application/interviewing/hiring process as a result of your disability, you may request a reasonable accommodations by emailing our recruiting team at recruiting@la-z-boy.com or by calling 734-242-1444.</div>

About Signify Through bold discovery and cutting-edge innovation, we lead an industry that is vital for the future of our planet: lighting. Through our leadership in connected lighting and the Internet of Things, we're breaking new ground in data analytics, AI, and smart solutions for homes, offices, cities, and beyond. At Signify, you can shape tomorrow by building on our incredible 125+ year legacy while working toward even bolder sustainability goals. Our culture of continuous learning, creativity, and commitment to diversity and inclusion empowers you to grow your skills and career. Join us, and together, we’ll transform our industry, making a lasting difference for brighter lives and a better world. You light the way. More About The Role This is an exciting job opportunity for you to light the way as a Product Data Analyst Intern in Eindhoven with Signify. Your Responsibilities Will Include <ul><li>Maintaining and improving data quality dashboards to track accuracy, completeness, and consistency of product data</li><li>Automating repetitive tasks using Python or Excel macros</li><li>Performing mass data uploads and corrections for product information</li><li>Investigating customer/market complaints on published product data and implement corrective actions</li><li>Collaborating with cross-functional teams (Product Management, MCM, Factory Data Management, IT) to resolve data issues and improve processes</li><li>Supporting marketing text and product data improvements leading to online product findability.</li><li>Assisting with sustainability related data requirements, including Environmental Product Declarations (EPDs) </li></ul>Key Requirements <ul><li>SQL: Comfortable writing queries, handling joins, aggregations, and creating/optimizing database structures.</li><li>Snowflake: Confident navigating the platform, managing data pipelines, and working with cloud-based databases.</li><li>Power BI: Able to design dashboards, build visualizations, and analyse data effectively.</li><li>Excel: Proficient in advanced functions, data manipulation, pivot tables, and large dataset management.</li><li>Python: Experience with scripting for data analysis, automation, and working with libraries such as Pandas, NumPy, or similar. </li></ul>More About You While we value and appreciate all applicants, we believe that the following experience and skills will be needed to shine brightly in this job opening: <ul><li>MSc student in Business, Marketing, Data Science or related field</li><li>Previous experience working on projects or coursework involving the tools mentioned under key requirements</li><li>Proven ability to learn and adapt quickly to new challenges.</li><li>Strong analytical and problem-solving skills </li></ul>Everything we’ll do for you You can grow a lasting career here. We’ll encourage you, support you, and challenge you. We’ll help you learn and progress in a way that’s right for you, with coaching and mentoring along the way. We’ll listen to you too, because we see and value every one of our 30,000+ people. We believe that a diverse and inclusive workplace fosters creativity, innovation, and a full spectrum of bright ideas. With a global workforce representing 99 nationalities, we are dedicated to creating an inclusive environment where every voice is heard and valued, helping us all achieve more together. Come join us, and together we can light the way.

Question	Topic	Difficulty	Ask Chance
Causal Inference Without A/B	A/B Testing & Experimentation	Medium	Very High
Department Expenses	SQL	Medium	Very High
Black Friday Shopping Spree	SQL	Medium	Very High

Shopee Data Analyst Interview Questions + Guide in 2025

Overview

Shopee Data Analyst Interview Process

Shopee Data Analyst Interview Questions

Shopee Data Analyst Jobs