Analytics Engineer

• Design, build, and maintain scalable data models in Amazon Redshift to support reporting, dashboards, and ad hoc analysis.
• Collaborate with data engineering teams to expand and optimize the analytics warehouse architecture.
• Establish and enforce standards for schema design, naming conventions, and data lineage.
• Develop, maintain, and optimize data pipelines that deliver clean and reliable data to business users.
• Partner with stakeholders to gather requirements and translate business needs into scalable data solutions.
• Create and maintain comprehensive data documentation, including metrics definitions and transformation logic.
• Support BI platforms by ensuring analytics-ready datasets and assisting with dashboard development.
• Monitor data quality and implement testing, alerting, and validation processes to ensure warehouse reliability.
• Identify opportunities to improve data accessibility, consistency, and usability across the organization.
• Promote best practices in analytics engineering, including version control, code reviews, and reproducible workflows.

Analytics Engineer – Digital Media

• Participate in vendor scoping sessions to finalize full table and field requirements before the build phase begins.
• Model a dedicated datamart in the dbt transformations marts layer, sourcing data from core order, line item, and customer tables.
• Translate vendor schema specifications into specific internal field mappings, accurately accounting for DTC-adjusted logic such as ship-to addresses, order dates, and customer grain.
• Configure Snowflake data sharing and connections to facilitate seamless vendor ingestion.
• Write comprehensive dbt tests and documentation for all delivered models to ensure long-term data quality and transparency.
• Manage the full merge request workflow using GitLab, adhering to strict peer review processes before deployment.

Senior Analytics Engineer – ETL/ELT Focused, Design Marketplace

• Design and implement a multi-tier SaaS reporting infrastructure to support diverse client levels and brand campaign requirements.
• Lead the GA4 and Google Tag Manager strategy, overseeing implementation, QA, and the definition of event tracking standards for QR scans, lead captures, and promo engagement.
• Architect and manage GA4 data exports into BigQuery, building robust models that join event data with account, venue, and subscription datasets.
• Integrate data from diverse sources including Sanity CMS, Mailchimp, SMS platforms, and POS systems to create a unified view of the consumer journey.
• Develop reusable reporting templates and automated dashboards for client recaps, monthly summaries, and real-time campaign performance.
• Evaluate and deploy reporting automation tools such as Looker Studio Pro, AgencyAnalytics, or Whatagraph to enhance scalability.
• Establish data governance and access control protocols to ensure secure, account-specific reporting views.
• Partner with product and engineering teams to ensure tracking requirements are seamlessly integrated into the development lifecycle.
• Translate complex analytics into actionable business insights for internal stakeholders, venues, and brand partners.
• Maintain comprehensive documentation including tracking plans, data dictionaries, and architectural workflows.

See all jobs on JobTailor

Analytics Engineer – Digital Media

Senior Analytics Engineer – ETL/ELT Focused, Design Marketplace

Senior Data Analytics Engineer – Hospitality Tech