Duties

Summary

This position is open until filled. The first cut-off date for review of applications will be Tuesday, July 21st, 2020.

The incumbent reports to the Information Systems Manager in the Office of Administration and is responsible for performing a variety of programming and integration activities.
Learn more about this agency

Responsibilities

The key responsibilities of the Software Engineer/Architect are to:

• Design and implement ETL processes using Oracle Data Integrator (ODI)
• Install, migrate and upgrade Oracle Data Integrator (ODI) versions in different working environments
• Maintain and enhance Data Warehouse data models using dimensional data modeling, star/snowflake schemas, fact and dimension tables.
• Manage the Oracle Business Intelligence Enterprise Edition (OBIEE)/Oracle Analytics Server (OAS) repositories (RPD).
• Develop Business Intelligence (BI) reports in different subject areas and upgrade existing reports.
• Develop and maintain code using Oracle PL/SQL.
• Perform additional duties as assigned.

Travel Required

Not required

Supervisory status
No

Promotion Potential
14

Requirements

Conditions of Employment

Qualifications

MANDATORY QUALIFICATION REQUIREMENTS
Applicants must have an undergraduate degree from an accredited university or college in Information Technology, Engineering or a related field of study. Applicants must have four (4) years of demonstrated experience utilizing the technical skills listed below.

One (1) year of specialized work experience equivalent to the previous level in the federal service is required. For example, one (1) year of specialized experience at the GS-11 level is required to qualify for appointment at the GS-12 level. Specialized experience is defined as progressively responsible work experience that has equipped the applicant with the particular knowledge, skills, and abilities that will enable the individual to successfully perform the duties of this position, and that is typically in or related to the work of this position.

Applicants must have a strong technical aptitude, interpersonal, oral and written communication skills. Applicants must also have the ability to multi-task and must be able to work alone and in a team setting.

TECHNICAL SKILL REQUIREMENTS

• Strong ETL / ELT development experience with Oracle Data Integrator (preferably version 12).
• Experience with Dimensional Data modeling.
• Extensive expertise in OBIEE/OAS Repository Admin Tool.
• Strong Oracle database knowledge.
• Strong SQL and PL/SQL skills including complex query building and query performance tuning.
• Experience in creating Business Intelligence (BI) reports in different subject areas and upgrading of the existing reports.
• Experience with creating Oracle BI (Business Intelligence) Publisher reports and integrating with OBIEE.

Highly competitive applicants will have:

• Experience with Oracle Analytic Server including Data Visualization.
• Oracle Fusion Middleware High Availability Architecture/Infrastructure knowledge.
• Knowledge of Oracle Jet (JavaScript Extension Toolkit) charts.
• Knowledge and/or experience of cloud environments.

PREFERRED QUALIFICATIONS
Preference will be given to applicants with one or more of the following areas of experience:

• Advanced degree from an accredited university or college in a relevant field of study.
• Strong analytical, troubleshooting, and problem resolution skills.
• Experience in obtaining and understanding business requirements.

Education

Applicants must have an undergraduate degree from an accredited university or college in Information Technology, Engineering or a related field of study.

Additional information

• This position is in the excepted service and does not carry the tenure rights of positions in the competitive Civil Service.
• All information is subject to verification. Applicants are advised that false answers or omissions of information on application materials or inability to meet the following conditions may be grounds for non-selection, withdrawal of an offer of employment, or dismissal after being employed.
• Selection for this position is contingent upon completion of OF-306, Declaration for Federal Employment during the pre-employment process and proof of U.S. citizenship or, for noncitizens, proof of authorization to work in the United States and proof of entitlement to receive compensation. Additional information on the employment of non-citizens can be found at: https://help.usajobs.gov/index.php/Employment_of_Non-citizens . For a list of documents that may be used to provide proof of citizenship or authorization to work in the United States, please refer to http://www.uscis.gov/files/form/i-9.pdf .
• A background security investigation is required for all selectees. Appointment will be subject to a selectee's successful completion of a background security investigation and favorable adjudication. Failure to successfully meet these requirements may be grounds for appropriate personnel action. A background security reinvestigation or supplemental investigation may be required at a later time.
• All new Commission employees must identify a financial institution for direct deposit of pay before appointment, mandated by the Federal Compensation Act.
• All new Commission employees, those converted from a temporary appointment to a permanent appointment, and all rehired former Commission employees are required to serve a one-year probationary period. The probationary period begins on the effective date of the employee's appointment, conversion, or rehire.
• Applicant must relocate to the Washington DC Metropolitan area.

How You Will Be Evaluated

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

The Commission evaluates applicants through a structured interview. Applicants may also be screened for some jobs through a narrative/application review, and/or a preliminary telephone interview. Applicants may be required to take a skills assessment test. Applicants who do not address the qualification requirements (mandatory and preferred) in his or her application materials as stated in the vacancy announcement are automatically disqualified from consideration and must re-apply before the closing date to be considered for employment.

The Office of Human Resources: (1) reviews the applicant's application to ensure the proper materials are submitted, (2) ensures that the application addresses all of the qualification requirements (mandatory and preferred) as stated in the vacancy announcement; and, (3) determines whether the applicant meets the qualification requirements for the particular position and notifies the applicant about the status of his or her application. Applicants who meet the mandatory qualification requirements will be considered and their application materials will be forwarded to the screening panel for review. Applicants who do not meet the mandatory qualification requirements for the position are automatically disqualified from consideration. In addition, some applicants may be tested using various assessment tools not listed on the vacancy announcement to verify an applicant's experience, knowledge, and training directly related to the job in order to identify the best qualified applicants for consideration and selection.

Background checks and security clearance

Security clearance
Other

Drug test required
No

Required Documents

Cover Letter
Resume

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.