Skip to content

Snowflake Engineer/Admin - Pipeline

Woodbridge, NJ 07095

Employment Type: Contract Expertise: Data and Business Analytics Job Number: 24108 Pay Range:

Job Description

Snowflake Engineer/Admin Key Responsibilities
  • Administered and optimized Snowflake environments, including schema creation, table setup, user management, warehouse scaling, performance tuning, backups, and monitoring disk/query performance.
  • Manage replication processes using tools like FiveTran or HVR, including creating locations and channels, monitoring agents, analyzing latency, and ensuring efficient replication flow.
  • Develop and troubleshoot complex SQL queries (T-SQL preferred) and leverage Python for automation, performance analysis, and orchestrating workflows to connect databases with Snowflake.
  • Collaborate with data engineering, security, and application teams to ensure database reliability, performance, and alignment with business needs.
  • Document database configurations, processes, and troubleshooting steps comprehensively to support team knowledge sharing and compliance.
  • Participate in on-call rotations and off-hours deployments to maintain system availability and performance.
Required Skills and Qualifications Database Administration (50%)
  • Extensive experience in Snowflake administration (not ETL), including end-to-end ownership of schema creation, table setup, user management, performance tuning, warehouse scaling, backups, and troubleshooting query/disk performance issues.
  • Strong hands-on experience with replication tools (FiveTran or HVR), including creating locations/channels, monitoring agents, and analyzing replication latency.
  • Proficiency in checking thresholds, analyzing warehouse blocking, and remediating query slowness in Snowflake environments.
Scripting and Integration (50%)
  • Strong SQL skills (T-SQL preferred) for writing and optimizing complex queries.
  • Experience with Python for automation, performance analysis, and orchestrating workflows to integrate databases with Snowflake.
  • Ability to connect Snowflake with other database systems through scripting and automation.
Additional Considerations
Experience with RDBMS platforms is a plus:
  • Oracle: User/schema setup, pipeline management.
  • DB2 (On-Prem): Hands-on experience with AIX/DB2 utilities (backup, reorg, runstats, rebind).
  • SQL Server: Familiarity with general usage and indexing strategies.
  • Familiarity with AWS services (e.g., RDS, DMS, S3, Glue, DocumentDB, DynamoDB, Redis) in managing Snowflake environments is advantageous.
  • Exposure to DevOps practices, including version control tools (e.g., Git) and SDLC/Agile environments, is highly valued.
  • Candidates must be local to Boston to facilitate collaboration and occasional on-site work. Why Join Us?
    This role offers an opportunity to join a high-performing team of five experienced DBAs managing a hybrid database infrastructure that powers critical business operations. You’ll work with modern cloud platforms like Snowflake, contribute to infrastructure modernization, and collaborate with a forward-thinking team dedicated to excellence in data management and innovation.
    What is a Pipeline Job?
    These roles represent future opportunities we've uncovered through our client discussions. We have stripped away the rigid “Must Haves,” “Mandatories,” and “Required” criteria to find the right fit for their needs. By applying for these future roles, we will complete our human-centered process to see if you are a fit while adding your profile to our database to be considered for additional openings. When you apply, rest assured a human will thoroughly review your resume and respond to you personally. We take pride in finding the right match for each job, valuing your unique talents and potential over just what's on your resume.


     
Apply Online

Send an email reminder to:

Share This Job:

Related Jobs:

Login to save this search and get notified of similar positions.

About Woodbridge, NJ

Ready to embark on a fulfilling career journey in Woodbridge, New Jersey? This vibrant area nestled in Middlesex County is brimming with job opportunities and endless possibilities for professional growth. From the picturesque landscapes of Merrill Park to the bustling atmosphere of Woodbridge Center Mall, there's something for everyone in this thriving community. Take a stroll through the artsy Downtown Woodbridge and catch a show at the historic State Theatre. Indulge in a delicious slice of Woodbridge's famous pizza or explore the diverse culinary scene that lines Main Street. Join our team and discover why Woodbridge is not just a place to work, but a place to thrive. Explore our job listings today and kickstart your career in this charming and bustling region!