Job DescriptionThis role supports Federal Human Capital (HC) operations by delivering advanced workforce analytics, reporting, and data-driven insights. The specialist will extract, analyze, and translate HR data from multiple Federal systems into clear, executive-ready insights that inform workforce planning, hiring strategy, and organizational performance.
Key Job Duties
Support workforce analytics initiatives by collecting, analyzing, and interpreting Federal Human Resources (HR) data from systems such as NFC, HRConnect, and USA Staffing (USAS).
Develop and maintain dashboards and reports tracking key HR metrics (e.g., hiring timelines, attrition, workforce demographics, onboarding progress).
Build dynamic Excel, Power BI, or similar tools that allow real-time updates during executive briefings.
Provide recurring and ad hoc data analysis to support HR data calls, audits, and reporting requirements. Analyze the data and prove the outcome of the analysis.
Extract and normalize historical HR data from federal systems and portals (e.g., National Finance Center [NFC], HR Connect, USA Staffing, Enterprise Services Portal).
Track, collect, and develop datasets supporting HR audits, payroll reviews (A-123), and performance reporting.
Translate complex HR datasets into clear, concise, and visually compelling presentations for senior leadership.
Convert technical HR terminology and Federal processes into plain-language insights for non-HR stakeholders.
Assist in end-to-end hiring analytics, including pipeline tracking, onboarding timelines, and process optimization; identify inefficiencies and recommend data-driven improvements.
Through data analytics, support continuous improvement initiatives aligned with agency HR and management goals.
Respond rapidly to changing requirements, priorities, and leadership requests.
Collaborate with HR teams, program offices, and leadership to refine analytics needs and deliverables.
Provide on-the-spot data adjustments and analysis during meetings with executives.
Job RequirementsMust be a US Citizen.
Must be able to obtain and maintain the government-required security clearance.
A minimum of 4 years of experience supporting Federal HR data calls, audits, and reporting requirements; and translating complex HR and workforce data into clear, actionable insights for senior leaders.
Strong storytelling skills using data visualization and executive level presentations.
Knowledge of HC strategies and workforce analytics methodologies.
Understanding of Federal HR processes, including hiring, onboarding, personnel actions, and workforce planning.
Advanced expertise in Microsoft (MS) Excel (pivot tables, advanced formulas, data modeling) and SQL, queries, and formulas.
Experience building interactive dashboards (Excel, Power BI, Tableau, or similar).
Strong data manipulation and analysis skills across large datasets to summarize numerical and quantifiable data to provide usable information.
Experience pulling large data sets for data calls, turning raw data into ratios, percentages, analytics for executive briefings; creating excel sheets where data can be searched.
Familiarity with Federal HR systems such as:NFC (National Finance Center)
HR Connect
USAS
Other Federal HR platforms
Experience smashing two data sets into a single data call response.
Experience utilizing AI, such as copilot, to do analytics and formulas is preferred.
YRCI is a veteran-owned professional services firm located in the greater Washington, DC area. We provide human resources (HR), acquisitions, and management/financial services to Federal and commercial clients across the Nation. Founded in 2001, YRCI began with four dedicated individuals working from the founder's home. The company has since seen explosive growth and was recognized by the Virginia Chamber of Commerce as one of their 2009 Fantastic 50 winners to honor the fastest growing companies in Virginia. In 2008, YRCI was listed on the Washington Technology’s Fast 50 list of fastest growing government contractors. Additionally, the Alliance for Workplace Excellence recognized YRCI’s demonstration of outstanding commitment by awarding us six consecutive Workplace Excellence Awards. We are proud that 2014 was the best year in the history of the company. We have grown and remained stable during the adversity that Government has thrown to our industry. YRCI is resilient, growing, and has a bright future of success with our valued customers ahead of us. We currently have more than 160 active projects supporting our customers and have contracted to more than 80 government agencies and 110 commercial clients. More importantly, we have helped put thousands of people to work.