SUMMARY
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.
ESSENTIAL DUTIES & RESPONSIBILITIES
- 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.
SUPERVISORY RESPONSIBILITIES
None.
MINIMUM QUALIFICATIONS
- 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.
DESIRED QUALIFICATIONS & SKILLS
- 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.
WORK SCHEDULE
Full-time. May be required to work additional hours as needed to complete assignment or project.
TRAVEL
None.
DRIVING REQUIREMENTS
None.
WORK ENVIRONMENT
Work is expected to be remote; however, the company reserves the right to require onsite work.
PHYSICAL DEMANDS
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.
COMPENSATION & BENEFITS PACKAGE
- 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.
Compliance:
To be considered for this position, all applicants must apply on the company website, https://katmaicorp.com/life-at-katmai/
We are a VEVRAA Federal Contractor
We are an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to age, race, color, religion, sex, sexual orientation, gender identity or national origin, disability status, protected veteran status, marital status, familial status or any other characteristic protected by law. https://katmaicorp.com/life-at-katmai/#equal_opportunity Preference will be given to Ouzinkie Shareholders, Descendants of Shareholders and Spouses of Shareholders in accordance with Title 43 U.S. Code 1626(g) and Title 42 U.S. Code 2000e - 2(i).