Senior SAS Application Solution Developer
FedTec is seeking a Senior SAS Application Solution Developer to provide senior-level SAS development support. The roles primary focus is migrating legacy COBOL programs to modern SAS code and SAS Data Integration (DI) jobs and modernizing and automating publication processes for the Annual Statistical Supplement SSI OASDI Earnings Geographic and Representative-Payee publications across the SAS Data Analytics Platform (DAP) including the SAS Analytics Research Center (ARC) and supporting Mainframe and AWS environments.
Location: Baltimore MD
Required Responsibilities:
- Lead COBOL-to-SAS migration activities including reading and interpreting legacy COBOL programs and converting them to modern SAS code and SAS Data Integration (DI) jobs
- Convert legacy COBOL programs used in the Continuous Work History Sample (CWHS) process to SAS DI jobs and develop SAS DI jobs to generate 10% CWHS files and 100% High Earners files.
- Provide senior-level SAS application development support to SSAs RAPA division for statistical publication modernization and expansion.
- Update upgrade test and migrate existing publication automated code to the most current version of the SAS/ARC software.
- Modernize and automate publication processes for the Annual Statistical Supplement including cross-program tables Highlights and Trends Insured Status Provisions Benefit Computation and Automatic Adjustments tables Benefit Types and Levels Effect of Current Earnings and Taxation of Benefits and the SSI Federal Benefit Rates table.
- Maintain Supplemental Security Income (SSI) publications Earnings Master Geography and Demographic (MGD) file Earnings Publication OASDI publications Geographic publications and Representative-Payee automated publication processes.
- Update SSI Monthly and Yearly statistical table inputs from SSR datasets to concurrent datasets.
- Update SAS DI baseline data from Reference Tax Year (RTY) 2017 to RTY 2023 across the 21 earnings publication tables included in the Annual Statistical Supplement.
- Update RTY 2023 SAS Enterprise Guide projects to incorporate the Master Geographic Demographic (MGD) SAS datasets into the annual earnings publication process.
- Enhance the MGD methodology to assign all taxpayers a State and County code and develop algorithms to add taxpayers with wage forms processed in subsequent processing years.
- Validate that SAS Enterprise Data Integration Studio (DI) jobs migrated from the integration environment to the production environment including SharePoint and Executive Order zMFA updates run successfully end-to-end.
- Translate business requirements into functional and technical requirements then into SAS code ETL workflows and automated production jobs.
- Lead full lifecycle development activities including requirements analysis solution design systems architecture technical walkthroughs validation planning system testing deployment and post-implementation support.
- Develop and maintain technical and user documentation operational run books and training materials and present project status and outcomes to SSA stakeholders.
- Collaborate with RAPA staff and the RAPA modernization team on ongoing publication production and ad hoc research projects requiring SAS data extracts and statistics.
Mandatory Requirements:
- Bachelors degree in Computer Science Information Systems Statistics Mathematics or related technical field; Associates degree with 7 years of relevant experience may substitute for the bachelors degree requirement.
- Minimum 7 years of relevant experience in SAS application development ETL workflow design or statistical data production.
- Demonstrated proficiency in COBOL-to-SAS migration including reading interpreting and converting legacy COBOL programs into modern SAS code and SAS DI jobs (required).
- Proven experience with publication automation using SAS DI in a federal or large enterprise environment.
- Demonstrated proficiency in statistical and data analysis using SAS tools deployed on the SSA Analytics Research Center (ARC) Platform.
- Hands-on experience with SAS Enterprise Guide 8.x and SAS Enterprise Data Integration (EDI) Studio (required).
- Experience using SAS EDI Studio to develop test and maintain ETL workflows.
- Experience translating business requirements into technical requirements and SAS code (required).
- Expert-level use of SQL and demonstrated experience with relational databases including DB2.
- Proven experience designing and developing functional applications and systems of high technical complexity.
- Experience across the full software development lifecycle including business requirements gathering functional and detailed requirements analysis solution design systems architecture validation planning and system testing.
- Experience proposing system changes to management users and technical teams and presenting work and project outcomes to stakeholders.
- Experience with project planning management and reporting using standard planning tools.
- Strong technical and user documentation skills including the ability to develop operational run books training materials and user guides.
- Knowledge of SSA administrative master files including the Supplemental Security Record (SSR) Numident Master Earnings File (MEF) and Master Beneficiary Record (MBR) / Payment History Update System (PHUS) is highly desired.
- Excellent written and verbal communication skills including effective technical writing.
- Proactive self-starter with the ability to manage multiple concurrent projects and meet deadlines.
- Ability to work confidently with technical teams analysts and Government stakeholders at all levels of the organization.
- Must be able to obtain and maintain a Public Trust
When You Join FedTec You Are Joining a Family! We take pride in our work and the true and transparent relationships we build with our employees and partners. Just as you would do for your own family we prioritize your safety health and happiness. That is why weve created the FedTec Total Well-Being program offering benefits like:
- Health & Wellness: Medical dental and vision plans with valuable features like Telehealth virtual care and resources to support your physical and mental well-being.
- Time to Recharge: Generous paid time off to relax and rejuvenate.
- Financial Security: 401(k) company-paid short- and long-term disability life insurance and additional voluntary coverage.
- Life & Family Support: Employee Assistance Program (EAP) Pet Insurance and Prepaid Legal services.
- Recognition & Growth: The FedTec Applause program rewards outstanding contributions while our Learning & Development programs support your career growth.
- Fitness & Wellness: The FedTec Fit Program includes an on-staff Fitness Coach personal and group training sessions company fitness challenges and ongoing wellness support.
Visit to learn more about who we are and where you can make an impact!
Commitment to Non-Discrimination
As an Equal Opportunity Employer we consider all qualified applicants without regard to disability protected veteran status or any other status protected by law. We are committed to a fair and inclusive workplace where advancement is based on merit skills and contributions.
If you feel that your qualifications talents and values align with our culture we welcome you to apply by submitting your resume today!
No Agencies Please
Senior SAS Application Solution Developer FedTec is seeking a Senior SAS Application Solution Developer to provide senior-level SAS development support. The roles primary focus is migrating legacy COBOL programs to modern SAS code and SAS Data Integration (DI) jobs and modernizing and automating ...
Senior SAS Application Solution Developer
FedTec is seeking a Senior SAS Application Solution Developer to provide senior-level SAS development support. The roles primary focus is migrating legacy COBOL programs to modern SAS code and SAS Data Integration (DI) jobs and modernizing and automating publication processes for the Annual Statistical Supplement SSI OASDI Earnings Geographic and Representative-Payee publications across the SAS Data Analytics Platform (DAP) including the SAS Analytics Research Center (ARC) and supporting Mainframe and AWS environments.
Location: Baltimore MD
Required Responsibilities:
- Lead COBOL-to-SAS migration activities including reading and interpreting legacy COBOL programs and converting them to modern SAS code and SAS Data Integration (DI) jobs
- Convert legacy COBOL programs used in the Continuous Work History Sample (CWHS) process to SAS DI jobs and develop SAS DI jobs to generate 10% CWHS files and 100% High Earners files.
- Provide senior-level SAS application development support to SSAs RAPA division for statistical publication modernization and expansion.
- Update upgrade test and migrate existing publication automated code to the most current version of the SAS/ARC software.
- Modernize and automate publication processes for the Annual Statistical Supplement including cross-program tables Highlights and Trends Insured Status Provisions Benefit Computation and Automatic Adjustments tables Benefit Types and Levels Effect of Current Earnings and Taxation of Benefits and the SSI Federal Benefit Rates table.
- Maintain Supplemental Security Income (SSI) publications Earnings Master Geography and Demographic (MGD) file Earnings Publication OASDI publications Geographic publications and Representative-Payee automated publication processes.
- Update SSI Monthly and Yearly statistical table inputs from SSR datasets to concurrent datasets.
- Update SAS DI baseline data from Reference Tax Year (RTY) 2017 to RTY 2023 across the 21 earnings publication tables included in the Annual Statistical Supplement.
- Update RTY 2023 SAS Enterprise Guide projects to incorporate the Master Geographic Demographic (MGD) SAS datasets into the annual earnings publication process.
- Enhance the MGD methodology to assign all taxpayers a State and County code and develop algorithms to add taxpayers with wage forms processed in subsequent processing years.
- Validate that SAS Enterprise Data Integration Studio (DI) jobs migrated from the integration environment to the production environment including SharePoint and Executive Order zMFA updates run successfully end-to-end.
- Translate business requirements into functional and technical requirements then into SAS code ETL workflows and automated production jobs.
- Lead full lifecycle development activities including requirements analysis solution design systems architecture technical walkthroughs validation planning system testing deployment and post-implementation support.
- Develop and maintain technical and user documentation operational run books and training materials and present project status and outcomes to SSA stakeholders.
- Collaborate with RAPA staff and the RAPA modernization team on ongoing publication production and ad hoc research projects requiring SAS data extracts and statistics.
Mandatory Requirements:
- Bachelors degree in Computer Science Information Systems Statistics Mathematics or related technical field; Associates degree with 7 years of relevant experience may substitute for the bachelors degree requirement.
- Minimum 7 years of relevant experience in SAS application development ETL workflow design or statistical data production.
- Demonstrated proficiency in COBOL-to-SAS migration including reading interpreting and converting legacy COBOL programs into modern SAS code and SAS DI jobs (required).
- Proven experience with publication automation using SAS DI in a federal or large enterprise environment.
- Demonstrated proficiency in statistical and data analysis using SAS tools deployed on the SSA Analytics Research Center (ARC) Platform.
- Hands-on experience with SAS Enterprise Guide 8.x and SAS Enterprise Data Integration (EDI) Studio (required).
- Experience using SAS EDI Studio to develop test and maintain ETL workflows.
- Experience translating business requirements into technical requirements and SAS code (required).
- Expert-level use of SQL and demonstrated experience with relational databases including DB2.
- Proven experience designing and developing functional applications and systems of high technical complexity.
- Experience across the full software development lifecycle including business requirements gathering functional and detailed requirements analysis solution design systems architecture validation planning and system testing.
- Experience proposing system changes to management users and technical teams and presenting work and project outcomes to stakeholders.
- Experience with project planning management and reporting using standard planning tools.
- Strong technical and user documentation skills including the ability to develop operational run books training materials and user guides.
- Knowledge of SSA administrative master files including the Supplemental Security Record (SSR) Numident Master Earnings File (MEF) and Master Beneficiary Record (MBR) / Payment History Update System (PHUS) is highly desired.
- Excellent written and verbal communication skills including effective technical writing.
- Proactive self-starter with the ability to manage multiple concurrent projects and meet deadlines.
- Ability to work confidently with technical teams analysts and Government stakeholders at all levels of the organization.
- Must be able to obtain and maintain a Public Trust
When You Join FedTec You Are Joining a Family! We take pride in our work and the true and transparent relationships we build with our employees and partners. Just as you would do for your own family we prioritize your safety health and happiness. That is why weve created the FedTec Total Well-Being program offering benefits like:
- Health & Wellness: Medical dental and vision plans with valuable features like Telehealth virtual care and resources to support your physical and mental well-being.
- Time to Recharge: Generous paid time off to relax and rejuvenate.
- Financial Security: 401(k) company-paid short- and long-term disability life insurance and additional voluntary coverage.
- Life & Family Support: Employee Assistance Program (EAP) Pet Insurance and Prepaid Legal services.
- Recognition & Growth: The FedTec Applause program rewards outstanding contributions while our Learning & Development programs support your career growth.
- Fitness & Wellness: The FedTec Fit Program includes an on-staff Fitness Coach personal and group training sessions company fitness challenges and ongoing wellness support.
Visit to learn more about who we are and where you can make an impact!
Commitment to Non-Discrimination
As an Equal Opportunity Employer we consider all qualified applicants without regard to disability protected veteran status or any other status protected by law. We are committed to a fair and inclusive workplace where advancement is based on merit skills and contributions.
If you feel that your qualifications talents and values align with our culture we welcome you to apply by submitting your resume today!
No Agencies Please
View more
View less