What are the responsibilities and job description for the Lead Data Build Tool - Dallas, TX, NJ - W2 ONLY position at Cygnus Professionals Inc.?
We are seeking a skilled DBT Lead to oversee the development and optimization of DBT (Data Build Tool) pipelines for efficient data transformation and modeling. The ideal candidate will bring hands-on experience in DBT, data engineering, and an ability to collaborate across teams to ensure high-quality and scalable solutions.
Key Responsibilities:
- Lead the development and implementation of DBT models, ensuring efficient data transformation workflows.
- Collaborate with data engineers, analysts, and stakeholders to gather requirements and translate them into robust DBT solutions.
- Optimize DBT pipelines for performance, scalability, and maintainability.
- Enforce best practices in version control, testing, and documentation within the DBT environment.
- Monitor and troubleshoot DBT workflows to ensure reliability and timely delivery of data products.
- Provide guidance and mentorship to the team on DBT practices and advanced modeling techniques.
- Stay updated on the latest DBT features and incorporate them into the data transformation ecosystem.
Qualifications:
- Proven experience as a DBT Lead or Developer, with a strong portfolio of implemented DBT projects.
- Expertise in SQL and data modeling concepts.
- Familiarity with cloud-based data warehouses (e.g., Snowflake, BigQuery, Redshift).
- Strong understanding of ETL/ELT processes and data pipeline optimization.
- Experience in CI/CD practices and version control systems (e.g., Git).
- Excellent communication skills to collaborate with technical and non-technical stakeholders.
Salary : $45 - $50
