09 Sep
|
Programmers.io
|
India
09 Sep
Programmers.io
India
:
1. BigQuery Attribution Pipeline
- Own the GA4 ? BigQuery data model end-to-end: schema, session logic, event definitions, and the revenue attribution layer that reporting draws from
- Define and enforce channel grouping rules in BigQuery — resolving the current discrepancies between GA4 default channel groups and what reports are actually showing
- Maintain the reconciliation process between GA4 session/revenue data and BigQuery exports — establish a documented, repeatable QA cadence so divergences are caught proactively, not reactively
- Write and maintain the SQL transformations that feed Looker Studio dashboards and executive reporting — including eCommerce revenue, session attribution, and conversion rate by channel
- Own the BigQuery dataset structure, access controls, and documentation so that all team members can query with confidence
- Build and maintain attribution accuracy monitoring: automated checks that flag when GA4-to-BQ variance exceeds defined thresholds
2. Server-Side GTM Ownership
- Take immediate ownership of the three open sGTM migration tickets: container URL update, post-migration tracking validation, and Meta/third-party ad pixel validation via server GTM
- Own the server-side GTM container configuration — tags, clients, triggers, and variable mappings — as the single accountable engineer
- Validate that all paid media vendor pixels (Meta CAPI, Google Ads, Pinterest Tag) are firing correctly through the server container and that conversion data matches platform-reported figures
- Manage consent mode v2 implementation: ensure that cookie-rejected sessions are handled correctly in the server-side pipeline and that their impact on channel attribution is understood and documented
- Define and document the event passthrough architecture: which events fire client-side, which are handled server-side, and why
- Own the ongoing server container QA process — after any significant release or GTM change, run a structured validation before signing off
3. Attribution Accuracy & Ongoing Maintenance
- Maintain and evolve the attribution model as the business adds channels, changes checkout flows, or modifies tracking architecture
- Investigate and resolve the non-consent session impact on direct traffic — currently open (CTE-54704) — and document the expected behavior going forward
- Own the channel grouping logic across all reporting surfaces: GA4 property, BigQuery, and Looker Studio — ensuring consistent definitions everywhere
- Audit attribution data quarterly: identify channels that are over- or under-attributed, document findings, and implement corrections
- Be the internal expert on GA4 attribution settings: attribution windows, cross-channel data-driven attribution, and how they interact with the BigQuery export
- Establish a formal change-management process for attribution — any modification to GTM tags, channel grouping, or BQ schema that affects attribution data must be documented, reviewed, and communicated before it goes live
4. Reporting & Dashboard Support
- Build and maintain the core eCommerce and digital marketing dashboards in Looker Studio that draw from the BigQuery attribution layer you own
- Ensure dashboard metric definitions are aligned with the attribution model — no dashboard should define revenue or channel differently from the source-of-truth BQ model
- Support Power BI reporting for stakeholders who require offline-capable reports
- Own the Google Sheets ? SharePoint migration for reporting infrastructure as part of the ongoing Google sunset initiative
5. GTM Web Implementation (Shared Scope)
- Implement and validate GA4 event tracking via GTM for new Digital Product features — PLP filters, PDP interactions, cart events, and checkout flows
- Review and approve data layer specifications from Engineering before implementation begins
- Conduct post-release GTM validation as standard practice — this is non-negotiable before a ticket is closed
Must-Have Skills Big Query (SQL), Server-Side GTM, GA4 Attribution
Valuable-to-Have Skills
Consent Mode, Meta CAPI, Google Tag Manager, Looker studios
📌 Senior Analytics Engineer- 1 (India)
🏢 Programmers.io
📍 India