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.