DBT Developer with SQL__ DOE__ NJ(onsite day 1)

Hi Team,

 

Need profiles ASAP.

 

Job Title: DBT Developer            

Location: New Jersey(Onsite Position)

Duration: 12 Months

 

SQL – 70% and DBT – 30%

SQL is mandatory.

Job Description:

A dbt (data build tool) Developer is responsible for leveraging dbt to transform, model, and manage data within an organization's data analytics stack. dbt Developers play a crucial role in streamlining data workflows, ensuring data accuracy, and providing a structured foundation for data analysis and reporting.

Responsibilities:

1. Data Transformation and Modeling:

   - Design and implement data transformations and models using dbt to create structured, cleaned, and aggregated datasets.

   - Develop and maintain dbt models that accurately represent business logic and data requirements.

2. SQL Expertise:

   - Write and optimize SQL queries within dbt to extract, manipulate, and join data from various sources (e.g., databases, APIs, flat files).

   - Ensure SQL code follows best practices for readability, performance, and maintainability.

3. Version Control:

   - Use version control systems (e.g., Git) to manage dbt codebase, enabling collaborative development and tracking changes over time.

   - Collaborate with data engineers and analysts to coordinate code changes.

4. Testing and Documentation:

   - Implement unit tests within dbt to verify the accuracy and reliability of data transformations.

   - Document dbt models, data lineage, and transformations to facilitate understanding and collaboration.

5. Automation:

   - Schedule and automate dbt runs to keep data models up-to-date and synchronized with source systems.

   - Implement data orchestration and scheduling as needed.

6. Data Quality Assurance:

   - Develop and enforce data quality checks and validations within dbt to identify and rectify data issues.

   - Monitor data quality and integrity, responding to anomalies or discrepancies.

7. Performance Optimization:

   - Optimize dbt models and queries for performance, identifying and addressing bottlenecks.

   - Analyze and fine-tune data processing pipelines to meet performance requirements.

8. Collaboration:

   - Collaborate closely with data engineers, data analysts, and business stakeholders to understand data requirements and deliver data solutions.

   - Participate in cross-functional teams and contribute to data-related projects.

9. Security and Compliance:

   - Ensure data security and compliance with relevant data protection regulations (e.g., GDPR, HIPAA) through appropriate data handling practices.

10. Knowledge Sharing:

    - Share knowledge of dbt best practices and data modeling techniques with team members.

    - Provide training and support to data analysts and other users of dbt.

Qualifications:

• Bachelor's or master's degree in computer science, data science, or a related field.
• Strong proficiency in SQL and experience working with relational databases.
• 3+ years of experience using dbt for data transformation and modeling in a data warehouse environment (e.g., Snowflake, BigQuery, Redshift).
• 7+ years of experience building business rules using a business rules engine similar to dbt
• Familiarity with version control systems (e.g., Git) and code collaboration workflows.
• Excellent data analysis and problem-solving skills.
• Strong attention to detail and a commitment to data quality.
• Understanding of data warehousing concepts and best practices.
• Knowledge of data governance and data security principles.
• Effective communication and collaboration skills to work with diverse teams.
• Experience with other data tools and languages (e.g., Python, R, Looker) is a plus

 

 

Thanks, and Regards

TechProjects

Saurav Agarwal

Talent Acquisition Specialist (IT Services)

Dice IT Solutions d/b/a TechProjects

Website - www.techprojects.com

Email: saurav@techprojects.com

Work     # (732) 230-2515

Fax        # 732-828-9901

Efax      # 860-371-2599

||850  Carolier Ln ( 1^st Floor) || North Brunswick || NJ 08902 ||

 

  E-Verify® is a registered trademark of the U.S. Department of Homeland Security

TechProjects participates in the Employment Eligibility Verification Program (E-Verify) offered by USCIS.
www.dhs.gov/E-Verify

|M/WBE Certified – New Jersery State & New York City