DBT Core Developer

Role: DBT DeveloperExperience: 4-5 yearsLocation: RemoteRequired skills: DBT core, Python, SQL, Snowflake/GBQ Responsibilities:1. DBT Modeling: - Develop and maintain data models using DBT (Data Build Tool) for transforming raw data into consumable and efficient structures. - Implement best practices in DBT for version control, documentation, and testing of data models. 2. SQL Development: - Write complex SQL queries for data extraction, transformation, and loading (ETL) processes. - Optimize SQL code for performance and efficiency. 3. Python Programming: - Leverage Python scripting for custom transformations and orchestration of data workflows. - Collaborate with data engineering and data science teams to integrate DBT models into end-to-end data pipelines. 4. Snowflake or BigQuery Expertise: - Work with Snowflake or BigQuery to design and implement scalable and efficient data warehouse solutions. - Optimize queries and storage structures for performance and cost-effectiveness. 5. Data Warehousing: - Design and maintain data warehouse schemas, ensuring data integrity and consistency. - Collaborate with cross-functional teams to understand business requirements and implement data models accordingly. 6. Performance Tuning: - Monitor and optimize the performance of DBT models, SQL queries, and overall data processing pipelines. - Troubleshoot and resolve performance issues in collaboration with the infrastructure and database teams. 7. Quality Assurance: - Implement testing methodologies for DBT models to ensure data accuracy and reliability. - Conduct code reviews and provide constructive feedback to peers. Qualifications:1. Bachelor’s degree in Computer Science, Information Technology, or a related field.2. 4-5 years of hands-on experience as a DBT Core Developer with proficiency in SQL.3. Strong programming skills in Python for data transformations and automation.4. Experience with Snowflake or BigQuery as a data warehousing solution.5. Knowledge of data modeling best practices and principles.6. Excellent problem-solving and analytical skills.7. Strong communication and collaboration skills. Preferred Skills:1. Familiarity with version control systems, especially Git.2. Experience with data orchestration tools (e.g., Airflow).3. Knowledge of data governance and security best practices.4. Certification in DBT or related technologies is a plus.

Key Skills

• Python
• SQL