Sql Developer

Roles/Responsibilities:

• Develop SQL using DBT within a Snowflake environment.
• Code locally within a docker container using Visual Studio Code, and deploy updates via GIT/Azure DevOps.
• Integrate with CI/CD pipelines and author comprehensive descriptions for all pull requests.
• Define and map dbt sources, implementing source freshness rules.
• Leverage dbt macros effectively to modularize and reuse complex logic across models.
• Design fact and dimension tables using a star schema optimized for Power BI.
• Implement standard and custom dbt tests, including macros, to ensure data resiliency and catch anomalies.
• Schedule tasks and validate incremental materialization logic to optimize compute costs.
• Generate and maintain comprehensive documentation, ensuring column[1]level descriptions exist for all production models.
• Optimize and performance-tune models by leveraging Snowflake clustering and dbt pre/post-hooks.

Mandatory Skills:

1. 3 years of experience with DBT
2. Experience with Snowflake
3. Experience with school district-level data
4. Experience with version control
5. Experience with a production pipeline