Snowflake Data Engineer

4 weeks ago

Toronto, Ontario, Canada ZS Full time

Transforming Global Healthcare and Beyond

ZS is a management consulting and technology firm that empowers its employees to shape solutions from start to finish. As a Snowflake Data Engineer, you will work closely with leads to develop and maintain a right-sized data catalog and data lineage for commercial and medical affairs applications.

Key Responsibilities:

  • Partner with leads to ensure a clear understanding of business and technical needs, assisting in selecting the best strategy and translating them into effective data solutions.
  • Design and implement solutions in Snowflake/Matillion/DBT using industry-leading best practices for life sciences data, ensuring optimal performance, efficient operations, security, and compliance with regulatory standards.
  • Work closely with leads to develop and maintain a right-sized data catalog and data lineage for commercial and medical affairs applications.
  • Identify, test, and prototype solutions, supporting testing teams with identifying the optimal test strategy.
  • Get reviews on designs to ensure consistency with architectural best practices, participate in regular implementation reviews to ensure consistent quality and adherence with standards.
  • Work in an agile team to implement data quality checks, set up process orchestrations, mitigate vulnerabilities, devise testing strategies, and automate repeatable tasks, participating and assisting in root cause analysis activities.

Requirements:

  • 2-5 years of data engineering experience with a proven track record in ETL, data modeling, data warehouse design, development, and ingesting data from diverse data sources using Matillion and Snowflake technologies.
  • Hands-on experience developing and optimizing within the Snowflake cloud data warehouse environment, with Snowpro certification a plus.
  • Advanced-level SQL/Matillion/DBT programming skills with the ability to perform ELT optimization for performance, knowledge/experience with cloud technologies (Lambda, S3, AWS policies, etc.) and Python programming.
  • Ability to handle end-to-end Matillion/Snowflake ETL process integrations, customization, and deployment of solutions that serve as the source of truth for reports, dashboards, and data visualizations.
  • Experience in defining and implementing quality standards for ELT, SQL, Snowflake, and DBT, as well as documenting and training other teammates on these standards.
  • Experience working in agile teams with short release cycles and possessing strong verbal, written, and team presentation communication skills.
  • Data-driven mindset with high analytical capability, with a history of leveraging data and analytical techniques to optimize business decisions.

Additional Skills:

  • Understanding of the pharmaceutical domain, with experience in analyzing and working with patient data, call activity data from CRM systems, and marketing data such as web traffic, email campaign metrics, and consent management.
  • Experience in data aggregation of channel sales (SP/SD) data, 3PL data, etc.
  • Experience in working with data from Veeva CRM, Marketing CRM, Salesforce ServiceCloud, and HealthCloud.

Perks and Benefits:

ZS offers a comprehensive total rewards package, including health and well-being, financial planning, annual leave, personal growth, and professional development. Our robust skills development programs, multiple career progression options, and internal mobility paths, as well as our collaborative culture, empower you to thrive as an individual and global team member.

We are committed to giving our employees a flexible and connected way of working. A flexible and connected ZS allows us to combine work from home and on-site presence at clients/ZS offices for the majority of our week. The magic of ZS culture and innovation thrives in both planned and spontaneous face-to-face connections.

  • Sr. Snowflake Data Engineer

    4 weeks ago

    Toronto, Ontario, C6A, Ontario, Canada State Street Full time

    Who we are looking forThe candidate must have more than 7+ years of experience in IT. This role is for a Snowflake Data Engineer with strong experience in design/data modeling/development & performance tuning. Candidate will be working on building Cloud based DW solutions for F2B clients.What you will be responsible forAs Snowflake Data Engineer you...

  • Senior Snowflake Developer

    4 weeks ago

    Toronto, Ontario, Canada Astra North Infoteck Inc. Full time

    Job Title: Senior Snowflake DeveloperJob Summary:Astra North Infoteck Inc. is seeking a highly skilled Senior Snowflake Developer to join our team. As a key member of our data engineering team, you will be responsible for designing, implementing, and maintaining large-scale data pipelines using Snowflake.Key Responsibilities:• Design and develop complex...

  • Senior Snowflake Developer

    4 weeks ago

    Toronto, Ontario, Canada Astra North Infoteck Inc. Full time

    Astra North Infoteck Inc. is seeking a highly skilled Snowflake Developer to join our team. As a key member of our data engineering team, you will be responsible for designing, implementing, and maintaining large-scale data pipelines using Snowflake and Python.Key Responsibilities:Design and implement data pipelines using Snowflake and PythonDevelop and...

  • Data Engineer

    1 month ago

    Toronto, Ontario, Canada NTT DATA Services Full time

    Job Summary:We are seeking a highly skilled Staff Data Engineer with expertise in Google Cloud Platform to join our Data Intelligence team. The ideal candidate will be a growth-minded, adaptable, and collaborative individual with a strong background in designing and implementing tailored data solutions.Key Responsibilities:Provide thought leadership in...

  • Data Engineering Lead

    4 weeks ago

    Toronto, Ontario, Canada World Education Services Full time

    Job Summary:The Data Engineering Lead will be responsible for designing, developing, and maintaining our data architecture, with a focus on Snowflake and ETL processes. The ideal candidate will have a deep background in data engineering, expertise with Snowflake's cloud data platform, and highly proficient in ETL tools and methodologies.Key...

  • Data Engineering Expert

    1 week ago

    Toronto, Ontario, Canada CI Financial Full time

    Job OverviewWe are seeking a talented Data Engineer to join our Data Analytics & Reporting team.Key Responsibilities:Develop and maintain internal data aggregation solutions leveraging Snowflake, AWS, and other platforms.Create automations that support the delivery of enriched data for consumption by various business functions across the enterprise.Build...

  • Data Engineering Leader

    4 weeks ago

    Toronto, Ontario, Canada Moneris Full time

    About This RoleWe are seeking an experienced Data Engineer to join our team at Moneris. As a key member of our data engineering team, you will be responsible for designing and developing scalable data solutions that support our data-driven decision-making process.Key ResponsibilitiesDesign and develop data pipelines using Snowflake for efficient data...

  • Data Engineer Lead

    1 week ago

    Toronto, Ontario, Canada Moneris Full time

    Unlock Your Potential as a Senior Data EngineerWe are seeking an experienced Senior Data Engineer to join our dynamic team at Moneris. As a key member of our data-driven decision-making process, you will design and develop scalable data solutions using Snowflake and Databricks.About the Role: You will be responsible for building efficient data pipelines,...

  • Data Engineering Lead

    2 weeks ago

    Toronto, Ontario, Canada Lorven Technologies Full time

    About Lorven TechnologiesWe are a leading technology firm based in Ontario, Canada.Salary:$125,000 - $180,000 per yearJob DescriptionWe are seeking an experienced Data Engineer to lead our big data team.Key ResponsibilitiesDesign and implement scalable big data solutions using Scala, Java, Hive, HDFS, Unix shell scripting, SQL, and Snowflake.Develop and...

  • Senior Data Engineer

    4 weeks ago

    Toronto, Ontario, Canada Moneris Full time

    Your Moneris Career - The OpportunityWe are seeking a highly skilled Senior Data Engineer to join our team. As a key member of our data engineering team, you will be responsible for designing and developing scalable data solutions to support our data-driven decision-making.Key Responsibilities:Design and develop data pipelines using Snowflake for efficient...

  • Data Engineer for Cloud Data Warehouse

    2 weeks ago

    Toronto, Ontario, Canada Lyons Consulting Group Full time

    Job OverviewSr. Data Engineer - Cloud Data WarehouseAbout the RoleWe are seeking an experienced Sr. Data Engineer to join our team at Lyons Consulting Group. As a key member of our cloud data warehouse team, you will be responsible for designing, building, and maintaining scalable data pipelines to support our clients' business needs.The ideal candidate will...

  • Data Engineer

    3 weeks ago

    Toronto, Ontario, Canada Equest Full time

    Data Engineer PositionWe are seeking a highly skilled Data Engineer to expand and increase our data and data pipeline architecture and optimize data flow and collection for teams. The ideal candidate will have experience in developing and following structured work processes in data engineering and have a strong background in data integration tools, SQL,...

  • Data Engineering Leader for Large Scale Data Solutions

    2 weeks ago

    Toronto, Ontario, Canada Royal Bank of Canada Full time

    About the OpportunityWe are seeking an experienced Data Engineer to lead the development of large scale data solutions. Reporting to the Associate Director, this role will focus on building highly scalable data ingestion products, developing and deploying data pipelines, and ensuring the smooth operation of our data pipelines.Key Responsibilities: Transform...

  • Data Engineering Expert

    2 weeks ago

    Toronto, Ontario, Canada Tiger Analytics Full time

    Data Engineer Position at Tiger AnalyticsTiger Analytics is a fast-growing advanced analytics consulting firm. We are the trusted analytics partner for several Fortune 100 companies, enabling them to generate business value from data.Our team seeks an experienced Data Engineer with expertise in Dataiku to design, build, and maintain data pipelines,...

  • Data Architect

    1 month ago

    Toronto, Ontario, Canada Tiger Analytics Full time

    Tiger Analytics: Pioneering AI and Analytics SolutionsWe are a leading provider of bespoke data and analytics solutions, empowering organizations to tackle complex business challenges. Our team of experts is passionate about harnessing the power of data to drive innovation and growth.Job SummaryWe are seeking an experienced Data Architect to join our team...

  • Strategic Data Analytics Manager

    2 weeks ago

    Toronto, Ontario, Canada NTT DATA Services Full time

    Job Summary:NTT DATA Services is seeking a Strategic Data Analytics Manager to remotely join our team in or near Toronto, Ontario, Canada.We are looking for a seasoned data professional with Google Cloud Platform expertise to lead our Data Intelligence team. The ideal candidate is an intellectually curious and growth-minded individual who excels in...

  • Chief Data Analytics Strategist

    3 weeks ago

    Toronto, Ontario, Canada NTT DATA Full time

    Job Title: Chief Data Analytics StrategistJob Summary:NTT DATA is seeking a Chief Data Analytics Strategist to design and implement tailored data solutions that meet customer needs and use cases. The ideal candidate will have expertise in Google Cloud Platform and a proven track record of success in developing and delivering detailed presentations to...

  • Data Engineering Specialist

    4 weeks ago

    Toronto, Ontario, Canada Tiger Analytics Full time

    Tiger Analytics is a leading advanced analytics consulting firm that empowers Fortune 100 companies to generate business value from data. Our team of experts brings deep expertise in Data Science, Machine Learning, and AI, making us the trusted analytics partner for several top companies.We are seeking an experienced Data Engineer with expertise in Dataiku...

  • Data Engineer

    4 weeks ago

    Toronto, Ontario, Canada Capgemini Full time

    Job Title: Data Engineer - Cloud Data Warehouse ExpertJob Summary:We are seeking a highly skilled Data Engineer to join our team at Capgemini. As a Data Engineer, you will be responsible for designing, building, and maintaining large-scale data pipelines using cloud-based technologies. Your expertise in cloud data warehousing and data engineering will enable...

  • Senior Data Engineering Specialist

    2 weeks ago

    Toronto, Ontario, Canada Capgemini Full time

    Job Title: Medallia DeveloperKey ResponsibilitiesDesign and implement data engineering solutions using ETL and data warehousing techniques.Configure and manage Medallia Voice of Customer Platform for survey creation and executive dashboard development.Develop and maintain data flows from Medallia to Enterprise Data Lake.Collaborate with the design team to...