Description: 

Supports teams to develop, and implement innovative solutions to complex business and technology problems

Skills – Essential:

• Experience on multiple full release project life cycles including Agile. (Essential)
• Demonstrates technical leadership skills (Essential)
• Expertise in working with SQL in an AWS data warehousing/data lake environment. (Essential)
• SQL Programming: Strong command over SQL programming language and its syntax, including complex queries, joins, subqueries, indexing, and optimization techniques. (Essential)
• Performance Tuning and Optimization: Ability to analyze query performance, identify bottlenecks, and optimize SQL statements and database configurations for improved efficiency and response times. (Essential)
• Troubleshooting and Debugging: Proficiency in diagnosing and resolving database-related issues, such as connectivity problems, performance degradation, or data integrity concerns. (Essential)
• Documentation and Communication: Strong written and verbal communication skills to effectively document scripts, procedures, and database changes. Ability to collaborate with other team members and stakeholders. (Essential)
• Problem-solving and Analytical Thinking: Strong problem-solving skills and the ability to think analytically when analyzing complex data requirements, designing efficient queries, and resolving database-related issues. (Essential)
• Experienced using AWS Glue or AWS RedShift (Highly Desirable) alternate cloud technologies would be considered also.

Skills – Desirable

• Knowledge and experience of modem software design and development methodologies & frameworks (e.g. Agile/Scrum)
• Scripting Languages: Familiarity with scripting languages like Shell scripting, Python, or PowerShell, which are often used for automating tasks, data manipulation, and integration with other systems. (Desirable)
• Database Design and Modelling: Knowledge of database design principles, entity-relationship (ER) modelling, and normalization to ensure efficient and scalable database structures. (Desirable)
• Familiarity with related technologies: Knowledge of other relevant technologies such as data warehousing, data analytics, reporting tools, and integration platforms can be beneficial. (Desirable)

Experience

• Participates as a member of the development teams.
• Development knowledge of multiple back-end languages and technologies
• Participates in cross-functional teams.
• Applies technical knowledge to provide maintenance solutions across one or more technology areas.
• Supports the team to develop innovative team solutions
• Participates in code reviews.
• Uses knowledge and experience to help shape the application backlog.
• Actively contributes to refinement sessions.
• Flexible and willing to accept a change in priorities as necessary.
• Attention to detail with a pragmatic and enthusiastic attitude to work.
• Ability to work effectively in a globally dispersed team and with clients and vendors.