Data Engineer

UpRecruit; Los Angeles (CA); Remote; USD 130,000 - 150,000; Full time

Job summary

A data solutions firm is seeking a Data Pipeline Engineer to enhance core data infrastructure while handling data ingestion and integration issues. You will maintain and optimize SQL-based ETL workflows, develop reliable connections with third-party SaaS platforms, and ensure data quality and scalability. The ideal candidate will have 3–6+ years of relevant experience, strong SQL and PostgreSQL skills, and familiarity with ETL tools. This full-time position is remote, offering competitive compensation and growth potential.

Qualifications

• 3–6+ years of experience in data engineering or ETL roles.
• Deep SQL and PostgreSQL expertise including schema design.
• Strong understanding of REST APIs, authentication, and integrations.

Responsibilities

• Maintain and improve data ingestion pipelines.
• Troubleshoot schema mismatches and API limits.
• Build and optimize ETL workflows in PostgreSQL.

Skills

Data engineering

SQL

PostgreSQL

REST APIs

Git/GitHub Actions

ETL tools

Tools

Hotglue

dbt

Airflow

Fivetran

Job description

Base Pay Range

$130,000.00/yr - $150,000.00/yr

The Role

Our client is seeking a Data Pipeline Engineer to own and enhance the core data infrastructure that powers their product ecosystem. This role is highly impactful — you will maintain ingestion pipelines, troubleshoot complex integration issues, optimize SQL workflows, and build reliable connections between internal systems and key third‑party SaaS platforms.

This position is ideal for a data engineer who loves solving messy data problems, improving reliability, and building clean, scalable data models. You’ll work closely with product leadership, engineering, and external tools to ensure the data foundation is robust and ready for high‑volume growth.

What You’ll Do

• Maintain and improve data ingestion pipelines, including integrations built with Hotglue and Heroku
• Troubleshoot and resolve schema mismatches, API limits, authentication errors, and connection issues
• Build and optimize SQL‑based ETL/ELT workflows, transformations, and views in PostgreSQL
• Manage staging datasets, including anonymization and synthetic data generation
• Define and implement core customer‑facing metrics in partnership with product leadership
• Develop and maintain third‑party SaaS integrations (HubSpot, QuickBooks, Asana, etc.)
• Support lightweight DevOps tasks including CI/CD workflows, performance tuning, and monitoring
• Ensure reliability and scalability across a multi‑tenant SaaS data architecture
• Drive best practices for data quality, versioning, and pipeline observability

What We’re Looking For

• 3–6+ years of experience in data engineering, integrations, or ETL‑focused roles
• Deep SQL and PostgreSQL expertise (schema design, optimization, performance tuning)
• Experience with ETL tools such as Hotglue, dbt, Airflow, Fivetran, or similar
• Strong understanding of REST APIs, OAuth authentication, rate limiting, and webhook‑driven integrations
• Familiarity with Git, GitHub Actions, and modern CI/CD workflows
• Experience working with SaaS data models and multi‑tenant architectures
• Strong problem‑solving skills and a collaborative, product‑oriented mindset

Bonus Experience

• Knowledge of SOC2/GDPR compliance or secure data‑handling practices
• Experience generating synthetic datasets or anonymizing production data
• Exposure to LLM/AI‑powered workflows or data enrichment processes

Compensation

Full‑time | Remote | No C2C

Seniority Level

Mid‑Senior level

Employment Type

Full‑time

Job Function / Industries

IT System Custom Software Development