Data Engineer with DBT__ DOE__ Trenton, NJ(onsite day 1)

Hi Team,

Hope you all are doing good!

 

Need Data Engineer with DBT for the client DOE for onsite day 1 position in Trenton, NJ

 

Job Title: DBT Developer 

Location: Trenton NJ (onsite) 

Duration: 12 months contract

  

Job Description: 

  

Overview: 

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 Modelling: 

• 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 

 

--
You received this message because you are subscribed to the Google Groups "Bestc2cjob" group.
To unsubscribe from this group and stop receiving emails from it, send an email to bestc2cjob+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/bestc2cjob/BYAPR05MB4102A55D03F313011E590D72ABDDA%40BYAPR05MB4102.namprd05.prod.outlook.com.