About the role

  • Senior Analytics Developer at SOCi developing data pipelines and analytic products for AI-powered marketing solutions. Collaborating with teams to ensure data quality and business insights.

Responsibilities

  • Own the relationship with one or more business team stakeholders for the data team.
  • Collaborate with business teams to identify, document and develop analytic solutions.
  • Collaborate with data analysts, engineers and other stakeholders on data lake models.
  • Develop and maintain data pipelines collecting data from various source systems.
  • Develop and maintain data model transformations for use in analytic models.
  • Ensure data accuracy, quality and consistency with monitoring and validation processes.
  • Maintain our data catalog, and document data pipelines, transformations and models.
  • Monitor, and respond to production incidents in the data lake.
  • Optimize queries, and data engineering activities for performance and cost.
  • Assist in implementing data governance and security best practices.
  • Document processes, workflows, and data definitions to support knowledge sharing.
  • Guide user story breakdown sessions, and contribute to quarterly planning sessions.
  • Provide mentorship and coaching to junior Analytics Developers.
  • Be willing to adapt to changes in the job description as necessary by the business and accept all other duties as assigned.

Requirements

  • 5+ years of experience working with cloud based data platforms (Airflow, FiveTran, Stitch, etc.)
  • Expert-level proficiency in SQL and hands-on experience with cloud-based data warehouse platforms (e.g., Snowflake, Redshift, BigQuery).
  • Proficiency and working experience in Python.
  • Proficiency building transformations and data models using declarative programming (dbt, Snowflake Dynamic Tables, SQLMesh).
  • Strong knowledge of data modeling, schema design, and data governance principles.
  • Experience with “Data Hub” or equivalent open source data catalog platform is a plus.
  • Demonstrated experience optimizing performance and managing complex datasets.
  • Excellent leadership and communication skills, with a proven ability to mentor and guide team members.

Benefits

  • Health insurance plans, dental, and vision
  • Wellness incentives
  • 401(k) plan with employer match
  • Flexible paid time off
  • Quarterly wellness days
  • Paid holidays
  • Unique employee engagement programs

Job type

Full Time

Experience level

Senior

Salary

CA$87,000 - CA$135,000 per year

Degree requirement

Bachelor's Degree

Tech skills

AirflowAmazon RedshiftBigQueryCloudOpen SourcePythonSQL

Location requirements

HybridTorontoCanada

Report this job

Found something wrong with the page? Please let us know by submitting a report below.