Junior Data Engineer - Growth & BI Mentorship

First Roles; California; On-site; USD 70,000 - 110,000; Full time

Job summary

First Roles in California is seeking a Junior Data Engineer to help build, maintain, and optimize data pipelines, gaining hands-on experience with cloud data platforms and BI initiatives.

The ideal candidate has 1–3 years in data, analytics, or software engineering and is eager to deepen expertise in data transformation and reporting using Snowflake, Redshift, dbt, and BI tools. You will collaborate with stakeholders and participate in code reviews.

Qualifications

• 1–3 years of experience in data, analytics, or software engineering.
• Strong SQL skills and ability to query and analyze large datasets.
• Working knowledge of Python for data engineering or analytics tasks.
• Familiarity with cloud-based data warehouses (Snowflake, Redshift) or similar platforms.
• Experience with data transformation tools (dbt) and BI/visualization tools.

Responsibilities

• Develop, test, and deploy ETL/ELT pipelines to ingest, transform, and deliver data from multiple sources.
• Build integrations with external systems, APIs, and third‑party platforms.
• Monitor pipelines, troubleshoot issues, and ensure reliability and performance.
• Create and maintain BI dashboards and reporting assets.
• Ensure data quality through validation, testing, and monitoring processes.
• Contribute to data models and transformation workflows.

Skills

SQL

Python

Analytical thinking

Communication

Education

Bachelor's degree or equivalent in CS/Engineering/Math

Tools

Snowflake

Amazon Redshift

dbt

Tableau

Power BI

Looker

Sigma

Job description

First Roles in California is seeking a Junior Data Engineer to help build, maintain, and optimize data pipelines, gaining hands-on experience with cloud data platforms and BI initiatives.

The ideal candidate has 1–3 years in data, analytics, or software engineering and is eager to deepen expertise in data transformation and reporting using Snowflake, Redshift, dbt, and BI tools. You will collaborate with stakeholders and participate in code reviews.