Summary
Public Service Loan Forgiveness Program and Creditable Service for Annual Leave Accrual are available.
This position is located in the Office of the Chief Information Officer (OCIO), Business Solutions Center (BSC).
IT Specialist (DATAMGT) is responsible for database design, development, configuring, testing, acquisition, deployment, maintenance, monitoring, security and support, data structure logic, data availability and data quality.
This job is open to
The public
U.S. Citizens, Nationals or those who owe allegiance to the U.S.
Career transition (CTAP, ICTAP, RPL)
Federal employees whose job, agency or department was eliminated and are eligible for priority over other applicants.
Clarification from the agency
Applications will be accepted from any U.S. citizen. Direct Hire Authority will be used to fill this position. Veterans Preference and traditional rating and ranking of applicants does not apply to this vacancy.
Duties
- Develops, deploys, maintains, and administers data pipelines and enterprise data engineering solutions.
- Designs and integrates ETL workflows using tools and languages such as Python, AWS, Azure, and Apache Spark to clean, blend, join, and transform datasets.
- Defines requirements and supports data structure design, development, implementation, and maintenance for FSIS data systems.
- Serves as a point of contact, liaison, facilitator, and SME for requirement gathering, standards enforcement, modernization efforts, and data platform administration.
- Participates in and leads requirements analysis and refinement sessions; resolves requirement conflicts and ensures clarity, completeness, and consistency.
- Leads daily Scrum meetings, plans sprints, tracks and reports agile metrics (e.g., sprint velocity), and demonstrates product capabilities to customers and FSIS leadership.
- Meets with customers to gather requirements for existing and new implementations.
- Collaborates with senior staff, Project Management, Architecture, Enterprise groups, and external FSIS stakeholders to design and implement data warehouse and data lake solutions.
- Provides subject-matter expertise in enterprise and emerging data management technologies, including data orchestration and data engineering/analytics.
- Ensures data and index integrity; performs data validation across multiple datasets.
- Establishes, implements, and oversees Standard Operating Procedures (SOPs) for data platform administration and data management technologies.
- Ensures business requirements are documented and tested.
- Serves as liaison between OCIO system developers and business stakeholders for business application requirements.
- Creates, edits, maintains, and reviews SDLC documentation.
Requirements
Conditions of employment
- You must be a US Citizen or US National.
- Males born after 12/31/1959 must be Selective Service registered or exempt.
- Subject to satisfactory adjudication of background investigation and/or fingerprint check.
- Successful completion of one-year probationary period, unless previously served. Refer to the Next Steps section for more information.
- Direct Deposit: Per Public Law 104-134 all Federal employees are required to have federal payments made by direct deposit to their financial institution.
- Successfully pass the E-Verify employment verification check. To learn more about E-Verify, including your rights and responsibilities, visit https://www.e-verify.gov/.
- False statements or responses on a resume or application can jeopardize employment and may be grounds for disciplinary action, including removal from Federal service.
- If you are selected, you may need to complete a Declaration for Federal Employment (OF-306) prior to being appointed to determine suitability for Federal employment and to authorize a background investigation.
Qualifications
Applicants must meet all qualifications and eligibility requirements by the closing date of the announcement including specialized experience and competency proficiency as defined below.
FOR GS-13 CONSIDERATION: Applicants must have one year of specialized experience at the GS-12 grade level in the Federal service or equivalent responsibility in the private sector/pay systems. This specialized experience must include all the following:
- Experience with the principles and methods to identify, analyze, specify, design, and manage functional data and data lake infrastructure requirements; includes translating data requirements into technical requirements used for logical design or presenting alternative technologies or approaches.
- Experience working on a Cloud data lake and/or Data warehouse.
- Experience with building data pipelines / ETLs using tools and languages such as python and Apache spark.
- Experience leading Scrum and/or Agile meetings and tracking agile metrics.
In addition to the above specialized experience requirements, applicants will undergo a structure resume review to determine whether they meet the Individual Occupational Requirements (IOR) of the 2210 series. Successfully completing the 2210 series USAHire assessment with a passing score will be used as proof of possessing the necessary proficiency in the following competencies: Attention to Detail, Customer Service, Decision Making, Interpersonal Skills, and Teamwork. A panel of subject matter experts will review your resume to determine if you meet the minimum proficiency level (as defined by the 2210 series IOR) for the following competencies:
- Information Management
- Oral Communication
- Problem Solving
- Technical Competence
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 and can provide valuable training and experience that translates directly to paid employment. You will receive credit for all qualifying experience, including volunteer experience.
Click here for more information on this series: OPM Information Technology Management Series 2210
Additional information
Career Transition Assistance Plan (CTAP), Reemployment Priority List (RPL), or Interagency Career Transition Assistance Plan (ICTAP): Visit the OPM website for information on how to apply as a CTAP, RPL, or ICTAP eligible. To exercise selection priority for this vacancy, CTAP/RPL/ICTAP candidates must meet the basic eligibility requirements and all selective factors. CTAP/ICTAP candidates must be rated and determined to be well qualified (or above) based on an evaluation of the competencies listed in the How You Will Be Evaluated section. When assessed through a score-based category rating method, CTAP/ICTAP applicants must receive a rating of at least 80 out of a possible 100 on the USAHire Assessment.
Reasonable Accommodation (RA) Requests: If you believe you have a disability (i.e., physical or mental), covered by the Rehabilitation Act of 1973 as amended that would interfere with completing the USA Hire Competency Based Assessments, you will be granted the opportunity to request a RA in your online application. Requests for RA for the USA Hire Competency Based Assessments and appropriate supporting documentation for RA must be received prior to starting the USA Hire Competency Based Assessments. Decisions on requests for RA are made on a case-by-case basis. If you meet the minimum qualifications of the position, after notification of the adjudication of your request, you will receive an email invitation to complete the USA Hire Competency Based Assessments, based on your adjudication decision. You must complete all assessments within 48 hours of receiving the URL to access the USA Hire Competency Based Assessments if you received the link after the close of the announcement. To determine if you need a RA, please review the Procedures for Requesting a Reasonable Accommodation for Online Assessments.
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.
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.
How you will be evaluated
You will be evaluated for this job based on how well you meet the qualifications above.
Due to the Direct-Hire Authority (DHA), applicants are not rated and ranked numerically, and Veteran's preference does not apply. Applicants are strongly encouraged to provide complete information about their job-related experience and education. Your resume must document that you meet the Qualification Requirements detailed above. Applicants who meet the minimum qualification requirements established for the position will be placed in the Eligible category. Although Veteran's preference does not apply due to the existence of the DHA for this position, applicants are still encouraged to provide documentation related to veteran's preference.
Applications will be evaluated in accordance with Office of Personnel Management's (OPM) Delegated Examining Procedures and USDA policy using the direct hire authority. Final rating will be determined by your score on the USAHire assessment. In order to be eligible for referral, you must complete the USAHire assessment with a passing score and demonstrate the extent to which they possess the following knowledge, skills, and abilities (KSA) or competencies (as described in the qualifications section above):
COMPETENCY LIST:
- Attention to Detail
- Customer Service
- Decision Making
- Information Management
- Interpersonal Skills
- Oral Communication
- Problem Solving
- Teamwork
- Technical Competence
The USA Hire 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 assessment.
Overstating your qualifications and/or experience in your application materials or application questionnaire may result in your removal from consideration. Cheating on an assessment may also result in your removal from consideration.
Your application, including the online Assessment Questionnaire, will be reviewed to determine if you meet (a) minimum qualification requirements and (b) your resume supports the answers provided to the job-specific questions. Your resume must clearly support your responses to all the questions addressing experience and education relevant to this position. Those determined to be in the best qualified category will be referred to the selecting official for consideration.
NOTE: If, after reviewing your resume and/or supporting documentation, a determination is made that you have inflated your qualifications and or experience, your score may be adjusted to more accurately reflect your abilities, or you may be found ineligible. Please follow all instructions carefully. Errors or omissions may affect your rating. Providing inaccurate information on Federal documents could be grounds for non-selection or disciplinary action up to and including removal from the Federal service.
Clicking the link below will present a preview of the application form; i.e. the online questionnaire. The application form link below will only provide a preview and does not initiate the application process. To initiate the online application process, click the "Apply" button to the right.
To preview the application questionnaire, click the following link:
https://apply.usastaffing.gov/ViewQuestionnaire/12946770
Required Documents
The following documents are required for your applicant package to be complete. Encrypted documents will not be accepted. Failure to submit required, legible documents may result in loss of consideration.
Resume that includes: Personal Information: name, address, contact information; Education; Work Experience related to this position as described in the major duties including work schedule, hours worked per week, dates of employment; title, series, grade (if applicable); other qualifications. Resume cannot exceed 2 pages.
- Your application may be disqualified if you include any of the information listed here: What should I leave out of my resume?
If education is required or you are using education to qualify, you must submit a copy of
all relevant college transcripts. An unofficial copy is sufficient with the application if it includes your name and the necessary course information; however, if you are selected, you will be required to submit official transcripts prior to entering on duty. Education must have been successfully obtained from an accredited school, college or university. If any education was completed at a foreign institute, you must submit with your application evidence that the institute was appropriately accredited by an accrediting body recognized by the U.S. Department of Education as equivalent to U.S. education standards. There are private organizations that specialize in this evaluation and a fee is normally associated with this service. For a list of private organizations that evaluate education, visit the
NACES website. All transcripts must be in English or include an English translation.
If claiming Veterans' Preference, you must submit a DD-214, Certificate of Release from Active Duty, which shows dates of service and discharge under honorable conditions. If currently on active duty, you must submit a certification of expected discharge or release from active duty service under honorable conditions not later than 120 days after the date the certification is submitted. Veterans' Preference must be verified prior to appointment. Without this documentation, you will not receive Veterans' Preference, and your application will be evaluated based on the material(s) submitted.
If claiming 10-point Veterans' Preference, you must provide the DD-214 or certification requirements (see above bullet), plus the proof of entitlement of this preference as listed on the SF-15 Application for 10-point Veterans' Preference. The SF-15 should be included but is not required. Failure to submit these documents could result in the determination that there is insufficient documentation to support your claim for 10-point preference. For more information on Veterans' Preference visit
FedsHireVets.
Surplus or displaced employees eligible for CTAP, RPL, or ICTAP priority must provide: proof of eligibility (RIF separation notice, notice of proposed removal for declining a transfer of function or directed reassignment to another commuting area, notice of disability annuity termination), SF-50 documenting separation (as applicable), current performance appraisal with rating of at least "Fully Successful" or equivalent, and your most recent SF-50 noting position, grade level, and duty location with your application per 5 CFR 330.
If you are relying on your education to meet qualification requirements:
Education must be accredited by an accrediting institution recognized by the U.S. Department of Education in order for it to be credited towards qualifications. Therefore, provide only the attendance and/or degrees from
schools accredited by accrediting institutions recognized by the U.S. Department of Education.
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.
How to Apply
Please read the entire announcement and all the instructions before you begin an application. To apply and be considered for this position, you must complete all required questionnaires, assessments, and required documentation as specified in the How to Apply and Required Documents section. The complete application package must be submitted by 11:59 PM (ET) on the closing date of the announcement to receive consideration. Resumes must not exceed two pages. The application process is as follows:
- 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:59 PM (ET) on the announcement closing date.
- If you are required to complete any USA Hire Assessments, you will be notified after submitting your application. The notification will be provided in your application submission screen and via email. The notification will include your unique assessment access link to the USA Hire system and the completion deadline. Additionally, in USAJOBS you can click "Track this application" to return to your assessment completion notice.
- Access USA Hire using your unique assessment link. Access is granted through your USAJOBS login credentials.
- Review all instructions prior to beginning your assessments. You will have the opportunity to request a testing accommodation before beginning the assessments should you have a disability covered under the Rehabilitation Act of 1973 as amended.
- Set aside at least 3 hours to take the USA Hire assessments; however, most applicants complete the assessments in less time. If you need to stop the assessments and continue later, you can re-use your unique assessment link.
- Your responses to the USA Hire Assessments will be reused for one year (in most cases) from the date you complete an assessment. If future applications you submit require completion of the same assessments, your responses will be automatically reused.
Visit the
USA Hire Applicant Resource Center for practice assessments and assessment preparation.
To update your application, including supporting documentation: During the announcement open period, return to your USAJOBS account, find your application record, and click
Edit my application. This option will no longer be available once the announcement has closed.
To view the announcement status or your application status: Click on this:
https://www.usajobs.gov/Help/how-to/application/status/. Your application status page is where you can view your application status, USA Hire assessment completion status, and review your notifications sent by the hiring agency regarding your application.
Please verify that documents you are uploading from USAJOBs transfer into the Agency's staffing system as there is a limitation to the number of documents that can be transferred. However, once in the Agency's staffing system, you will have the opportunity to upload additional documents. Uploaded documents must be less than 5MB and in one of the following document formats: GIF, JPG, JPEG, PNG, RTF, PDF, TXT or Word (DOC or DOCX). Do not upload Adobe Portfolio documents because they are not viewable. Please ensure your resume does not exceed two pages.
Applicants who submit a resume that exceeds two pages will be removed from consideration.
Next steps
Your application will be reviewed to verify that you meet the eligibility and qualification requirements for the position prior to issuing referral lists to the selecting official. If further evaluation or interviews are required, you will be contacted. Log in to your USAJOBS account to check your application status.
You must choose to turn on email notifications in your USAJOBS profile if you want to receive important email notifications that may impact your applicant experience (e.g. If you start an application and do not submit it prior to the closing date, USAJOBS will send an email reminder that the closing date is approaching and your application is in an incomplete status).
Multiple positions may be filled from this announcement.
As a condition of employment for accepting this position, you will be required to serve a 1-year probationary period during which we will evaluate your fitness and whether your continued employment advances the public interest. In determining if your employment advances the public interest, we may consider: your performance and conduct; the needs and interests of the agency; whether your continued employment would advance organizational goals of the agency or the Government; and whether your continued employment would advance the efficiency of the Federal service. Upon completion of your probationary period your employment will be terminated unless you receive certification, in writing, that your continued employment advances the public interest.
Under the Fair Chance Act, agencies are not allowed to request information about an applicant's criminal history until a conditional offer of employment has been made, except as allowed for access to classified information; assignment to national security duties or positions; acceptance or retention in the armed forces; or recruitment of a Federal law enforcement officer. An applicant may submit a complaint or any other information related to an organization's alleged noncompliance with the Fair Chance Act. The complaint must be submitted within 30 calendar days of the date of the alleged noncompliance. To make a Fair Chance Act inquiry or complaint, send an email with the appropriate information to fsis.fca@usda.gov, subject line: Fair Chance Act.