Deskripsi Pekerjaan
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. Responsibilities 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 taxonomie