FREE ACCESS
5,000–10,000 jobs/day
See all jobs on Scoutfield
Search thousands of fresh jobs every day.
Discover
- Fresh listings
- Fast filters
- No subscription required
Create a free account and start exploring right away.
Core Competencies
Role fitCore Competencies
Use this summary to align your resume positioning with the role.
Demonstrates strong expertise in Power BI and advanced Excel for developing dashboards and reports, alongside proficiency in VBA, Power Query, and macros for process automation. Capable of managing resource allocation and planning while driving automation initiatives to enhance operational efficiency.
Highest-signal resume keywords
Power BI Dashboard DevelopmentAdvanced Excel FunctionsVBA AutomationResource Management ToolsAnalytical Skills
ATS Keywords
Tailor your resumeApplicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills
Power BIExcelVBAPower QueryMacrosData AnalysisReporting AutomationResource AllocationPerformance MetricsCapacity Planning
Soft Skills
Analytical ThinkingCommunication SkillsAttention to DetailProactive ApproachTime Management
Tools & Technologies
Power BIExcelVBAPower QueryRetain
Industry Keywords
Resource ManagementOperational EfficiencyWorkforce PlanningData ReportingPerformance Metrics
Tech Stack
Tools & technologiesVBA
About the role
Key responsibilities & impact- Develop, maintain, and enhance real-time dashboards and reports on resource utilization, capacity planning, and performance metrics
- Use Power BI and advanced Excel functions to automate reporting and provide data analysis to leadership
- Analyze trends, identify patterns, and provide actionable recommendations for resource allocation and planning
- Ensure reports and data are delivered in the right format and aligned with business needs
- Identify reporting and resource management inefficiencies and propose automation solutions using VBA, Power Query, and macros
- Drive automation initiatives to reduce manual effort and increase reporting accuracy and efficiency
- Improve resource management workflows to enhance scalability, reduce turnaround time, and ensure effectiveness
- Own key deliverables, including streamlining non-audit assurance reports and developing advanced dashboards such as an RVA trends dashboard
- Manage deliverables and prioritize tasks to meet deadlines
- Provide insights and suggest enhancements to processes, tools, and reporting methods
- Make decisions, optimize processes and resource management, and oversee team management as needed
- Allocate personnel, supervise team members, assign tasks, provide necessary tools and support, and evaluate performance
- Collaborate with resourcing and operational teams to meet reporting and data needs
- Contribute to innovative tools and solutions for workforce planning, resource allocation, and operational efficiency
Requirements
What you’ll need- Strong expertise in Power BI for developing dashboards, reports, and analytics
- Advanced proficiency in Excel, including formulas, pivot tables, and advanced functions
- Experience with VBA, Power Query, and macros for process automation
- Familiarity with resource management tools such as Retain or similar resource planning software
- Strong analytical and critical thinking skills
- Ability to manage multiple priorities and meet deadlines while ensuring high-quality deliverables
- Strong communication skills
- Ability to take ownership of tasks, work independently, and drive deliverables with minimal supervision
- Proactive and self-motivated approach to work
- Strong attention to detail
- Ability to adapt to changing business needs and provide innovative solutions
Benefits
Comp & perks- Flexible environment
- Health and wellness packages
- Rewards
- Learning opportunities
- Professional development opportunities
- Opportunities to build new skills and take on leadership roles
- Mentorship and networking opportunities
- Diverse, equitable and inclusive culture
- Disability-related recruitment adjustments or accommodations
- Equal opportunity employment
