Senior Data Engineer Job at Tredence Inc., Portland, OR

bTEwTzZaU3lPdXR5OElRWGN0OE1Za1VVK0E9PQ==
  • Tredence Inc.
  • Portland, OR

Job Description

Job Summary:

We are seeking a highly skilled and experienced Senior Snowflake Data Engineer to join our data engineering team. The ideal candidate will have deep expertise in Snowflake architecture , data modeling , data quality frameworks , and extensive experience with Python , SQL , and advanced Snowflake features such as Snowpipe , SnowSQL , and Snowpark . You will play a key role in designing, building, and optimizing our data infrastructure to support analytics, reporting, and data science use cases across the organization.

Key Responsibilities:

  • Design and implement scalable and efficient data pipelines using Snowflake.
  • Develop and optimize data models (Star, Snowflake, and Data Vault) to support business intelligence and analytics.
  • Design and implement data quality frameworks to ensure accuracy, completeness, and consistency of data.
  • Build and maintain data ingestion processes using Snowpipe , SnowSQL , and third-party tools.
  • Leverage Snowpark for advanced transformation and data science workloads.
  • Implement robust security and access control policies within the Snowflake environment.
  • Collaborate with data analysts, data scientists, and business stakeholders to understand requirements and deliver reliable solutions.
  • Monitor performance and optimize queries, pipelines, and Snowflake storage/computation.
  • Support production deployment and perform root cause analysis on any issues related to the Snowflake environment.
  • Document design decisions, data flows, and processes for cross-team knowledge sharing.

Required Skills & Qualifications:

  • 8+ years of experience in data engineering with strong proficiency in Snowflake.
  • Hands-on experience with Snowflake architecture , Snowpipe , SnowSQL , and Snowpark .
  • Proficiency in SQL and Python for ETL/ELT development and data transformation.
  • Strong understanding of data modeling techniques (3NF, Star, Snowflake, Data Vault).
  • Experience implementing data quality checks , lineage, and validation mechanisms.
  • Familiarity with CI/CD practices and tools for deploying data pipelines.
  • Working knowledge of cloud platforms such as AWS, Azure, or GCP.
  • Excellent problem-solving skills and the ability to work independently as well as in a team environment.
  • Strong communication and stakeholder management skills.

Preferred Qualifications:

  • Snowflake certification (SnowPro Core or Advanced).
  • Experience with orchestration tools like Airflow or dbt.
  • Exposure to streaming data pipelines and event-driven architecture.
  • Experience working in an Agile environment.

Job Tags

Similar Jobs

VSC Fire & Security, Inc.

Fire Sprinkler Designer II Job at VSC Fire & Security, Inc.

 ...VSC Fire & Security in Atlanta, Georgia is seeking candidates for the position of Sprinkler Designer II. What we offer: Competitive salary. Range $38.00 - $48.00 and up based on experience (overtime eligible). Monday - Friday (occasional evening, weekend, and... 

Confidential - Job Hiring

Personal Assistant Job at Confidential - Job Hiring

Our client, a confidential UHNWI is seeking an experienced Personal Assistant to support a wonderful family and team. Position: Personal Assistant to Private Family Location: Palo Alto, CA (Local candidates preferred) Compensation: $100,000$150,000 per year ...

The Baer Group

SAP Testing Lead (16999) Job at The Baer Group

 ...Baer is looking for SAP Testing Lead for a 6+ month project located in Lynnfield, MA Title: SAP Testing Lead Location: Hybrid - Lynnfield, MA (Onsite 3 days) Duration: 6 months Rate: Hourly Plus Expenses Reimbursed Alignment: W2 or C2C Description... 

Addition Management

Food Service Expeditor Job at Addition Management

 ...Position: Food Service Fulfillment Manager Location: Chicago, Illinois (Fully on site) Salary: $55K-$60K Growing Hospitality...  ...Directing, coordinating, and arranging all logistics team members for delivery/fulfillment. Train and promote best in class service... 

Burns White LLC

Healthcare Litigation Attorney Job at Burns White LLC

 ...s true that our work can be demanding at times but it is rewarding and challenging. Mentoring...  ...established and high-functioning team of attorneys, nurses, paralegals, assistants, and...  ...to interact with clients and be part of a team that actually goes to trial...