Employer Active
Job Alert
You will be updated with latest job alerts via emailJob Alert
You will be updated with latest job alerts via emailJob Title: SQL/ETL/Snowflake/Python Developer
Location: New Jersey(Onsite Position)
Duration: 12 Months
SQL and ETL are mandatory. Good to have DBT experience.
Job Description:
A dbt (data build tool) Developer is responsible for leveraging dbt to transform model and manage data within an organizations 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 uptodate 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 finetune 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 crossfunctional teams and contribute to datarelated 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:
Full Time