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