This position is located in the Division of Enforcement's Office of Market Intelligence (OMI). OMI is responsible for a number of intelligence and analytic programs, including the intake, analysis, and evaluation of thousands of tips, complaints, and referrals (TCRs), and other intelligence that the SEC receives each year, and the referral of this intelligence for potential investigation or other action.
Summary
This position is located in the Division of Enforcement's Office of Market Intelligence (OMI). OMI is responsible for a number of intelligence and analytic programs, including the intake, analysis, and evaluation of thousands of tips, complaints, and referrals (TCRs), and other intelligence that the SEC receives each year, and the referral of this intelligence for potential investigation or other action.
Serving as a leading authority for sourcing, collecting, and structuring data and developing analytical work products and enterprise reports related to the Commission's Tips, Complaints and Referrals (TCR) System and other systems related to TCRs.
Analyzing, designing, and integrating TCR database information into user-friendly, custom-built, reports and visualizations related to investigations, litigations, examinations, rule makings, and internal and external reporting.
Performing a consultative role by working with staff to help determine data and analysis needs, suggest solutions, explain results, and present analysis related to TCR information by developing, creating, and managing complex data reports in cross-functional collaboration with end-users across the Commission.
Interfacing with staff in the Division of Economic and Risk Analysis regarding the application of artificial intelligence and automated reporting capabilities related to TCRs.
Applying expertise with back-end databases including Oracle platforms and SQL Servers to identify and obtain required TCR-related data and then apply expertise with front-end database reporting and visualization tools including MicroStrategy (MSTR) and/or Tableau.
Applying mastery of SQL and MSTR analytical tools to perform fundamental analysis of Oracle databases to develop a wide variety of highly detailed enterprise reports and establishing automated report delivery and notifications to allow agency leaders to make quicker, more informed decisions.
Developing updated enforcement based analytical reports in MSTR from previous systems such as Business Objects (BOXI), Crystal Reports, and MS Access.
Translating data analytics obtained from the TCR system into written reports and presentations for senior agency officials across the Microsoft Office Suite of products, especially Power Point and Excel (pivot tables and charts), and Adobe Acrobat products, to support agency operations, oversight, and accountability.
Application procedures are specific to this vacancy announcement. Please read all the instructions carefully. Failure to follow the instructions may result in you not being considered for this position.
Supplementary vacancies may be filled in addition to the number stated in this announcement.
This position has promotion potential to the SK-14.
PROBATIONARY PERIOD: This appointment may require completion of a one-year probationary period.
SECURITY CLEARANCE: Entrance on duty is contingent upon completion of a pre-employment security investigation. Favorable results on a Background Investigation may be a condition of employment or selection to another position.
DRUG TESTING: This position may be subjected to drug testing requirements.
PERMANENT CHANGE OF STATION (PCS): Moving/Relocation expenses are not authorized.
DIRECT DEPOSIT: All Federal employees are required to have Federal salary payments made by direct deposit to a financial institution of their choosing.
This position is in the collective bargaining unit.
This position is eligible to request telework in accordance with the SEC 's telework policy.
Qualifications
All qualification requirements must be met by the closing date of this announcement.
Qualifying experience may be obtained in the private or public sector. 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.
BASIC REQUIREMENT: Applicants must possess IT related experience demonstrating each of the four competencies:
Reviewing work to ensure it is in line with established standards or to identify deficiencies (Attention to Detail);
Collaborating with customers to identify their information technology needs or to resolve their hardware and software problems (Customer service);
Explaining technical information orally to non-technical audiences (Oral Communication); and
Evaluating alternatives to recommend solutions to hardware or software problems (Problem Solving).
MINIMUM QUALIFICATION REQUIREMENT: In addition to meeting the basic requirement, applicants must also meet the minimum qualification requirement.
SK-14: Applicant must have at least one year of specialized experience equivalent to the GS/SK-13 level: Specialized experience includes:
Applying expertise with back-end databases including Oracle such as Oracle Fusion Middleware platform and SQL Server (PL/SQL, SQL Server, and T-SQL) to identify and obtain required TCR related data and then apply expertise with front-end database reporting and visualization tools including MSTR and/or Tableau; AND
Generating and customizing analytical reports from databased tables and structures using SQL with MSTR outputs in MS Office Suite and Adobe Acrobat formats for end users; AND
A MicroStrategy Master Analysis Certification or similar certification is preferred but not required.
Additional information
SEC COMPENSATION PROGRAM: The overall salary range listed above is provided for informational purposes as it represents the full range that is applicable to current employees in this occupation/grade; however, a selectee's initial pay is always set below the maximum rate of the range. Please click here for additional information.
IMPORTANT INFORMATION FOR SURPLUS OR DISPLACED FEDERAL EMPLOYEES: Career Transition Assistance Plan (CTAP) and Interagency Career Transition Assistance Plan (ICTAP) are available to individuals who have special priority selection rights under this plan. Individuals must be minimally qualified for this position to receive consideration for special priority selection. CTAP or ICTAP eligibles will be considered minimally qualified if they meet the minimum requirements for this position.
Reasonable Accommodation: If you are an applicant who needs a reasonable accommodation for disability to participate in the application process at the SEC, submit the form for Reasonable Accommodation for Participation in Job Application Process here. Please be sure to submit your request at least 5 business days in advance of the date you need the requested accommodation.
Equal Employment Opportunity (EEO) Information for SEC Job Applicants: Federal EEO laws protect all applicants from discrimination on the following bases: race, color, sex (not limited to conduct which is sexual in nature, includes pregnancy, gender identity, sexual orientation, transgender status), age (40 and over), religion, national origin, disability, genetic information, retaliation for participating in the EEO process or opposing discrimination. Applicants who believe they have been discriminated against on any EEO basis can seek recourse through the SEC's administrative complaints process. To be timely, an individual must enter the EEO process within 45 days from when they know (or should have known) of the alleged discrimination. Click here for additional information.
TTY/ASCII: Video Relay Service users are welcome to contact the appropriate SEC office or employee via the contact information listed above. If you do not otherwise have access to a Video Phone or Video Relay service, you may send us an email or use the Federal Video Relay Service via the internet. For more information about using the Federal Relay Service and to create a new account, please see: https://www.federalrelay.us/
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.
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.
How you will be evaluated
You will be evaluated for this job based on how well you meet the qualifications above.
If you meet the minimum qualifications stated in the vacancy announcement, we will compare your resume and supporting documentation to your responses on the occupational questionnaire. Your resume must support your responses to the occupational questionnaire. After review of your application materials, if you are determined to be minimally qualified, you will be referred to the selecting official. Applicants eligible for Veterans' Preference will receive selection priority over non-veteran preference eligibles.
Your qualifications will be evaluated on the following competencies (knowledge, skills, abilities and other characteristics):
Critical Thinking, Technical Communication, and Technical Competency
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.
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.
You must provide a complete Application Package, which includes:
Required: Your responses to the Occupational Questionnaire.
Required: Your complete and comprehensive resume that includes a complete history of your work experience and the applicable employment dates with months and years. To determine if you qualify for this position, OHR will review your work history that is relevant to the specific position for which you applied. If you are an external candidate selected for this position, OHR will review your complete work history to establish your starting salary. If you are a current SEC employee selected for this position, the standard percentage increases will be applied (i.e., 6% for non-supervisory and 10% for supervisory positions) if your selection results in a promotion. If your selection results in lateral movement (i.e. no change in grade) you will maintain your current salary.Note: Your resume must directly address the definition of specialized experience listed in the qualification section of this announcement and must NOT contain pictures. For external candidates: Information on how your resume will be used for pay setting purposes can be found here.
Required, if applicable: CTAP/ICTAP documentation (a copy of a separation notice or other proof of eligibility for priority selection; a copy of an SF-50, Notification of Personnel Action, showing current position, grade, promotion potential, and duty location; AND a copy of your most recent performance appraisal.)
Required, if applicable: Veteran's Preference Documentation (DD-214, Member Copy 4 or other documentation containing dates of service and character of discharge. Disabled veterans and other applicants eligible for 10-point Veteran's Preference please include: documentation to validate your claim - VA letter, SF-15, etc).
If you are relying on your education to meet qualification requirements:
Failure to provide all of the required information as stated in this vacancy announcement may result in an ineligible rating or may affect the overall rating.
To apply for this position, you must complete the online application and submit the documentation specified in the Required Documents section below.
A complete application package must be submitted by 11:59 PM (EST) on the closing date of the announcement to receive consideration.
To begin, click Apply to access the online application. You will need to be logged into your USAJOBS account to apply. If you do not have a USAJOBS account, you will need to create one before beginning the application.
Follow the prompts to select your résumé and/or other supporting documents to be included with your application package. You will have the opportunity to upload additional documents to include in your application before it is submitted. Your uploaded documents may take several hours to clear the virus scan process.
After acknowledging you have reviewed your application package, complete the Include Personal Information section as you deem appropriate and click to continue with the application process.
You will be taken to the online application which you must complete in order to apply for the position. Complete the online application, verify the required documentation is included with your application package, and submit the application.
To verify the status of your application, log into your USAJOBS account (https://my.usajobs.gov/Account/Login), all of your applications will appear on the Welcome screen. The Application Status will appear along with the date your application was last updated. For information on what each Application Status means, visit: https://www.usajobs.gov/Help/how-to/application/status/.
If you are unable to apply online or need to fax a document you do not have in electronic form, view the following link for information regarding an Alternate Application.
Division of Enforcement
100 F Street NE
Washington, DC 20549
US
Next steps
You will be notified of your application status through USAJOBS at four points during the hiring process, as applicable. You can check the status of your application by accessing the USAJOBS website at http://usajobs.gov/ and clicking on "Track Your Online Application."
By submitting your application, you are certifying the accuracy of the information contained in your application. If you make a false statement in any part of your application, you may not be hired, you may be terminated after you begin work, or you may be fined or jailed. After making a tentative job offer, we will conduct a suitability/security background investigation. You will be required to submit official documentation before appointment. The agency will then verify the information provided on your application (i.e., degree, Veterans' Preference, certification of disability, etc.).
The Federal hiring process is set up to be fair and transparent. Please read the following guidance.
You must provide a complete Application Package, which includes:
Required: Your responses to the Occupational Questionnaire.
Required: Your complete and comprehensive resume that includes a complete history of your work experience and the applicable employment dates with months and years. To determine if you qualify for this position, OHR will review your work history that is relevant to the specific position for which you applied. If you are an external candidate selected for this position, OHR will review your complete work history to establish your starting salary. If you are a current SEC employee selected for this position, the standard percentage increases will be applied (i.e., 6% for non-supervisory and 10% for supervisory positions) if your selection results in a promotion. If your selection results in lateral movement (i.e. no change in grade) you will maintain your current salary.Note: Your resume must directly address the definition of specialized experience listed in the qualification section of this announcement and must NOT contain pictures. For external candidates: Information on how your resume will be used for pay setting purposes can be found here.
Required, if applicable: CTAP/ICTAP documentation (a copy of a separation notice or other proof of eligibility for priority selection; a copy of an SF-50, Notification of Personnel Action, showing current position, grade, promotion potential, and duty location; AND a copy of your most recent performance appraisal.)
Required, if applicable: Veteran's Preference Documentation (DD-214, Member Copy 4 or other documentation containing dates of service and character of discharge. Disabled veterans and other applicants eligible for 10-point Veteran's Preference please include: documentation to validate your claim - VA letter, SF-15, etc).
If you are relying on your education to meet qualification requirements:
Failure to provide all of the required information as stated in this vacancy announcement may result in an ineligible rating or may affect the overall rating.
To apply for this position, you must complete the online application and submit the documentation specified in the Required Documents section below.
A complete application package must be submitted by 11:59 PM (EST) on the closing date of the announcement to receive consideration.
To begin, click Apply to access the online application. You will need to be logged into your USAJOBS account to apply. If you do not have a USAJOBS account, you will need to create one before beginning the application.
Follow the prompts to select your résumé and/or other supporting documents to be included with your application package. You will have the opportunity to upload additional documents to include in your application before it is submitted. Your uploaded documents may take several hours to clear the virus scan process.
After acknowledging you have reviewed your application package, complete the Include Personal Information section as you deem appropriate and click to continue with the application process.
You will be taken to the online application which you must complete in order to apply for the position. Complete the online application, verify the required documentation is included with your application package, and submit the application.
To verify the status of your application, log into your USAJOBS account (https://my.usajobs.gov/Account/Login), all of your applications will appear on the Welcome screen. The Application Status will appear along with the date your application was last updated. For information on what each Application Status means, visit: https://www.usajobs.gov/Help/how-to/application/status/.
If you are unable to apply online or need to fax a document you do not have in electronic form, view the following link for information regarding an Alternate Application.
Division of Enforcement
100 F Street NE
Washington, DC 20549
US
Next steps
You will be notified of your application status through USAJOBS at four points during the hiring process, as applicable. You can check the status of your application by accessing the USAJOBS website at http://usajobs.gov/ and clicking on "Track Your Online Application."
By submitting your application, you are certifying the accuracy of the information contained in your application. If you make a false statement in any part of your application, you may not be hired, you may be terminated after you begin work, or you may be fined or jailed. After making a tentative job offer, we will conduct a suitability/security background investigation. You will be required to submit official documentation before appointment. The agency will then verify the information provided on your application (i.e., degree, Veterans' Preference, certification of disability, etc.).
Fair and transparent
The Federal hiring process is set up to be fair and transparent. Please read the following guidance.
