Senior Analytics Developer

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)
• Cost Optimization in Cloud SQL Databases

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.