Analytics Engineer

Socket.dev; Canada; On-site; 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 is looking for an Analytics Engineer to join our team full-time in Canada.

We are a custom product engineering company that supports both multinational organizations and scaling startups to solve their most complex business challenges. With a global team of over 4,000 highly skilled developers, consultants, analysts and product owners, we engineer technology that redefines industries and shapes the way people live.

About the role:

As an Analytics Engineer, you will be at the forefront of transforming raw data into reliable enterprise data assets that enable strategic decision‑making across the organization. Yourfocus will be building and productionalizing new Subscriptions data sets from the ground up, ensuring they support universal analytics needs for critical aspects of the business. You will collaborate closely with stakeholders to understand business needs, translate domain expertise into actionable data logic, and help shape the future of data-driven insights at scale. This role requires deep technical expertise in analytics engineering, a keen understanding of stakeholder needs, and the ability to drive alignment on data sets that serve as the single source of truth. You will support the creation and initial operationalization of data pipelines, while ensuring smooth transitions to long‑term ownership by data engineering teams.

What Success Looks Like:

• Clarity & Trust: You have built data sets that are trusted across the organization, enabling consistent, high-quality insights
• Efficiency Gains: Your work has reduced time to insights, enabling faster decision‑making and saving analytics resources
• Scalability & Extensibility: The data assets you create are scalable and flexible, ready to adapt to future needs without major rework
• Cross-functional Alignment: You've driven alignment between business, data, and engineering teams, ensuring that data logic is both widely accepted and operationally feasible

Responsibilities:

• Build Enterprise Data Assets (0 → 1): Lead efforts to create new data sets from scratch, focusing on foundational analytics assets that serve universal business purposes
• Enable Robust & Extensible Analytics: Establish widely accepted logic for critical data sets, driving alignment on a single source of truth that reduces confusion, rework, and analytical overhead
• Set Analytics Requirements: Collaborate with business stakeholders to capture data requirements, ensuring that new data assets are both fit for purpose and future‑proof
• Translate Domain Expertise into Data Logic: Work with domain experts to convert their knowledge into computational logic that underpins new data sets
• Productionalize Data Sets: Build and deploy v1 data sets in a way that allows the business to benefit immediately from their insights, while ensuring scalability and maintainability
• Alerting & Monitoring: Implement alerting mechanisms to ensure that data sets are monitored effectively, with issues flagged to appropriate teams for timely resolution
• External Reporting Support: Enable data exports to external parties by supporting development and testing of reporting data sets
• Change Management Support: Help stakeholders manage changes to business logic and analytics requirements, especially when upstream data sets evolve (e.g., claim rewrite, coupon migration)

Requirements:

• Bachelor'sorMaster'sdegreeinComputerScience,DataScience,Analytics,ora related field
• 4+yearsofexperienceindataengineering,analyticsengineering,orrelatedfields,with a proven track record of building and maintaining large-scale data assets
• ExpertiseinSQLforqueryinganddatatransformation
• StrongprogrammingskillsinPythonfordatamanipulation,automation,andbuilding data pipelines. Experience with frameworks likePandas,NumPy, andPySpark is preferred
• ExperiencewithclouddataplatformssuchasSnowflake,BigQuery,orAWS Redshift, including working with cloud-native tools for data integration and transformation
• ExperiencewithETLorchestrationtoolssuchasAirflowformanagingandscheduling DAGs, ensuring that workflows are efficient, reliable, and scalable
• Familiaritywithdatamodelingconceptssuchasstar/snowflakeschemasandbuilding logical and physical data models for analytics use cases
• ExperienceworkingwithversioncontrolsystemslikeGitforcollaborationand maintaining code integrity
• ProficiencywithBItoolssuchasTableau,Looker,orPowerBIfordashboardingand data visualization
• ExperiencewithalertingandmonitoringtoolslikeDatadog,PagerDuty,orGrafana forensuringdatapipelinehealthandresolvingissuesproactively.
• FamiliaritywithCI/CDpipelinesandexperiencewithDevOpspracticesinadata engineering context
• Experienceworkingwithdatagovernanceanddataqualityframeworkstoensure compliance and accuracy of enterprise data
• Strongunderstandingofanalyticsworkflows,fromdatacollectiontoprocessingand analysis,with experience indata lineageanddata catalogingtools (e.g.,Alation,Collibra)
• Excellentproblem-solvingandcommunicationskills,withtheabilitytonavigatecomplex business needs and translate them into technical requirements

Desirable:

• Experienceinthehealthcare,health-tech,orsimilarindustries,withexposuretoworking withhealthcare data(e.g., claims, EHR, or HCP data)
• Familiaritywithagiledevelopmentmethodologiesandworkingincross-functional teams
• Priorexperienceworkingwithdiversedatatypes,includingeventdata,transactional data, andmarketing data

What's in it for you:

• Strong community: Work alongside top professionals in a friendly, open-door environment
• Growth focus: Take on large-scale projects with a global impact and expand your expertise
• Tailored learning: Boost your skills with internal events (meetups, conferences, workshops), Udemy access, language courses, and company-paid certifications
• Endless opportunities: Explore diverse domains through internal mobility, finding the best fit to gain hands‑on experience with cutting‑edge technologies
• Care: Healthcare, Basic Life Insurance, Short and Long‑term disability insurance according to the Company's Benefit Plans

About us:

At Ciklum, we are always exploring innovations, empowering each other to achieve more, and engineering solutions that matter. With us, you'll work with cutting-edge technologies, contribute to impactful projects, and be part of a One Team culture that values collaboration and progress. Now expanding across Canada, we're looking for talented professionals to strengthen our North American footprint. Join us to innovate at scale and deliver world‑class solutions to global clients.

Explore, empower, engineer with Ciklum!