Demo

Data Engineer (W2)

Systemart
Trenton, NJ Full Time
POSTED ON 2/12/2025
AVAILABLE BEFORE 5/11/2025

Job Description

Design, implement, and optimize data solutions using the Snowflake cloud data platform. This role plays a pivotal part in architecting data warehouses, data lakes, and ETL processes to enable efficient data storage, processing, and analytics for the DOE.

A Senior Snowflake Developer is a highly skilled professional responsible for designing, implementing, and optimizing data solutions using the Snowflake cloud data platform. This role plays a pivotal part in architecting data warehouses, data lakes, and ETL processes to enable efficient data storage, processing, and analytics for the organization.

Responsibilities

1. Data Architecture

  • Collaborate with data architects to design and develop Snowflake data models and schemas.
  • Create and maintain a well-structured data warehouse and data lake architecture.

2. Data Integration

  • Develop ETL (Extract, Transform, Load) processes to ingest data from various sources into Snowflake.
  • Ensure data integration processes are efficient, reliable, and scalable.
  • Design and implement data pipelines using Snowflake features like tasks and streams.
  • 3. Performance Optimization

  • Optimize query performance by creating and maintaining appropriate indexes, materialized views, and clustering keys.
  • Identify and resolve performance bottlenecks in data processing.
  • 4. SQL Development

  • Write complex SQL queries, stored procedures, and user-defined functions (UDFs) to support data analytics and reporting needs.
  • Ensure SQL code follows best practices for readability and performance.
  • 5. Security and Access Control

  • Implement and manage security measures, including role-based access control (RBAC) and data encryption, to protect sensitive data.
  • Audit and monitor data access and user activities.
  • 6. Data Quality Assurance

  • Define and implement data quality checks and validation processes to maintain data accuracy.
  • Establish data quality rules and alerts to proactively identify issues.
  • 7. Documentation

  • Create and maintain technical documentation for data models, ETL processes, and data dictionaries.
  • Document best practices, standards, and guidelines for Snowflake development.
  • 8. Version Control and Deployment

  • Use version control systems (e.g., Git) for managing Snowflake SQL scripts and objects.
  • Coordinate the deployment of changes to Snowflake environments.
  • 9. Monitoring and Alerts

  • Set up monitoring and alerting for Snowflake environments to proactively detect and respond to issues.
  • Troubleshoot and resolve incidents related to data processing and performance.
  • 10. Backup and Recovery

  • Implement backup and recovery strategies to ensure data integrity and availability.
  • Develop and test data recovery procedures.
  • 11. Collaboration

  • Collaborate with data engineers, data scientists, and business analysts to understand data requirements and provide data solutions.
  • Work with cross-functional teams to support data-related projects and initiatives.
  • Qualifications

  • Bachelor's or master's degree in computer science, data engineering, or a related field.
  • 7 years of experience as a Snowflake developer or data engineer with a focus on data warehousing and ETL.
  • Snowflake certification(s) is a plus.
  • Strong SQL skills and proficiency in data modeling and database design.
  • Knowledge of cloud data warehousing concepts and best practices.
  • Familiarity with data integration tools and technologies.
  • Solid understanding of data governance, data security, and compliance requirements.
  • Experience with version control systems and deployment processes.
  • Excellent problem-solving and troubleshooting skills.
  • Strong communication and collaboration abilities.
  • Ability to work in an Agile or iterative development environment.
  • If your compensation planning software is too rigid to deploy winning incentive strategies, it’s time to find an adaptable solution. Compensation Planning
    Enhance your organization's compensation strategy with salary data sets that HR and team managers can use to pay your staff right. Surveys & Data Sets

    What is the career path for a Data Engineer (W2)?

    Sign up to receive alerts about other jobs on the Data Engineer (W2) career path by checking the boxes next to the positions that interest you.
    Income Estimation: 
    $92,929 - $122,443
    Income Estimation: 
    $122,257 - $154,284
    Income Estimation: 
    $168,522 - $211,152
    Income Estimation: 
    $189,259 - $248,928
    Income Estimation: 
    $92,929 - $122,443
    Income Estimation: 
    $122,257 - $154,284
    Income Estimation: 
    $71,122 - $96,652
    Income Estimation: 
    $92,929 - $122,443
    Income Estimation: 
    $122,257 - $154,284
    Income Estimation: 
    $143,391 - $179,890
    View Core, Job Family, and Industry Job Skills and Competency Data for more than 15,000 Job Titles Skills Library

    Job openings at Systemart

    Systemart
    Hired Organization Address Boston, MA Contractor
    POSITION SUMMARY: The Corporate Accounts Payable (AP) Analyst is responsible for day to day activities that support invo...
    Systemart
    Hired Organization Address Boston, MA Contractor
    Requirement: Minimum of a high school education or equivalent required. Requires at least two years of relevant experien...
    Systemart
    Hired Organization Address Plano, TX Full Time
    This position will work with our Treasury Operations group, which covers the Middle Office tasks of daily review, confir...
    Systemart
    Hired Organization Address Newark, NJ Contractor
    Description: • Conduct ad-hoc analysis through database querying, followed by insightful interpretation of results and t...

    Not the job you're looking for? Here are some other Data Engineer (W2) jobs in the Trenton, NJ area that may be a better fit.

    Cybersecurity Senior Data Engineer

    NTT DATA Group Corporation, Princeton, NJ

    Mechanical Engineer

    ACS - Engineer. Integrate. Build., Trenton, NJ

    AI Assistant is available now!

    Feel free to start your new journey!