IT Project Coordinator

Position: IT Project Coordinator 2
Req

Remote Position:
Yes

Region:
Americas

Country: USA

** General Overview*
* *
* Functional Area

** :
Information Technology (ITM)

** Career Stream** : IT Project Management ()

** 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 (FPA), 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 FPA principles, revenue recognition, cost

accounting (COGS), margin analysis, and contractual…