IT Specialist (Applications Software).

Bureau of Economic Analysis; Suitland (MD); On-site; USD 70,000 - 100,000; Full time

Job summary

The Bureau of Economic Analysis in Suitland, MD seeks a skilled IT professional to lead database development, modernization, and maintenance across BEA systems. You will work on SQL Server databases, data pipelines, and ETL processes to support statistics and dissemination.

As part of the software lifecycle, you will perform analysis, design, development, testing, implementation, and operations tasks, collaborating with teams to implement standardized database structures and improve data quality.

Qualifications

• IT-related experience required; may be paid or volunteer.
• Experience with SQL Server and ETL workflows.
• Familiarity with DevSecOps and Agile methodologies.

Responsibilities

• Engage in database development, modernization, and maintenance across BEA systems.
• Execute all phases of the BEA Software Development Life Cycle (SDLC).
• Identify common database structures across BEA applications and systems.

Skills

Attention to Detail

Customer Service

Oral Communication

Problem Solving

Education

Graduate education toward PhD

Tools

SQL Server

ERWIN Data Modeler

SSMS

Visual Studio Code

Git

JSON/XML/CSV

Job description

Duties

• Engage in database-related development, modernization, and enhancement (DME) and operational and maintenance activities associated with BEA’s statistical, collection and dissemination, and business support statistical systems.
• Execute all phases of the BEA Software Development Life Cycle, including business analysis/requirements gathering, design/documentation, development, testing, implementation, and operation and maintenance.
• Identify and assist in the implementation of common database structures and techniques across BEA’s database-driven applications and systems, where appropriate.

Requirements

Conditions of employment

• Applicants must meet all qualification requirements by the closing date of this announcement.
• U.S. Citizen
• Suitable for Federal employment.
• Registered for Selective Service if applicable. (www.sss.gov)
• A one-year probationary period may be required.
• Relocation expenses may not be paid.
• This is a NON-BARGAINING unit position.

Qualifications

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.

Experience

• 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; is committed to providing quality products and services.
• 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.
• Problem Solving - Identifies problems; determines accuracy and relevance of information; uses sound judgment to generate and evaluate alternatives, and to make recommendations.

Specialized Experience

For the Band 3 (GS-11) you must have one year of experience at a level of difficulty and responsibility equivalent to the Band 2 (GS-9) in the Federal service. Experience for this position includes: working with Microsoft SQL Server Database Management System; building and maintaining database objects such as tables, views, schemas, synonyms, stored procedures, user defined functions using the Transact Structured Query Language (T‑SQL) programming language; executing database normalization activities; experience with SQL graph data structures; working with data pipelines to support batch data processing and Extract, Transform, and Load (ETL) activities; working with agile software development and Development, Security, and Operations (DevSecOps) methodologies; using software tools such as SQL Server Management Studio, ERWIN Data Modeler, and Visual Studio Code; experience with software version control systems Git; experience with data formats such as JSON, XML, and CSV.

OR

Education

• 3 years of progressively higher-level graduate education leading to a Ph.D. degree or Ph.D. or equivalent doctoral degree.

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.

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

The Department of Commerce also provides reasonable accommodations to applicants with disabilities. If you need a reasonable accommodation for any part of the application and hiring process, please notify the Human Resources Office. The decision on granting reasonable accommodation will be on a case-by-case basis. TTY users can contact the Human Resources Office via the Federal Relay Service, 1-800-877-8339.

Benefits

• 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.
• 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.

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.