JOBSEARCHER

Analytics Engineer (dbt, SQL, Data Pipelines)

ARCHIVED

We can't find an active application page for this role right now. It may reopen or be listed elsewhere. Use Next Steps to search for an active apply link and similar live jobs.

Raw data → dbt → Clean, organized data → Analytics & reporting | Role focus: 80% backend (pipelines, SQL, dbt) | 20% BI support We are seeking a backend-focused Analytics Engineer to build and optimize scalable data transformation workflows. This role is heavily centered on dbt, SQL, and modern ELT pipelines, with a strong emphasis on data modeling, quality, and performance. You’ll partner closely with data and business teams to deliver clean, reliable datasets that power analytics and decision-making.
Important: Candidates must be authorized to work in the United States on a W2 basis without current or future sponsorship. Third-party candidates will not be considered.
Core Responsibilities:
  • Build and manage dbt models to transform raw data into clean, analytics-ready datasets
  • Develop and optimize data pipelines across cloud data platforms (ELT workflows)
  • Write complex, performant SQL for scalable data transformation and modeling
  • Implement data quality checks, testing, and lineage within dbt environments
  • Use Python for data ingestion and automation, and SQL/dbt for transformation and modeling Required SkillsHands-on experience with dbt (Core or Cloud)
  • Strong SQL (advanced joins, CTEs, performance tuning)
  • Experience with pipeline orchestration tools (Airflow, ADF, or similar)
  • Solid understanding of data modeling (star/snowflake schemas)
  • Experience in cloud data environments (Snowflake, BigQuery, Redshift, etc.)For immediate consideration, please email UPDATED resume to lisa.norman@randstadusa.com