What are the responsibilities and job description for the CCAS Spreadsheet and Analysis Subject Matter Expert (SME) position at Red Gate Group?
Company Description
The Red Gate Group, founded in 2006, is a Service-Disabled Veteran-Owned Company based in Chantilly, VA, providing Systems Engineering & Technical Assistance (SETA) support to clients across the Department of Defense and Intelligence Community. Our motto, "Making a Difference for Country and Client," reflects our deep commitment to national security and service excellence. As an employer of choice, we offer comprehensive benefits including flexible time off, 11 paid holidays, immediate 401(k) eligibility with a generous match, and full medical, dental, and vision coverage through Anthem. Our employees enjoy 100% company-paid life insurance and disability benefits, along with professional development assistance for degrees and certifications. We foster a culture of growth and work-life balance, backed by our commitment to supporting both our clients' missions and our employees' success. Join our team and be part of an organization that values both service excellence and employee wellbeing.
Job Description
The Red Gate Group is seeking a CCAS Spreadsheet and Analysis Subject Matter Expert (SME) to support the a Program Office under the Office of the Under Secretary of Defense for Acquisition and Sustainment (OUSD (A&S)) in Ft Belvoir, VA. This program offers a flexible alternative to the traditional GS personnel system, empowering innovative personnel management strategies across the Department of Defense.
Key Responsibilities:
-Develop, maintain, and improve complex Excel spreadsheets using Visual Basic for Applications (VBA) to support compensation management and data analysis.
-Support government pay transaction processing, ensuring compliance with applicable policies and personnel systems.
-Consult with internal stakeholders to provide customer support for compensation tools.
-Conduct data analysis to provide actionable insights that enhance personnel management strategies under alternative personnel systems.
Qualifications
Required Qualifications
- Must be US Citizen
- Bachelor’s degree in IT or a related field such as Business Information Systems or Information Systems degree) (10 years of relevant work experience may substitute for the degree requirement).
- Five or more years of experience supporting compensation management computations, government pay transaction processing, and/or data analysis for demonstration or alternate personnel systems within the Federal Government.
- Visual Basic for Applications (VBA) experience to support complex excel spreadsheet macros.
- Extensive knowledge of SAS
Desired Qualifications
- Experience with demonstration or alternative personnel systems
- Understanding of federal personnel operations, policies, and processes
Additional Information
The Red Gate Group, Ltd. is an Equal Opportunity/Affirmative Action Employer. The Red Gate Group, Ltd. considers applicants without regard to race, color, religion, age, national origin, ancestry, ethnicity, gender, gender identity, gender expression, sexual orientation, marital status, veteran status, disability, genetic information, citizenship status, or membership in any other group protected by federal, state, or local law. Know Your Rights
