SQL Developer

Job description :

• 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 - 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
• Self-directed and able to prioritize own workload