DBT Snowflake developer

Other Jobs To Apply

Hello

Greetings!!!

This is Sakshi from Jconnect INC. Below is the requirement with my client. Please let me know if you are available for this role.

Title: DBT Snowflake developer

Location: Remote

Duration: Fulltime

JOB DESCRIPTION:

Job Description

DBT Snowflake developer

A Job Description for a DBT Developer with 3-5 years of experience, focusing on macros, modeling, and hands-on SQL within a Snowflake platform, would typically include the following:

Job Title: DBT Developer (Snowflake)

Experience: 3-5 years

Roles and Responsibilities:

DBT Development & Data Transformation:
• Design, develop, and maintain robust and scalable data transformation pipelines using dbt on the Snowflake platform.
• DBT Macro Development to Create and utilize Jinja-based DBT macros to promote code reusability, modularity, and dynamic SQL generation within DBT projects.
• Data Transformation & Orchestration to Implement and manage data transformation pipelines using DBT, integrating with various data sources and ensuring efficient data flow.
• Utilize advanced dbt concepts, including macros, materializations (e.g., incremental, view, table), snapshots, and configurations to build efficient data models.
• Write highly optimized and complex SQL queries for data manipulation, cleaning, aggregation, and transformation within dbt models.
• Implement and enforce best practices for dbt project structure, version control (Git), documentation, and testing.

Data Modeling:
• Collaborate with data analysts, engineers, and business stakeholders to understand data requirements and translate them into effective data models (e.g., star schema, snowflake schema).
• Design and implement logical and physical data models within dbt to support analytical and reporting needs.

Snowflake Platform Expertise:
• Leverage Snowflake features and functionalities for performance optimization, including virtual warehouses, clustering, caching, and query optimization.
• Manage and optimize data ingestion and integration processes from various sources into Snowflake.

Collaboration & Communication:
• Work closely with cross-functional teams to understand business requirements, troubleshoot issues, and deliver high-quality data solutions.
• Participate in code reviews, provide constructive feedback, and ensure adherence to coding standards.
• Communicate technical concepts effectively to both technical and non-technical audiences.

Quality & Governance:
• Ensure data quality, integrity, and lineage throughout the data transformation process.
• Implement and maintain DBT tests to ensure data quality, integrity, and adherence to business rules.
• Implement and maintain data governance policies and procedures within the dbt environment.
• Develop and execute automated tests for dbt models to ensure data accuracy and reliability.

Continuous Improvement:
• Stay updated with the latest dbt and Snowflake features and best practices.
• Identify opportunities for process improvements and implement automation where appropriate.

Required Skills:
• Proven hands-on experience with dbt in a production environment, including extensive use of macros and advanced modeling techniques.
• Expert-level proficiency in SQL for data querying, manipulation, and transformation.
• Strong experience with Snowflake, including performance tuning and optimization.
• Solid understanding of data warehousing concepts and ETL/ELT processes.
• Experience with version control systems, particularly Git.
• Familiarity with data modeling principles (star schema, snowflake schema).
• Excellent problem-solving and analytical skills.
• Strong communication and collaboration abilities.

If you are interested, please send me your updated resume ASAP with below details:

  • Full Name:
  • Current Location/Zip:
  • Contact Number:
  • E-Mail Id:
  • Alternate Email Id:
  • Visa/Work Permit Status:
  • Current Rate/Salary:
  • Expected Base Salary:
  • Notice Period/Availability to Start:
  • Skype ID:
  • Willingness to relocate to job location:
  • Any Relocation Concern (family/house/weather):
  • Current/Previous Employer Name:
  • Preferred Interview timings (Specify Time zone):
  • Any other job opportunity in process & at which stage:
  • Overall Experience Summary:
  • LinkedIn URL:


Looking forward for your response..

Thanks and Regards,

Sakshi Tripathi

Jconnect Infotech Inc.

168 Barclay Center Ste. 347,

Cherry Hill, NJ 08034

Email: sakshi@jconnectinc.com

LinkedIn ID:
Back to blog

Other Jobs To Apply

Direct Response Copywriter - REMOTE

Freelance Copywriter for Startups (Socials & Newsletters)

Remote Article Writer

Legal Researcher & Writer (Attorney – US Law, JD) Remote

Scripted Writer

Medical Writer (Remote, US)

Remote Grant Writer for Global Development

Remote Freelance Ghostwriter for Business Leaders Job at Advantage Media Group i

Blog Writers Needed for Family Advice and Activity Website

Technical Writer(Entry Level)- Contract- Remote

Copywriter - Remote

Content Writer/ Freelancer

Remote Healthcare Customer Service Representative

Customer Service Representative I (Remote Raleigh, NC)

Remote Customer Service | Insurance Agent

United Airlines Reservations Representative (Remote)

Work From Home Customer Service Rep

Customer Service Agent - Remote Data Entry Agent – Full/Part Time

Online Chat Support (Remote)

GoHighLevel Non-Voice Customer Support Representative

Remote- Customer Experience Service

Quality Analyst (Remote)

Entry Level Freight Dispatcher - Work from Home - $1,200 to $3,000+/Week (1099)

Remote | Scheduling Coordinator | Entry Level | No Experience Needed

REMOTE CSR - No Experience Required

Bilingual Spanish Customer Service Representative - Remote in AR

Online Customer Support Specialist (REMOTE) ©

Customer Service Manager (Call Center) , Phoenix, AZ (Hybrid)

(Remote) Sr Implementation Consultant

Sr. Presales Engineer - Order Management Solutions - Remote

Remote Travel Support Representative - Hotel Reservations

Booking Agent (Remote)

Patient Care Coordinator (Remote)

Tier 2 Help Desk Specialist – Part-Time, Weekend Night Shift

Remote | Financial Crime Fraud Investigation Specialist —$65–$90/hour

Remote Retention Representative

Benefits Onboarding Specialist (Remote, Entry Level)

Senior Client Relations Manager

Customer Success Manager, CSM

Email Support Agent

Technical Support Representative Level 1

Remote Outbound Call Center Agents

Inbound Call Center Representative - Work from Home

Online Live Chat Jobs

Remote Chat Support Agent

Remote Full time and Part time Call Center Agent

Customer Service (Remote)

Remote Sales and Marketing Specialist

Supervisor, Programmatic Media Remote (USA)

Digital Marketing Executive (Remote)

Common Interview Questions And Answers

1. HOW DO YOU PLAN YOUR DAY?

This is what this question poses: When do you focus and start working seriously? What are the hours you work optimally? Are you a night owl? A morning bird? Remote teams can be made up of people working on different shifts and around the world, so you won't necessarily be stuck in the 9-5 schedule if it's not for you...

2. HOW DO YOU USE THE DIFFERENT COMMUNICATION TOOLS IN DIFFERENT SITUATIONS?

When you're working on a remote team, there's no way to chat in the hallway between meetings or catch up on the latest project during an office carpool. Therefore, virtual communication will be absolutely essential to get your work done...

3. WHAT IS "WORKING REMOTE" REALLY FOR YOU?

Many people want to work remotely because of the flexibility it allows. You can work anywhere and at any time of the day...

4. WHAT DO YOU NEED IN YOUR PHYSICAL WORKSPACE TO SUCCEED IN YOUR WORK?

With this question, companies are looking to see what equipment they may need to provide you with and to verify how aware you are of what remote working could mean for you physically and logistically...

5. HOW DO YOU PROCESS INFORMATION?

Several years ago, I was working in a team to plan a big event. My supervisor made us all work as a team before the big day. One of our activities has been to find out how each of us processes information...

6. HOW DO YOU MANAGE THE CALENDAR AND THE PROGRAM? WHICH APPLICATIONS / SYSTEM DO YOU USE?

Or you may receive even more specific questions, such as: What's on your calendar? Do you plan blocks of time to do certain types of work? Do you have an open calendar that everyone can see?...

7. HOW DO YOU ORGANIZE FILES, LINKS, AND TABS ON YOUR COMPUTER?

Just like your schedule, how you track files and other information is very important. After all, everything is digital!...

8. HOW TO PRIORITIZE WORK?

The day I watched Marie Forleo's film separating the important from the urgent, my life changed. Not all remote jobs start fast, but most of them are...

9. HOW DO YOU PREPARE FOR A MEETING AND PREPARE A MEETING? WHAT DO YOU SEE HAPPENING DURING THE MEETING?

Just as communication is essential when working remotely, so is organization. Because you won't have those opportunities in the elevator or a casual conversation in the lunchroom, you should take advantage of the little time you have in a video or phone conference...

10. HOW DO YOU USE TECHNOLOGY ON A DAILY BASIS, IN YOUR WORK AND FOR YOUR PLEASURE?

This is a great question because it shows your comfort level with technology, which is very important for a remote worker because you will be working with technology over time...