- 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 current 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