Los Angeles, CA, 90006, USA
217 days ago
SQL Developer
Job Description: Qualifications and Duties: + Establish and document the technical requirements for reporting software such as 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 to validate data. (Knowledge of PowerBI is not required but a plus) + 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. + Facilitate SQL design sessions and SQL 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. Knowledge of snowflake, git, pull requests, visual studio code, and dbt is strongly recommended. + Develop and maintain documentation on all database models, tables, guidelines, methods, and standards to ensure consistency and clarity. + Provide recommendations for further definition of development standards and application architecture based on industry best practices and emerging technologies. + Conduct unit testing and assist in user testing of complex SQL statements or report modifications to ensure quality and functionality meet requirements. + Train other staff members in development processes and standards to ensure consistency across the team.
Confirm your E-mail: Send Email