Senior Analytics Developer

SOCi; Vancouver, Toronto; Hybrid; CAD 80,000 - 110,000; Full time

Job summary

A leading marketing solutions company located in Vancouver is seeking a Senior Analytics Developer to lead the development of data pipelines and analytics products. The role involves optimizing data infrastructure and assisting analysts with accurate data models. Candidates should have over 5 years of experience in cloud data platforms, expertise in SQL, and proficiency in Python. This full-time position offers a comprehensive benefits package and opportunities for career growth.

Benefits

Comprehensive Benefits Package

Health insurance

401(k) plan with employer match

Flexible Work Environment

Flexible paid time off

Wellness incentives

Qualifications

• 5+ years experience with cloud based data platforms.
• Expert-level proficiency in SQL and hands-on experience with data warehouse platforms.
• Proficiency in Python and data transformations.

Responsibilities

• Own relationship with business stakeholders.
• Develop and maintain data pipelines.
• Ensure data accuracy and quality.

Skills

Cloud based data platforms

SQL

Python

Data modeling

Data governance principles

Performance optimization

Leadership

Education

Bachelor’s or Master’s degree in Computer Science

Tools

Snowflake

Tableau

Airflow

FiveTran

Stitch

Job description

Overview

SOCi, the leader in AI-powered marketing solutions for multi-location businesses, is currently looking for an experienced Senior Analytics Developer. The Senior Analytics Developer contributes by leading the development of data pipelines, transformations, data models, and analytic products in our data lake. You will represent the data team as a subject matter expert, and data model spokesperson, demonstrated by your ability to answer business questions quickly and accurately from the data lake. The role develops strategic data and analytic products by bridging the gap between the business, data analytics, and data engineering.

Senior Analytics Developers support our analyst community with robust, efficient, trustworthy data models and analytical best practices. The role will contribute to developing, optimizing and maintaining our data lake infrastructure, ensuring data is accessible, accurate, documented, and primed for business insights. This is a hands-on technical role designed for someone who is passionate about data and eager to learn and grow in a fast-paced environment.

Note: This section has been reformatted for clarity. Salary guidance previously stated in the original description has been preserved if applicable; exact salary ranges should be confirmed with the employer.

What You’ll Need to be Successful

Must Have

• 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.

Desired Skills (but not required)

• Experience with modern cloud BI tools (e.g., Tableau, ThoughtSpot, Looker)
• Experience with the data lake medallion architecture (bronze, silver, gold or stage, ODS, Analytic)

Education

• Bachelor’s or Master’s degree in Computer Science, Information Systems, or a related field preferred.

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.

What SOCi Provides to You

• Comprehensive Benefits Package (full-time permanent, non-contract roles only)
• Health insurance plans, dental, and vision
• Wellness incentives
• 401(k) plan with employer match
• Flexible Work Environment (full-time, non-contract roles only)
• Flexible paid time off
• Quarterly wellness days
• Paid holidays
• Empowering Career Growth and Success

Equal Opportunity

SOCi is an Equal Opportunity/Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex including sexual orientation and gender identity, national origin, disability, protected Veteran Status, or any other characteristic protected by applicable federal, state, or local law. Please note that if selected for a position at SOCi, you will be required to complete an E-Verify check to confirm your eligibility to work in the United States (if applicable).

About SOCi

SOCi is the leader in AI-powered marketing solutions for multi-location businesses. With its proprietary Genius AI™ and suite of Genius Agents™, SOCi provides a first-of-its-kind, AI-powered digital workforce capable of handling the workload of 1,000 local marketers™, empowering brands to achieve unmatched digital visibility, strengthen customer engagement, and scale faster than ever before.

This description retains the core responsibilities and qualifications and focuses on the job-relevant information while removing extraneous application form content. The final job description should be reviewed to ensure it conforms to internal policy before publishing.