Find your next opportunity

Job details

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. Your focus 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’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 proven track record of building and maintaining 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. Experience with frameworks like Pandas, NumPy, and PySpark is preferred * Experience with cloud data platforms such as Snowflake, BigQuery, or AWS Redshift, including working with cloud-native tools for data integration and transformation * Experience with ETL orchestration tools such as Airflow for managing and scheduling DAGs, ensuring that workflows are efficient, reliable, and scalable * Familiarity with data modeling concepts such as star/snowflake schemas and building logical and physical data models for analytics use cases * Experience working with version control systems like Git for collaboration and maintaining code integrity * Proficiency with BI tools such as Tableau, Looker, or Power BI for dashboarding and data visualization * Experience with alerting and monitoring tools like Datadog, PagerDuty, or Grafana for ensuring data pipeline health and resolving issues proactively. * Familiarity with CI/CD pipelines and experience with DevOps practices in a data engineering context * Experience working with data governance and data quality frameworks to ensure compliance and accuracy of enterprise data * Strong understanding of analytics workflows, from data collection to processing and analysis, with experience in data lineage and data cataloging tools (e.g., Alation, Collibra) * Excellent problem-solving and communication skills, with the ability to navigate complex business needs and translate them into technical requirements Desirable: * Experience in the healthcare, health-tech, or similar industries, with exposure to working with healthcare data (e.g., claims, EHR, or HCP data) * Familiarity with agile development methodologies and working in cross-functional teams * Prior experience working with diverse data types, including event data, transactional data, and marketing 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! Interested already? We would love to get to know you! Submit your application. We can’t wait to see you at Ciklum. #LI-AV3

What you’ll do

The Analytics Engineer will lead the creation of enterprise data assets from scratch, transforming raw data into reliable sources of truth for strategic decision-making. They will collaborate with stakeholders to define data requirements, build scalable pipelines, and ensure effective monitoring and maintenance of data sets.

Requirements

Candidates must hold a Bachelor’s or Master’s degree in a relevant field and possess at least 4 years of experience in data or analytics engineering. Proficiency in SQL, Python, cloud data platforms, and ETL orchestration tools is essential for this role.

Benefits

• Healthcare • Basic Life Insurance • Short-term disability insurance • Long-term disability insurance • Udemy access • Language courses • Company-paid certifications

Listed skills

• SQL · Preferred
• Python · Preferred
• Git · Preferred
• Tableau · Preferred
• Power BI · Preferred
• CI/CD · Preferred

Other relevant skills

Identified from the job description. Confirm important requirements above.

• SQL
• Python
• Pandas
• NumPy
• PySpark
• Snowflake
• BigQuery
• AWS Redshift
• Airflow
• Data modeling
• Git
• Tableau
• Looker
• Power BI
• Datadog
• CI/CD
• Cloud-Native Computing
• Pipelines
• PagerDuty
• Strategic Decision Making
• External Reporting
• Alation Data Catalog
• Workflow Management
• Snowflake Schema
• Apache Airflow
• Git (Version Control System)
• Technical Requirements
• Snowflake (Data Warehouse)
• Collibra (Software)
• Data Lineage
• Data Types
• Agile Methodology
• Amazon Web Services
• Business Logic
• Automation
• Business Intelligence
• Google BigQuery
• Boost (C++ Libraries)
• Medical Records
• Change Management
• Decision Making
• Version Control
• Communication
• Computer Science
• Computational Logic
• Directed Acyclic Graph (Directed Graphs)
• Data Engineering
• Data Governance
• Data Integration
• Extract Transform Load (ETL)

Job areas

• Data & Analytics
• Technology
• Software
• Engineering
• Consulting
• Analytics Engineer
• Data Engineer
• Software Developers
• Database Administrators