This announcement will be used to fill vacancies through OPM-Authorized Government-Wide Direct Hire Authority. Category rating, veteran's preference, and traditional rating and ranking of applicants DO NOT APPLY to this vacancy. For more information on OPM's Authorization of Direct Hire Authority, pleaseclick here.
Summary
This announcement will be used to fill vacancies through OPM-Authorized Government-Wide Direct Hire Authority. Category rating, veteran's preference, and traditional rating and ranking of applicants DO NOT APPLY to this vacancy. For more information on OPM's Authorization of Direct Hire Authority, pleaseclick here.
Implements Extract, Transform, Load (ETL) processes in support cloud-based data analytics environments, and cloud data architecture in Azure Data Lake and Synapse with distributed SQL pools, using established security protocols.
Demonstrates hands-on experience maintaining SQL databases, including expertise in SQL and T-SQL.
Leads cyber risk management and devises strategies to reduce risk across SBA OIG's cloud computing environment using a deep understanding of cybersecurity domain areas and federal cyber policies, frameworks, and programs.
Creates and executes a vision and strategy to implement a secure and user-friendly query functionality to SBA OIG's integrated cloud environment.
Monitors and follows IT security protocols over PII and other sensitive data, particularly as it relates to third party data sharing agreements to archive data appropriately, efficiently and securely.
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 complete the required background investigation paperwork by the pre-determined due date, will be disqualified.
You may be required to serve on a one year supervisory probationary period.
You must meet the Basic Education Requirement.
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 demonstrate sufficient specialized experience to perform the duties of this position. Your resume is the key means we have for evaluating your skills, knowledge, and abilities, as they relate to this position. Therefore, we encourage you to submit a thorough resume that directly relates to this position. Applicants must meet any basic requirements and specialized experience.
Basic Education Requirement:
IT Competencies: For all positions, individuals must have IT-related experience (which may be obtained by paid or unpaid experience and/or completion of specific, intensive training (for example, IT certification), as appropriate) demonstrating each of the four competencies listed below:
Attention to Detail - Is thorough when performing work and conscientious about attending to detail.
Customer Service - Works with clients and customers (that is, any individuals who use or receive the services or products that your work unit produces, including the general public, individuals who work in the agency, other agencies, or organizations outside the Government) to assess their needs, provide information or assistance, resolve their problems, or satisfy their expectations; knows about available products and services; is committed to providing quality products and services.
Oral Communication - Expresses information (for example, ideas or facts) to individuals or groups effectively, taking into account the audience and nature of the information (for example, technical, sensitive, controversial); makes clear and convincing oral presentations; listens to others, attends to nonverbal cues, and responds appropriately.
Problem Solving - Identifies problems; determines accuracy and relevance of information; uses sound judgment to generate and evaluate alternatives, and to make recommendations.
SPECIALIZED EXPERIENCE: Applicants must possess one year of specialized experience equivalent in difficulty and responsibility to the next lower grade level in the Federal Service. Specialized experience is experience that has equipped the applicant with the particular competencies/knowledge, skills and abilities to successfully perform the duties of the position. This experience need not have been in the federal government.
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.
To qualify at the GS-14 level: SPECIALIZED EXPERIENCE: You must have one full year (52 weeks) of specialized experience equivalent to the next lower grade level GS-13 in the Federal service. Specialized experience MUST include all of the following:
Computing cloud environments in cloud infrastructure such as Azure.
Implementing cloud data architecture in Azure Data Lake and Synapse with distributed SQL pools and maintaining the security of those systems.
Implementing architectural designs, managing configurations and installation of cloud-based applications, and providing operational support of cloud infrastructures.
All qualification requirements must be met by 11:59 pm (Eastern Time) on the closing date of this vacancy announcement.
Education
Education may not be substituted for experience for this position.
Additional information
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.
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
Technical Credibility
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 Questionnaire3. Relevant Transcript(s)4. A complete Talent Plus Assessment, if required after initial qualification determination5. 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 08/25/2023 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 STREET 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. 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 Questionnaire3. Relevant Transcript(s)4. A complete Talent Plus Assessment, if required after initial qualification determination5. 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 08/25/2023 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 STREET 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. 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.
