Python Developer (SAS), Systems Modernization - REMOTE

Lead the modernization of core data processing systems. Responsible for translating complex legacy SAS logic into robust, high-performance Python solutions. Build and maintain scalable data pipelines that handle large-scale datasets, ensuring that our data products are accurate, well-documented, and optimized for a cloud-native environment. Work with DSD IT Specialists in an integrated team environment., * Analyze existing SAS-based systems and re-implement logic into Python, ensuring functional parity while improving maintainability and scalability.

• Design and develop end-to-end pipelines to read, clean, and transform diverse data formats-including SAS datasets, Parquet, JSON, and SQL-utilizing larger-than-memory processing techniques.
• Profile and refactor code to eliminate bottlenecks. Implement parallel computing strategies using libraries such as Dask, multiprocessing, etc. to handle production-scale workloads efficiently.
• Use Python to interface with PostgreSQL for high-volume data storage and retrieval.
• Implement rigorous automated testing and data quality checks (both in-transit and at-rest) to ensure the integrity of critical data assets.
• Maintain high standards for code quality by producing well-documented, readable, and extensible code. Actively participate in knowledge sharing and peer reviews to foster a collaborative engineering culture.
• 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 systems to glean functional requirements to develop optimized, Python-based solutions.
• Use Python to read and reformat large datasets.
• Clearly document and verbally communicate through step-by-step procedures, presentations, explanations of Python coding, configuration settings with rationale, shadowing, and other techniques deemed appropriate by current staff and/or management to ensure adequate knowledge transfer.
• Attend branch meetings and share technical knowledge clearly.
• Maintain regular communication with team as required.
• Maintain regular and punctual attendance.
• Perform other duties as assigned.

• Five (5) to seven (7) years of experience improving code performance such as the ability to profile and refactor code to identify bottlenecks and overhead, preferably on production code.
• Experience writing high-quality code that is well documented and easy to read, use, maintain, and extend.
• Ability to perform basic Linux commands as an end user.
• Experience with data validation in a statistical processing environment.
• Proficiency in Python, including reading and reformatting large data files.
• Experience with Parquet, SQL, JSON, and larger-than-memory datasets.
• Experience with libraries like PySpark, multiprocessing, Dask, and code profiling tools.
• Experience in Linux environments and cloud-native resources (e.g., AWS).
• Strong SQL skills, specifically with PostgreSQL integration.
• Version control (Git), unit testing, and technical documentation.
• Must pass the Census Bureau Security Investigation / background investigation., * Five (5) to seven (7) years of related experience with backend and front-end development, relational databases and application development, or an equivalent combination of experience, preferred.
• Bachelor's degree in computer science or related field is preferred.
• Ability to read and interpret SAS code; SAS programming experience preferred.
• Familiar with database designs that balance usability with functionality.
• Cloud computing experience, preferably with Amazon Web Services (AWS), is a plus., Position consists of sitting for long periods of time, using hands/ fingers, handling, reaching with hands and arms, speaking or translating. Periods of walking, standing, bending, kneeling, stooping, crouching, and lifting equipment weighing up to 10 pounds. Moderate to extended periods of office work with heavy periods of computer usage. May be assigned occasional to moderate periods of analytical tasks requiring extensive reasoning abilities. It is Katmai's business philosophy and practice to provide reasonable accommodations, according to applicable state and federal laws, to all qualified individuals with physical or mental disabilities.

• Pay range: $145k to $150k per year.
• Eligible Benefits: Medical, Dental, Vision, Life & AD&D Insurance, Long-Term & Short-Term Disability Insurance, 401(k) Savings Plan, Employee Assistance Program (EAP), Paid Time Off (PTO), 11 Paid Federal Holidays, and Leave of Absence.