SQL Developer

QUALIFICATIONS AND DUTIES -

Note - Candidate should have work exp. with any state clients.

1) Establish and document the technical requirements for reporting software such as 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) Debug and test PowerBI reports based on user requirements and feedback from subject
matter experts to validate data. (Knowledge of PowerBI is not required but a plus)
 

4) 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.
 

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

6) Generate SQL tables using dbt according to established procedures and standards.
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.