Workforce / Workload Analyst

MetaPhase; Washington (District of Columbia); Hybrid; USD 90,000 - 130,000; Full time

Job summary

MetaPhase Consulting is seeking a Workforce / Workload Analyst to support the FTA SHIFT initiative in Washington, DC. The role requires 5+ years of data analytics experience, Power BI expertise, and strong modeling and visualization skills.

Hybrid work arrangement with onsite engagement at FTA HQ as requested. Candidates must meet U.S. Public Trust requirements and collaborate with stakeholders to deliver data-driven staffing recommendations.

Qualifications

• Minimum 5+ years of data analyst experience.
• Experience with workforce/workload/quantitative analysis.
• Ability to develop analytical models and translate data into business recommendations.
• Strong spreadsheet and quantitative modeling capabilities.
• Experience with data visualization and dashboard development.
• Ability to document data structures, calculations, and methodologies.
• Strong communication and presentation skills.
• Ability to work with stakeholders to define analytical requirements.

Responsibilities

• Evaluate Power BI workload dashboard and data structures.
• Document office-by-office tasks and Work Breakdown Structures.
• Analyze Level of Effort assumptions and workload baselines.
• Develop methods to translate workload into staffing targets.
• Conduct workforce and staffing trend analysis.
• Realign workload models with changing organizational structures.
• Support evaluation and selection of replacement technology.
• Assist in developing and testing the replacement workload modeling tool.
• Provide data quality checks and validate model calculations.
• Create analytical documentation, data definitions, and user guidance.
• Create visualizations and executive-ready analyses.
• Support knowledge transfer and training for sustainability.
• Ensure outputs meet Section 508 requirements.

Skills

Data analysis

Quantitative analysis

Data visualization

Communication

Stakeholder collaboration

Problem solving

Presentation skills

Documentation

Education

Bachelor's degree in data analytics or related field

Tools

Power BI

R/Shiny

Python/Dash

SQL

Excel

Job description

Description

At MetaPhase, we believe Quirky is Cool and being authentic is the only way to be! We take the work we do very seriously and do a lot of important mission-focused work for our clients. We are individuals with different passions and strengths who take as much joy in the work we do as from those we work with. Today, we have a team that is invested in creating new solutions that lean forward, challenge the status quo, but also reflect our intimate knowledge of our customers’ business. Over the years we have fostered a culture in which we are united by shared values-passion, solidarity, generosity, curiosity, and boldness and these come alive in the work we do and how we do it.

Together, we know our people are our difference —for our clients and our colleagues.

Are you ready to:

• Work alongside a dedicated and diverse set of people to offer honest advice and practical guidance to our clients?
• Learn and grow by taking advantage of every opportunity available to you?
• Join a company which prides itself on its shared values and inclusive culture?
• Be the difference and make it happen?

MetaPhase is currently supporting the Federal Transit Administration (FTA) through the Strategic HQ Integration and Functional Transformation (SHIFT) initiative, an 18-month effort to assess and optimize FTA Headquarters organizational structures, functions, staffing, governance, and workload models.

In support of this project, MPC is seeking a Workforce / Workload Analyst with five or more (5+) years of data analyst experience to support development of a data-driven workforce and workload model for FTA Headquarters. In this role, it is expected that the analyst evaluates FTA's legacy Power BI workload dashboard, refines office-level workload and Level of Effort models, develops mathematically justified staffing targets, and supports creation of a sustainable replacement workload modeling capability using an FTA/DOT-approved alternative technology.

What You Will Be Doing

• Evaluate the existing Power BI workload dashboard, data structures, dependencies, calculations, and reporting metrics
• Document office-by-office tasks and Work Breakdown Structures
• Analyze task-level Level of Effort assumptions and workload baselines
• Develop quantitative methods for translating workload into optimal staffing targets
• Conduct workforce and staffing trend analysis
• Realign workload models as organizational functions and personnel structures change
• Support evaluation and selection of an approved replacement technology
• Help develop, test, and validate the replacement workload modeling tool and dashboard
• Support automated quarterly ingestion of CASTLE and Alpha Roster information
• Conduct data quality checks and validate model calculations
• Develop analytical documentation, data definitions, calculation logic, and user guidance
• Create visualizations and executive-ready workforce analyses
• Support knowledge transfer and training so FTA personnel can independently maintain the solution
• Ensure dashboard and electronic outputs support Section 508 requirements

What We Need From You (Required)

• Minimum of five or more (5+) years of data analyst experience, as required by the RFQ
• Demonstrated experience performing workforce, workload, operational, or quantitative analysis
• Experience developing analytical models and translating data into business recommendations
• Strong spreadsheet and quantitative modeling capabilities
• Experience with data visualization and dashboard development
• Ability to document data structures, calculations, assumptions, and methodologies
• Strong analytical, problem-solving, communication, and presentation skills
• Experience working with stakeholders to define analytical requirements
• Ability to successfully fulfill FTA Public Trust suitability requirements

Nice to Have (Desired)

• Federal government analytics experience
• Experience with workforce planning or staffing models
• Experience with R/Shiny, Python/Dash, or Microsoft-native analytical utilities
• Python, R, SQL, or similar analytical programming experience
• Experience migrating or replacing Power BI dashboards
• Experience building automated data ingestion processesExperience with Section 508-compliant data visualization
• Experience with CASTLE, Alpha Roster, or comparable federal workforce datasets

Required Clearance

Ability to obtain and successfully fulfill FTA Public Trust/Suitability requirements; U.S. Citizenship preferred.

Work Location

Hybrid - Washington, DC. Remote work with onsite engagement at FTA Headquarters in Washington, DC as requested.

Travel

None

Education

Bachelor's degree in data analytics, statistics, operations research, mathematics, economics, information systems, or a related field.

Compensation

Compensation decisions are dependent of the facts and circumstances of each case.

About MetaPhase Consulting

MetaPhase Consulting is different with a purpose - demonstrating a new approach to the industry that puts employees and culture first! We continue to be recognized by industry as one of the fastest growing and most impactful consultancies in the nation, and are aggressively hiring to grow our team:

Fastest Growing Awards

• Inc 5000 Fastest Growing Company - 2020, 2021, 2022, 2023
• Washington Technology Fast 50 Award - 2020, 2021
• Financial Times America's Fastest Growing Companies - 2021, 2022, 2023

Best Places to Work Awards

• Washington Post Top Workplaces - 2022, 2023, 2024
• Washington's Business Journal's Best Places to Work - 2021, 2022
• Virginia Businesses Best Place to Work - 2021, 2022, 2023, 2024
• Northern Virginia Technology Council Top 100 Technology Firms - 2020

Company & Individual Awards

• 2021 Washington Business Journal Small Business - CEO of the Year
• 2021 FedScoop 50 - Industry Leadership Award Nominee
• 2021, 2023, 2024 Moxie Award Finalist
• 2022 SECAF Government Contractor Awards ($27.5 to $50 Million in Revenue)
• 2022 FedScoop Best Bosses Finalist - Brett McLaren
• 2022 Washington Business Journal 40 under 40 - Brett McLaren
• 2022 FedHealth IT and G2XChange Women in Leadership Awards - Beth Angerman
• 2022 George Mason University Prominent Patriots in Business - Fred Costa
• 2022 TiE DC Capital ELITE Award
• 2023, 2024 Elev8 Engage GovCon Finalist
• 2023 Maryland Tech Council ICON Awards Finalist for Government Contracting Company of the Year: Over $50 Million
• 2023 Greater Washington Government Contractor of the Year ($25 to $75 million) Awards Finalist

MetaPhase Consulting is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, national origin, disability or veteran status, or any other factors protected by federal, state, or local law. For more information, visit us at: metaphase.tech

#dice