Remote Data Transformation Analyst Jobs in New York

JOB TITLE: Data Engineer II
LOCATION: REMOTE- US

THE ROLE:

We're looking for a Data Engineer II to join Splice's Data Engineering team and help scale the platform that powers creator payouts, revenue reporting, and product analytics across Splice's product lines.

Data Engineering builds and maintains the reliable foundation that makes trusted data possible, enabling teams across Splice to work from a governed, consistent source of truth. We are accountable for the warehouse and pipeline foundation; ingestion, transformations, and the standards and quality guardrails that keep data consistent, timely, and usable. This is a mid-level, high-ownership role: engineers here carry features from technical design through delivery, monitoring, and documentation, and participate in our on-call rotation.

The work requires hands-on data engineering experience. Our stack; BigQuery, SQLMesh, Python, Dagster- is distinct from Splice's web engineering stack, and effective contribution requires domain expertise in data pipeline systems, not general software engineering background.

TEAM INFORMATION:

You'll be joining Splice's Data Engineering team, a small, embedded platform team responsible for the pipelines, transformations, and warehouse infrastructure the rest of the company depends on. Our systems support finance-critical processes (contributor payouts, GAAP revenue reporting), product analytics, and data reliability for customer-facing features like recommendations. We operate with a shared on-call rotation and a strong bias toward observable, well-documented, durable systems.

WHAT YOU'LL DO:

Pipeline Development & Transformation

• Build and maintain data models in SQLMesh, including incremental strategies, testing, and documentation
• Continuously improve and evolve our orchestration and transformation infrastructure as the platform scales
• Modernize legacy pipeline jobs in Python and SQLMesh, reducing technical debt over time

Reliability & Observability

• Participate in on-call rotation; triage and resolve incidents including ETL failures, data unavailability, and core metric breakage
• Build introspectable software: define alert thresholds, emit metrics and logs, produce dashboards, and establish closed-loop escalation paths
• Improve observability across the platform so failures are caught early and resolved quickly

Finance & Revenue Pipelines

• Extend and maintain pipelines powering creator payouts and GAAP-compliant revenue reporting across Splice's product lines
• Build pipeline support for new revenue streams as Splice launches them

Platform Quality & Optimization

• Improve query performance and reduce compute costs in BigQuery
• Contribute to ingestion platform work and product analytics infrastructure
• Uphold our definition of done: validation complete, documentation updated, monitoring in place before closing a ticket

JOB REQUIREMENTS:

• 3+ years of hands-on data engineering experience in a production environment
• Proficiency in SQL — window functions, CTEs, query optimization, execution plan analysis
• Proficiency in Python for pipeline logic, data transformation, and testing (maintainable code, not just scripts)
• Experience with a modern transformation framework — SQLMesh, dbt, or equivalent — including incremental models, testing, and documentation
• Production experience with a cloud data warehouse (we use BigQuery); understands partitioning, clustering, and cost management
• Experience with at least one workflow orchestrator (Dagster, Airflow, Prefect, or equivalent)
• Demonstrated ability to build observable, reliable data systems — alerting, dashboards, and data quality checks
• Comfortable owning small-to-medium features from technical design through delivery with limited guidance

SPLICE BENEFITS:

• Compensation & Equity: Competitive pay with annual reviews and equity opportunities.
• Time Off: Unlimited PTO to recharge and thrive.
• Health & Wellness: Comprehensive medical, dental, and vision coverage for you and your dependents.
• Retirement Savings: 401(k) plan with immediate vesting and company match.
• Parental Support: 12 weeks of fully paid parental leave for non-birthing parents, and 18-20 weeks for birthing parents.
• Flexible Work Options: Work remotely or connect at our office hubs and creative spaces worldwide.
• Professional Growth: Annual learning budget, leadership programs, and team ambassador opportunities.
• Community & Connection: Inclusive events, team meet-ups, and vibrant Employee Resource Groups.

The national pay range for this role is $94,952 - $118,690. Individual compensation will be commensurate with the candidate's experience.