Job Description:Data Architect Snowflake AWS and DBTLocation Canada Client location Markham OfficeWorking model Hybrid 3 days Work From Office 2 days mandatory Tue Wed 1 day flexible any day from Mon Thu FriPrimary SkillsArchitect and implement advanced data solutions using Snowflake on AWS ensuring scalable secure and highperformance data environmentsExtensive experience in data architecture and engineering with a proven track record in largescale data transformation programs ideally in insurance or financial servicesProven experience in architecting and implementing advanced data solutions using Snowflake DBT on AWSProven experience in DBT to manage and automate complex data transformations within Snowflake ensuring modular testable and versioncontrolled transformation logicExperience in implementing the lake house solution Medallion architecture for financial or insurance carriersExpertise in design and orchestrating data acquisition pipelines using Snowflake OpenFlow and Apache Airflow for workflow automation enabling seamless ingestion of different data from diverse sourcesDeep expertise in Snowflake with handson experience delivering Snowflake as an enterprise capabilityProficiency in SQL data modelling ETLELT processesExperience in optimizing and tune Snowflake environments for performance cost and scalability including query optimization and resource managementExperience in architectinglead migration of workloads from Cloudera to SnowflakeExperience in evaluating the data technology platform including data governance suites data security productsDevelop robust data models and data pipelines to support data transformation integrating multiple data sources and ensuring data quality and integrityDocument architecture data flows and transformation logic to ensure transparency maintainability and knowledge sharing across teamsStrong knowledge of data lifecycle mgmt data retention data modelling and working knowledge of cloud computing and modern development practicesSecondary SkillsFamiliarity with data mesh principles data product delivery and modern datawarehousing paradigmsExperience in Designing Streamlit apps and define new capabilities and data productsleveraging snowflake ML and MLOPS capabilitiesSnowPro advanced certification preferredKnowledge of scripting languages PythonJavaExperience in Insurance DomainSoft SkillsExcellent written and verbal communication skills experience working with crossfunctional teams and presenting to leadershipStrong ability to work with client stakeholdersSkills:Mandatory Skills : SnowflakeAbout Company:LTM is an AI-centric global technology services company and the Business Creativity partner to the world’s largest and most disruptive enterprises. We bring human insights and intelligent systems together to help clients create greater value at the intersection of technology and domain expertise. Our capabilities span integrated operations, transformation, and business AI — enabling new ways of working, new productivity paradigms, and new roads to value. Together with over 87,000 employees across 40 countries and our global network of partners, LTM — a Larsen & Toubro company — owns business outcomes for our clients, helping them not just outperform the market, but to Outcreate it. Please also note that neither LTM nor any of its authorized recruitment agencies/partners charge any candidate registration fee or any other fees from talent (candidates) towards appearing for an interview or securing employment/internship. Candidates shall be solely responsible for verifying the credentials of any agency/consultant that claims to be working with LTM for recruitment. Please note that anyone who relies on the representations made by fraudulent employment agencies does so at their own risk, and LTM disclaims any liability in case of loss or damage suffered as a consequence of the same. Recruitment Fraud Alert - https://www.ltimindtree.com/recruitment-fraud-alert/
