Data Engineer

Data Engineer / Analytics Engineer dbt, Trino & AWS Location: Pleasanton, CA Work Arrangement: 100% Onsite / In Office Duration: Contract Experience: 3+ Years Industry: Technology / Software Job Summary We are seeking an experienced Data Engineer / Analytics Engineer with strong expertise in dbt, SQL, Trino/Presto, and AWS to build and maintain scalable data transformation pipelines and analytics solutions. The ideal candidate will have hands-on experience with data modeling, data warehousing, ETL/ELT pipelines, workflow orchestration, and modern data stack technologies . This role will work with large-scale, distributed data environments and collaborate with cross-functional teams to deliver data-driven insights around performance, capacity, and cost engineering. Key Responsibilities Develop, maintain, and optimize scalable data transformation pipelines using dbt and SQL. Build and maintain data ingestion, transformation, scheduling, and analytics workflows. Develop robust data models and data warehouse solutions . Work with Trino/Presto to query and analyze large-scale distributed datasets. Build and manage ETL/ELT pipelines using Python, Apache Airflow , and other data engineering technologies. Work with AWS data and database services, including AWS RDS . Work with relational databases such as MySQL and PostgreSQL . Collaborate with domain experts and cross-functional engineering teams to understand business and technical requirements. Develop automated data models and contribute to pipeline architecture and optimization. Analyze complex datasets and provide actionable, data-driven recommendations. Support BI, reporting, analytics, and data visualization initiatives. Implement data quality, reliability, and performance improvements. Participate in code reviews and maintain source-controlled data engineering workflows using Git . Contribute to CI/CD, DevOps, and GitOps practices for data pipelines. Required Qualifications 3+ years of experience in Data Engineering, Analytics Engineering, Data Warehousing, Software Development, or Data Science. Strong hands-on experience with dbt . Strong SQL development and data analysis skills. Experience with data modeling, data warehousing, and ETL/ELT pipelines . Experience with Trino or Presto . Experience working with modern data stack technologies. Experience with at least one major cloud platform, preferably AWS . Experience with Apache Airflow or similar workflow orchestration tools. Strong programming experience with Python , Java, or Scala. Experience with relational databases such as PostgreSQL or MySQL . Strong understanding of distributed data processing and large-scale data environments. Bachelor's degree in Computer Science or a related field, or equivalent practical experience. Preferred Qualifications Experience with semantic-layer technologies such as LookML, Cube, or MetricsFlow . Experience with Lightdash or similar BI/analytics platforms. Experience with business intelligence and data visualization tools. Experience with AWS RDS and cloud-based data platforms. Knowledge of CI/CD, DevOps, and GitOps practices. Experience working in open-source data engineering environments. Experience working with large-scale or multi-petabyte data environments. Top 5 Must-Haves dbt Advanced SQL Trino / Presto AWS Data Modeling + ETL/ELT + Apache Airflow #J-18808-Ljbffr