Design and build the reporting data architecture, structuring BigQuery datasets, tables, and views for scalable, multi-account, and multi-venue analytics.
Build and manage ingestion pipelines from multiple disparate data sources, utilizing APIs , webhooks, scheduled syncs, ETL/ELT tools, or custom scripts.
Set up and manage data exports from GA4 to BigQuery , establishing clean data relationships across all reporting entities including accounts, venues, campaigns, and subscription tiers.
Integrate diverse data streams including Google Tag Manager , CMS platforms, email and SMS marketing tools, receipt validation services, and POS systems.
Create clean SQL models to transform raw behavioral data and business metadata into reusable, reporting-ready tables.
Prepare foundational data models to power automated dashboards and client-facing analytics for various BI platforms like Looker Studio .
Establish comprehensive data quality assurance processes, validation checks, and actively monitor pipeline reliability.
Maintain clear, thorough documentation for schemas, data flows, transformations, reporting logic, and event taxonomies.
Partner cross-functionally with product and engineering teams to ensure tracking is implemented correctly and to support privacy-conscious data practices.
Qualifications and Job Requirements
4+ years of professional experience in data engineering, analytics engineering, product analytics, or data analysis.
Demonstrated, hands-on experience building a data warehouse or reporting database entirely from scratch (this is a mandatory requirement for the role).
Strong proficiency in SQL and extensive experience structuring and managing BigQuery .
Proven ability to build, manage, and scale ETL or ELT data pipelines.
Deep understanding of event-based analytics and direct experience with GA4 to BigQuery exports.
Expertise in data modeling for analytics and the ability to create reporting-ready datasets for BI tools.
Experience working with APIs , webhooks, or scheduled data syncs to join data across multiple sources.
Exceptional documentation, data governance, and data QA habits.
Experience with Looker Studio , Looker Studio Pro , or other white-label reporting platforms (e.g., AgencyAnalytics , Databox , DashThis ) is preferred.
Familiarity with modern data tools and scripting languages such as Python , Zapier , or Google Cloud Functions is a plus.
Experience defining GA4 event taxonomies and working with Google Tag Manager is highly advantageous.
Background in SaaS reporting, client-facing dashboards, or multi-tenant analytics is preferred.
Familiarity with marketing platforms, CMS tools (like Sanity CMS ), marketing automation systems (like Mailchimp ), or POS systems is a plus.
Prior experience in hospitality, retail, CPG, loyalty, rebates, or campaign attribution reporting is a strong plus.
Requirements
4+ years of professional experience in data engineering, analytics engineering, product analytics, or data analysis.
Demonstrated, hands-on experience building a data warehouse or reporting database entirely from scratch (this is a mandatory requirement for the role).
Strong proficiency in SQL and extensive experience structuring and managing BigQuery .
Proven ability to build, manage, and scale ETL or ELT data pipelines.
Deep understanding of event-based analytics and direct experience with GA4 to BigQuery exports.
Expertise in data modeling for analytics and the ability to create reporting-ready datasets for BI tools.
Experience working with APIs , webhooks, or scheduled data syncs to join data across multiple sources.
Exceptional documentation, data governance, and data QA habits.
Experience with Looker Studio , Looker Studio Pro , or other white-label reporting platforms (e.g., AgencyAnalytics , Databox , DashThis ) is preferred.
Familiarity with modern data tools and scripting languages such as Python , Zapier , or Google Cloud Functions is a plus.
Experience defining GA4 event taxonomies and working with Google Tag Manager is highly advantageous.
Background in SaaS reporting, client-facing dashboards, or multi-tenant analytics is preferred.
Familiarity with marketing platforms, CMS tools (like Sanity CMS ), marketing automation systems (like Mailchimp ), or POS systems is a plus.
Prior experience in hospitality, retail, CPG, loyalty, rebates, or campaign attribution reporting is a strong plus.
Benefits
100% Remote Work: Enjoy the freedom to
Additional Information
About Truelogic
At Truelogic we are a leading provider of nearshore staff augmentation services headquartered in New York. For over two decades, we've been delivering top-tier technology solutions to companies of all sizes, from innovative startups to industry leaders, helping them achieve their digital transformation goals.
Our team of 600+ highly skilled tech professionals, based in Latin America, drives digital disruption by partnering with U.S. companies on their most impactful projects. Whether collaborating with Fortune 500 giants or scaling startups, we deliver results that make a difference.
By applying for this position, you're taking the first step in joining a dynamic team that values your expertise and aspirations. We aim to align your skills with opportunities that foster exceptional career growth and success while contributing to transformative projects that shape the future.
Our Client
Growing digital menu, engagement, and brand activation platform tailored for on-premise hospitality and retail environments. They provide venues with mobile-first experiences, consumer lead capture capabilities, and measurable reporting for brands and campaign partners.
Job Summary
We are seeking a hands-on Data Engineer to design and build the foundational data infrastructure that will power a scalable, automated SaaS reporting system. This critical role focuses on transitioning the platform from manual dashboard creation to a robust reporting pipeline capable of supporting multiple client accounts, venues, and subscription tiers. The ideal candidate is an architectural builder at heart, bringing deep expertise in constructing data warehouses entirely from scratch, establishing ETL processing, and creating reporting-ready datasets that will enable future analysts and client-facing business intelligence tools to thrive.
Truelogic · Mexico