Writes technical design documentation based on business requirements and data architecture principles.
Develops and/or reviews unit testing protocols for SQL scripts, procedures, and data pipelines using automation frameworks.
Completes documentation and procedures for pipeline deployment, operational handover, and monitoring.
May mentor or guide junior developers and data engineers.
Enable real-time and batch data processing architectures that support AI-driven analytics, recommendations, forecasting, and intelligent automation.
Optimise cloud data platforms for AI scalability, including data lakehouse architectures, semantic layers, and high-performance data retrieval patterns.
Stays current with Snowflake features, best practices, and industry trends in cloud data platforms.
Performs additional related duties as assigned.
Knowledge and Experience
5+ years of professional experience in data engineering or database development.
Expert knowledge of Snowflake (Tidal is an added advantage).
Strong Hands-on experience
Writing complex SQL queries and stored procedures
Database stored procedures, functions, views, and schema design
Using Streams, Tasks, Time Travel, and Cloning
Proficiency in database performance tuning and performance optimisation — clustering, warehouse sizing, caching, etc.
Experience configuring external stages to integrate with cloud storage (AWS S3, Azure Blob, etc.).
Experience writing Python/Shell scripts for data processing.
Proficiency in using Git and working within Agile/Scrum SDLC environments.
Familiarity working in a Software Development Life Cycle (SDLC) leveraging Agile principles.
Excellent analytical, decision-making, and problem-solving skills.
Ability to multitask in a fast-paced environment with a focus on timeliness, documentation, and communication with peers and business users.
Strong verbal and written communication skills to engage both technical and non-technical audiences at various organisational levels.
Bachelor’s degree in computer science, Engineering, or related field (or equivalent experience).