SQL Developer

Job Summary

We are seeking a skilled SQL Developer with 5+ years of experience to develop and optimize high-quality database solutions. The ideal candidate will possess strong proficiency in SQL (including Snowflake), expertise in performance tuning of complex queries, and experience with OLAP databases and data warehouse patterns.

Key Responsibilities

• 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

Requirements

Technical Skills

• 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 (e.g., Snowflake)
• Strong skills in performance tuning of complex SQL queries, procedures, and indexing strategies
• Experience in designing OLAP databases using data warehouse patterns and schemas 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 Skills

• 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