Tredence
Salesforce Data Cloud + Snowflake Developer

Rate - $65 -$80 CAD

Location Canada

Duration 6 months Possibility for extension

About:

Tredence is seeking a skilled Salesforce Data Cloud to join our team. As a Salesforce Data Cloud Developer with Snowflake expertise, you will be responsible for building and maintaining solutions within Salesforce Data Cloud (formerly Salesforce CDP). A key focus will be on writing and optimizing Snowflake SQL queries and designing efficient data pipelines. You will work closely with solution architects and cross-functional teams to ensure that customer data is ingested, modeled, unified, and activated for personalized, real-time engagement.

Key Responsibilities:

  • Write, optimize, and troubleshoot SQL queries within the Snowflake environment, ensuring efficient data manipulation, transformation, and retrieval.
  • Design, develop, and implement Salesforce Data Cloud solutions to ingest and manage data from various sources, including web, mobile, Snowflake, and external systems.
  • Develop and optimize data pipelines between Salesforce Data Cloud and Snowflake, ensuring efficient data processing
  • Implement ETL/ELT processes using Snowflake to transform and load data from various sources, ensuring data integrity and quality.
  • Manage data partitioning, clustering, and materialized views within Snowflake to optimize query performance and storage costs.
  • Implement data ingestion pipelines using Salesforce Ingestion API and configure Web and Mobile SDKs to capture and sync customer interaction data.
  • Develop and maintain Data Model Objects (DMOs) and Data Lake Objects in Salesforce Data Cloud and Snowflake to efficiently store and organize customer data.
  • Build and configure Identity Resolution (IDR) processes to unify customer profiles across multiple data sources and systems.
  • Create and deploy Calculated Insights to generate metrics and actionable insights that enhance customer profiles and segmentation.
  • Develop complex Segmentation logic to define audiences for marketing and customer engagement campaigns, based on behavior, demographics, and other key attributes.
  • Support the activation of customer segments across multiple marketing channels, working with Salesforce Marketing Cloud or other integrated platforms.
  • Ensure data flows seamlessly between Salesforce Data Cloud, Snowflake, and other external systems, ensuring data quality and integrity.

Qualifications:

  • 3+ years of hands-on experience developing solutions with Salesforce Data Cloud (formerly Salesforce CDP).
  • 2+ years of experience working with Snowflake, with a strong focus on writing and optimizing SQL queries in Snowflake.
  • Expertise in Snowflake's data sharing capabilities for secure and efficient data collaboration with internal and external stakeholders.
  • Proficiency in data modeling, working with Data Model Objects (DMOs) and Data Lake Objects in both Salesforce and Snowflake environments.
  • Experience building and optimizing ETL/ELT processes for data ingestion and transformation using Snowflake.
  • Expertise in Identity Resolution (IDR) and profile unification techniques to create single customer views.
  • Proven ability to implement Calculated Insights to derive actionable metrics from customer data.
  • Proficiency in designing and building Segmentation strategies to deliver personalized experiences.
  • Familiarity with Snowflake features like Time Travel, Cloning, and Zero-Copy Cloning
  • Familiarity with APIs and data integration tools such as MuleSoft or other middleware solutions.

Preferred Qualifications:

  • Certified Salesforce Data Cloud Consultant.
  • Expertise in Snowflake data architecture, query optimization, and performance tuning.
  • Experience in CPG industry or B2B environments with complex customer journeys.
  • Experience with Snowflake's data governance, compliance, and security best practices.
Apply Now Back to Results