Staff Insights Engineer

Job summary

This role focuses on building and scaling the data foundation necessary for B2B marketing attribution and activation. The Staff Insights Engineer will work closely with the marketing team to ensure the accuracy and reliability of data used in published benchmarks and reports.

Qualifications

• Extensive experience with production SQL, including window functions and query optimization over large datasets.
• Proven track record in data engineering, having managed a warehouse project from start to finish, including dimensional modeling and transformation frameworks.
• Strong statistical knowledge, including sampling, confidence intervals, and understanding of selection bias.
• Experience with data aggregation and privacy, particularly in publishing findings derived from customer data.
• Excellent technical writing skills, capable of creating clear methodology notes.

Responsibilities

• Build the benchmark dataset and improve the data aggregation and anonymization processes.
• Develop version-controlled data transformations and define metric definitions for marketing queries.
• Ensure the statistical methodology is robust and transparent, including handling selection bias.
• Provide timely and defensible answers to marketing inquiries, reducing dependency on engineering for data queries.
• Oversee the analysis behind quarterly benchmark reports and ensure the self-service layer is effective for marketing needs.

Skills

• Proficient in SQL and data engineering practices.
• Strong statistical analysis capabilities.
• Ability to write clear and concise technical documentation.

Education

• Relevant degree in a quantitative field or equivalent experience.

Tools

• Experience with BigQuery on Google Cloud and transformation frameworks such as Dataform or dbt.