Description

You will design, develop, and maintain SQL-based data structures to support reporting and visualization requirements.

Responsibilities

• Create and maintain complex SQL statements, tables, and views to drive PowerBI visualizations.
• Establish technical requirements for reporting software, including report design, unit test plans, and test cases.
• Manage the full development lifecycle from requirements gathering and design through to implementation and production support.
• Facilitate SQL design sessions and code walk-throughs to ensure adherence to development standards using dbt.
• Debug and test reports based on user requirements and subject matter expert feedback.

Required Skills

• 5+ years of experience in SQL development.
• Proficiency in writing complex SQL statements for table and view generation.
• Experience using dbt for SQL table generation and development standards.
• Knowledge of Snowflake.
• Experience with Git, pull requests, and Visual Studio Code.
• Experience conducting unit testing and assisting in user testing for complex SQL modifications.
• Ability to document database models, guidelines, and methods.
• Experience working with state clients.

Preferred Skills

• Knowledge of PowerBI.

Key Skills

Education

Any Graduate