Description
You will build and maintain data infrastructure to support data analysis and business operations.
Responsibilities
- Develop, maintain, and optimize data pipelines using DBT and SQL on Snowflake DB.
- Collaborate with data analysts, QA, and business teams to build scalable data models.
- Implement data transformations, testing, and documentation within the DBT framework.
- Execute data warehousing tasks in Snowflake, including ingestion, query optimization, and tuning.
- Use Python for automation, scripting, and supplemental data processing.
Required Skills
- 8+ years of experience in building data engineering pipelines.
- Expert-level proficiency in DBT and advanced SQL.
- Hands-on experience with modern columnar/MPP data warehouses, specifically Snowflake.
- Strong understanding of ETL/ELT processes and data modeling concepts.
- Proficiency in Python for data manipulation and workflow automation.
- Experience with CI/CD for data pipelines.
- Familiarity with automation principles.
- Knowledge of AWS, Azure, or GCP.
Preferred Skills
- Experience with orchestration tools like Airflow or Prefect.
- Knowledge of data governance and metadata management.