Senior Python Developer - Streamlit​/Snowflake Migration

Work Authorization:

GC, USC, All valid EADs except OPT, CPT, H1B

• Python
• Snowflake
• AWS EC2
• SQL
• Code modularization and refactoring
• Authentication and access control
• Testing / QA in production and server environments

• Migrate an existing Streamlit-based workforce planning application from a Snowflake Native App architecture to an AWS EC2-hosted environment.
• Refactor the current Python codebase to improve modularity, maintainability, performance, and memory efficiency.
• Maintain and optimize read/write integrations with Snowflake, including transactional write-back, hybrid table interactions, and authentication handling across environments.
• Support EC2 environment setup, deployment configuration, dependency management, and server-side testing.
• Identify and resolve differences between QA and production environments, including caching behavior and authentication fallback issues.
• Partner with internal technical leads to execute the migration within a short, milestone-driven engagement.
• Deliver technical documentation covering architecture, deployment steps, and operational runbooks.

• 5+ years of professional Python development experience in enterprise or large-scale environments.
• Strong experience building and supporting production-grade Python applications with clean, modular architecture.
• Hands‑on experience with Snowflake, including SQL development, roles/permissions, warehouse concepts, and Python connector-based integrations.
• Experience deploying and managing Python applications on AWS EC2, including server setup, security groups, IAM roles, and networking.
• Strong understanding of application hosting patterns such as systemd, Docker, reverse proxies, SSL/TLS, and domain routing.
• Experience troubleshooting environment-specific issues across QA and production.
• Ability to contribute immediately in a short-term engagement with minimal ramp-up time.

• Prior experience migrating applications from Snowflake Native Apps to externally hosted environments
• Docu Sign API or other e‑signature platform integration experience
• Experience with HR or workforce planning data domains
• Experience building persona-based or role-based access layers in Streamlit