Build and maintain scalable batch and incremental data pipelines using Python, SQL, and Snowflake. Develop warehouse models, transformations, automation, data quality checks, lineage, alerting, and performance optimizations. Collaborate with analysts, data scientists, and application teams to deliver trusted datasets, while documenting pipelines, schemas, and data contracts.
Role Overview
We need an experienced Data Engineer to build and maintain reliable, scalable data pipelines and warehouse models on Snowflake. You will turn raw data from many sources into trusted datasets for analytics, reporting, and downstream applications.
Key Responsibilities
- Design, build, and operate batch and incremental data pipelines using Python and SQL.
- Develop and optimize data models and transformations in Snowflake.
- Write automation and operational scripts to orchestrate, monitor, and troubleshoot data workflows.
- Implement data quality checks, validation, lineage, and alerting.
- Tune query performance and manage warehouse cost and resource usage.
- Collaborate with analysts, data scientists, and application teams to understand requirements and deliver datasets.
- Document pipelines, schemas, and data contracts.
Required Qualifications
- 7+ years of experience in data engineering or a closely related field.
- Strong Python skills and experience with scripting languages (for example Bash).
- Advanced SQL, including complex joins, window functions, and performance tuning.
- Hands-on experience with Snowflake (warehouses, stages, tasks, streams, role-based access).
- Solid understanding of data warehousing, dimensional modeling, and ETL/ELT patterns.
Preferred Qualifications
- Experience with orchestration tools (for example Airflow) and transformation frameworks (for example dbt).
- Familiarity with AWS or GCP data services.
- Exposure to data governance, security, and privacy practices.
Compensation, Benefits and Duration
Minimum Compensation: USD 48,000
Maximum Compensation: USD 168,000
Compensation is based on actual experience and qualifications of the candidate. The above is a reasonable and a good faith estimate for the role.
Medical, vision, and dental benefits, 401k retirement plan, variable pay/incentives, paid time off, and paid holidays are available for full time employees.
This position is available for independent contractors
No applications will be considered if received more than 120 days after the date of this post.
Photon San Francisco, California, USA Office
San Francisco, United States
Similar Jobs
Fintech • Payments • Financial Services
Lead Data Engineer responsible for defining architecture, engineering standards, and best practices for the enterprise data platform, collaborating with distributed teams for modernization and scalability.
Top Skills:
AirflowAurora PostgresqlAWSKafkaRedshiftSQL Server
Big Data • Real Estate • Software
The Senior Data Engineer will optimize data ingestion pipelines, manage PostgreSQL databases, design ETL processes, and ensure system reliability in a remote-first, collaborative environment.
Top Skills:
AWSAws AuroraCi/CdCloudFormationPostgresRubyRuby On RailsTerraform
Big Data • Cloud • Software • Database
Leads technical compliance and federal authorization programs for MongoDB’s public-sector cloud products. Responsibilities include managing FedRAMP High, DoD IL5+, CJIS, and ITAR assessments; coordinating auditors, 3PAOs, agencies, and engineering teams; maintaining continuous monitoring, POA&Ms, security plans, evidence, dashboards, and remediation workflows; mapping NIST controls; advising on cloud security configurations; and mentoring stakeholders. The role requires deep public-sector GRC expertise, strong communication, and the ability to manage complex audits through Authorization to Operate.
Top Skills:
AWSCjisConfluenceDod SrgFedrampFips 140-2GCPItarJIRAAzureMongodb AtlasNist 800-171Nist 800-53
What you need to know about the San Francisco Tech Scene
San Francisco and the surrounding Bay Area attracts more startup funding than any other region in the world. Home to Stanford University and UC Berkeley, leading VC firms and several of the world’s most valuable companies, the Bay Area is the place to go for anyone looking to make it big in the tech industry. That said, San Francisco has a lot to offer beyond technology thanks to a thriving art and music scene, excellent food and a short drive to several of the country’s most beautiful recreational areas.
Key Facts About San Francisco Tech
- Number of Tech Workers: 365,500; 13.9% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Google, Apple, Salesforce, Meta
- Key Industries: Artificial intelligence, cloud computing, fintech, consumer technology, software
- Funding Landscape: $50.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Sequoia Capital, Andreessen Horowitz, Bessemer Venture Partners, Greylock Partners, Khosla Ventures, Kleiner Perkins
- Research Centers and Universities: Stanford University; University of California, Berkeley; University of San Francisco; Santa Clara University; Ames Research Center; Center for AI Safety; California Institute for Regenerative Medicine
