Recruiting Specialist

Avenue5 Residential, LLC Career Center; Phoenix (AZ); On-site; USD 48,000 - 72,000; Full time

Job summary

Avenue5 Residential, LLC Career Center is seeking a highly organized recruiting coordinator to support full-cycle recruiting, reporting, and workforce data analysis in Phoenix. You will coordinate interviews, manage postings, and ensure a smooth candidate experience while delivering data-driven insights.

The role emphasizes Excel-based tracking, dashboard creation, and polished PowerPoint presentations for leadership reviews.

Qualifications

• Bachelor’s degree in finance, accounting, business administration, or a related field preferred.
• Strong to advanced Microsoft Excel skills, including PivotTables, XLOOKUP/VLOOKUP, formulas, charts, and data analysis.
• Strong Microsoft PowerPoint skills, with the ability to create professional, leadership-ready presentations.

Responsibilities

• Support full-cycle recruiting activities, including job postings, candidate sourcing, screening, interview coordination, and offer processes.
• Partner with hiring managers to understand staffing needs and recruiting priorities.
• Maintain accurate candidate and requisition information within the applicant tracking system (ATS).
• Track recruiting activity and key metrics such as time-to-fill, candidate pipeline, hiring volume, and source effectiveness.
• Provide a positive and professional candidate experience throughout the hiring process.
• Assist with recruiting initiatives, hiring events, and special projects.
• Prepare recurring and ad hoc HR and recruiting reports for leadership and business partners.
• Analyze workforce and recruiting data to identify trends, opportunities, and areas requiring attention.
• Develop and maintain Excel-based trackers, dashboards, and reporting tools.
• Validate data for accuracy and consistency.
• Track and report key metrics, including headcount, vacancies, turnover, hiring activity, and recruiting performance.
• Translate data into clear, actionable insights for stakeholders.
• Use advanced Excel skills to organize, analyze, and present large data sets.
• Create and maintain formulas, PivotTables, charts, lookups, conditional formatting, and data-driven dashboards.
• Develop polished PowerPoint presentations for leadership meetings, recruiting updates, business reviews, and HR initiatives.
• Transform complex HR data into concise, visually effective presentations and executive-level summaries.
• Maintain consistent formatting and high standards for reporting accuracy and presentation quality.

Skills

Advanced Excel

PowerPoint

ATS/HRIS experience

HR analytics

PivotTables

Lookup functions

Education

Bachelor’s degree in finance, accounting, business administration, or related field

Tools

ATS/HRIS

Job description

Position Summary

We are seeking a highly organized, analytical, and detail-oriented recruiting coordinator to support recruiting activities, reporting, and workforce data analysis. This role combines hands-on recruiting coordination with strong reporting and presentation responsibilities. The ideal candidate has excellent communication skills and advanced proficiency in Microsoft Excel and PowerPoint.

Key Responsibilities

Recruiting and Talent Acquisition

• Support full-cycle recruiting activities, including job postings, candidate sourcing, screening, interview coordination, and offer processes.
• Partner with hiring managers to understand staffing needs and recruiting priorities.
• Maintain accurate candidate and requisition information within the applicant tracking system (ATS).
• Track recruiting activity and key metrics such as time-to-fill, candidate pipeline, hiring volume, and source effectiveness.
• Provide a positive and professional candidate experience throughout the hiring process.
• Assist with recruiting initiatives, hiring events, and special projects.

HR Reporting and Analytics

• Prepare recurring and ad hoc HR and recruiting reports for leadership and business partners.
• Analyze workforce and recruiting data to identify trends, opportunities, and areas requiring attention.
• Develop and maintain Excel-based trackers, dashboards, and reporting tools.
• Validate data for accuracy and consistency.
• Track and report key metrics, including headcount, vacancies, turnover, hiring activity, and recruiting performance.
• Translate data into clear, actionable insights for stakeholders.

Excel and PowerPoint

• Use advanced Excel skills to organize, analyze, and present large data sets.
• Create and maintain formulas, PivotTables, charts, lookups, conditional formatting, and data-driven dashboards.
• Develop polished PowerPoint presentations for leadership meetings, recruiting updates, business reviews, and HR initiatives.
• Transform complex HR data into concise, visually effective presentations and executive-level summaries.
• Maintain consistent formatting and high standards for reporting accuracy and presentation quality.

Qualifications

• Bachelor’s degree in finance, accounting, business administration, or a related field preferred.
• Strong to advanced Microsoft Excel skills, including PivotTables, XLOOKUP/VLOOKUP, formulas, charts, and data analysis.
• Strong Microsoft PowerPoint skills, with the ability to create professional, leadership-ready presentations.
• Experience working with an ATS, HRIS, or other HR technology preferred.
• Strong analytical skills and attention to detail.
• Excellent written and verbal communication skills.
• Ability to manage multiple priorities and meet deadlines in a fast-paced environment.
• Ability to handle confidential employee and candidate information appropriately.