Senior Workforce Analytics & Modeling Analyst

Amerisource Solutions; United States; Remote; USD 120,000 - 160,000; Full time

Job summary

MGT is seeking a highly analytical Senior Workforce Analytics & Modeling Analyst to develop scalable models, reports, and dashboards for workforce planning, staffing, utilization, productivity, and labor cost decisions. The ideal candidate will have strong expertise in SQL, Power BI, and Advanced Excel, along with experience in business analytics, data modeling, scenario analysis, and reporting automation.

The candidate will work closely with U.S.-based stakeholders to translate business

Qualifications

• Bachelor’s degree in analytics, business, finance, economics, information systems, HR, or operations.
• 7+ years of experience in Business Analytics, Data Analytics, Operational Analytics, Financial Modeling, Workforce Analytics, or related field.
• Strong experience developing analytical models and conducting scenario analysis.
• Advanced SQL skills, including query writing, troubleshooting, and data validation.
• Advanced Power BI skills, including data modeling, dashboard development, reporting, and data validation.
• Advanced Microsoft Excel skills, including complex formulas, pivot tables, model building, scenario analysis, and data validation.
• Ability to analyze workforce metrics such as headcount, turnover, labor cost, hiring, utilization, capacity, and productivity.
• Experience translating business requirements into analytical models, reports, and actionable insights.
• Experience improving analytical workflows through automation, AI-enabled tools, process improvement, and documentation.
• Strong analytical thinking, problem-solving, and root-cause analysis skills.
• Excellent written and verbal communication skills, including the ability to present findings to leadership.
• Strong attention to detail and commitment to data accuracy and reporting quality.
• Ability to work independently in a remote environment and collaborate effectively with U.S.-based stakeholders.
• Excellent English communication skills and availability to work during U.S. business hours.

Responsibilities

• Develop and maintain analytical models linking revenue, labor costs, headcount, utilization, capacity, and productivity.
• Translate business requirements into models, reports, dashboards, and actionable recommendations.
• Conduct scenario analysis to evaluate staffing, workforce efficiency, productivity, and cost implications.
• Analyze performance trends and their impact on hiring and planning.
• Present analytical findings, risks, and recommendations to leadership.
• Write, troubleshoot, and validate SQL queries to extract and analyze data.
• Develop interactive dashboards and recurring reports using Power BI and Excel.
• Analyze workforce metrics: headcount, turnover, labor costs, hiring, utilization, capacity, productivity.
• Validate data sources, calculations, queries, and outputs for accuracy.
• Integrate workforce, operational, and financial data to identify trends and opportunities.
• Prepare clear, data-driven reports and presentations for stakeholders and leadership.
• Own recurring analytics and reporting activities from requirements through delivery.
• Investigate data discrepancies, root causes, and implement solutions.
• Improve reporting processes, data quality, documentation, and efficiency.
• Develop and maintain documentation for models, logic, processes, SOPs.
• Identify opportunities to create scalable solutions and improve reliability.
• Use automation and AI-enabled tools to reduce manual reporting and improve efficiency.
• Identify opportunities to streamline recurring analytical workflows.
• Use AI tools for documentation, triage, process mapping, and summarizing insights.
• Support scalable analytics and reporting processes.
• Collaborate with cross-functional teams to understand requirements and deliver solutions.
• Communicate complex data insights clearly.
• Independently manage analytical assignments and provide practical recommendations.
• Work with U.S.-based stakeholders and leadership while owning deliverables.

Skills

Analytical modeling

Scenario analysis

Problem-solving

Communication

Independent work

Education

Bachelor's degree in Analytics, Business, Finance, Economics, Information Systems, HR, Operations, or related field

Master's degree in Analytics, Business, Finance, HR, Operations, Data Science, or related field

Tools

SQL

Power BI

Microsoft Excel

Snowflake

Python

Job description

About MGT

MGT is a leading provider of technology and advisory solutions serving state, local, and education government agencies (SLED) across the United States. The company partners with thousands of agencies to improve technology, operational and economic performance, strengthen critical networks, solve complex workforce and financial challenges, and advance education systems.

Founded in 1975, MGT combines specialized expertise, innovative technology, and strategic advisory services to help public-sector organizations address their most important challenges.

Job Summary

MGT is seeking a highly analytical and experienced Senior Workforce Analytics & Modeling Analyst to develop scalable analytical models, reports, and dashboards that support workforce planning, staffing, utilization, productivity, and labor cost decisions.

The ideal candidate will have strong expertise in SQL, Power BI, and Advanced Excel, along with experience in business analytics, data modeling, scenario analysis, and reporting automation.

The candidate will work closely with U.S.-based stakeholders to translate business requirements into actionable insights, improve reporting accuracy, identify operational trends, and provide data-driven recommendations to support leadership decision-making.

Key Responsibilities

1. Workforce Analytics & Business Modeling

• Develop and maintain analytical models connecting revenue, labor costs, headcount, utilization, capacity, and workforce productivity.
• Translate business requirements into analytical models, reports, dashboards, and actionable recommendations.
• Conduct scenario analysis to evaluate staffing requirements, workforce efficiency, productivity, and cost implications.
• Analyze business performance trends and their impact on hiring requirements and workforce planning.
• Present analytical findings, risks, trade-offs, and recommendations to leadership.

2. Data Analytics & Reporting

• Write, troubleshoot, and validate SQL queries to extract and analyze business data.
• Develop and maintain interactive dashboards, recurring reports, and self-service reporting solutions using Power BI and Excel.
• Analyze workforce metrics, including headcount, turnover, labor costs, hiring, utilization, capacity, and productivity.
• Validate source data, calculations, queries, and reporting outputs to ensure accuracy and consistency.
• Integrate workforce, operational, and financial data to identify trends, risks, and improvement opportunities.
• Prepare clear, data-driven reports and presentations for business stakeholders and leadership.

3. Process Improvement & Quality Management

• Own recurring analytics and reporting activities from requirements gathering through delivery.
• Investigate data discrepancies, reporting issues, and workflow problems to identify root causes and implement solutions.
• Improve reporting processes, data quality, documentation, and operational efficiency.
• Develop and maintain documentation for analytical models, reporting logic, processes, and standard operating procedures.
• Identify opportunities to create scalable solutions and improve reporting reliability.

4. Automation & AI Enablement

• Leverage automation and AI-enabled tools to reduce manual reporting efforts and improve efficiency.
• Identify opportunities to streamline recurring analytical and operational workflows.
• Use AI tools for documentation, issue triage, process mapping, and summarizing analytical insights.
• Support the development of scalable and efficient analytics and reporting processes.

5. Stakeholder Collaboration

• Collaborate with cross-functional business teams to understand requirements and deliver analytical solutions.
• Communicate complex data insights in a clear and structured manner.
• Independently manage analytical assignments and provide practical recommendations.
• Work closely with U.S.-based stakeholders and leadership while maintaining strong ownership of deliverables.

Required Skills & Qualifications

• Bachelor's degree in Analytics, Business, Finance, Economics, Information Systems, Human Resources, Operations, or a related field.
• 7+ years of experience in Business Analytics, Data Analytics, Operational Analytics, Financial Modeling, Workforce Analytics, or a related field.
• Strong experience developing analytical models and conducting scenario analysis.
• Advanced SQL skills, including query writing, troubleshooting, and data validation.
• Advanced Power BI skills, including data modeling, dashboard development, reporting, and data validation.
• Advanced Microsoft Excel skills, including complex formulas, pivot tables, model building, scenario analysis, and data validation.
• Ability to analyze workforce metrics such as headcount, turnover, labor cost, hiring, utilization, capacity, and productivity.
• Experience translating business requirements into analytical models, reports, and actionable insights.
• Experience improving analytical workflows through automation, AI-enabled tools, process improvement, and documentation.
• Strong analytical thinking, problem-solving, and root-cause analysis skills.
• Excellent written and verbal communication skills, including the ability to present findings to leadership.
• Strong attention to detail and commitment to data accuracy and reporting quality.
• Ability to work independently in a remote environment and collaborate effectively with U.S.-based stakeholders.
• Excellent English communication skills and availability to work during U.S. business hours.

Preferred Qualifications

• Master's degree in Analytics, Business, Finance, Human Resources, Operations, Data Science, or a related field.
• Experience with Snowflake or another relational or cloud data environment.
• Python experience in predictive analytics or advanced modeling.
• Experience in workforce planning, headcount forecasting, capacity planning, labor cost analysis, utilization, or productivity analytics.
• Experience in professional services, consulting, managed services, staffing, or other labor-driven business environments.
• Certifications in analytics, business intelligence, data visualization, process improvement, or project management.
• Experience using AI tools to improve reporting and analytical workflows.
• Experience working with remote or internationally distributed teams supporting U.S.-based stakeholders.