SQL Developer with Snowflake and DBT

SQL Developer with Snowflake and DBT

Location - Los Angeles, CA (Offsite/Remote- But If needed should be able to go onsite)

Roles & Responsibilities:

1) Establish and document the technical requirements for reporting software including tables, views, report design, unit test plans, and test cases.

2) Assist in all phases of the reporting software development cycle including requirements gathering, analysis, design, testing, implementation, and production support.

3) Proficiently create and maintain complex SQL statements to generate tables and views that will be used by PowerBI developers to drive visualizations. Develop and enhance SQL-based tables and views as per user requirements.

4) Facilitate SQL design sessions and SQL code walk-throughs to ensure adherence to development standards and best practices using dbt.

5) Have at least 1 year of experiences as a dbt developer, with a strong focus in Snowflake.

6) Knowledge of snowflake, git, pull requests, visual studio code, and dbt is strongly recommended.

7) Develop and maintain documentation on all database models, tables, guidelines, methods, and standards to ensure consistency and clarity.

8) Provide recommendations for further definition of development standards and application architecture based on industry best practices and emerging technologies.

9) Conduct unit testing and assist in user testing of complex SQL statements or report modifications to ensure quality and functionality meet requirements.

10) Train other staff members on development processes and standards to ensure consistency across the team.

Thanks

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.