Senior Data Pipeline Engineer
Location: Brazil (Remote)
About Sphise Technologies
Sphise Technologies is a global outsourcing and talent solutions company, partnering with high-growth businesses to build strong, high-impact teams across finance, technology, and operations.
Our trusted high-growth healthcare technology partner is hiring a Senior Data Pipeline Engineer to own and scale the data infrastructure that powers our platform, building integrations, transformations, and orchestration that ensure reliable, analytics-ready data for hundreds of customer workspaces.
Position Overview:
For our Client we're hiring a Senior Data Pipeline Engineer to own and scale the data infrastructure powering our platform. You'll build integrations from marketing and sales platforms, transform raw data into analytics-ready models, and orchestrate pipelines that run reliably across hundreds of customer workspaces. This foundational role requires architectural thinking, experience with ELT patterns, columnar storage, and multi-tenant systems. If you love designing clean data models, building robust pipelines, and connecting new data sources end-to-end, this is the role for you.
What You'll Do
* Expand our data integrations — add new source connectors (ad platforms, social media, payment processors) with full extraction, loading, transformation, and orchestration flows
* Write and maintain incremental SQL transformation models across staging, core, and analytics layers optimized for a columnar analytics engine
* Design and maintain orchestration workflows — event-driven sensors, schedules, partitions, and automated pipeline chains
* Optimize our analytics warehouse — schema design, partitioning strategies, materialized views, sort keys, and data retention policies for performance at scale
* Scale our multi-tenant architecture — each customer workspace gets isolated databases, and you'll manage the per-tenant pipeline lifecycle
* Build data quality checks, freshness monitoring, alerting, and pipeline health dashboards
What You Bring
* 5+ years of progressive experience in data engineering — we care about your growth trajectory, not just time served
* Strong SQL skills — CTEs, window functions, complex aggregations, and performance tuning for analytical workloads
* Production experience with columnar analytics databases (ClickHouse, Snowflake, BigQuery, Redshift, or similar OLAP engines)
* Hands-on experience with ELT pipelines and SQL transformation frameworks (dbt or similar)
* Experience with modern data orchestration tools (Dagster, Airflow, Prefect, or similar)
* Comfortable writing data pipeline code in Python
* Experience with cloud-based data integration platforms for managing source connectors and sync configurations
* Bachelor's degree in Computer Science, Engineering, or equivalent practical experience
Nice to Have
* Experience with marketing and ads platform APIs (TikTok, Meta, Google Ads, Pinterest)
* Background in multi-tenant data architecture — per-customer database isolation and credential management
* E-commerce domain knowledge — orders, customers, transactions, RFM segmentation, customer lifetime value
* Experience with PostgreSQL and cross-database patterns between relational and analytical databases
* Familiarity with Next.Js or TypeScript — our console is built with Next.Js, and wiring integrations into the frontend is a plus
* Understanding of how data models feed into AI/LLM agent systems
Who You Are
* You have a genuine drive to learn and grow — we hire for potential and curiosity as much as current skill
* You think in systems — you see how extraction, transformation, orchestration, and the analytics layer fit together as one whole
* You take ownership end-to-end — from designing the schema to monitoring the pipeline in production
* You're comfortable with ambiguity and can make sound architectural decisions without a playbook for every situation
* You communicate clearly and enjoy working directly with founders and cross-functional teammates
Benefits:
* Competitive salary to recognise and reward your achievements.
* Flexible work environment.
* Opportunities for professional and personal growth.