IT Project Coordinator 2

Req ID: 140468

Remote Position: Yes

Region: Americas

Country: USA

General Overview

Functional Area: Information Technology (ITM)

Career Stream: IT Project Management (ITM_PRM)

Role: Coordinator 2

Job Title: IT Project Coordinator 2

Job Code: CR2-ITM-PROJ

Direct/Indirect Indicator: Indirect

Summary

We are seeking a highly analytical and detail-oriented Service Pricing & Business Data

Analyst (Band 08) to join our growing Services Organization. This unique hybrid role bridges

Financial Planning & Analysis (FP&A), Data Analytics, and IT Systems to drive commercial

success across our global service offerings.

In this role, you will be primarily responsible for building, refining, and maintaining complex

financial and pricing models across key service offerings-including Advanced Exchange

Program (AEP), Warranty & Repair, Onsite Support, IT Asset Management (ITAM), and IT

Asset Disposition (ITAD). You will aggregate and analyze large datasets from cross-functional

platforms (SAP ERP, Salesforce CRM, ticketing, and data warehouses) to deliver strategic

pricing recommendations, evaluate customer profitability trends, and optimize contract margin

performance.

Detailed Description

Performs tasks such as, but not limited to, the following:

Service Pricing & Financial Modeling

Design, construct, and continuously refine dynamic, multi-variable pricing models for

complex service agreements (AEP, Warranty/Repair, Onsite Services, ITAM, ITAD).

Integrate granular cost drivers into pricing models, including labor rates,

component/material costs, turn-around time (TAT) metrics, Service Level Agreements

(SLAs), volumes, and target margin thresholds.

Conduct scenario modeling, sensitivity analyses, and cost-benefit assessments to support

new deal quoting, contract renewals, and commercial bidding strategy.

Partner with Commercial, Finance, and Operations leads to validate cost inputs and

maintain pricing governance and deal approval frameworks.

Data Integration & Analytics

Extract, clean, and consolidate customer operational, financial, and transactional data

from disparate platforms (SAP ERP, Salesforce/CRM, internal service ticketing systems,

and data warehouses).

Build and maintain interactive dashboards and reporting solutions in Power BI to monitor

customer margins, service delivery costs, and pricing variances.

Track pricing accuracy and post-sale commercial performance against forecasted

margins, highlighting risks and revenue recovery opportunities.

Business & Trend Analysis

Analyze customer utilization metrics, historical repair/replacement trends, and service

request volumes to identify profitability leaks and operational efficiencies.

Provide variance analysis between modeled pricing expectations and actual delivery

costs during month-end and quarterly financial reviews.

Automate financial and pricing data workflows to reduce manual input, improve

throughput, and elevate data integrity across systems.

Prepare clear executive summary presentations and actionable insights for senior

leadership and cross-functional partners.

Knowledge/Skills/Competencies

Technical Skills

Advanced Microsoft Excel Proficiency: Expertise in complex formulas, nested logic,

index/match, dynamic arrays, VBA/macros, Scenario Manager, and financial/pricing

model architecture.

Business Intelligence & Data Analysis: Strong skills in Power BI (DAX, Power Query)

for building visual reporting dashboards.

System Familiarity: Prior experience pulling, blending, and querying data from ERP

systems (SAP preferred), CRM platforms (Salesforce), ticketing platforms, or SQL-based

data warehouses.

Financial Acumen: Solid understanding of FP&A principles, revenue recognition, cost

accounting (COGS), margin analysis, and contractual financial structures.

Core Competencies

Hybrid Analytical Mindset: Ability to synthesize complex, unstructured data into clear,

commercially viable financial models and strategic business recommendations.

Problem-Solving & Attention to Detail: Rigorous standards for data accuracy, error-

checking, and auditability in complex spreadsheets.

Cross-Functional Collaboration: Strong communication skills to interact effectively with

Finance, IT, Operations, Legal, and Sales teams.

Time Management: Capability to prioritize multiple urgent quoting requests and long-

term analytics projects in a fast-paced environment.

Preferred Qualifications / Plus Factors

Proficiency in SQL, Python, or R for data extraction and scripting.

Familiarity with enterprise financial planning tools (e.g., SAP, Anaplan).

Experience with circular economy, reverse logistics, or lifecycle asset management

models (ITAM/ITAD).

Physical Demands

Typical Experience

2-5 years of progressive experience in FP&A, commercial pricing, business/data analytics, or financial operations.

Typical Education

Bachelor's degree in Finance, Accounting, Data Analytics, Information Systems, Business Administration, or a related quantitative field.

Notes

This job description is not intended to be an exhaustive list of all duties and responsibilities of the position. Employees are held accountable for all duties of the job. Job duties and the % of time identified for any function are subject to change at any time.

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

This policy applies to hiring, promotion, discharge, pay, fringe benefits, job training, classification, referral and other aspects of employment and also states that retaliation against a person who files a charge of discrimination, participates in a discrimination proceeding, or otherwise opposes an unlawful employment practice will not be tolerated. All information will be kept confidential according to EEO guidelines.

Celestica is an E-Verify employer.

Location: This is a remote position, with travel as necessary. We are open to considering candidates close to any of our US locations in Massachusetts, Pennsylvania, Minnesota, Texas, Arizona, Oregon or California as well as locations near major airports such as the Northeast, Southeast, Midwest and Pacific Coast.

COMPANY OVERVIEW:

Celestica, Inc. (NYSE: CLS; TSX: CLS) is a technology leader dedicated to driving customer success and market advancements. With deep expertise in design, engineering, manufacturing, supply chain, and platform solutions, Celestica enables critical data center infrastructure for AI, cloud, and hybrid cloud and advances technologies in high-growth markets. With a talented team and a strategic global network, Celestica helps its customers achieve competitive advantages.

Today, Celestica delivers innovative supply chain solutions globally to customers in strategic two operating and reporting segments: Advanced Technology Solutions (ATS) and Connectivity and Cloud Solutions (CC):

ATS: This segment serves customers in complex, regulated and high-reliability markets such as Industrial & Smart Energy, Aerospace & Defense, Semiconductor Capital Equipment, and HealthTech. It is engineering led, with deep expertise in design, manufacturing and lifecycle solutions.

CCS: This segment focuses on high-performance technology solutions and services for the data center, serving hyperscalers, digital native customers and enterprises. Celesticas Platform Solutions offering provides innovative and customizable computing, storage and networking solutions enabling AI-driven growth.

Built on a legacy of trust and performance, Celestica has earned its reputation by delivering results in complex and fast-changing markets. Celestica exceeds customer expectations by identifying trends and staying ahead of the curve. Backed by comprehensive capabilities and a global network across North America, Europe and Asia, Celestica helps customers gain competitive advantage with the quality, flexibility and resiliency they need to respond quickly to shifts in demand. Guided by a bold vision to accelerate market advancements, Celestica delivers innovative solutions and technologies that turn complexity into opportunity. Anchored in teamwork and commitment, Celestica strives to be the most trusted partner to its customers and colleagues worldwide.

Celestica would like to thank all applicants, however, only qualified applicants will be contacted.

Celestica does not accept unsolicited resumes from recruitment agencies or fee based recruitment services.