Analytics Engineer (dbt, SQL, Data Pipelines)

Raw data → dbt → Clean, organized data → Analytics & reporting | Role focus: 80% backend (pipelines, SQL, dbt) | 20% BI supportWe 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 ResponsibilitiesBuild and manage dbt models to transform raw data into clean, analytics-ready datasetsDevelop and optimize data pipelines across cloud data platforms (ELT workflows)Write complex, performant SQL for scalable data transformation and modelingImplement data quality checks, testing, and lineage within dbt environmentsUse 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