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 map the source to target rules and fields
Non-Technical
Excellent interpersonal, analytical, and problem-solving skills
Excellent verbal and written communication skills
Ability to learn quickly and get things done
Ability to multi-task in a fast-paced environment
Motivated to share knowledge in a team environment
