Remote Senior Workforce Analytics & Modeling Lead

Amerisource Solutions

United States

Remote

USD 120,000 - 160,000

Full time

6 days ago

Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

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.