USAJOBS connects job seekers with federal jobs across the United States and around the world as the official employment site for the federal government

This job is open to

Help

Internal to an agency

Current federal employees of the hiring agency that posted the job announcement.

Clarification from the agency

Internal to the Agency only (CSOSA/PSA).

Duties

Help

Designs and implements enterprise data warehouse, data integration, and information delivery solutions to meet agency business and analytical needs.
Develops, maintains, and optimizes ELT/ETL pipelines, data models, and data transformation processes supporting reporting, analytics, and operational decision-making.
Identifies system defects, data quality issues, and process inefficiencies; recommends and implements corrective actions and improvements.
Adapts existing data solutions to evolving stakeholder requirements and emerging technical challenges.
Collaborates with team members, supervisors, and stakeholders to enhance solution quality, resilience, and performance.
Communicates data management goals, priorities, and resource needs to stakeholders across the agency.
Monitors system utilization and costs to ensure efficient and cost-effective operations.
Maintains awareness of trends, best practices, and regulatory requirements related to data warehousing, data governance, and information delivery.
Designs and maintains data quality assurance processes to ensure accurate, timely, and reliable data for reporting and analysis.
Develops and monitors ETL pipelines that transform, enrich, and aggregate data for business intelligence and analytics.
Provides customer support to business intelligence users, helping them access, interpret, and apply data effectively.
Captures and responds to user feedback, questions, and change requests related to data and reporting needs.
Implements data governance and data quality best practices to strengthen stakeholder engagement and system reliability.
Produces technical documentation, data modeling diagrams, and presentations to explain data solutions and promote user understanding.
Designs, develops, and maintains the agency's data catalog to support data discovery and transparency.
Responds to user inquiries, complaints, and access requests in a timely, accurate, and customer-focused manner.
Ensures compliance with all applicable data privacy, information security, and access control policies and regulations.

Requirements

Help

Conditions of employment

Must be a U.S. Citizen or National
Males born after 12-31-59 must be registered for Selective Service, if applicable
Background security investigation, drug test, and favorable adjudication
May be required to successfully complete a one year probationary period (unless already completed).
Time-in-grade requirements must be met within 30 calendar day of the closing date of this announcement
CSOSA uses E-Verify, if you are selected for this position, the documentation that you present for purposes of completing the Department of Homeland Security (DHS) Form I-9 will be verified through the DHS "E-Verify" System.
Bargaining Unit Status: Eligible - This position is represented by American Federation of Government Employees, Local 0727.
All Federal employees are required to have Federal salary payments directly deposited into a financial institution of their choosing.
This is not a virtual or remote position; you must live within or be willing to relocate within a commutable distance of the duty location which is Washington D.C. (District of Columbia).

Qualifications

Time-in-Grade: Current or former federal employees who have held a GS position in the preceding 52 weeks, must meet the time in grade requirement. Applicant must have served 52 weeks as a GS-13 or higher grade in Federal Service.

To minimally qualify for the IT Specialist (Data Management), GS-2210-14 position, you must meet both, the BASIC REQUIREMENT and the SPECIALIZED EXPERIENCE as stated below:

BASIC REQUIREMENT
Ph.D. or equivalent doctoral degree or 3 full years of progressively higher level graduate education leading to a Ph.D. or equivalent doctoral degree in computer science, engineering, information science, information systems management, mathematics, operations research, statistics, or technology management or degree that provided a minimum of 24 semester hours in one or more of the fields identified above and required the development or adaptation of applications, systems or networks.
OR
You must have IT-related experience 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.
Oral Communication - Expresses information (for example, ideas or facts) to individuals or groups effectively, considering 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.

NOTE: Your resume' must demonstrate all the IT-related competencies and experience to be considered qualified.

In addition to meeting the Basic Requirement (positive education or experience), applicants must possess one year of Specialized Experience equivalent to the next lower grade (GS-13 or equivalent in other pay scales) within the Federal service, which demonstrates the ability to perform the duties of the position.

SPECIALIZED EXPERIENCE
You must have one full year of specialized experience equivalent to the GS-13 level in the Federal service. Specialized experience must demonstrate all the following:

Designing, developing, and maintaining enterprise data warehouse solutions, including data storage, data transformation, data enhancement, and data integration to support reporting, analytics, and business intelligence.
Developing, implementing, and monitoring ETL/ELT pipelines that ingest, standardize, normalize, transform, enrich, and aggregate data from multiple source systems for analytical and operational use.
Applying advanced data modeling techniques, including relational and dimensional modeling, de-normalization of transactional data, and creation of structures optimized for analysis and reporting.
Implementing data quality assurance processes, including automated data quality checks, anomaly detection, and remediation of data defects to ensure accuracy, completeness, and timeliness of enterprise data assets.
Contributing to enterprise data architecture, including evaluating existing solutions, recommending improvements, and ensuring scalability, flexibility, and alignment with business and technical requirements.
Supporting data governance activities, such as developing metadata, maintaining data catalogs, documenting data assets, and applying data lifecycle management practices.
Ensuring compliance with data security and privacy requirements, including implementing and maintaining access controls, safeguarding sensitive data, and adhering to applicable laws, regulations, and policies.
Providing customer support to data and analytics users, including responding to inquiries, resolving data access issues, addressing data quality concerns, and communicating technical information clearly to non-technical stakeholders.
Collaborating with cross-functional teams, participating in technical discussions, identifying process improvements, and contributing to the enhancement of enterprise data solutions.

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

Education is not substitutable for Specialized Experience at this grade level.

ARE YOU USING YOUR EDUCATION TO QUALIFY? You MUST provide transcripts or other documentation to support your educational claims. Unless otherwise stated: (1) official or unofficial transcripts are acceptable, or (2) you may submit a list with all of your courses, grades, semester, year, and credit for the course. All materials must be submitted by the closing date of the announcement.
PASS/FAIL COURSES: If more than 10 percent of your undergraduate course work (credit hours) were taken on a pass/fail basis, your claim of superior academic achievement must be based upon class standing or membership in an honor society.
GRADUATE EDUCATION: One academic year of graduate education is considered to be the number of credits hours your graduate school has determined to represent one academic year of full-time study. Such study may have been performed on a full-time or part-time basis. If you cannot obtain your graduate school's definition of one year of graduate study, 18 semester hours (or 27 quarter hours) should be considered as satisfying the requirement for one year of full-time graduate study.
FOREIGN EDUCATION: 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: http://www.ed.gov/about/offices/list/ous/international/usnei/us/edlite-visitus-forrecog.html

Additional information

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 CompetencyBased 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. (https://appsupport.usastaffing.gov/hc/en-us/sections/28980686389652-Reasonable-Accommodation-Information)

If you are an eligible Career Transition Assistance Program (CTAP) or Interagency Career Transition Assistance Program (ICTAP) applicant, you may apply for special selection over other applicants for this position. Individuals who have special priority selection rights under the CTAP or ICTAP must be well qualified for the position. To be well qualified, applicants must satisfy all qualification requirements for the vacant position and meet the mid-level (scoring between 85 and 89) of the rating criteria for all factors or the established cutoff score. CTAP/ICTAP eligibles must submit one of the following as proof of eligibility for the special selection priority: a separation notice; a "Notice of Personnel Action" (SF-50) documenting separation; an agency certification that you cannot be placed after injury compensation has been terminated; an OPM notification that your disability annuity has been terminated; OR a Military Department or National Guard Bureau notification that you are retired under 5 U.S.C. 8337(h) or 8456. Additional information about ICTAP and CTAP eligibility is at: http://www.opm.gov/policy-data-oversight/workforce-restructuring/employee-guide-to-career-transition/.

This vacancy announcement may be used to fill future vacancies for identical positions within the next year.

Relocation expenses are not authorized.

Only experience and education obtained by the closing date of this announcement will be considered.

You must meet all qualification requirements within 30 days after the closing date of this announcement and before placement in the position.

CSOSA is an Equal Opportunity Employer.

If you are currently, or have been within the last 5 years, a political Schedule A, Schedule C, Non-career SES or Presidential Appointee employee in the Executive Branch, you must disclose this information to the Human Resources Office.

Position is Mission Essential and is not subject to administrative dismissal in emergencies based on inclement weather conditions, or other emergency situations, as appropriate. A Mission Essential employee is required to report for, or remain at, work in emergency situations; dismissal or closure announcements do not apply to him/her unless his/her supervisor instructs otherwise.

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.

How you will be evaluated

You will be evaluated for this job based on how well you meet the qualifications above.

Once the announcement has closed, a review of your résumé and supporting documentation will be used to determine whether you meet the qualification requirements listed on this announcement. If you are minimally qualified, your résumé and supporting documentation will be compared against your responses to the assessment questionnaire to determine your level of experience. If, after reviewing your résumé and/or supporting documentation, a determination is made that you have inflated your qualifications and/or experience, you may lose consideration for this position. Please follow all instructions carefully when applying, errors or omissions may affect your eligibility.

You will be assessed on the following competencies (knowledge, skills, abilities, and other characteristics):

Accountability
Attention to Detail
Customer Service
Decision Making
Flexibility
Influencing/Negotiating
Integrity/Honesty
Interpersonal Skills
Learning
Reading Comprehension
Reasoning
Self-Management
Stress Tolerance
Teamwork

The USA Hire Assessments 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.

To be considered for this position, you must complete all required steps in the process. In addition to the application and application questionnaire, this position requires an online assessment. The online assessment measures critical general competencies required to perform the job.

Overstating your qualifications and/or experience in your application materials or application questionnaire may result in your removal from consideration. Cheating on the online assessment may also result in your removal from consideration.

Help

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 submit all 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. 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 resources at https://support-usahire.opm.gov/hc/en-us.

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. If utilizing the "Locking Assessment Responses" functionality, substitute this paragraph with the recommended text found in Appendix E.

To view the announcement status or your application status: Visit https://www.usajobs.gov/Help/howto/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.

Agency contact information

Dwayne Jenkins

Phone: 202 220-5449
Email: dwayne.jenkins@csosa.gov

Address: CSOSA
800 North Capitol Street NW Suite 700
Washington DC, DC 20002
US

Next steps

Based on your application and your responses to the application questionnaire, you may be presented with instructions on how to access the USA Hire system to complete the online assessments. The online assessments must be completed within 48 hours following the close of this announcement. You will have the opportunity to request a testing accommodation for the assessment should you have a disability covered under the Rehabilitation Act of 1973 as amended.

Your assessment results will be kept on record for one year and used toward future positions for which you might apply that require the same assessments.

To be considered for the position, you must meet all qualifications, including meeting or exceeding the cut score on the required assessments.

Required Documents

Help

You must submit a complete Application Package which includes:
-Your responses to the Online Occupational Questionnaire (This is completed automatically during the apply online process).
To apply for this position,
- Your resume' showing work schedule, hours worked per week, dates of employment and duties performed.
- Other supporting documents:
- Cover Letter, optional
- College transcript(s), if qualifying based on education
- Most recent SF-50, "Notification of Personnel Action" showing you are/were in the competitive service and the highest grade or promotion potential held (if applying as a status candidate with current or former Federal Service)
- DD-214, SF-15 Form and VA letter, or certification of expected discharge or release from active duty from Veterans for consideration under Veteran hiring authorities. https://www.usajobs.gov/Veterans.
- Noncompetitive appointment authority documentation, if applicable
- Career Transition Assistance Program/Interagency Career Transition Assistance Program Documentation, if applicable (e.g. Certification of Expected Separation, Reduction-In-Force Separation Notice, or Notice of Proposed Removal; SF-50 that documents the RIF separation action; and most recent performance appraisal.)
If you fail to provide these documents, you will be marked as having an incomplete application package and will not be considered any further.

How to Apply

Help

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 submit all 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. 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 resources at https://support-usahire.opm.gov/hc/en-us.

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. If utilizing the "Locking Assessment Responses" functionality, substitute this paragraph with the recommended text found in Appendix E.

To view the announcement status or your application status: Visit https://www.usajobs.gov/Help/howto/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.

Agency contact information

Dwayne Jenkins

Phone: 202 220-5449
Email: dwayne.jenkins@csosa.gov

Address: CSOSA
800 North Capitol Street NW Suite 700
Washington DC, DC 20002
US

Next steps

Based on your application and your responses to the application questionnaire, you may be presented with instructions on how to access the USA Hire system to complete the online assessments. The online assessments must be completed within 48 hours following the close of this announcement. You will have the opportunity to request a testing accommodation for the assessment should you have a disability covered under the Rehabilitation Act of 1973 as amended.

Your assessment results will be kept on record for one year and used toward future positions for which you might apply that require the same assessments.

To be considered for the position, you must meet all qualifications, including meeting or exceeding the cut score on the required assessments.