IT Project Coordinator 2
Celestica · Hillsborough County, NH · 1 mo ago
Information TechnologyFull-time
We need to output HTML fragment with sections only if content present. Must not repeat job title as heading. Use for section headings: About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule. We need to extract content from posting.
We need to remove boilerplate: EEO, legal, etc. Also remove application instructions (none). Remove duplicated lines.
We need to preserve all substantive info.
Let's parse posting.
First part: "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."
That's the summary/overview.
Then "Detailed Description Performs tasks such as, but not limited to, the following:" then bullet list.
We need to extract responsibilities: likely the list under Detailed Description.
Then "Knowledge/Skills/Competencies Technical Skills ..." then list.
Then "Preferred Qualifications / Plus Factors ..."
Then "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."
Then "Notes ..." (boilerplate). Then "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."
Then "Company Overview ..." (maybe we can include as About the role? Actually About the role could be summary. Company Overview maybe not needed but could be included as About the role? The instruction: use headings for sections like About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule. We need to decide which sections have content.
We have:
- About the role: could be the summary/overview (General Overview). That seems appropriate.
- Responsibilities: the detailed description list.
- Requirements: maybe the Typical Experience and Education? Or "Preferred Qualifications / Plus Factors" could be Qualifications? Actually "Qualifications" heading could capture both required and preferred? The instruction: Use headings for sections like About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule. So we need to map.
We have Technical Skills (list) and Core Competencies (list) under Knowledge/Skills/Competencies. That could go under Skills.
We have Preferred Qualifications / Plus Factors (list) could go under Qualifications.
We have Typical Experience and Education could go under Requirements (or Qualifications). Usually Requirements includes experience and education. We'll put them under Requirements.
We have no explicit Benefits, Pay, Schedule info. So we should NOT create those sections.
We also have Location info (remote, travel). Could be part of About the role or maybe a separate section? Not in allowed headings. Could fold into About the role as a paragraph.
We must not include boilerplate like EEO, E-Verify, etc.
We must not repeat job title as heading.
We must output only HTML fragment.
Let's craft sections:
for section headings: About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule. We need to extract content from posting.
We need to remove boilerplate: EEO, legal, etc. Also remove application instructions (none). Remove duplicated lines.
We need to preserve all substantive info.
Let's parse posting.
First part: "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."
That's the summary/overview.
Then "Detailed Description Performs tasks such as, but not limited to, the following:" then bullet list.
We need to extract responsibilities: likely the list under Detailed Description.
Then "Knowledge/Skills/Competencies Technical Skills ..." then list.
Then "Preferred Qualifications / Plus Factors ..."
Then "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."
Then "Notes ..." (boilerplate). Then "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."
Then "Company Overview ..." (maybe we can include as About the role? Actually About the role could be summary. Company Overview maybe not needed but could be included as About the role? The instruction: use headings for sections like About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule. We need to decide which sections have content.
We have:
- About the role: could be the summary/overview (General Overview). That seems appropriate.
- Responsibilities: the detailed description list.
- Requirements: maybe the Typical Experience and Education? Or "Preferred Qualifications / Plus Factors" could be Qualifications? Actually "Qualifications" heading could capture both required and preferred? The instruction: Use headings for sections like About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule. So we need to map.
We have Technical Skills (list) and Core Competencies (list) under Knowledge/Skills/Competencies. That could go under Skills.
We have Preferred Qualifications / Plus Factors (list) could go under Qualifications.
We have Typical Experience and Education could go under Requirements (or Qualifications). Usually Requirements includes experience and education. We'll put them under Requirements.
We have no explicit Benefits, Pay, Schedule info. So we should NOT create those sections.
We also have Location info (remote, travel). Could be part of About the role or maybe a separate section? Not in allowed headings. Could fold into About the role as a paragraph.
We must not include boilerplate like EEO, E-Verify, etc.
We must not repeat job title as heading.
We must output only HTML fragment.
Let's craft sections:
About the role
... summary plus location info maybe. We need to include all substantive info: Remote position, travel as necessary, open to candidates near certain US locations and major airports. We'll include that. Then
Responsibilities
- ... each bullet from Detailed Description. We need to extract bullet points: The list after "Performs tasks such as, but not limited to, the following:" includes: - 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. We need to flatten into
- items. Could keep sub-bullets as separate
- but maintain content. We'll produce each as separate
- .
Then
Requirements
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.
ThenQualifications
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).
Skills
We have Technical Skills and Core Competencies. We could combine into one- with items.
Technical Skills list:
- 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.
We'll put each as
- .
We must not include Benefits, Pay, Schedule.
Now ensure we didn't include any boilerplate like EEO, E-Verify, etc.
Check for any leftover like "Notes This job description is not intended to be an exhaustive list..." that's boilerplate; we should drop.
Also drop "Celestica is an Equal Opportunity Employer..." etc.
Also drop "Celestica is an E-Verify employer."
Also drop "Celestica would like to thank all applicants..." etc.
Also drop "Company Overview" maybe we could include as About the role? But we already have About the role with summary. The company overview is extra but could be considered part of About the role? The instruction: include a section ONLY when the posting has real, specific content for it. The posting does have company overview content. Could we add another section like "About the company"? Not allowed headings. So we could incorporate into About the role paragraph after summary. That would be okay.
Thus About the role paragraph will include summary + location + company overview.
We need to preserve all substantive information; we must not omit company overview details. So we will include them.
Let's craft About the role paragraph:
We have 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."
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: paragraphs about Celestica.
We'll combine into one
maybe multiple
but instruction: use
for prose. Could have multiple
under the section. That's fine. We'll output:
About the role
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.
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.
Celestica, Inc. (NYSE: CLS; TSX: CLS) is a technology