Are you interested in a rewarding and challenging career? Join the U.S. Small Business Administration, Office of Inspector General! SBA OIG provides auditing, investigative, and other high quality services to support and assist the SBA in achieving its mission. We promote open and honest communication and encourage a positive work environment. We are listed among the top ranked agencies in the Partnership for Public Service's 2021 Best Places to Work in the Federal Government!
Summary
Are you interested in a rewarding and challenging career? Join the U.S. Small Business Administration, Office of Inspector General! SBA OIG provides auditing, investigative, and other high quality services to support and assist the SBA in achieving its mission. We promote open and honest communication and encourage a positive work environment. We are listed among the top ranked agencies in the Partnership for Public Service's 2021 Best Places to Work in the Federal Government!
Implements cloud data architecture in Azure Data Lake and Synapse with distributed SQL pools, using established security protocols.
Designs and implements Extract, Transform, Load (ETL) processes in support cloud-based data analytics environments.
Maintains SQL databases, including expertise in SQL and T-SQL.
Creates and oversees the application of a diverse set of models, tools, and risk and decision science techniques to develop and enhance program operational and analytic capabilities.
Uses data management tools to control the organization's storage, retrieval, security, and integrity of data.
Maintains up-to-date knowledge of current trends and services for cloud-based data environments.
You must successfully complete a background investigation. Candidates who do not respond to the background investigation request by the pre-determined due date, will be disqualified.
You may be required to serve a one-year probationary period.
Candidates who are determined to be qualified for this position, must complete an additional online assessment through Talent Plus. You must complete the Talent Plus Assessment within 48 business hours of being sent the email notification.
Qualifications
In order to qualify for this position, your resume must provide sufficient evidence of experience, knowledge, skills, and abilities needed to perform the duties of the position. Therefore, we encourage you to submit a thorough resume that directly relates to this position.
Specialized Experience Statement:
GS-13: One year of specialized experience, equivalent to the GS-12 grade level in the Federal service, obtained in either the private or public sector such as: experience in data extraction and modeling activities that could be used to support audits and investigations, including improving access to internal and external data; experience in the management and analysis of how to collect, use, manage, share and report data within and across organizations; experience providing cloud data guidance. Ability to ensure stringent application of information security/information assurance policies, principles and practices to all components of cloud data; and experience in maintaining SQL databases, including expertise in SQL and T-SQL.
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.
TIME-IN-GRADE: If you are a current career or career-conditional federal employee applying for promotion under Merit Promotion you must have completed a minimum of 52 weeks in positions at the next level lower than the position being filled.
All qualification requirements must be met by 11:59 pm (Eastern Time) on 04/21/2022.
Education
For this position you must meet the qualification requirement using experience alone -- no substitution of education for experience is permitted.
Additional information
COVID-19 VACCINATION: To ensure compliance with an applicable preliminary nationwide injunction, which may be supplemented, modified, or vacated, depending on the course of ongoing litigation, the Federal Government will take no action to implement or enforce the COVID-19 vaccination requirement.
SUITABILITY, CLEARANCE & REQUIREMENTS: A background investigation may be required for all new hires. Appointment will be subject to the applicant's successful completion of a background investigation and favorable adjudication. Failure to successfully meet these requirements will be grounds for termination.
SELECTIVE SERVICE: If you are a male applicant born after December 31, 1959, you must certify that you have registered with the Selective Service System, or are exempt from having to do so under the Selective Service Law. For additional information visit www.sss.gov.
FINANCIAL DISCLOSURE: You are required to file a new entrant Confidential Financial Disclosure Report (OGE 450 Report).
Additional vacancies may be filled from this vacancy announcement if additional vacancies occur within 180 days of the date the certificates were issued.
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.
Your qualifications will be evaluated based on your application materials, the responses you provide on the application questionnaire, and the result of the online assessment required for this position (if you are determined qualified after initial review). You will be assessed on the following competencies (knowledge, skills, abilities, and other characteristics):
Data Management
Database Management Systems
Team Building
In addition to the application and Occupational Questionnaire, this position requires submission of an Talent Plus Online Assessment by all candidates determined to be qualified. The online assessment measures critical general competencies required to perform the job. The assessment includes a cut score based on the minimum level of required proficiency in these critical general competencies. You must meet or exceed the cut score to be considered. You will not be considered for the position if you score below the cut score or fail to complete the online assessment (if forwarded to you). In order to be considered for this position, you must complete all required steps in the process.
Overstating your qualifications and/or experience in your application materials or application questionnaire may result in your removal from consideration.
Career and InterAgency Career Transition Assistance Programs: If you are applying for a special selection priority under SBA's Career Transition Assistance Plan (open to surplus SBA employees only) or the Interagency Career Transition Assistance Program (open to surplus and displaced Federal employees), you must: meet CTAP eligibility criteria, be rated well-qualified for the position with a rating of 85 or above based on the competencies listed below, and submit the appropriate documentation to support your CTAP eligibility. Click here for more information.
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.
To apply for this position, you must submit a complete Application Package which includes:
1. Your resume showing work schedule, hours worked per week, dates of employment and duties performed.
2. A complete Occupational Questionnaire
3. A complete Talent Plus Assessment, if required after initial qualification determination
4. In addition to the online application (resume and responses to the occupational questionnaire), you are required to submit the following forms, if applicable. It is the responsibility of the applicant to ensure all documents are legible:
Federal employees must submit proof of your permanent career/career-conditional competitive status ("1" or "2" in Tenure, block 24 and "1" in Position Occupied, block 34). Submit SF-50 showing current grade and tenure and an SF-50 showing highest (permanent) grade ever held, if different. NOTE: An award or detail SF-50 will not be accepted as proof of status.
If you are using education as a substitution for experience (the announcement will state whether this is allowed), or if there is an educational requirement for this position, you must submit a copy of your transcripts (unofficial or official) that clearly describes your qualifying education. If selected, official transcripts will be required;
If you are claiming Veteran status, you must submit a copy of all required documents to support your claim (including a DD-214 showing character of service)--see VetGuide;
To receive consideration for a special appointment authority (30%, severely disabled, Peace Corps, ICTAP, VRA), you must submit all required documentation supporting your claim for Special Appointing Authorities;
Veterans who are still in the service may be granted tentative preference on the basis of information contained in their applications, but they must produce a DD-214 (showing the character of service) or other proof of service to receive consideration for veterans' preference. For more information on Veterans' Preference, please visit FedsHireVets.gov.
For proof of CTAP/ICTAP eligibility, you must provide documentation from each of the following three categories:
1. One of the following:
Your Reduction in Force (RIF) separation notice;
Your RIF notice offering a lower graded position accompanied by a declination of the offer (the RIF notice must state that declination will result in separation under RIF);
Notice of proposed removal for declining a directed geographic relocation outside the local commuting area (e.g., a directed reassignment or change in duty station);
Certificate of expected separation; or
Other official agency certification or notification indicating that your position is surplus (e.g., a notice of position abolishment or a notice of eligibility for discontinued service retirement).
2. Your Notification of Personnel Action(s), SF-50(s), or other official documentation that shows:
a. You are a current:
i. career or career-conditional competitive service employee, in tenure group 1 or 2, at grade GS-15 or equivalent and below; or
ii. excepted service employee serving without time limit at grade GS-15 or equivalent and below who has been conferred noncompetitive appointment eligibility and selection priority by law for competitive service positions; and
b. The position you may be or are being separated from:
i. Is equal to or higher than the grade of the job announced; and
ii. Has the same or higher promotion potential as the job announced; and
iii. Is in the same local commuting area as the job announced.
3. Your most recent performance rating of record (which must be rated at least fully successful or equivalent).
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.
Please read the entire announcement and all the instructions before you begin an application. To apply for this position, you must complete the initial online application, to include the initial online assessment and submission of the required documentation specified in the Required Documents section below. The complete application package must be submitted by 11:59 PM (ET) on 04/21/2022 to receive consideration. The application process is as follows:
To begin the application process, click the Apply Online button.
Answer the questions presented in the application and attach all necessary supporting documentation.
Click the Submit Application button prior to 11:59PM (ET) on the announcement closing date.
After submitting an online application, you will be notified whether or not you are required to take the additional online assessment through Talent Plus. This message will be delivered to you via email. You must complete the Talent Plus Assessment within 48 business hours of being sent the email notification.
If you are asked to take the Talent Plus Assessment, you will be presented with a unique URL to access the Talent Plus system.
Note, set aside at least 40 minutes to take the assessment; however, most applicants complete the assessment in less time. If you need to stop the assessment and continue at a later time, you can re-use the URL sent to you via email.
To update your application, including supporting documentation, at any time during the announcement open period, return to your USAJOBS account (https://my.usajobs.gov/Account/Login) . There you will find a record of your application, the application status, and an option to Update Application. This option will no longer be available once the announcement has closed.
To verify the status of your application both during and after the announcement open period, log into your USAJOBS account: https://my.usajobs.gov/Account/Login . All of your applications will appear on the Welcome page. The application record in your USAJOBS account provides an Additional Application Information page that provides information regarding the documentation you submitted and any correspondence we have sent related to this application. 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/.
OFFICE OF INSPECTOR GENERAL HR OFFICE
409 3RD STRET, SW
WASHINGTON, DC 20416
US
Next steps
Once your responses to the occupational questionnaire are received by our system, you will be sent an acknowledgement email stating that your submission was successful. If you meet the minimum qualifications of this position, you will be presented with instructions on how to access the Talent Plus Assessment system via email. The additional assessment must be completed within 48 business hours following email notification. After a review of your complete application is made, you will be notified of your rating and/or referral to the hiring official. If further evaluation or interviews are required you will be contacted. During the evaluation and interview process you may be asked to provide written responses to questions or writing samples. You may track the status of the application process through USAJOBS and you will be notified of the outcome.
The Federal hiring process is set up to be fair and transparent. Please read the following guidance.
To apply for this position, you must submit a complete Application Package which includes:
1. Your resume showing work schedule, hours worked per week, dates of employment and duties performed.
2. A complete Occupational Questionnaire
3. A complete Talent Plus Assessment, if required after initial qualification determination
4. In addition to the online application (resume and responses to the occupational questionnaire), you are required to submit the following forms, if applicable. It is the responsibility of the applicant to ensure all documents are legible:
Federal employees must submit proof of your permanent career/career-conditional competitive status ("1" or "2" in Tenure, block 24 and "1" in Position Occupied, block 34). Submit SF-50 showing current grade and tenure and an SF-50 showing highest (permanent) grade ever held, if different. NOTE: An award or detail SF-50 will not be accepted as proof of status.
If you are using education as a substitution for experience (the announcement will state whether this is allowed), or if there is an educational requirement for this position, you must submit a copy of your transcripts (unofficial or official) that clearly describes your qualifying education. If selected, official transcripts will be required;
If you are claiming Veteran status, you must submit a copy of all required documents to support your claim (including a DD-214 showing character of service)--see VetGuide;
To receive consideration for a special appointment authority (30%, severely disabled, Peace Corps, ICTAP, VRA), you must submit all required documentation supporting your claim for Special Appointing Authorities;
Veterans who are still in the service may be granted tentative preference on the basis of information contained in their applications, but they must produce a DD-214 (showing the character of service) or other proof of service to receive consideration for veterans' preference. For more information on Veterans' Preference, please visit FedsHireVets.gov.
For proof of CTAP/ICTAP eligibility, you must provide documentation from each of the following three categories:
1. One of the following:
Your Reduction in Force (RIF) separation notice;
Your RIF notice offering a lower graded position accompanied by a declination of the offer (the RIF notice must state that declination will result in separation under RIF);
Notice of proposed removal for declining a directed geographic relocation outside the local commuting area (e.g., a directed reassignment or change in duty station);
Certificate of expected separation; or
Other official agency certification or notification indicating that your position is surplus (e.g., a notice of position abolishment or a notice of eligibility for discontinued service retirement).
2. Your Notification of Personnel Action(s), SF-50(s), or other official documentation that shows:
a. You are a current:
i. career or career-conditional competitive service employee, in tenure group 1 or 2, at grade GS-15 or equivalent and below; or
ii. excepted service employee serving without time limit at grade GS-15 or equivalent and below who has been conferred noncompetitive appointment eligibility and selection priority by law for competitive service positions; and
b. The position you may be or are being separated from:
i. Is equal to or higher than the grade of the job announced; and
ii. Has the same or higher promotion potential as the job announced; and
iii. Is in the same local commuting area as the job announced.
3. Your most recent performance rating of record (which must be rated at least fully successful or equivalent).
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.
Please read the entire announcement and all the instructions before you begin an application. To apply for this position, you must complete the initial online application, to include the initial online assessment and submission of the required documentation specified in the Required Documents section below. The complete application package must be submitted by 11:59 PM (ET) on 04/21/2022 to receive consideration. The application process is as follows:
To begin the application process, click the Apply Online button.
Answer the questions presented in the application and attach all necessary supporting documentation.
Click the Submit Application button prior to 11:59PM (ET) on the announcement closing date.
After submitting an online application, you will be notified whether or not you are required to take the additional online assessment through Talent Plus. This message will be delivered to you via email. You must complete the Talent Plus Assessment within 48 business hours of being sent the email notification.
If you are asked to take the Talent Plus Assessment, you will be presented with a unique URL to access the Talent Plus system.
Note, set aside at least 40 minutes to take the assessment; however, most applicants complete the assessment in less time. If you need to stop the assessment and continue at a later time, you can re-use the URL sent to you via email.
To update your application, including supporting documentation, at any time during the announcement open period, return to your USAJOBS account (https://my.usajobs.gov/Account/Login) . There you will find a record of your application, the application status, and an option to Update Application. This option will no longer be available once the announcement has closed.
To verify the status of your application both during and after the announcement open period, log into your USAJOBS account: https://my.usajobs.gov/Account/Login . All of your applications will appear on the Welcome page. The application record in your USAJOBS account provides an Additional Application Information page that provides information regarding the documentation you submitted and any correspondence we have sent related to this application. 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/.
OFFICE OF INSPECTOR GENERAL HR OFFICE
409 3RD STRET, SW
WASHINGTON, DC 20416
US
Next steps
Once your responses to the occupational questionnaire are received by our system, you will be sent an acknowledgement email stating that your submission was successful. If you meet the minimum qualifications of this position, you will be presented with instructions on how to access the Talent Plus Assessment system via email. The additional assessment must be completed within 48 business hours following email notification. After a review of your complete application is made, you will be notified of your rating and/or referral to the hiring official. If further evaluation or interviews are required you will be contacted. During the evaluation and interview process you may be asked to provide written responses to questions or writing samples. You may track the status of the application process through USAJOBS and you will be notified of the outcome.
Fair and transparent
The Federal hiring process is set up to be fair and transparent. Please read the following guidance.
