Excel Data Analyst Jobs in Silver Spring, MD (NOW HIRING)

Summary
This position is located in the Division of Consumer Response and Operations (DCRO) in the Bureau of Consumer Protection (BCP) at the Federal Trade Commission (FTC) in Washington, D.C. The Bureau of Consumer Protection investigates and litigates civil actions to enforce federal consumer protection laws. For more information visit https://www.ftc.gov/about-ftc.
Learn more about this agency
Duties
Help
If selected for the position of Data Analyst, you will provide analysis and intelligence concerning consumer reports, information obtained during law enforcement investigations and actions, and other data maintained by the FTC.
As part of your responsibilities, you will support the Consumer Sentinel Network (CSN) and other law enforcement efforts and agency priorities. Consumer Sentinel is a secure online tool available to law enforcement authorities throughout the United States and abroad. It includes a searchable data bank of consumer reports about fraud, scams, and bad business practices received by the FTC and external data contributors.
In this position, you will support multiple FTC/BCP program areas, including anti-fraud, identity theft, Do Not Call, and Take it Down Act enforcement, as well as the consumer redress program.
You will perform the following duties:
- Support senior data analysts, management, and other staff in developing methods to extract and analyze data from CSN or from data obtained during the course of investigations and transmit this information to the appropriate internal and external users.
- Leverage analytics and visualization tools (Tableau) to present information in a way that drives fact-based decision-making.
- Assist in the extraction, cleaning, processing of medium size datasets.
- Analyze, clean, and process sensitive consumer data collected in various mediums, converting the data into a uniform standardized format for use in redress activities.
- Assist in querying and mining small and medium datasets, to discover patterns, using traditional or advanced techniques such as large language models.
- Use MS Excel, Python and other programming languages to analyze small to medium datasets of structured and unstructured data.
- Energetically work with teams to create data products for a wide range of stakeholders.
Requirements
Help
Conditions of employment

• U.S. citizenship requirement must be met by the closing date of this vacancy.
• Position is subject to a background investigation.
• Males born after December 31, 1959 must register with Selective Service.
• The position may be subject to completion of a one-year probationary period. Probationary periods are an extension of the hiring process.
• If selected for this position, the agency will evaluate your fitness and whether continuation of employment advances the public interest before extending your appointment beyond the one-year probationary period.
• Resume and supporting documents (See How To Apply).
• This position is in the bargaining unit. This position is represented by the American Federation of Government Employees (AFGE), Local 2211.

Qualifications
To qualify for a Data Analyst position at the GS-09 level, you must meet the following requirements:
You must demonstrate in your resume at least one (1) year of qualifying experience equivalent to at least the GS-07 level in the Federal service obtained in either the private or public sector, performing the following types of tasks: analyzing data with use of excel, tableau or other software with small to medium datasets.
OR You can qualify based on education for the GS-09, if you have completed:
- a Master's or equivalent graduate degree; or have two full years of progressively higher level graduate education leading to such a degree or an LL.B. or J.D., if related.
OR A combination of graduate level education and specialized experience that equals 100% of the requirements for the GS-09 level as outlined above.
Experience refers to paid and unpaid experience, including volunteer work done through National Service programs (e.g., Peace Corps, AmeriCorps) and other organizations (e.g., professional; philanthropic; religious; spiritual; community, student, social). Volunteer work helps build critical competencies, knowledge, and skills and can provide valuable training and experience that translates directly to paid employment. You will receive credit for all qualifying experience, including volunteer experience.
Education
If you qualify on the basis of education in lieu of experience, you must submit a copy of your transcripts . Unofficial transcripts will be accepted in the application package; however, official transcripts will be required prior to receiving an official offer.
If you are using education completed in foreign colleges or universities to meet the qualification requirements, you must show the education credentials have been evaluated by a private organization that specializes in interpretation of foreign education programs and such education has been deemed equivalent to that gained in an accredited U.S. education program; or full credit has been given for the courses at a U.S. accredited college or university. For further information, visit: https://www.ed.gov/about/initiatives/international-affairs/recognition-of-foreign-qualifications.
Additional information
If you are a veteran with preference eligibility and are claiming 5-points veterans' preference, you must submit a copy of your DD-214 or other proof of eligibility. If you are claiming 10-point veterans' preference, you must also submit an SF-15, "Application for 10-Point Veterans' Preference" plus the proof required by that form. For more information on veterans' preference visit: VETERANS GUIDE
Males born after 12-31-59 must be registered or exempt from Selective Service (see Selective Service System).
Career Transition Assistance Programs: These programs apply to employees who have been involuntarily separated from a Federal service position within the competitive service or Federal service employees whose positions have been deemed surplus or no longer needed. To receive selection priority for this position, you must: (1) meet CTAP or ICTAP eligibility criteria; (2) be rated well-qualified for the position with a score of 87 or above; and, (3) submit the appropriate documentation to support your CTAP or ICTAP eligibility. For more information visit: CAREER TRANSITION.
Non-competitive Appointment Authorities:
For more information on non-competitive appointment authority eligibility requirements:
- Persons with Disabilities-Schedule A
- Special Hiring Authorities for Veterans
- Special Hiring Authority for Certain Military Spouses
- Other Special Appointment Authorities
Expand Hide additional information
Candidates should be committed to improving the efficiency of the Federal government, passionate about the ideals of our American republic, and committed to upholding the rule of law and the United States Constitution.
Benefits
Help
A career with the U.S. government provides employees with a comprehensive benefits package. As a federal employee, you and your family will have access to a range of benefits that are designed to make your federal career very rewarding. Opens in a new windowLearn more about federal benefits.
Review our benefits
Eligibility for benefits depends on the type of position you hold and whether your position is full-time, part-time or intermittent. Contact the hiring agency for more information on the specific benefits offered.