Addx Corporation is committed to delivering the highest quality services and products to our clients. To meet this objective, Addx employs a team of highly skilled, experienced, and knowledgeable professionals certified, licensed, and capable of delivering a wide range of solutions that set a high standard for professional services excellence and help our clients achieve lasting results. We currently have an IMMEDIATE opening for a Senior Computer Programmer located in Alexandria, VA at the US Patent and Trademark Office site.
Key Role/Position Description:
The Computer Programmer shall support the Office of Chief Economist, U.S. Patent & Trademark Office, being detailed virtually full-time to the Center for Economic Studies at the U.S. Census Bureau, providing support for collaborative economic and statistical research activities between the two Agencies.
The Computer Programmer shall support the Center conducting economic research, including basic academic research and research to support the public data user community outside the Census Bureau. The Computer Programmer will engage in various tasks associated with computer programming and database management, including but not limited to:
1. Developing and maintaining new program source code;
2. Modifying/updating/extending existing Fortran/C/C++ source code;
3. Modifying/updating/extending existing SAS source code;
4. Leading algorithm development activities for matching names and addresses;
5. Performing application software development for intricate programs and modeling;
6. Assisting in developing approaches to deal with unusual programming problems, or with novel or undeveloped aspects of using models and large time-series applications;
7. Working independently and often at his/her own initiative to analyzing and refining applications development requirements with Center and among collaborators;
8. Translating systems requirements into applications by planning and designing systems architecture, writing, debugging, and maintaining code;
9. Managing large databases;
10. Creating databases from primary information and by name and address matching of existing databases;
11. Ensuring database validity and testing for integrity;
12. Managing concurrency control; and maintaining database security.
Work will be conducted on a cluster of Linux servers that are remotely located and accessible via computer terminal. Specific tasks include:
1. Matching the Census Bureau’s Business Register and the USPTO’s patent database -- In this task, the Computer Programmer shall link the two databases using name and address matching algorithms for years starting in the late 70’s and up to the most current year available. The Computer Programmer will tap into existing knowledge at the Census Bureau in this regard and will be required to interact with experts in the field. In that capacity the Computer Programmer will be expected to take a proactive leading role in extending and improving existing algorithms either with existing or newly identified software. Deliverables will include assessment of current algorithms, BR-Census linked files (SAS), and a methodology report.
2. Geocoding the Business Register -- In this task, the Computer Programmer shall attach latitude and longitude to establishments in the Business Register (BR) for 1975-2006. The BR is a large dataset; the number of establishments per year to be geocoded ranges from roughly 5 to 9 million. Address information is available for each establishment. The geocoding work will likely, but not certainly, be completed using Python programming in ArcGIS. Deliverables for this component include but are not limited to: the Geocoding plan, BR data files, and the methodology report.
Skill Set / Functional Industry Knowledge
1. Knowledge of relational database theory;
2. Experience using SQL for complex queries in very large datasets, and experience in schema development;
3. Experience with general-purpose programming using high-level programming languages such as Python;
4. Ability to quickly acquire new programming languages and other skills;
5. Ability to work and communicate with researchers and with IT staff;
6. Strong communicator and analytical writer
7. Strong problem-solving ability
Demonstrated experience working in a team environment with software developers and database personnel working with subject matter experts (e.g., Economists) to produce client deliverables. Good communications skills required.
The position is subject to successfully obtaining Census Bureau Special Sworn Status. As such the Computer Programmer will be required to undergo background clearance (Sensitive but Unclassified) and demonstrate suitability to work with Census Bureau Title 13 and Title 26 data.
Additional Keywords or Acronyms:
1. Experience using SQL in the context of a complex legacy database environment
2. Familiarity with current version of Oracle
3. Knowledge of Python version 2
4. Experience providing database support for statistical tasks such as report generation, econometric analysis, or data mining
5. Experience at Census or USPTO
Addx - 2 years ago
Addx Corporation is committed to delivering the highest quality services and products to our clients. To meet this objective, Addx employs a...