> Markdown version of [/jobs/ext/2954363-it-project-coordinator-2](https://www.wearedevelopers.com/jobs/ext/2954363-it-project-coordinator-2). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # IT Project Coordinator 2 - **Company:** Celestica, Inc. - **Location:** Portsmouth, NH, United States (Remote available) - **Experience:** Experienced - **Contract:** Permanent contract - **Skills:** Microsoft Excel, Data Analysis, Analysis of Variance (ANOVA), Big Data, Spreadsheets, Information Systems, Data Integration, Data Integrity, Data Mining, Data Warehousing, Database Queries, Excel Formulas, Issue Tracking Systems, Python (Programming Language), SAP ERP, Power BI, Anaplan, Salesforce.Com, SAP (Applications), SQL Databases, Transaction Data, Unstructured Data, Scripting, Macros, Powerquery, Information Technology, Vba Programming Language, Data Analytics - **Published:** September 17, 2026 - **Apply:** https://www.careerjet.com/job/usbaa84d03fb81638923136d5349310c3e/eaa ## About the Role * 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. ## Description 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., 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., We are seeking an experienced, highly organized, proactive and detail-focused Executive Operations & Administrative Coordinator to provide administrative, operational, and project-… + 2 days ago + Apply easily ## Related Videos - [Headless by Design: Building Enterprise Systems That Agents Can Actually Use](https://www.wearedevelopers.com/videos/100092-headless-by-design-building-enterprise-systems-that-agents-can-actually-use) - [Crafting Custom Frameworks with Rust: A Deep Dive into Procedural Macros](https://www.wearedevelopers.com/videos/849-crafting-custom-frameworks-with-rust-a-deep-dive-into-procedural-macros) - [From Global Capability Centers to AI-Powered Command Centers](https://www.wearedevelopers.com/videos/100096-from-global-capability-centers-to-ai-powered-command-centers) - [Delete the roles, deploy the skills](https://www.wearedevelopers.com/videos/2104-delete-the-roles-deploy-the-skills) - [Modularity: Let's dig deeper](https://www.wearedevelopers.com/videos/1200-modularity-let-s-dig-deeper) - [Remote Driving on Plant Grounds with State-of-the-Art Cloud Technologies](https://www.wearedevelopers.com/videos/251-remote-driving-on-plant-grounds-with-state-of-the-art-cloud-technologies) ## Related Articles - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Best Companies to work for in London: Top 25 Companies in 2023](https://www.wearedevelopers.com/magazine/187-best-companies-to-work-for-in-london-top-25-companies-in-2023) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [How We Built a Worry-Free System That Runs for 10+ Years – And What We’d Do Again](https://www.wearedevelopers.com/magazine/751-how-we-built-a-worry-free-system-that-runs-for-10-years-and-what-we-d-do-again) - [IT Salaries in UK](https://www.wearedevelopers.com/magazine/288-it-salaries-in-uk)