Salary
💰 CA$93,400 - CA$110,700 per year
About the role
- Own and optimize the data pipelines that power marketing analytics, ensuring timely delivery, accuracy, and integrity of large-scale datasets
- Diagnose and resolve complex data issues by debugging SQL scripts, auditing data sources, and collaborating with Data Engineering to enhance pipeline performance and reliability
- Lead data governance initiatives by establishing and enforcing best practices for data quality, consistency, and documentation
- Develop and automate scripts for data validation, transformation, and migration to improve operational efficiency and integration
- Conduct complex, deep-dive analyses to measure marketing campaign impact, identify performance trends, and provide actionable recommendations
- Utilize advanced SQL and scripting to query, transform, and synthesize massive datasets from disparate sources and develop new methodologies and metrics
- Develop comprehensive reports and presentations translating complex analytical findings into clear, actionable insights for stakeholders
- Lead end-to-end development of marketing analytics tools and scalable dashboards; partner with marketing stakeholders to gather requirements and translate business needs into technical specifications
Requirements
- 3+ years of experience in a highly analytical and technical role, such as a Data Analyst, Business Intelligence Engineer, or hybrid Marketing Analyst/Software Engineer
- Demonstrated experience in building and maintaining data-driven solutions and platforms
- Expert-level proficiency in SQL for complex data querying, manipulation, and analysis of large datasets
- Proficiency in at least one scripting language (e.g., Python or R) for data extraction, transformation, automation, and statistical analysis
- Strong experience with data visualization and dashboarding tools (e.g., Google internal dashboard systems, Google Sheets)
- Proficiency in Google Apps Script for automation and tool customization
- Familiarity with data warehousing concepts and experience working with large-scale data infrastructures
- Strong quantitative and qualitative analytical skills
- Excellent written and verbal communication skills to articulate technical details and analytical findings