> Markdown version of [/jobs/ext/3323002-data-analyst-engineering-resource-management](https://www.wearedevelopers.com/jobs/ext/3323002-data-analyst-engineering-resource-management). 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). --- # Data Analyst (Engineering Resource Management) - **Company:** Renesas - **Location:** Swindon, UK - **Experience:** Experienced - **Contract:** Permanent contract - **Skills:** Microsoft Excel, Data Analysis, Big Data, Databases, Data Integration, Data Visualization, Python (Programming Language), Lookup Table, Pivot Tables, Power BI, Standard Sql, Tableau (Software), Macros, Data Analytics, Tools for Reporting - **Published:** September 23, 2026 - **Apply:** https://dejobs.org/x/x/C3969C4A34F141E5B06ECA94C7263388/job/ ## About the Role * 4-7 years' experience in data analysis, business analytics, resource planning, or related quantitative roles * Advanced proficiency in Excel, including pivot tables, VLOOKUP, INDEX-MATCH, data consolidation, and macros * Experience with Power BI, Tableau, or similar data visualization and analytics tools * Intermediate SQL skills or equivalent ability to extract and transform data * Experience with Python or R for data processing and analysis * Understanding of project and resource management concepts and practices * Ability to analyze large, complex datasets and identify patterns, trends, and anomalies * Strong written and verbal communication in English; ability to communicate clearly with senior management * Excellent interpersonal skills; ability to build relationships with cross-functional teams * Detail-oriented; able to maintain data integrity and follow processes consistently * Resilient and proactive; comfortable with ambiguity and capable of persistent problem-solving ## Description Enable data-driven engineering resource allocation and strategic capacity planning across the R&D organisation. This role provides the Resource Planning team and senior management with accurate, actionable analytics on engineering resource utilization, demand forecasting, and project feasibility analysis. The role is critical to ensuring optimal allocation of engineering talent to high-priority projects on the roadmap. SCOPE AND SCALE: * Analysis across ~80-150+ engineers in the PCP R&D engineering resource base * Portfolio-level visibility across 10-25+ concurrent projects * Support for capital and resource budgeting decisions * Integration with enterprise resource planning and project management tools ? Resource Database and Tool Management Maintain and continuously update the resource allocation database and dedicated resource management tool, ensuring accuracy of engineer skills, availability, project assignments, and planned capacity. Develop and maintain data validation procedures and automated integrity checks. ? Scenario Analysis and Planning Support Conduct scenario analysis to evaluate feasibility of new projects against available engineering capacity. Model multiple resource allocation scenarios and support what-if analysis for strategic decisions on project prioritization and roadmap adjustments. ? Capacity Planning and Demand Forecasting Analyze current and projected resource utilization across projects. Identify capacity gaps, bottlenecks, and resource constraints by skill set. Develop capacity forecasts for 6-12 month horizons to support staffing and recruitment planning decisions. ? Data Analysis and Reporting Extract, transform, and analyze complex resource data from multiple sources. Create dashboards and automated reporting for stakeholder visibility. Produce regular reports on resource utilization, project allocation, and KPIs. Develop data-driven insights and recommendations for senior management. ? Cost and Resource Estimation Support project cost estimation based on resource allocation models. Analyze cost implications of different resource allocation strategies. Provide cost-benefit analysis for make-vs-buy and outsourcing decisions. ? Continuous Improvement and Framework Development Maintain and enhance the resource analysis and management framework in collaboration with the Resource Planning team. Implement process improvements and efficiency gains in resource tracking and analysis. Evaluate and recommend enhancements to resource management tools and systems. ? Stakeholder Collaboration and Communication Liaise with R&D Managers, Programme/Design Controllers, and Leadership to understand resource planning needs. Present findings and recommendations to senior management. Support resource allocation decisions through clear data storytelling. Work with Finance and HR on resource budget and headcount planning. ? KEY PERFORMANCE MEASURES Success in this role will be measured by: * Resource forecasts and capacity plans align with actual outcomes within<5% variance * Resource database reflects real-time project status with >95% data accuracy * Resource managers and senior leadership use analytical outputs in >80% of resource allocation decisions * Automation of recurring reports and analyses reduces manual effort by >30% year-on-year * Analysis and recommendations lead to measurable improvements in resource utilization and project delivery * Ad-hoc analytical requests completed within agreed SLAs (typically 5-10 working days) ## Related Videos - [Alibaba Big Data and Machine Learning Technology](https://www.wearedevelopers.com/videos/37-alibaba-big-data-and-machine-learning-technology) - [Data Driven HR in Europe](https://www.wearedevelopers.com/videos/1489-data-driven-hr-in-europe) - [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) - [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag) - [Data Analytics with Microsoft Fabric: End-to-End Use Case with Data Agents](https://www.wearedevelopers.com/videos/1547-data-analytics-with-microsoft-fabric-end-to-end-use-case-with-data-agents) - [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt) ## Related Articles - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Data Analyst Salary in Switzerland](https://www.wearedevelopers.com/magazine/276-data-analyst-salary-in-switzerland) - [Data Analyst Salary Austria](https://www.wearedevelopers.com/magazine/275-data-analyst-salary-austria) - [Software Engineer Salary London](https://www.wearedevelopers.com/magazine/252-software-engineer-salary-london) - [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market)