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 insightsEfficiency Gains: Your work has reduced time to insights, enabling faster decision‐making and saving analytics resourcesScalability & Extensibility: The data assets you create are scalable and flexible, ready to adapt to future needs without major reworkCross-functional Alignment: You've driven alignment between business, data, and engineering teams, ensuring that data logic is both widely accepted and operationally feasibleResponsibilities:Build Enterprise Data Assets (0 → 1): Lead efforts to create new data sets from scratch, focusing on foundational analytics assets that serve universal business purposesEnable 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 overheadSet Analytics Requirements: Collaborate with business stakeholders to capture data requirements, ensuring that new data assets are both fit for purpose and future‐proofTranslate Domain Expertise into Data Logic: Work with domain experts to convert their knowledge into computational logic that underpins new data setsProductionalize 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 maintainabilityAlerting & Monitoring: Implement alerting mechanisms to ensure that data sets are monitored effectively, with issues flagged to appropriate teams for timely resolutionExternal Reporting Support: Enable data exports to external parties by supporting development and testing of reporting data setsChange 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 field4+yearsofexperienceindataengineering,analyticsengineering,orrelatedfields,with a proven track record of building and maintaining large-scale data assetsExpertiseinSQLforqueryinganddatatransformationStrongprogrammingskillsinPythonfordatamanipulation,automation,andbuilding data pipelines. Experience with frameworks likePandas,NumPy, andPySpark is preferredExperiencewithclouddataplatformssuchasSnowflake,BigQuery,orAWS Redshift, including working with cloud-native tools for data integration and transformationExperiencewithETLorchestrationtoolssuchasAirflowformanagingandscheduling DAGs, ensuring that workflows are productive, reliable,



and scalableFamiliaritywithdatamodelingconceptssuchasstar/snowflakeschemasandbuilding logical and physical data models for analytics use casesExperienceworkingwithversioncontrolsystemslikeGitforcollaborationand maintaining code integrityProficiencywithBItoolssuchasTableau,Looker,orPowerBIfordashboardingand data visualizationExperiencewithalertingandmonitoringtoolslikeDatadog,PagerDuty,orGrafana forensuringdatapipelinehealthandresolvingissuesproactively.FamiliaritywithCI/CDpipelinesandexperiencewithDevOpspracticesinadata engineering contextExperienceworkingwithdatagovernanceanddataqualityframeworkstoensure compliance and accuracy of enterprise dataStrongunderstandingofanalyticsworkflows,fromdatacollectiontoprocessingand analysis,with experience indata lineageanddata catalogingtools (e.G.,Alation,Collibra)Excellentproblem-solvingandcommunicationskills,withtheabilitytonavigatecomplex business needs and translate them into technical requirementsDesirable:Experienceinthehealthcare,health-tech,orsimilarindustries,withexposuretoworking withhealthcare data(e.G., claims, EHR, or HCP data)Familiaritywithagiledevelopmentmethodologiesandworkingincross-functional teamsPriorexperienceworkingwithdiversedatatypes,includingeventdata,transactional data, andmarketing dataWhat's in it for you:Strong community: Work alongside top professionals in a friendly, open-door environmentGrowth focus: Take on large-scale projects with a global impact and expand your expertiseTailored learning: Boost your skills with internal events (meetups, conferences, workshops), Udemy access, language courses, and company-paid certificationsEndless opportunities: Explore diverse domains through internal mobility, finding the best fit to gain hands‐on experience with cutting‐edge technologiesCare: Healthcare, Basic Life Insurance, Short and Long‐term disability insurance according to the Company's Benefit PlansAbout 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! #J-18808-Ljbffr

📌 Analytics Engineer (Ottawa)
🏢 Socket.dev
📍 Ottawa