Onsite/ Hybrid/ Remote: Remote
Duration: 2 Months
Rate Range: Upto $89/hr on W2
Work Authorization: GC, USC, All valid EADs except OPT, CPT, H1B
Must Have:
- Python
- Snowflake
- AWS EC2
- Streamlit
- SQL
- Application migration / deployment
- Code modularization and refactoring
- Authentication and access control
- Testing / QA in production and server environments
Responsibilities:
- 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.
Qualifications:
- 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.
- Bachelor’s degree plus relevant experience.
Nice to Have:
- Prior experience migrating applications from Snowflake Native Apps to externally hosted environments
- DocuSign 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