Why This Role Stands Out
You'll drive critical data-driven decisions for engineering resource allocation and capacity planning within a leading technology company, offering significant impact on strategic project prioritization and roadmap adjustments. This hybrid role is ideal for a mid-senior data analyst who thrives on complex analysis, scenario modeling, and ensuring optimal talent deployment, providing excellent opportunities for skill development and career advancement. Apply now to contribute to a renowned organization and gain visibility across a substantial engineering base.
Quick Overview
Job 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)
- 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
Renesas is an embedded semiconductor solution provider driven by its Purpose, To Make Our Lives Easier. With a global team of over 21,000 engineers and problem solvers in more than 30 countries, we offer the opportunity to work on world‑leading technology for Automotive, Industrial, Infrastructure, and IoT, shaping a safer, healthier, greener, and smarter future.
At Renesas, TAGIE is our culture, grounded in being Transparent, Agile, Global, Innovative, and Entrepreneurial. It shapes how we work, grow and deliver on our purpose together. This collaborative spirit and mindset drive our semiconductor technology to transform industries and impact millions of lives.
We believe in rewarding our employees with a competitive benefits package alongside their salary. More information will be provided during the hiring process.
Are you ready to join our team and shape the future with us?
Renesas Electronics is an equal opportunity and affirmative action employer, committed to supporting diversity and fostering a work environment free of discrimination on the basis of sex, race, religion, national origin, gender, gender identity, gender expression, age, sexual orientation, military status, veteran status, or any other basis protected by law. For more information, please read our Diversity & Inclusion Statement.
Similar jobs
- S-
Data Analyst
NewSR2 - Socially Responsible Recruitment
London🇬🇧Remote1 hour agoSQLAgileTechnology - EI
Market Insight and Data Analyst
NewExperis IT
Birmingham🇬🇧£38.0k - £44.1k/yrOn-site1 hour agoSQLPower BIPythonTechnology - HA
Data Analyst
NewHarnham
london🇬🇧£55k/yrHybrid1 hour agoStakeholder ManagementVBATechnology - MG
Senior Market Data Analyst
NewMan Group
London🇬🇧On-site11 hours agoSQLGitJira+2Technology - MG
People Analytics & amp ; AI Transformation Analyst
NewMan Group
London🇬🇧On-site11 hours agoSQLGDPRPower BI+2 - LC

Pensions Administration Data Services Assistant / Analyst
NewLane Clark & Peacock
London🇬🇧Hybrid11 hours agoMicrosoft ExcelAdministrative