SQL Developer

Shuvel - Los Angeles, CA

Full-time

Los Angeles, CA

About the position

The position involves establishing and documenting technical requirements for reporting software, particularly focusing on SQL and PowerBI. The role encompasses all phases of the reporting software development cycle, including requirements gathering, analysis, design, testing, implementation, and production support. The candidate will also be responsible for debugging and testing reports, creating complex SQL statements, and maintaining documentation to ensure consistency and clarity in development processes.

Responsibilities

• Establish and document technical requirements for reporting software including tables, views, report design, unit test plans, and test cases.
• Assist in all phases of the reporting software development cycle including requirements gathering, analysis, design, testing, implementation, and production support.
• Debug and test PowerBI reports based on user requirements and feedback from subject matter experts.
• Create and maintain complex SQL statements to generate tables and views for PowerBI developers.
• Develop and enhance SQL-based tables and views as per user requirements.
• Facilitate SQL design sessions and code walk-throughs to ensure adherence to development standards and best practices using dbt.
• Generate SQL tables using dbt according to established procedures and standards.
• Develop and maintain documentation on all database models, tables, guidelines, methods, and standards.
• Provide recommendations for further definition of development standards and application architecture based on industry best practices.
• Conduct unit testing and assist in user testing of complex SQL statements or report modifications.
• Train other staff members in development processes and standards.

Requirements

• Strong knowledge of SQL and experience in creating complex SQL statements.
• Experience with dbt for generating SQL tables and maintaining development standards.
• Familiarity with PowerBI for debugging and testing reports is a plus.
• Knowledge of Snowflake, Git, pull requests, and Visual Studio Code is strongly recommended.
• Ability to document technical requirements and maintain clear guidelines.

Nice-to-haves

• Knowledge of PowerBI is not required but is a plus.
• Experience with industry best practices and emerging technologies.