Data Engineer

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 #J-18808-Ljbffr UpRecruit