What You’ll Do
- Take ownership of pipeline stability and performance across our GCP-based stack (BigQuery, GCS, Dataprep / Dataflow)
- Lead the enhancement of our existing ETL workflows to support better modularity, reusability, and error handling
- Help introduce lightweight governance practices—including column-level validation, source tracking, and transformation transparency
- Support development of a semantic layer (e.g., KPI definitions, normalized metric naming) to reduce rework and support downstream users
- Work with analysts and dashboard developers to structure data outputs for intuitive use and parameterization
- Collaborate with team leadership to prioritize improvements based on impact and feasibility
- Support platform readiness for automated reporting, predictive modeling, and AI-enhanced analysis
- Contribute to team culture through clear documentation, mentoring, and code review
- Participate in hiring, onboarding, and evolving our internal standards
What We’re Looking For
Must-Have :
4–6+ years of experience in data engineering, preferably in a fast-paced agency or multi-client environmentSolid command of Google Cloud Platform, especially BigQuery, GCS, and Cloud Dataprep (Alteryx) or DataflowStrong SQL and Python skills with a focus on transformation and data reliabilityExperience building and maintaining ETL pipelines in productionFamiliarity with metadata-driven development, version control, and task orchestration (Airflow or equivalent)Proven ability to balance individual execution with team collaborationClear communicator, able to translate technical trade-offs to non-technical stakeholdersNice-to-Have :
Experience applying basic data governance principles (e.g., lineage tracking, validation frameworks, naming conventions)Exposure to building or maintaining a semantic layer (via dbt, LookML, etc.)Familiarity with AI / ML workflows or tooling for automated insight generationUnderstanding of marketing or media datasetsExperience developing custom marketing attribution modelsExperience mentoring junior team members or participating in code / process standardization