MGT Consulting Group

Data Analyst - Workforce Planning


Location: Remotely based US


MGT Consulting Group is a national leader in public sector management consulting and services that delivers diverse business consulting services to a wide range of public sector groups. Celebrating its 45th year in 2019, the firm attracts exceptional talent and empowers them to exceed client expectations as they navigate the dynamic demands of public agency performance.

MGT is seeking a Workforce Data Analyst to support the HR & Culture Department in making data-driven decisions. This role will work at the direction of the Strategic Workforce Management Lead to architect and build reports that provide insight into workforce supply and demand and inform tactical resource management. They will have also provide support to HR Leaders in creating standard and ad-hoc reports, analyzing workforce data, identifying data trends, and ensuring HR data integrity. This position will leverage various data sources and fields (headcount, employee demographics, job requisition, compensation, utilization, skills, etc.) to deliver results.


  • Supports the design and execution of resource management framework and develop and track staffing metrics and communicate meaningful insights on trends, forecasts, opportunities for improvement and areas of concern, how metrics impact financial performance, client delivery, and employee engagement
  • Collects and compiles HR metrics and data from complex multi-source datasets including the human resource information system (HRIS), management, employee surveys, employment records, project management tool, and other sources to build, often from scratch, complicated spreadsheet-based models to support the organization's growth and key objectives
  • Creates ad-hoc and standard monthly reports to identify trends and patterns with attention to recruitment, hiring practices, turnover, compensation, and other HR metrics
  • Uses data visualization programs, tools, and techniques to generate dashboards, reports, and presentations that aid in data storytelling.
  • Provide project support for HR programs and initiatives such as performance management, reward and recognition programs, M&A activity, and recruitment to support department FY22 strategic plan


  • Bachelor's degree in Finance, Mathematics, Data Analysis, HR, or Business Administration
  • Two (2) or more years of experience in Human Resources or data analysis experience
  • Advanced knowledge of MS Excel (VLOOKUP's, pivot tables, complex functions, VBA)
  • Experience gathering unstructured data to transform and analyze statistical data, generate reports, and summarize analysis into understandable, actionable reports, and recommendations
  • Ability to design/generate and implement systems necessary to collect, maintain and analyze data.
  • Strong verbal and written communication skills with the ability to identify and articulate results in easy-to-understand business terms
  • Ability to prioritize workload, meet deadlines, and perform multiple tasks with attention to detail
  • Self-starter with experience working effectively in an ambiguous, fast-paced, entrepreneurial, diverse, and dynamic environment with frequent deadlines


  • Data Analytics Certifications preferred
  • Experience in a professional service environment strongly preferred

MGT of America Consulting, LLC will not discriminate against any employee or applicant for employment on the basis of race, color, religion, sex, national origin, age, disability, marital status, genetic information, sexual orientation, pregnancy, gender identity, or any other characteristic or class protected by law.

MGT Consulting Group
  • Apply Now

    with our quick 3 minute Application!

  • * Fields Are Required

    What is your full name?

    How can we contact you?

  • Sign Up For Job Alerts!

  • Share This Page
logo about capabilities industries insights careers contact