Salary

$114,684 - $149,091 per year

Duties

Help

As a Senior Data Architect, you will:

• Perform a variety of work involving planning, development, implementation, and administration of systems for the acquisition, storage, and retrieval of data.
• Apply and adapt new and improved approaches to the design, development, and implementation of data mining, data warehousing, and related data storage and retrieval systems.
• Develop guidelines for the application of data modeling practices to the development of data management applications.
• Diagnose and resolve the most complex data management problems and issues.
• Develop logical data models to be translated into workable physical database schema and structures in the database development process. Select modeling methodologies and tools. Generate models that are capable of accommodating new and unanticipated business requirements and processes. Verify model integrity. Maintain and revise existing models.
• Perform a variety of work involving the design, documentation, development, modification, testing, installation, implementation, and support of new or existing applications software.
• Lead a multi-functional development project in software analysis, design, development, and implementation for a new system or major enhancement to an existing system. Draft project plans and identify resource requirements. Ensure customer and management involvement throughout the software development process. Resolve critical issues affecting the configuration of the IT infrastructure. Coordinate the demonstration of new and enhanced applications to customers and management.
• Ensure applications are optimized for state-of-the-art technology and functionality.
• Lead the applications development process to identify and correct weaknesses in critical performance parameters and variances in achieving cost, schedule, and performance goals.

Requirements

Help

Conditions of employment

In accordance with Executive Order 14170, applicants are encouraged to respond to four short, free-response, essay questions in the questionnaire. Answer to these questions is not scored or rated. Your answers will be reviewed by the hiring manager and agency leadership if you are referred for selection consideration.

When you apply you will be asked a series of questions to determine your eligibility for employment and your qualification for this position specifically. You must answer all of these questions completely and truthfully.

Key Requirements:

• You must be a United States Citizen.
• This employer participates in the e-Verify program.
• Males must abide by Selective Service registration requirements.
• You will be required to report in person to the official duty location.

Conditions of Employment:

• Suitable for Federal employment, as determined by a background investigation.
• May be required to successfully complete a probationary period.

Qualifications

BASIC REQUIREMENT: Experience must be IT related; the experience may be demonstrated by paid or unpaid experience and/or completion of specific, intensive training (for example, IT certification), as appropriate.

For all positions individuals must have IT-related experience demonstrating each of the four competencies listed below. The employing agency is responsible for identifying the specific level of proficiency required for each competency at each grade level based on the requirements of the position being filled.

1. Attention to Detail - Is thorough when performing work and conscientious about attending to detail.
2. 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.
3. 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.
4. Problem Solving - Identifies problems; determines accuracy and relevance of information; uses sound judgment to generate and evaluate alternatives, and to make recommendations.

To meet this requirement, you must demonstrate proficiency in each of the four competencies listed above as follows:

GS-13: Advanced - You can perform the actions associated with each of these competencies without assistance. You are recognized within your immediate organization as "a person to ask" when difficult questions arise regarding each of these competencies. Focus is on broad organizational/professional issues; You have consistently provided practical/relevant ideas and perspectives on process or practice improvements which may easily be implemented; You are capable of coaching others in the application of each of these competencies by translating complex nuances relating to each competency into easy to understand terms; You participate in senior level discussions regarding these competencies; You assist in the development of reference and resource materials in these competencies.

SPECIALIZED EXPERIENCE REQUIREMENTS: A qualified candidate's resume must demonstrate at least one year of specialized experience equivalent to the next lower grade level (GS-12) in the Federal service. Specialized experience is defined as experience primarily focused on senior-level data architecture and lead data modeling. This includes 1) leading the design, development, and maintenance of complex logical and physical data models for enterprise data assets, such as data warehouses, data marts, and integration platforms, 2) applying and adapting new and improved architectural approaches and technologies to design and implement enterprise data integration, data warehousing, and data lake solutions, 3) developing and enforcing guidelines for enterprise data modeling practices, ensuring adherence to architectural standards, and planning and architecting major data integration projects, including the migration of existing ETL solutions to new technologies and platforms, and 4) diagnosing and resolving the most complex data management problems and issues, and providing expert technical advice and recommendations regarding data architecture and modeling strategies.

"Experience" refers to paid and unpaid experience. Examples of qualifying unpaid experience may include volunteer work done through National Service programs (such as Peace Corps and AmeriCorps); as well as work for other community-based philanthropic and social organizations. 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: Current Federal employees must meet time-in-grade requirements by the closing date of this announcement to receive consideration.

CTAP/ICTAP candidates: To be considered "well qualified" you must meet all of the requirements as described in this section.

You must meet all qualifications and eligibility requirements by the closing date of this announcement.

Education

There are no specific education requirements or substitution of education for experience for this position.

Additional information

• Under the Employee Referral Bonus program, certain BPA employees may be eligible for a monetary award for referring outside candidates for this difficult-to-fill position. The referring employee must complete the form BPA F 33300.01e and email it to careers@bpa.gov by midnight of the closing date of the job posting.
• This job opportunity announcement may be used to fill additional similar vacancies across DOE.

EEO Policy: USAJOBS Help Center | Equal employment opportunity policy

Reasonable Accommodation Policy: Employees or applicants may request Reasonable Accommodation (RA) for assistance, when applying or competing for a job or performing a job due to their medical condition or to exercise their religious beliefs. If you need reasonable accommodation in the application or selection process, please contact the Staffing Specialist listed on this vacancy announcement. USAJOBS Help Center | Reasonable accommodation policy

Reasonable Accommodation for USAHire: 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 reasonable accommodation in your online application. Requests for Reasonable Accommodations for the USA Hire Competency Based Assessments and appropriate supporting documentation for Reasonable Accommodation must be received prior to starting the USA Hire Competency Based Assessments. Decisions on requests for Reasonable Accommodations 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. 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 Reasonable Accommodation, please review the Procedures for Requesting a Reasonable Accommodation for Online Assessments here.

Veterans Information: USAJOBS Help Center - Veterans

Veterans and persons with disabilities are encouraged to apply.

Telework: https://www.opm.gov/telework/

Selective Service Registration: http://www.sss.gov/ - Who must register: https://www.sss.gov/faq/#who-needs-to-register

Hiring incentives may be authorized for a highly qualified candidate based on budget availability and in accordance with federal regulations.

BPA strives to ensure a safe and positive work environment.

We also understand the importance of work/life balance and offer a variety of programs and policies designed to create more flexible, responsive work environments supportive of commitments to community, home and family members. BPA also supports employees' overall wellness through its Be Well program, which helps employees adopt healthier lifestyles and feel better about their work/life balance. The program supports five key areas of life: career, community, financial, physical and social.

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.

Benefits

Help

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.

Once the announcement closes, we will conduct a review of your application package to verify your eligibility and qualifications. If you are found qualified, your application will move forward to additional phases of the review process.

Minimum Qualifications: Once the application process is complete, the Human Resources Offices or Subject Matter Expert (SME) will review your two-page resume and supporting documentation to determine whether you meet the minimum job qualifications.

Merit Promotion & VEOA Procedures: If you are minimally qualified for this job, you will be assessed and evaluated to determine if you are a best qualified candidate. Federal employees must meet time-in-grade requirements and current employees must have at least a fully successful or equivalent performance rating to receive consideration.

Your qualifications will be evaluated 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

Non-competitive Procedures: If you are applying under a non-competitive or special hiring authority, you will still be required to answer the assessment questions. However, you will not be evaluated against the rating and ranking criteria.

Your resume and supporting documentation will be used to determine if you are minimally qualified for this job. Veterans' Preference will be applied when required by the hiring authority (e.g., VRA, Schedule A).

All qualified non-competitive applicants and the best qualified Merit Promotion and VEOA applicants will be referred to the hiring manager for consideration.

Career Transition Assistance Programs: To receive selection priority for this position, you must: 1) meet the eligibility criteria; and 2) be rated "well-qualified", which is defined as having a score of 85 or better.

You must meet all qualifications and eligibility requirements by the closing date (07/19/2026) of this announcement.

To preview the Assessment Questionnaire, click https://apply.usastaffing.gov/ViewQuestionnaire/13003027.

USAHire: 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.

The USA Hire Assessment includes a cut score. USA Hire cut scores are based on the minimum level of proficiency required to perform the job for a specific series and grade. 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. The cut score is set at a government-wide level and not at the agency or individual vacancy level for USA Hire standard assessments. In accordance with 5 CFR 300.201(a), the U.S. Office of Personnel Management does not release testing and examination materials, scoring criteria including the specific cut score requirements, or other information used solely to determine individual qualifications, so as not to compromise the objectivity of the testing process.

Required Documents

Help

To apply for this position, you MUST provide a complete application package which includes:

• Your two (2) page RESUMEshowing all relevant work experience (paid and unpaid) including: duties performed; full name and address of each employer; start and end dates (month/day/year); work schedule (part-time, full-time, number of hours if intermittent); salary; and any completed education and training (program title, subject area, number of hours completed, and completion date).
• Cover Letter, optional, expressing additional information not covered in your resume.
• Transcripts, if specific educational requirements are indicated in this job announcement. Unofficial transcripts or any report listing institution, course title, credits earned (semester or quarter hour) and final grade is acceptable. It is your responsibility to provide adequate proof that you meet the educational requirements.

Submit one or more of the following to support your eligibility(s) to apply to this job announcement:

• SF-50, "Notification of Personnel Action" (current/former federal employees): Most recent Promotion, Within Rate Increase (WRI/WGI), or Appointment/Conversion SF-50 or Notification of Personnel Action showing you are/were in the competitive service and the highest grade or promotion potential held.
• Veterans: DD-214 Member Copy 4 showing type of discharge/character of service; current active duty members- certification of expected discharge or release from active duty under honorable conditions dated within 120 days; SF-15 Form and related documentation; VA letter. For more information visit the USAJOBS Help Center & OPM CHCOC website for VOW information.
• Individuals with Disabilities: Schedule A letter from a physician, local, state or federal rehabilitation office citing your eligibility under 5 CFR 213.3102 (u). For more information visit the USAJOBS Help Center.
• Certain Military Spouses: Permanent Change of Station (PCS) orders authorizing you to accompany the Military member to the new duty permanent station; OR verification of the member's 100% disability (VA Letter); and/or verification of the member's death while on active duty (DD-1300 and Death Certificate) AND verification of the marriage to the service member (i.e., a marriage license or other legal documentation verifying marriage). For more information visit the USAJOBS Help Center.
• Other non-competitive or special appointing authorities: provide documentation which supports your eligibility.
• 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.) For more information see the OPM Guide to Career Transition.

Failure to submit any of the above mentioned required documents may result in loss of consideration due to an incomplete application package. It is your responsibility to ensure all required documents have been submitted.

If selected for the position you MUST submit: A copy of your most recent performance appraisal/evaluation and incentive awards, you received in the last 5 years. The assigned HR Specialist will verify review this documentation to ensure selectee has at least a satisfactory performance rating before setting the entrance on duty date. If you do not have your most recent performance appraisal/evaluation, you will be asked to submit a statement as to why it is not available.

Salary

$114,684 - $149,091 per year

Read Full Description