Responsibilities
- Create, test, and implement enterprise-level apps with Snowflake
- Design and implement features for identity and access management
- Create authorization frameworks for better access control
- Implement novel query optimization, major security competencies with encryption
- Solve performance issues and scalability issues in the system
- Transaction management with distributed data processing algorithms
- Build, monitor, and optimize ETL and ELT processes with data models
- Understand and implement the latest delivery approaches based on data architecture
- Project documentation and tracking based on understanding user requirements
- Manage documentation of data models, architecture, and maintenance processes
- Continually review and audit data models for enhancement
- Maintenance of ideal data pipeline based on ETL tools
- Coordination with BI experts and analysts for customized data models and integration
- Code updates, new code development, and reverse engineering
- Performance tuning, user acceptance training, application support
- Perform Risk assessment, management, and mitigation plans
- Regular engagement with teams for status reporting and routine activities
- Migration activities from one database to another or on-premises to cloud
Requirements
- At least 5 years’ experience in enterprise-level Snowflake applications:
- Data ingestion into Snowflake
- Snowflake modeling – roles, databases, schemas
- Performance tuning and setting up resource monitors
- SQL performance measuring, query tuning, and database tuning
- Using ETL tools to build data warehouses
- Managing sets of XML, JSON, and CSV from disparate sources
- Knowledge of:
- Snowflake warehousing, architecture, processing, administration
- SQL language and cloud-based technologies, data warehousing concepts, data modeling, metadata management
- SQL-based databases like Oracle SQL Server, Teradata, etc.
- Coding in languages like Python, Java, JavaScript
- Root cause analysis of models with solutions
Interested candidate please click "APPLY" to begin your job search journey and submit your CV directly through the official PERSOLKELLY job application platform - GO Mobile. <https://go.persolkelly.com/job/apply/2543>
We regret that only shortlisted applicants would be notified.
Bautista Gia Grace De Guzman | REG No : R23111973
PERSOLKELLY SINGAPORE PTE LTD | EA License No : 01C4394
By sending us your personal data and curriculum vitae (CV), you are deemed to consent to PERSOLKELLY Singapore Pte Ltd and its affiliates to collect, use and disclose your personal data for the purposes set out in the Privacy Policy which is available at https://www.persolkelly.com.sg/policies. You also acknowledge that you have read, understood, and agree to the said Privacy Policy.
