Celestica

IT Project Coordinator 2

Celestica$80K — $95K *
US-AnywhereRemote in New Hampshire, US
Finance & Insurance
Less than 5 years of experience
Job Overview by Ladders

Qualifications

  • Bachelor's degree in Finance, Accounting, Data Analytics, or a related field.
  • 2-5 years in FP&A, pricing, or business/data analytics roles.
  • Advanced proficiency in Microsoft Excel; familiarity with financial modeling and complex formulas.
  • Experience with Power BI for data visualization and reporting.
  • Understanding of financial principles including cost accounting and margin analysis.

Responsibilities

  • Design and refine multi-variable pricing models for service agreements.
  • Integrate cost drivers into pricing models for various services.
  • Conduct scenario modeling and cost-benefit assessments for deal quoting.
  • Extract and consolidate data from ERP and CRM systems.
  • Build interactive dashboards in Power BI to track pricing and margins.
  • Analyze service request data to identify profitability trends and operational efficiencies.
  • Automate financial workflows to enhance data accuracy and efficiency.

Benefits

  • Remote work flexibility with opportunities for travel when necessary.
  • Engagement in a hybrid role bridging finance, data analytics, and IT systems.
  • Collaboration with cross-functional teams for comprehensive business insights.
Full Job Description
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.

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.

About Celestica

Celestica is a Canadian multinational electronics manufacturing services company headquartered in Toronto, Ontario. The company provides a range of services to original equipment manufacturers (OEMs) in the aerospace and defense, communications, enterprise computing, healthcare, industrial, semiconductor, and smart energy industries. Celestica's services include design and engineering, supply chain management, assembly and testing, and after-market services. The company operates in North America, Europe, and Asia and has manufacturing facilities in over 10 countries. Celestica was founded in 1994 as a subsidiary of IBM Canada and became an independent company in 1997.
Learn more about Celestica
Size
23,915 employees
Market Cap
$1.3 billion
Industry
Founded
1994
5 Year Trend
-1.3%
NASDAQ

Similar Jobs

More Jobs at Celestica

More Finance & Insurance Jobs

Find similar IT Project Coordinator 2 jobs: