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.