Data Engineer (Snowflake)
Infrastructure & Support
Mount LaurelNJ Contract Mar 26, 2024
100% REMOTE - Java Software Engineer II

Our client, a New Jersey based Technology and Infrastructure Solutions Company, is seeking an Data Engineer focused in Snowflake and related technologies to join their dynamic team. This position is a 12 month contract position  and is 100% remote. The Data Engineer is responsible for analyzing, designing, developing, modifying writing, editing and implementing software programming applications. 

Summary: We are seeking a talented and experienced Snowflake Data Engineer to join the team. As a Snowflake Data Engineer, you will be responsible for designing, implementing, and optimizing data solutions using Snowflake's cloud data platform. 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.

  • 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.
  • Work closely with other members of the business 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.
Nice to Have:
  • 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