Python Data Engineer

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

Location: Oakland, CA or San Ramon, CA – Hybrid

Candidates: Local candidates only

Contract: Through September 30, 2027

Compensation: $92/hour

About the Role

Our client, a leading organization in the energy and utilities industry, is seeking a highly motivated Python Data Engineer to support the design, development, and deployment of data-driven applications.

This role will focus on building applications that streamline business processes, improve asset management capabilities, and provide actionable operational insights. The ideal candidate will have hands‑on experience with Python, Streamlit, Snowflake, and data engineering, along with the ability to develop scalable data applications and pipelines that integrate information from multiple enterprise systems.

What You'll Do

• 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.

Required Qualifications

• 3–5 years of experience in Python development.
• 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.

Preferred Qualifications

• Experience with Snowpark for Python.
• Experience with Airflow or other orchestration tools.
• Experience with automated deployment pipelines.

Why This Opportunity?

Join a long-term technology initiative within the energy and utilities industry, developing data-driven applications that directly support operational processes, asset management, and business decision-making.