Senior Data Analytics Engineer (BI)

Trafilea is a Consumer Tech Platform focused on transformative brand growth, building an AI Growth Engine for the next generation of consumer brands. They are seeking a Senior Analytics Engineer (BI) to enhance their marketing reporting platform, improve data quality, and provide actionable insights through reliable and scalable BI solutions.

Responsibilities:

• Ensure dashboards and reports are accurate, reliable, and always available
• Implement monitoring, alerting, and SLAs for critical reporting assets
• Investigate and resolve data issues with a clear root-cause analysis
• Design and optimize SQL transformations and data models
• Improve the performance of datasets and reporting queries
• Reduce duplication by centralizing business logic in the data layer
• Build and maintain dashboards, reports, and analytical tools
• Translate business needs into scalable BI solutions
• Deliver projects with clear estimation and predictable execution
• Implement data validation checks and anomaly detection
• Proactively identify issues before they impact stakeholders
• Improve overall data quality across pipelines and reporting
• Act as a trusted partner for Marketing and commercial teams
• Define and maintain key metrics (CAC, ROAS, conversion funnels, etc.)
• Generate insights that directly influence business decisions

Requirements:

• 4–6+ years in Analytics Engineering, BI, or Data Engineering
• Advanced SQL skills (joins, CTEs, window functions, optimization)
• Strong experience with BI tools (Tableau or similar)
• Experience building and maintaining data models and pipelines
• Proven ownership of production reporting and data quality
• Ability to communicate insights to both technical and non-technical stakeholders
• Experience with AWS stack (S3, Redshift, Glue, Athena, etc.)
• Familiarity with dbt, Airflow, or modern ELT frameworks
• Experience in marketing analytics (CAC, ROAS, LTV, funnels, retention)