Data Analyst (Engineering Resource Management)

Renesas; Swindon; On-site; GBP 55,000 - 75,000; Full time

Job summary

Renesas seeks a data-driven Resource Planning Analyst to enable efficient allocation of engineering talent across R&D projects. You will build and maintain a resource database, create dashboards, and support capacity and demand forecasting to inform senior management decisions.

You will model scenarios, perform cost estimations, and collaborate with Finance, HR, and project leads to drive continuous improvement in resource management.

Qualifications

• 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
• Strong written and verbal communication in English; ability to communicate clearly with senior management

Responsibilities

• Enable data-driven engineering resource allocation and strategic capacity planning across the R&D organisation.
• Maintain and update the resource allocation database and dedicated resource management tool.
• Conduct scenario analysis to evaluate feasibility of new projects against available capacity.
• Develop capacity forecasts for 6-12 month horizons to support staffing decisions.
• Extract, transform, and analyze complex resource data from multiple sources and produce dashboards.
• Support project cost estimation based on resource allocation models and make-vs-buy analysis.
• Collaborate with R&D Managers, Programme/Design Controllers, and Leadership to present findings.

Skills

Data analysis

Resource planning

Stakeholder communication

Problem solving

Education

Tools

Power BI

Tableau

SQL

Python

R

Job description

• Full-time
• Employment Type: Regular (PERM)
• Remote Work Available: No

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

Analyzecurrent and projected resource utilization across projects. Identify capacity gaps, bottlenecks, and resource constraints by skill set. Develop capacity forecasts for6-12 monthhorizons to support staffing and recruitment planning decisions.

Data Analysis and Reporting

Extract, transform, andanalyzecomplex 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.Analyzecost 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.

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)

Qualifications

• 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 toanalyzelarge, 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

Additional Information

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 .