Snowflake Data Engineer

Artech

Sunnyvale, CA • On-site

$55 - $59/hr

Other

This job posting has expired and is no longer accepting applications. Check out similar jobs


Job description

Request ID: 86841-1
Title: Snowflake Data Engineer
Locations: Sunnyvale, CA (5x/ week onsite)
Duration: 6 Months
Pay Range: $55 - $59/Hour on W2 (All inclusive) - Applicants must be willing to work on W2
Introduction
We are seeking a highly skilled Snowflake Data Engineer for a 6-month contract position. This role requires a deep understanding of data engineering principles, particularly with Snowflake, and the ability to work onsite in the Bay Area. The ideal candidate will have experience in designing and implementing complex data pipelines and optimizing Snowflake performance.
Required Skills & Qualifications
  • Hands-on experience with writing complex queries using Joins, Self Joins, Views, Materialized Views, Cursors, Recursive queries, GROUP BY, and PARTITION BY functions, as well as SQL performance tuning.
  • Experience with ETL and Dimensional Data Modelling, including Slowly Changing Dimensions (SCD - Type 1, 2, 3).
  • Proficiency in Python scripting/programming, using libraries such as Pandas, PyParsing, and Airflow.
  • Strong understanding of Snowflake Architecture and experience designing and building solutions.
  • Prior work experience at client or in client's industry.
Applicants must be able to work directly for Artech on W2.
Preferred Skills & Qualifications
  • Experience with Snowflake performance optimization techniques.
  • Experience with Vertica and Singlestore.
  • Lead experience, including interacting with business stakeholders and leading data projects.
Day-to-Day Responsibilities
  • Design and implement enterprise-grade data pipelines using Snowflake, including ingestion and transformation.
  • Develop complex SQL transformations, stored procedures, and dynamic tables inside Snowflake for near real-time and batch processing.
  • Engineer Snowpipe and Kafka to Snowflake streaming ingestion pipelines, handling high throughput event data at scale.
Company Benefits & Culture
  • Collaborative work environment with opportunities for professional growth.
  • Access to cutting-edge technologies and tools.
  • Supportive team culture that values innovation and creativity.

For immediate consideration, please click APPLY to begin the screening process with Alex.



Frequently asked questions

Q: What skills or qualities help someone succeed as a Data Software Engineer?

A: To succeed as a Data Software Engineer, key technical skills include proficiency in programming languages such as Python, Java, or C++, as well as expertise in data structures, algorithms, and software development methodologies like Agile. Additionally, strong soft skills like effective communication, problem-solving, and collaboration are crucial, as Data Software Engineers often work with cross-functional teams and stakeholders to design, develop, and deploy data-driven solutions. By combining technical expertise with strong soft skills, Data Software Engineers can effectively drive business outcomes, innovate, and adapt to the rapidly evolving landscape of data technology.

Q: What is the career path for a Data Software Engineer?

A: A Data Software Engineer's typical career progression involves starting as a Junior Software Engineer, where they focus on developing and maintaining data-driven software applications, and gradually advancing to roles such as Senior Software Engineer, Technical Lead, or Data Architect, where they oversee large-scale data systems and lead cross-functional teams. Key opportunities for skill development include learning programming languages like Python, SQL, and Java, as well as data science tools like Hadoop, Spark, and machine learning frameworks like TensorFlow and PyTorch. Long-term, Data Software Engineers may pursue leadership roles, such as Director of Engineering or Chief Technology Officer, or transition into related fields like data science, product management, or entrepreneurship.