SQL Developer

Development of high-quality database solutions

Develop, implement, and optimize stored procedures and functions using SQL

Review and interpret ongoing business report requirements

Analyze existing SQL queries for performance improvements

Gather user requirements and identify new features

Provide data management support to users

Ensure all database programs meet company and performance requirements

Build appropriate and useful reporting deliverables

Suggest new queries

Provide timely scheduled management reporting

Investigate exceptions about asset movements

Mentor junior team members as needed

Work with data architects to ensure that solutions are aligned with company-wide technology directions

Required Skills Technical

Bachelor's degree in IT, Computer science, or related field

5+ years of experience as a SQL Developer or similar role

Strong proficiency with SQL and its variations among popular databases (Snowflake)

Strong skills in performance tuning of complex SQL queries, procedure and indexing strategies

Experience in designing, OLAP databases using data warehouse patterns and schema's including facts, dimensions, sorting keys, indexes, constraints etc.

Query design and performance tuning of complex queries for very large data sets Knowledge of best practices when dealing with relational databases

Capable of troubleshooting common database issues

Translating functional and technical requirements into detailed design

Data Analysis experience, for example mapping the source to target rules and fields