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.
Marketing Data Analytics Engineer building Salesforce, Marketo, and warehouse pipelines for PointClickCare’s healthcare analytics platform. Automating campaign reporting and supporting marketing - sourced pipeline insights.
Senior Analytics Engineer designing Lime’s finance - grade data warehouse and semantic layer. Ensuring governed, audit - ready reporting for the global shared micromobility business.
Analytics Engineer building Snowflake and dbt data platforms for Tucows’ Internet businesses. Applying AI, SQL, Looker, and Python to drive data - informed decisions.
Senior Analytics Engineer designing financial, GTM, and product data models for Lightspeed’s cloud commerce platform. Owning pipelines, documentation, and analytics foundations used across the business.
Senior Analytics Engineer building scalable data pipelines and AI - native analytics foundations at Mercury, a fintech company. Supporting agentic tooling, self - service analytics, governance, and data products.
Senior Business Systems Analyst modernizing Boeing Canada’s defence sustainment systems and cloud data platforms. Translating mission needs into requirements, analytics, integrations, and reporting solutions.
Senior Analytics Engineer building GTM pipelines, metrics, dashboards, and AI data tools. Supporting Motive’s platform for safer, more productive physical operations.
Data Analytics Engineer building trusted SQL data systems for Toptal, a global talent network. Owning transformation, governance, warehousing, and AI - enabled analytics foundations.
Analytics Engineer building dbt models, AI - ready datasets, and Tableau reporting for Movable Ink’s content personalization platform. Translating stakeholder needs into trusted metrics and business intelligence.