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