{bc}
indeed

Data Analyst (Engineering Resource Management)

Renesas
GBR
Full-time
Senior
Onsite
Discovered 1 months ago
ExcelPower BITableauSQLPythonR

Full Job Posting

Role overview

Enable data-driven engineering resource allocation and strategic capacity planning across the R&D organisation.

Provide actionable analytics on engineering resource utilization, demand forecasting, and project feasibility.

Support resource planning teams and senior management with decisions on high-priority roadmap projects.

Scope and scale

Analyze an engineering resource base of approximately 80-150 or more engineers.

Provide portfolio-level visibility across approximately 10-25 or more concurrent projects.

Support capital and resource budgeting decisions and integration with enterprise planning tools.

Resource management

  • Maintain the resource allocation database and dedicated resource management tool.
  • Track engineer skills, availability, project assignments, and planned capacity with high accuracy.
  • Develop data validation procedures and automated integrity checks.

Planning and forecasting

  • Model resource allocation scenarios to assess new project feasibility and roadmap priorities.
  • Analyze utilization, capacity gaps, bottlenecks, and constraints by skill set.
  • Produce six- to twelve-month capacity forecasts for staffing and recruitment planning.

Analysis and reporting

  • Extract, transform, and analyze complex resource data from multiple sources.
  • Create dashboards and automated reporting for stakeholder visibility.
  • Produce reports on resource utilization, project allocation, and KPIs.

Cost and improvement

  • Support project cost estimation and cost-benefit analysis for make-versus-buy and outsourcing decisions.
  • Improve resource tracking and analysis processes and recommend enhancements to management tools and systems.

Stakeholder collaboration

  • Work with R&D managers, programme and design controllers, and leadership to understand planning needs.
  • Present findings and recommendations to senior management through clear data storytelling.
  • Collaborate with Finance and HR on resource budgets and headcount planning.

Qualifications

  • 4-7 years of experience in data analysis, business analytics, resource planning, or related quantitative roles.
  • Advanced Excel proficiency, experience with BI tools, intermediate SQL, and Python or R for analysis.
  • Strong analytical, communication, interpersonal, problem-solving, and data integrity skills.

Performance measures

Forecasts and capacity plans should align with actual outcomes within a stated variance of less than 5%.

The resource database should reflect current project status with more than 95% data accuracy.

Automated reporting should reduce recurring manual effort by more than 30% year over year.

Apply for this job in 1 click

Skip the repetitive application forms

Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.

Sarah M.James T.Maya R.

Trusted by over 500,000 job seekers on Base Career

Start Free Today

More from this employer

More jobs at Renesas