Data Solutions Developer

Social Security Administration; Woodlawn (MD); On-site; USD 100,000 - 130,000; Full time

Benefits offered by this job

Recruitment incentive may be authorized

Job summary

A federal agency is seeking experienced IT Specialists to provide technical leadership in maintaining complex data solutions. This role involves building and maintaining ETL solutions and ensuring reliability and scalability of data environments. Qualified candidates should have strong skills in SQL and related technologies, along with a commitment to improving federal operations. Join a mission-driven team to make a significant impact for millions of citizens. This position provides a unique opportunity to leverage technology for social good.

Qualifications

• Experience must be IT related and can be demonstrated by paid or unpaid experience.
• Specialized experience is REQUIRED and must be explicitly documented in your resume.
• Must demonstrate providing technical leadership in design and support of large-scale solutions.

Responsibilities

• Provide technical leadership in design, development, and support of MI and BI applications.
• Build and maintain complex ETL solutions and database architectures.
• Communicate complex BI concepts to technical and non-technical audiences.

Skills

Attention to Detail

Customer Service

Oral Communication

Problem Solving

Tools

SQL

PL/pgSQL

PostgreSQL (Greenplum)

SQL Server

DB2

Oracle

Ab Initio

Linux shell scripting

Crontab

mainframe JCL

Job description

Summary

IT Specialist positions are being filled through the Office of Personnel Management's delegated Direct Hire Authority, open to all U.S. citizens. Selections made under this bulletin will be processed as new appointments to the civil service. Current civil service employees would, therefore, be given new appointments to the civil service. Under the provisions of the Direct Hire Authority, Veterans Preference and the "Rule of Many" do not apply.

Duties

This announcement serves as public notice. Applications submitted will be placed into a pool and will remain on file for selection as positions become available. Vacancies may be filled for up to 6 months after the closing date of this announcement. Applicants may not receive notifications of referral status until the full 6-month eligibility period has elapsed. Positions filled with applications from this pool will be placed into positions where Artificial Intelligence duties occupy the majority of the work performed.

Qualifications

Resumes exceeding two pages in length will not be considered. Please visit the new resume guidance for more information. READ ALL SECTIONS OF THIS ANNOUNCEMENT IN ITS ENTIRETY. THIS INFORMATION IS CRUCIAL TO SUBMITTING A SUCCESSFUL APPLICATION. To qualify for the 2210 IT Specialist series, you must demonstrate the following competencies. Experience must be IT related and may be demonstrated by paid or unpaid experience and/or completion of specific, intensive training (for example, IT certification).

• 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; know about available products and services; and 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.

In addition, to qualify for this GS-14 position you must have at least 52 weeks of specialized experience at or equivalent to the GS-13 level or above, which is in or related to the work of the position to be filled, that has equipped you with the particular knowledge, skills, and abilities to successfully perform the duties of the position. Such experience must primarily consist of:

• Providing technical leadership in the design, development, testing, and support of large‑scale Management Information (MI) and Business Intelligence (BI) applications and data environments.
• Building and maintaining complex ETL solutions and database architectures using a range of technologies such as SQL, PL/pgSQL, PostgreSQL (Greenplum), SQL Server, DB2, Oracle, Ab Initio, Linux shell scripting, Crontab, and mainframe JCL.
• Communicating complex Business Intelligence concepts to technical and non‑technical audiences.

Specialized Experience is REQUIRED and must be explicitly documented/described in your resume or you will be disqualified from further consideration. Qualification standards and additional information for this position can be found in the OPM guidance: http://www.opm.gov/policy-data-oversight/classification-qualifications/general-schedule-qualification-standards/2200/information-technology-it-management-series-2210-alternative-a/

Education

This position does not have an educational requirement. Education cannot be substituted for specialized experience.

Additional Information

See announcement cutoff dates under How to Apply. Are you ready to make a significant impact at the Social Security Administration? We are seeking experienced and innovative IT professionals to join our team as Data Solutions Developers. In this role, you will provide technical leadership in maintaining complex Extract, Transform, Load (ETL) solutions and database architectures using a range of technologies that drive data‑driven decision‑making for one of the nation’s most critical agencies. As a key member of our technology team, you will build and maintain complex data solutions and ensure the reliability, scalability, and efficiency of our data environments. We value professionals who understand how Artificial Intelligence (AI) can be leveraged to optimize MI and BI across the organization. If you thrive in a fast‑paced, mission‑driven environment and are passionate about leveraging technology to optimize business processes, this is the place for you. If you are ready to take your career to the next level and help shape the future of digital government services, join us and make a difference for millions of Americans! Recruitment incentive may be authorized. Additional selections may be made for this vacancy six months from the closing date of this announcement. This Direct Hire announcement may be used to fill the same or similar position in another office.

• If you are a male born after December 31, 1959, you must certify that you have registered with the Selective Service System or are exempt under the Selective Service Law.

As a condition of employment for accepting this position, you may be required to serve a 1‑year probationary period during which we will evaluate your fitness and whether your continued employment advances the public interest. In determining if your employment advances the public interest, we may consider: your performance and conduct; the needs and interests of the agency; whether your continued employment would advance organizational goals of the agency or the Government; and whether your continued employment would advance the efficiency of the Federal service. Upon completion of your probationary period your employment will be terminated unless you receive certification, in writing, that your continued employment advances the public interest. You may be required to file OGE form 450, Confidential Financial Disclosure Report, in accordance with 5 CFR section 2634, subpart i. 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.

Do you have a desire to:

• Help manage Social Security programs and analyze and solve problems?
• Help and advise millions of retired and disabled individuals?
• Work on a team to make a difference in people’s lives and your own?
• Join the Social Security Administration, one of the best places to work in the federal government?