Customer Data Platform Engineer (Snowflake)
Infrastructure & Support Mount Laurel, NJ
Contract Mar 26, 2024
Infrastructure & Support
Overview:
Our client, a New Jersey based Technology Company, is seeking a Data Engineer focused in Marketing and Customer-centric data with deep Snowflake experience who is well versed in developing API’s to connect Marketing Systems to other critical systems and data sources throughout the organization. This position is a 12 month contract position and is 100% remote. The Data Engineer is responsible for designing, building, and maintaining the infrastructure and systems that enable data collection, storage, processing, and analysis within the company.
Summary: We are seeking a talented and experienced Data Engineer to join the team. As a Data Engineer you will work closely with Marketing Systems, Tools and Customer Related Data as well as the CPD and Snowflake to increase the efficiency of data shared across applications. You will collaborate with cross-functional teams to build scalable and reliable data pipelines, enable advanced analytics capabilities, and drive data-driven decision-making across the organization.
Responsibilities:
Education and/or Experience:
Our client, a New Jersey based Technology Company, is seeking a Data Engineer focused in Marketing and Customer-centric data with deep Snowflake experience who is well versed in developing API’s to connect Marketing Systems to other critical systems and data sources throughout the organization. This position is a 12 month contract position and is 100% remote. The Data Engineer is responsible for designing, building, and maintaining the infrastructure and systems that enable data collection, storage, processing, and analysis within the company.
Summary: We are seeking a talented and experienced Data Engineer to join the team. As a Data Engineer you will work closely with Marketing Systems, Tools and Customer Related Data as well as the CPD and Snowflake to increase the efficiency of data shared across applications. You will collaborate with cross-functional teams to build scalable and reliable data pipelines, enable advanced analytics capabilities, and drive data-driven decision-making across the organization.
Responsibilities:
- Architect, implement, and maintain data pipelines and ETL processes on the Snowflake platform to support data ingestion, transformation, and storage.
- Design and optimize data models, schemas, and tables for performance, scalability, and efficiency.
- Set up data connectors, defining data schemas, configuring data processing workflows, and integrating with other systems and data sources to the Customer Data Platform.
- Design and implement data models and transformations to structure and enrich customer data within the CDP platform. This involves defining data schemas, mapping data fields, and transforming raw data into a standardized format that can be easily analyzed and accessed by other teams.
- Work closely with other members of the business, marketing department and technical teams to understand data requirements and develop solutions that meet business needs.
- Implement best practices for data governance, security, and compliance to ensure data integrity and regulatory compliance.
- Monitor and troubleshoot Snowflake environments, identifying and resolving performance issues, bottlenecks, and data quality issues.
- Evaluate and implement new Snowflake features and capabilities to enhance our data infrastructure and analytics capabilities.
- Document data architecture, processes, and workflows to facilitate knowledge sharing and ensure system documentation is up to date.
- Provide technical guidance and mentorship to junior team members, promoting a culture of continuous learning and innovation.
Education and/or Experience:
- 3-5 years of in-depth knowledge of Snowflake architecture including tables, schemas, databases and warehouses.
- 3-5+ years of experience using Postman for API design, development and API testing
- Ability to design, develop and consume REST APIs for data exchange between the Customer Data Platform and other systems
- Experience building and maintaining data pipelines to ingest, transform and load (ETL) customer data into Snowflake.
- Experience implementing and managing web Software Development Kits (SDKs) that include Angular, CSS, HTML, React, jQuery, Bootstrap to capture customer data from websites and mobile applications
- Knowledge of data quality checks, error handling, and scheduling tool.
- Proficiency in writing advanced SQL using Snowflake features like UDF, materialized views and clustering keys.
- Understanding of authentication, authorization and data formats (JSON, XML) is crucial.
- Understanding of security best practices in Snowflake.
- Understanding of user tracking, data encryption, and privacy regulations is essential.
- Experience with Postman
- In-depth knowledge of Snowflake architecture, including tables, schemas, databases, and warehouses.
- Ability to use data visualization tools like Power BI
- Ability to create dashboards and reports
- Experience with data integration tolls like Fivetran, DBT, Apache Airflow
- Familiarity with programming language like Python or Java
- Understanding of marketing automation platforms like Salesforce Marketing Cloud, Salesforce CRM
- Understanding Segmentation Journey orchestration.