Hybrid Python Data Engineer - Streamlit & Snowflake

Swoon; San Francisco (CA); Hybrid; USD 184,000 - 199,000; Full time

Job summary

Swoon is seeking a Python Data Engineer in the Oakland/San Ramon area (hybrid) to design and deploy data-driven applications. You will build Streamlit dashboards, pipelines, and integrations with Snowflake and enterprise systems, enabling actionable insights for energy and utilities operations.

The role emphasizes collaboration with business stakeholders, data quality, and deployment automation in Agile settings. Candidates should have 3–5 years Python and 2+ years Streamlit experience.

Qualifications

• 3–5 years of Python development experience.
• 2+ years of experience building applications with Streamlit.
• Strong SQL skills and understanding of database design concepts.
• Experience developing ETL/ELT processes and data pipelines.
• Knowledge of data engineering best practices, data quality controls, and data integration patterns.
• Experience working with REST APIs and external data sources.
• Experience with Git, version control, and CI/CD practices.
• Strong analytical, problem-solving, and communication skills.

Responsibilities

• Design, develop, and maintain Streamlit applications hosted on Snowflake.
• Develop Python-based solutions for data ingestion, transformation, validation, and reporting.
• Build scalable data pipelines and workflows to support business processes and analytics.
• Create interactive dashboards, forms, workflows, and self-service applications for business users.
• Develop and maintain integrations between Snowflake and enterprise systems, including SAP, SharePoint, REST APIs, and other internal platforms.
• Collaborate with business stakeholders to gather requirements and translate them into effective technical solutions.
• Support data modeling, data quality, and data governance initiatives.
• Troubleshoot production issues and implement application and performance improvements.
• Participate in Agile development activities, including sprint planning, backlog grooming, testing, and deployment.
• Create technical documentation, deployment guides, and support materials.

Skills

Python

Streamlit

SQL

ETL/ELT

Data integration

REST APIs

Git/CI-CD

Analytical

Tools

Snowflake

Snowpark for Python

Airflow

Git

CI/CD

Job description

Swoon is seeking a Python Data Engineer in the Oakland/San Ramon area (hybrid) to design and deploy data-driven applications. You will build Streamlit dashboards, pipelines, and integrations with Snowflake and enterprise systems, enabling actionable insights for energy and utilities operations.

The role emphasizes collaboration with business stakeholders, data quality, and deployment automation in Agile settings. Candidates should have 3–5 years Python and 2+ years Streamlit experience.