Dataford
Dataford
Top 15
Prep plan
Updated weekly · Last refresh Oct 17

Celestica Business Analyst Interview Questions

The questions to prepare for a Celestica Business Analyst interview. Questions from real interview reports rank first. Updated daily.

15questions
~2htotal time
Track your progressSign up free to work through all 15 questions and resume where you left off.
Start practicing free →
1
Behavioral & LeadershipStart here. 10 questions · ~80 min
Clarifying Requirements for a New SystemMedium

Tests structured requirements gathering under ambiguity, including stakeholder alignment, documentation quality, and ownership through delivery.

processdocumentationrequirementsCelestica
Taking Initiative on a Financial GapEasy

Tests initiative and ownership by asking for a concrete example of proactively solving a problem with measurable business impact.

Influence Without AuthorityLeadershipOwnershipCelestica
Contradicting Senior Stakeholder IntuitionMedium

Tests influence without authority when data conflicts with senior judgment, including stakeholder management and clear communication.

Conflict ResolutionStakeholder ManagementAnalysisCelestica
More Behavioral & Leadership questions with a free account
2
More topics5 questions · ~40 min
Applying Supply Chain Trends DailyMedium

Tests how you connect market and supply chain signals to practical business analysis work at Celestica.

Market TrendsBusiness Acumensupply chainCelestica
Excel Proficiency for AnalysisMedium

Assesses hands-on Excel capability for analysis, reporting, and decision support.

ExcelskillsCelestica
Prioritizing Analysis Under Time PressureHard

Tests your triage, analytical prioritization, and ability to produce actionable insights quickly.

Data AnalysisExecutionPrioritizationCelestica
Why Celestica and EMS DifferentiationMedium

Tests your motivation and your ability to articulate Celestica's differentiation in electronics manufacturing.

Business ModelCompetitive AnalysismotivationCelestica
Validating Data Integrity Across ERPsMedium

Tests your data validation, reconciliation, and reporting accuracy practices across systems.

Reconciliationdata integrityerp systemsCelestica

Sign up to see every question

Create a free account to unlock this list and practice real interview questions.

Get my prep plan
Hands-on SQL practiceWrite and run real queries in the editor. 3 drills · ~30 min
Second-Highest Transaction Amount QueryMedium
Practice
Practice drill

Find the second-highest distinct transaction amount using a subquery in PostgreSQL without LIMIT.

SubqueriesRankingsalaryCapgemini FSSBUFreechargeNPCI
Data Visualization TechniquesMedium
Practice
Practice drill

Create monthly, region-level metrics suitable for data visualization using SQL joins, date handling, and aggregation.

analytics toolspresentationdata visualizationWalmart Global TechExperian HealthFIRSTNET GLOBAL
Excel Expertise for AnalysisMedium
Practice
Practice drill

Classify employees by Excel expertise level using completed task counts and training hours.

analytics toolsData Analysisbusiness problemBoeing
The finish line: interview-readyComplete all 15 questions plus 3 hands-on drills to finish this plan.