Senior Analytics Developer

SOCi, Inc.; British Columbia; Hybrid; CAD 82,000 - 151,000; Full time

Job summary

A leading technology company is seeking a Senior Analytics Developer to lead the development of data pipelines and analytic products. This role involves collaborating with business teams and ensuring data accuracy in a hybrid work environment. The ideal candidate will have extensive experience with cloud-based data engineering platforms and SQL proficiency. Join a fast-paced team and contribute to innovative data solutions that empower brands.

Benefits

Comprehensive Benefits Package

Health insurance plans

401(k) plan with employer match

Flexible Work Environment

Flexible paid time off

Quarterly wellness days

Paid holidays

Qualifications

• 5+ years of experience with cloud-based data engineering platforms.
• Expert-level proficiency in SQL and hands-on experience with data warehouse platforms.
• Strong knowledge of data modeling and governance principles.

Responsibilities

• Own relationships with business team stakeholders for data solutions.
• Develop and maintain data pipelines and transformations.
• Ensure data accuracy and quality through monitoring processes.

Skills

SQL

Data Modeling

Data Governance

Python

Java

Education

Bachelor’s or Master’s degree in Computer Science

Tools

Airflow

FiveTran

Snowflake

Redshift

BigQuery

Tableau

Looker

Job description

SOCi, the CoMarketing Cloud for Multi-Location Enterprises, is currently looking for an experienced Senior Analytics Developer to lead 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.

Senor Analytic 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.

SOCi expects to pay a base salary in the range of $82,000 - $151,000 CAD base plus bonus. Within the range, individual pay is determined by factors such as job-related skills, experience, and relevant education or training.

Who We Are

SOCi is one of the fastest growing technology companies in the United States, ranking on the Inc. 5000 Fastest Growing Companies in America list for the last seven consecutive years. The leader in AI-powered marketing solutions for multi-location businesses, SOCi is trusted by nearly 1,000 top brands including Ford, Ace Hardware, Kumon, Liberty Tax, and more. At SOCi, our vision is to empower people to do what they love by providing intelligent software that can do the rest. 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. View more on our Awards & Accolades here !

How You’ll Make an Impact

• 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 Engineers.
• Be willing to adapt to changes in the job description as necessary by the business and accept all other duties as assigned

What You’ll Need to be Successful

• Hybrid Opportunity : This role is fully remote until our Vancouver, BC office is established. Once the office is in place, it will transition to a hybrid model, with a 50 / 50 split between remote and in-office work.

Must Have :

• 5+ years of experience working with cloud based data engineering 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 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.
• Proficiency in programming languages such as Python or Java.
• 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.

This position will remain open with applications due by June 5, 2025. This position is being hired on an urgent basis. The application window may close before June 5, 2025 if SOCi receives a sufficient number of applications to select a candidate prior to that date.

What SOCi Provides to You

• Comprehensive Benefits Package (full-time, 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

What’s Important at SOCi

Led by a team of industry experts, SOCi is leading the pack in Localized Marketing for Multi-Location brands. Our passionate team of SOCialites work from home around the globe!

Our collaborative, dynamic culture allows our teams to work cross-functionally and optimize productivity. We are a fast-paced, agile environment where thought leadership and input are encouraged. If you are looking for a place where you can come and make a difference in the way enterprise organizations utilize social technology, then SOCi is for you. Visit soci.ai for more information.

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

Apply for this job

indicates a required field

First Name

Last Name

Preferred First Name

Email

Phone

Resume / CV

Enter manually

Accepted file types : pdf, doc, docx, txt, rtf

Enter manually

Accepted file types : pdf, doc, docx, txt, rtf

LinkedIn Profile

Website

Are you legally authorized to work in the country where this job is posted?

• Select...

Will you now or in the future require sponsorship for an employment visa?

• Select...

What are your compensation expectations? Please provide a range.

If you were referred to SOCi by a current employee, please list their name here.

Voluntary Self-Identification

For government reporting purposes, we ask candidates to respond to the below self-identification survey.Completion of the form is entirely voluntary. Whatever your decision, it will not be considered in the hiringprocess or thereafter. Any information that you do provide will be recorded and maintained in aconfidential file.

As set forth in SOCi’s Equal Employment Opportunity policy,we do not discriminate on the basis of any protected group status under any applicable law.

If you believe you belong to any of the categories of protected veterans listed below, please indicate by making the appropriate selection.As a government contractor subject to the Vietnam Era Veterans Readjustment Assistance Act (VEVRAA), we request this information in order to measurethe effectiveness of the outreach and positive recruitment efforts we undertake pursuant to VEVRAA. Classification of protected categoriesis as follows :

A "disabled veteran" is one of the following : a veteran of the U.S. military, ground, naval or air service who is entitled to compensation (or who but for the receipt of military retired pay would be entitled to compensation) under laws administered by the Secretary of Veterans Affairs; or a person who was discharged or released from active duty because of a service-connected disability.

A "recently separated veteran" means any veteran during the three-year period beginning on the date of such veteran's discharge or release from active duty in the U.S. military, ground, naval, or air service.

An "active duty wartime or campaign badge veteran" means a veteran who served on active duty in the U.S. military, ground, naval or air service during a war, or in a campaign or expedition for which a campaign badge has been authorized under the laws administered by the Department of Defense.

An "Armed forces service medal veteran" means a veteran who, while serving on active duty in the U.S. military, ground, naval or air service, participated in a United States military operation for which an Armed Forces service medal was awarded pursuant to Executive Order 12985.

Select...

Voluntary Self-Identification of Disability

Form CC-305

Page 1 of 1

OMB Control Number 1250-0005

Expires 04 / 30 / 2026

Voluntary Self-Identification of Disability

Form CC-305 Page 1 of 1 OMB Control Number 1250-0005 Expires 04 / 30 / 2026

Why are you being asked to complete this form?

We are a federal contractor or subcontractor. The law requires us to provide equal employment opportunity to qualified people with disabilities. We have a goal of having at least 7% of our workers as people with disabilities. The law says we must measure our progress towards this goal. To do this, we must ask applicants and employees if they have a disability or have ever had one. People can become disabled, so we need to ask this question at least every five years.

Completing this form is voluntary, and we hope that you will choose to do so. Your answer is confidential. No one who makes hiring decisions will see it. Your decision to complete the form and your answer will not harm you in any way. If you want to learn more about the law or this form, visit the U.S. Department of Labor’s Office of Federal Contract Compliance Programs (OFCCP) website at www.dol.gov / ofccp .

How do you know if you have a disability?

A disability is a condition that substantially limits one or more of your “major life activities.” If you have or have ever had such a condition, you are a person with a disability. Disabilities include, but are not limited to :

• Alcohol or other substance use disorder (not currently using drugs illegally)
• Blind or low vision
• Cancer (past or present)
• Cardiovascular or heart disease
• Celiac disease
• Cerebral palsy
• Deaf or serious difficulty hearing
• Diabetes
• Disfigurement, for example, disfigurement caused by burns, wounds, accidents, or congenital disorders
• Epilepsy or other seizure disorder
• Gastrointestinal disorders, for example, Crohn's Disease, irritable bowel syndrome
• Mental health conditions, for example, depression, bipolar disorder, anxiety disorder, schizophrenia, PTSD
• Missing limbs or partially missing limbs
• Mobility impairment, benefiting from the use of a wheelchair, scooter, walker, leg brace(s) and / or other supports
• Nervous system condition, for example, migraine headaches, Parkinson’s disease, multiple sclerosis (MS)
• Neurodivergence, for example, attention-deficit / hyperactivity disorder (ADHD), autism spectrum disorder, dyslexia, dyspraxia, other learning disabilities
• Partial or complete paralysis (any cause)
• Pulmonary or respiratory conditions, for example, tuberculosis, asthma, emphysema

Disability Status Select...

PUBLIC BURDEN STATEMENT : According to the Paperwork Reduction Act of 1995 no persons are required to respond to a collection of information unless such collection displays a valid OMB control number. This survey should take about 5 minutes to complete.