In short
Data Analyst supporting a major Intelligence Community customer: collect, cleanse, and validate multi-source data, run statistical/trend/forecasting analysis, and build executive dashboards, KPIs, and briefing reports using Excel, SQL, and Power BI/Tableau. Also involves data governance, presenting to government stakeholders, and automating reporting workflows; requires an active TS/SCI with CI po
About the role
The Opportunity
Leaders cannot set priorities, defend resources, or measure impact when the data behind those decisions is scattered across systems, inconsistent, and assembled by hand. The Red Gate Group is seeking a Data Analyst to turn operational and administrative data into clear, trustworthy insight for a major Intelligence Community customer. You will collect, cleanse, transform, and validate structured and semi-structured data from multiple sources, then apply statistical, trend, comparative, and forecasting analysis to surface patterns, issues, and opportunities. You will build the dashboards, scorecards, key performance indicators, reports, and briefing materials that executive, operational, and technical audiences rely on, and you will produce recurring and ad hoc analysis supporting resource planning, budgeting, manpower and workforce analysis, logistics, facilities, return on investment, and operational assessments.
You will translate business questions into sound analytical approaches, document the assumptions, methods, limitations, and findings behind every product, and present results and recommendations directly to government stakeholders. Working alongside knowledge managers and data scientists, you will help sustain enterprise decision support products, maintain data governance and data quality, and advise staff at all levels on complex analytical problems. You will also look for ways to make reporting faster and more rigorous, analyzing business processes, mapping workflows, and designing, testing, and documenting automation that reduces manual effort and measurably improves how the work gets done.
You Have
- 5+ years of experience in analytical support, performance measurement, decision support, and business analytics.
- Bachelor's degree in Computer Science, Information Systems, Engineering, Mathematics, Statistics, Business, Economics, or a related field.
- Demonstrated experience leading complex analytical efforts and translating business questions into analytical approaches.
- Extensive experience developing executive-level reporting, dashboards, and performance frameworks.
- Experience using Excel, SQL, Power BI, Tableau, or similar tools.
- Experience with data cleansing, transformation, validation, and dashboard development.
- Ability to present analysis clearly to technical and non-technical audiences.
- TS/SCI with active CI Poly
Nice If You Have
- Experience with HTML/CSS for web development, graphic design, and photo editing software.
- Experience supporting Department of Defense or Intelligence Community organizations.
- Tableau, Power BI, or equivalent data visualization certification.
- DAMA, DCAM, or other data governance or data management certification.
- Experience with scripting, workflow automation, or low-code platform development.
Company Description
The Red Gate Group, founded in 2006, is a Service-Disabled Veteran-Owned Company based in Chantilly, VA. As an SDVOSB, the Red Gate Group has established a reputation for delivering quality multi-tiered services in intelligence analysis, strategic planning, program management, policy development, operational design, and technology integration. RGG delivers high-quality, customer-centric solutions around the world—from the foxhole to the highest levels of Government. 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. 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.