Who may apply: The Public Position located in: Info & Tech Dir Office, Payroll Services, DMO/ DMR & Uniques, DMO/DMR Data - ZTBCC Applicants on Cleveland list may be considered for positions in Bratenahl. The duty station of these positions will be assigned at the time of a job offer, and pay will be set in accordance with the duty station. Any on-site requirements will be determined by the duty station assigned upon selection.

Duties

Prepares system change/programming specifications, and specifies programming instructions, inputs and outputs, structures, and other analytical products to document the functional and technical requirements. Identifies how system modifications or new systems or subsystems affect current systems; prepares cost analysis; establishes target completion dates; and prioritizes proposed system changes or developments. Serves as an ETL (Extract, Transform and Load) developer writing, debugging and maintaining code. Uses Pentaho, Oracle SQL loader, DB2 High performance unload, and Linux shell scripting. Writing queries, stored procedures, triggers and functions using PL/SQL. Participates in systems requirement reviews and coordinates with customer/functional representatives and other technical personnel to clarify requirements.

Requirements

• U.S. Citizenship or National
• Suitable for Federal Employment
• Registered for Selective Service (if applicable)
• This national security position, which may require access to classified information, requires a favorable suitability review and security clearance as a condition of employment. Failure to maintain security eligibility may result in termination.

Qualifications

Resumes for federal government positions need more detailed work descriptions and accomplishments than a typical private sector resume. Please be sure to clearly describe the full scope of your work experiences in your resume. Basic Requirement: Applicants must have IT-related experience demonstrating the following competencies appropriate to, or above, the level of this position. Your resume and work experience should clearly support your ability to meet these competencies and will be evaluated as part of the entire application process. GS-7/9/11 Attention to Detail- experience reviewing my own information technology-related work or data to ensure accuracy, completeness, and consistency with standards. My work or the data that I produce is typically reviewed by my supervisor or another colleague Customer Service- experience having brief contact with customers to provide information about available information technology products and services and providing customers with standard products or routine services to address information technology needs Oral Communication- experience informing my supervisor and other IT staff of the status of information technology systems, projects, or daily operations, including the status of information technology systems, projects, or daily operations, including the communication of basic technical information to a non-technical audience Problem Solving- identifying or selecting from a number of alternatives to address routine information technology-related issues by gathering and applying information from standard sources that provide a limited number of solutions GS-12 Attention to Detail- experience reviewing my own information technology-related work or data and have been asked by others to review their work or data to ensure accuracy, completeness, and consistency with standards Customer Service- experience maintaining relationships with customers, assessing current information technology needs of customers, and developing or identifying information technology products and services that are tailored to meet customer needs Oral Communication- briefing mid-level management and IT staff on the status of information technology systems, projects, or daily operations, including the communication of technical information to a non-technical audience Problem Solving- identifying alternatives to address complex information technology-related issues by gathering and applying information from a variety of sources that provide a number of potential solutions FOR ENTRY AT THE GS-07 LEVEL: In addition to the Basic Competency Requirements listed above: One year of specialized experience equivalent in level of difficulty and responsibility to that of the next lower grade GS-05 in the federal service, which demonstrates the ability to perform the duties of the position, is required. Specialized experience is defined as: Applying basic IT principles and practices to assist in providing software and systems development support; providing input to design specifications, testing plans, and issue resolution of an automated system. FOR ENTRY AT THE GS-09 LEVEL: In addition to the Basic Competency Requirements listed above: One year of specialized experience equivalent in level of difficulty and responsibility to that of the next lower grade GS-07 in the federal service, which demonstrates the ability to perform the duties of the position, is required. Specialized experience is defined as: Assisting senior level programmers in the design, development and maintenance of systems; providing assistance in the design specifications, test plans, and issue resolution of an automated system. FOR ENTRY AT THE GS-11 LEVEL: In addition to the Basic Competency Requirements listed above: One year of specialized experience equivalent in level of difficulty and responsibility to that of the next lower grade GS-09 in the federal service, which demonstrates the ability to perform the duties of the position, is required. Specialized experience is defined as: Providing development, modification and support of an organization's batch processing using ETL tools; with some experience using high level languages such as Standard Query Language (SQL); and applying information systems concepts and methods sufficient to review proposed new system changes and software designs. FOR ENTRY AT THE GS-12 LEVEL: In addition to the Basic Competency Requirements listed above: One year of specialized experience equivalent in level of difficulty and responsibility to that of the next lower grade GS-11 in the federal service, which demonstrates the ability to perform the duties of the position, is required. Specialized experience is defined as: Providing technical expertise on the development, modification and support of an organization's batch processing using ETL tools; experience using high level languages such as Standard Query Language (SQL); and applying information systems concepts and methods sufficient to review and implement proposed new system changes and software designs. Volunteer Experience: 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 to paid employment. You will receive credit for all qualifying experience, including volunteer experience. You may qualify for consideration if meeting time-in grade, specialized experience, education requirement, 90 days after competitive appointment requirement, and all other qualification requirements within 30 calendar days after the closing date of the announcement, unless otherwise indicated on the announcement.

Education

FOR ENTRY AT THE GS-7 LEVEL:
Substitution of education for experience:
One full year of graduate level education in computer science, engineering, information science, information systems management, mathematics, operations research, statistics, or technology management; OR a bachelor's degree with 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 from an accredited college or university and claim eligibility for superior academic achievement (SAA) based on one of the following: a grade point average of a 3.0 or higher on a 4.0 scale, class standing in the upper third of your graduating class or major subdivision, or membership in a national scholastic honor society.

FOR ENTRY AT THE GS-9 LEVEL:
Substitution of education for experience:
Master's degree or equivalent graduate degree or 2 full years of progressively higher level graduate education leading to a Master's degree or equivalent graduate 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.

FOR ENTRY AT THE GS-11 LEVEL:
Substitution of education for experience:
A qualifying 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.

(You MUST submit transcripts and any other applicable documentation to verify your claim.)

***Combination of education and experience is not applicable for this position***

FOR ENTRY AT THE GS-12 LEVEL:
Education is not substitutable for specialized experience at this grade level.

Contacts

• Address DFAS - INFO AND TECHNOLOGY DIR OFFICE 4800 Mark Center Drive Alexandria, VA 22350 US
• Name: HR Customer Care Center
• Phone: (317) 212-0454
• Email: [email protected]