SUMMARY

Provide support to the U.S. Census Bureau's Demographic Systems Division (DSD) by offering Python development services in support of DSD’s migration of survey processing systems from Statistical Analysis System (SAS) to Python.

 

ESSENTIAL DUTIES & RESPONSIBILITIES

Assist with the development and documentation of the rewrite of The Survey of Income and Program Participation (SIPP) production processing system into a Python codebase. The scope of the SIPP Production processing consists of 200+ edit programs. (Revamp SIPP system, named SIPP Seamless, is currently in its planning phase). Support the ongoing SIPP production system and the SIPP Seamless system. Assist DSD with the implementation of Python code solutions using efficient methodologies to utilize the language’s strengths. Assist DSD in analyzing existing SAS-based system to glean functional requirements to develop optimized, Python-based solutions. Write high quality code that is well-documented and easy to read, use, and maintain. Use Python to read and reformat large datasets. Improve Python code performance. Attend branch meetings and share technical knowledge clearly. Work with customers and subject matter experts to capture and document business needs and processes through meetings and requirements gathering. Make recommendations concerning the feasibility of revising existing applications or developing new approaches to utilize resources more effectively. Troubleshoot issues as needed and work with appropriate resources to resolve problems. Assist DSD with developing proof-in-concepts, pilots, and alternatives analysis. Provide thorough documentation based on Census Bureau and/or DSD standards. Documentation includes but is not limited to formal specifications and/or systems logical diagrams, training, and in-code documentation. Participate in code and peer reviews, as well as formal walkthroughs as directed. Conduct formal presentations and provide written documents outlining any issues and concerns to Census Management. Utilize DSD version control system regularly to ensure all developed code is readily available to Census staff. Review the existing software systems and make recommendations to improve the design. Provide weekly and/or daily status reports in requested format to tasks manager or as directed. Work with and train designated Census Bureau IT specialists to ensure that the system is fully understood by those designated individuals responsible for maintaining the system once released to production. Maintain regular communications with team as required. Complete tasks using, but not limited to, technologies such as: Python related packages, tools, and products such as NumPy, Pandas, Anaconda, Jupyter Notebook, and VS code SAS Software such as Advanced Base SAS, SAS Macro Language, and SAS ODS software PostgreSQL Databases and related languages, tools, and products such as pgAdmin, and PL/pgSQL Version control software such as Git, GitLab or GitHub Linux terminal or other tools to allow for executing from the command line Microsoft suite including Word, Excel, PowerPoint, SharePoint, and Teams The following deliverables are required: Finalized Python modules and code for performing identified, demographic edits for the SIPP survey ISPB Python Programming Standards and Guidelines document Regular status reports Presentation and training material Evaluation and recommendation for database implementation Python code stored a version control software, such as SVN or GitLab Maintain regular and punctual attendance. Perform other duties as assigned.

 

SUPERVISORY RESPONSIBILITIES

None.