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 (BEA) in Suitland, MD, seeks an IT Specialist (Applications Software) in the Office of the Chief Information Officer. The role focuses on building and maintaining data software for federal analytics, leveraging SQL Server, T-SQL, ETL processes, and DevSecOps practices.

You will collaborate with cross-functional teams to design, deploy, and maintain database solutions, ensure data quality, and support mission-critical reporting with robust version control and data

Qualifications

• Experience with SQL Server database objects and T-SQL programming.
• Experience with data pipelines, ETL, and data formats JSON/XML/CSV.
• Familiarity with agile and DevSecOps methodologies.

Skills

SQL Server

T-SQL

ETL processes

DevSecOps

Education

Ph.D. or equivalent doctoral degree

Tools

SSMS

ERWIN Data Modeler

Visual Studio Code

Git

JSON

XML

CSV

Job description

This vacancy is for a IT Specialist (Applications Software) position in the Office of the Chief Information Officer located at the Bureau of Economic Analysis.

This Job Opportunity Announcement may be used to fill other IT Specialist (Applications Software), ZP-2210-3 positions within the Bureau of Economic Analysis in the same geographical location with the same qualifications and specialized experience.

EXPERIENCE

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.

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

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

Specialized Experience

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

After you submit this application, you will receive an e-mail informing you that a USA Hire assessment is required. You will have 48 hours from the closing date of this announcement, 11/06/2026, to complete the assessment as this assessment is part of your application.