KatmaiESSENTIAL DUTIES & RESPONSIBILITIES
· Analyze existing SAS-based systems and re-implement logic in Python, ensuring functional parity while improving maintainability, scalability, and performance.
· Design and develop end-to-end data pipelines to ingest, clean, validate, and transform diverse data formats—including SAS datasets, Parquet, JSON, and SQL—using larger-than-memory processing techniques.
· Profile, optimize, and refactor code to eliminate bottlenecks and improve performance. Implement parallel computing strategies using libraries such as Dask and multiprocessing to efficiently process production-scale workloads.
· Develop Python solutions that interface with PostgreSQL for high-volume data storage, retrieval, and processing.
· Implement automated testing, data validation, and quality assurance processes to ensure the integrity, accuracy, and reliability of critical data assets throughout the data lifecycle.
· Maintain high standards for code quality by producing well-documented, readable, maintainable, and extensible code. Participate in peer reviews and knowledge sharing to promote engineering best practices.
· Collaborate with DSD IT Specialists and other stakeholders to implement efficient, scalable Python solutions that meet functional and technical requirements.
· Partner with DSD stakeholders to validate business and technical requirements, troubleshoot implementation issues, and support the successful modernization of legacy systems.
· Attend branch meetings and communicate technical concepts, project updates, and recommendations clearly and effectively.
· Maintain regular communication with the team as required.
· Maintain regular and punctual attendance.
· Perform other duties as assigned.
· 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.
· Experience using Python to read and reformat large data files.
· Experience improving code performance, including profiling and refactoring code to identify bottlenecks and overhead, preferably in production environments.
· 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 in data validation in a statistical processing environment.
· Must pass the Census Bureau Security Investigation / background investigation.
· Must obtain and maintain any necessary security access and/or background checks.
DESIRED QUALIFICATIONS & SKILLS
· Five (5) to seven (7) years of related experience with back-end and front-end development, relational database and developing applications or equivalent combination of experience.
· Bachelor’s degree in computer science or related field is preferred.
· Experience in cloud computing, preferably with Amazon Web Services (AWS), is a plus.
· Statistical Analysis System (SAS) programming experience is a plus.
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.
*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.*
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).
Interested in this role?