At KATMAI, this remote-friendly opportunity in Orlando, FL delivers competitive compensation, comprehensive benefits, and a collaborative engineering culture. You will lead modernization of core data processing by translating legacy SAS logic into Python, building scalable data pipelines, and ensuring cloud-native performance, working in an integrated team with DSD IT Specialists.
Responsibilities
- Analyze existing SAS-based systems and re-implement logic in Python, preserving functionality while improving maintainability and scalability.
- Design and build end-to-end pipelines to read, clean, and transform diverse data formats—SAS datasets, Parquet, JSON, and SQL—using methods suitable for large, memory-intensive workloads.
- Profile and refactor code to remove bottlenecks; apply parallel processing with Dask, multiprocessing, and related tools for production-scale performance.
- Use Python to interface with PostgreSQL for high-volume data storage and retrieval.
- Implement automated tests and data quality checks (in transit and at rest) to safeguard data integrity.
- Maintain high code quality with well-documented, readable, and extensible code; participate in knowledge sharing and peer reviews to foster collaboration.
- Support DSD with Python solutions that leverage the language’s strengths and best practices.
- Assist in analyzing SAS-based systems to extract functional requirements and develop optimized Python-based solutions.
- Use Python to read, reformat, and manage large datasets.
- Document procedures clearly and communicate configurations with rationale to ensure knowledge transfer and onboarding support.
- Attend branch meetings and share technical knowledge in a clear manner.
- Maintain regular, reliable communication with the team and dependable attendance.
- Perform other duties as assigned.
Requirements
- Five to seven years of experience profiling and refactoring production-level code to identify bottlenecks and overhead.
- Proven ability to write high-quality, well-documented Python code that is easy to read, maintain, and extend.
- Competence with basic Linux command line usage.
- Experience validating data in statistical processing environments.
- Strong Python skills, including reading and reformatting large data files.
- Experience with Parquet, SQL, JSON, and large-scale datasets.
- Familiarity with PySpark, multiprocessing, Dask, and code profiling tools.
- Experience in Linux environments and cloud-native resources such as AWS.
- Robust SQL skills with PostgreSQL integration.
- Version control (Git), unit testing, and technical documentation experience.
- Must pass the Census Bureau Security Investigation / background investigation.
Technologies
- Python
- SAS
- Parquet
- JSON
- SQL
- PostgreSQL
- Dask
- multiprocessing
- PySpark
- AWS
- Linux
- Git
Compensation and Benefits
- Salary: USD 145,000 to 150,000 per year
- Medical, Dental, and Vision insurance
- Life and AD&D Insurance
- Long-Term and Short-Term Disability Insurance
- 401(k) Savings Plan
- Employee Assistance Program (EAP)
- Paid Time Off (PTO)
- 11 Paid Federal Holidays
- Leave of Absence
Work Environment and Schedule
Work is remote, with the possibility of on-site requirements at the company's discretion. This is a full-time position and may require additional hours to complete assignments or projects.
Travel and Driving
Travel: None. Driving requirements: None.
What to Expect in the Role
Collaborate with DSD IT Specialists within an integrated team to translate SAS logic into scalable Python solutions, develop robust data pipelines, and ensure cloud-native performance across diverse data formats. You will contribute to a culture of knowledge sharing, peer reviews, and clear communication, while maintaining meticulous documentation and code quality.
Physical Demands
Typically involves long periods of sitting and computer use, with occasional light lifting (up to 10 pounds) and periods of standing or walking as needed for tasks and collaboration.
