Analytics Engineer

Key Responsibilities

Design, build, and optimize data models and transformations in BigQuery using SQL , CTEs , window functions , and incremental logic .

Develop modular, reusable pipelines using Dataform or dbt , ensuring proper documentation, dependencies, and version control.

Collaborate with data architects, analysts, and business teams to define and maintain governed data layers .

Maintain and validate Looker dashboards to ensure parity between legacy (Roadnet) and modernized data sources.

Participate in the design of data architecture and lineage , ensuring consistency, scalability, and performance optimization.

Partner with governance and infrastructure teams to establish best practices for data quality, model ownership, and CI / CD workflows.

Automate and operationalize data tasks using Python , Cloud Functions , or Terraform (as applicable).

Ideal Candidate Profile

5–9 years of experience in data engineering or analytics engineering roles.

Proven experience in BigQuery , dbt / Dataform , and Looker within the GCP environment .

Strong understanding of data architecture , lineage , and governed data modeling .

Hands-on experience with SQL performance optimization and data quality management .

Excellent collaboration and communication skills to work with cross-functional teams.

Exposure to transportation, logistics, or routing analytics is a plus.