Remote job
Data Engineer II (Remote US)
Job details
About this role
Role overview Build and operate the data pipelines, warehouse models, and reliability foundations that support financial reporting, creator payouts, and product analytics. This mid-level role owns work from technical design through delivery, monitoring, and documentation, and shares responsibility for production support.
Responsibilities - Develop and maintain SQLMesh data models, including incremental processing, tests, and documentation. - Improve orchestration and transformation systems, and modernize legacy Python and SQL pipelines. - Participate in on-call support, investigating pipeline failures, unavailable data, and broken metrics. - Add alerts, logs, metrics, dashboards, and escalation paths to catch and resolve data issues quickly. - Maintain and extend pipelines for payouts, revenue reporting, and new revenue streams. - Optimize warehouse queries and compute use while supporting ingestion and analytics infrastructure.
Requirements - At least 3 years of hands-on data engineering experience in production environments. - Strong SQL skills, including window functions, CTEs, query tuning, and execution-plan analysis. - Python experience building maintainable pipeline logic, transformations, and tests. - Experience with a transformation framework such as SQLMesh or dbt, including incremental models, testing, and documentation. - Production experience with a cloud data warehouse, including partitioning, clustering, and cost management. - Experience with an orchestrator such as Dagster, Airflow, or Prefect, and with data-system observability and quality checks. - Ability to take small or medium features from design to delivery with limited guidance.
Benefits and work setup The role is remote within the United States. Benefits listed include medical, dental, and vision coverage; a 401(k) with company match; paid parental leave; flexible time off; learning support; and equity opportunities.