Senior Business Analyst

Amerisource Solutions; United States; Remote; USD 110,000 - 150,000; Full time

Job summary

MGT is seeking a Senior Workforce Analytics & Modeling Analyst to develop scalable analytical models, reports, and dashboards supporting workforce planning, staffing, utilization, and labor-cost decisions. The role emphasizes SQL, Power BI, and Advanced Excel, with collaboration across U.S.-based stakeholders to translate requirements into insights.

The ideal candidate will drive data-driven recommendations, improve reporting accuracy, and automate processes, while contributing to leadership

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.

Responsibilities

• Develop analytical models linking revenue, labor costs, headcount, utilization and productivity.
• Translate requirements into dashboards, reports and actionable recommendations.
• Conduct scenario analysis to evaluate staffing and cost implications.
• Present findings and risks to leadership.
• Own recurring analytics and reporting activities from requirements to delivery.
• Collaborate with cross-functional teams to deliver solutions.
• Validate data, queries, and outputs for accuracy.

Skills

SQL advanced

Power BI

Excel advanced

Workforce analytics

Data modeling

Scenario analysis

Communication

Remote work

Education

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

Tools

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.