Job Description:
• Design and write complex SQL queries to aggregate auction data AWS.
• Structure large-scale event data into a centralized data warehouse.
• Build and maintain data models that define core business metrics.
• Ensure Finance, Technology, and Business teams are working from consistent and reliable data.
• Lead the transition from legacy reporting tools to Looker.
• Develop LookML models and dashboards tracking signal volume, API performance, and customer activity trends.
• Partner with Finance to measure unit economics, margin by signal type, and revenue attribution.
• Partner with Technology teams to monitor signal delivery and data health using AWS logs and Datadog.
• Partner with Business Units to build profitability views showing which signal channels drive the most value.
• Maintain data integrity across Last Activity API and Activity Signal products.
• Identify and resolve data discrepancies and latency issues before they impact reporting or billing accuracy.
• Define and document analytics standards and best practices for the broader team.
Requirements:
• 5+ years of experience in business intelligence, data analytics, or data engineering environments.
• Demonstrated experience working with large-scale datasets and owning core business metrics end-to-end.
• Advanced SQL with the ability to query large, complex datasets.
• Experience working in cloud data environments such as AWS and DataBricks.
• Experience building dashboards and data models in Looker (LookML) or leading a migration to Looker.
• Experience working with event-based data, API logs, marketing, or streaming data.
• Ability to translate large datasets into clear business insights and performance metrics.
• Strong understanding of financial metrics such as LTV, CAC, and gross margin.
• Ability to work cross-functionally with Finance, Engineering, and business stakeholders, and to influence at a senior level.
• Familiarity with AWS / Snowflake for monitoring data pipelines and system performance.
• Experience analyzing API products, signal data, or event-driven systems.
• Experience mentoring analysts or setting team-wide analytics standards.
Benefits: