Analytics Engineer: Build Trusted Enterprise Data Assets

Socket.dev; Canada; Remote; CAD 110,000 - 165,000; Full time

Benefits offered by this job

Healthcare

Disability insurance

Life insurance

Job summary

Ciklum in Canada is seeking an Analytics Engineer to construct foundational data assets and scalable analytics pipelines. You will partner with stakeholders to translate business needs into reliable data logic and production-ready data sets that underpin enterprise insights.

You will collaborate with data engineering teams to ensure governance, scalability, and maintainability of analytics assets across the organization.

Qualifications

• Bachelor's or Master's degree in Computer Science, Data Science, Analytics, or a related field.
• 4+ years of experience in data engineering, analytics engineering, or related fields, with a track record of building large-scale data assets.
• Expertise in SQL for querying and data transformation.
• Strong programming skills in Python for data manipulation, automation, and building data pipelines (Pandas, NumPy, PySpark preferred).
• Experience with cloud data platforms such as Snowflake, BigQuery, or AWS Redshift, including cloud-native tools for data integration and transformation.
• Experience with ETL or orchestration tools such as Airflow for managing DAGs.
• Familiarity with data modeling concepts like star/snowflake schemas and building logical/physical data models for analytics.
• Experience with version control systems like Git.
• Proficiency with BI tools such as Tableau, Looker, or Power BI for dashboarding and data visualization.
• Experience with alerting/monitoring tools like Datadog, PagerDuty, or Grafana for pipeline health.
• Familiarity with CI/CD pipelines and DevOps practices in data engineering context.
• Experience with data governance and data quality frameworks.
• Strong understanding of analytics workflows, data lineage, and data cataloging tools (e.g., Alation, Collibra).

Responsibilities

• Build Enterprise Data Assets from scratch, focusing on foundational analytics assets that serve universal business purposes.
• Enable robust and extensible analytics by establishing widely accepted data logic that serves as a single source of truth.
• Set analytics requirements by collaborating with business stakeholders to capture data needs.
• Translate domain expertise into data logic for new data sets.
• Productionalize data sets and deploy v1 datasets to enable immediate business insights while ensuring scalability.
• Implement alerting and monitoring to ensure data sets are healthy and issues are addressed promptly.
• Support external reporting by developing and testing reporting data sets.
• Assist change management by accommodating upstream data changes (e.g., claims rewrite, coupon migration).

Skills

SQL

Python

Data pipelines

Data modeling

Git

BI tools

Education

Bachelor's or Master's degree in Computer Science, Data Science, Analytics, or related field

Tools

Snowflake

BigQuery

AWS Redshift

Airflow

Git

Tableau

Looker

Power BI

Job description

Ciklum in Canada is seeking an Analytics Engineer to construct foundational data assets and scalable analytics pipelines. You will partner with stakeholders to translate business needs into reliable data logic and production-ready data sets that underpin enterprise insights.

You will collaborate with data engineering teams to ensure governance, scalability, and maintainability of analytics assets across the organization.