Data Solutions Developer-DHA

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

Benefits offered by this job

Health benefits

Retirement plan

Work-life balance

Job summary

A government agency in Woodlawn, Maryland is seeking an IT Specialist (Data Solutions Developer) to provide technical leadership in building complex ETL solutions and database architectures. The ideal candidate will have strong expertise in SQL, PostgreSQL, and related IT technologies, with a passion for improving data-driven decision-making within the agency. This role emphasizes attention to detail and problem-solving skills in a mission-driven environment, making a significant impact on the agency's operations and services for the public.

Qualifications

• Must have a minimum of one year of specialized experience related to IT.
• Experience in ETL solutions and database architectures is necessary.
• Must be proficient in handling Management Information and Business Intelligence applications.

Responsibilities

• Develop and maintain ETL solutions for complex data environments.
• Provide technical leadership in database architecture.
• Communicate data-driven findings to technical and non-technical stakeholders.

Skills

Attention to detail

Customer service

Oral communication

Problem solving

Proficiency in SQL

Linux shell scripting

Education

Relevant IT experience

Tools

SQL Server

PostgreSQL (Greenplum)

Ab Initio

Job description

Summary

IT Specialist (APPSW) Data Solutions Developer position(s) 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. Applications may be gathered from additional recruitment sources. These will be added to the pool created by this announcement.

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.
• Applicants must qualify for the series and grade of the posted position.
• 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.
• Your resume must provide sufficient experience and/or education, knowledge, skills, abilities, and proficiency of any required competencies to perform the specific position for which you are applying.
• To qualify for the 2210 IT Specialist series, the applicant must demonstrate the following competencies:
• 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; 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.
• Applicants for the GS‑13 position must have at least 52 weeks of specialized experience at the GS‑12 level, or equivalent, which is in or related to the work of the position to be filled, that has equipped the applicant with the particular knowledge, skills, and abilities to successfully perform the duties of the position.
• Such IT‑related experience must include: contributing to the design, development, testing, and support of Management Information (MI) and Business Intelligence (BI) applications and data environments.
• Developing and maintaining ETL solutions and database architectures using technologies such as SQL, PL/pgSQL, PostgreSQL (Greenplum), SQL Server, DB2, Oracle, Ab Initio, Linux shell scripting, Crontab, and mainframe JCL.
• Supporting the implementation and maintenance of WebFOCUS reporting solutions.
• Communicating Business Intelligence concepts to technical and non‑technical audiences.
• Qualified experience includes proficiency in SQL, PL/pgSQL, PostgreSQL (Greenplum), SQL Server, DB2, Oracle, Ab Initio, Linux shell scripting, Crontab, mainframe JCL, and experience supporting Management Information and Business Intelligence applications and data environments.

Additional Information

See announcement cutoff dates below under How to Apply. 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. Applications may be gathered from additional recruitment sources.

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 ETL solutions and database architectures using a diverse set of technologies where your expertise will help ensure the reliability, scalability, and efficiency of our data environments. We value professionals who excel at developing and maintaining complex data solutions 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. 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!

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. This is a bargaining unit position represented by the American Federation of Government Employees.

Selective Service: If you are a male applicant born after December 31, 1959, you must certify that you have registered with the Selective Service System, or are exempt from having to do so under the Selective Service Law. See www.sss.gov.

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.

Do you have a desire to: help SSA manage its Social Security programs? 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 SSA, one of the Best Places to Work in the Federal Government!