Job description
About The Role:
- Designing and implementing data models that align with business requirements; creating and managing database objects such as tables, views, and schemas within Snowflake.
- Developing and maintaining ETL processes to move data into and out of Snowflake; integrating data from various sources, ensuring data quality, and transforming data to meet business needs.
- Optimizing queries and data warehouse performance for efficiency and scalability; monitoring and troubleshooting performance issues to ensure optimal system responsiveness.
- Implementing and managing security measures to protect data within Snowflake; setting up and maintaining user roles, privileges, and access controls to ensure data security and compliance.
- Integrating Snowflake with other data sources and tools to facilitate seamless data flow and analysis; collaborating with other teams to ensure data integration aligns with overall business goals.
- Automating routine tasks and processes to improve efficiency; orchestrating data workflows and dependencies to ensure timely and accurate data processing.
- Monitoring system health, performance, and resource utilization; conducting regular maintenance tasks such as backups, updates, and patches to keep the system running smoothly.
About You:
- In-depth knowledge and hands-on experience with Snowflake architecture, features, and capabilities.
- Proficiency in creating and managing data objects, such as databases, tables, and views in Snowflake.
- Strong SQL skills for querying, data manipulation, and performance optimization within the Snowflake environment.
- Experience in designing, developing, and maintaining ETL processes for data integration using tools like Snowflake's native features and Apache Airflow.
- Knowledge of data modelling principles and experience in designing effective and productive data models.
- Proficiency in scripting languages such as Python or Java for automating tasks and implementing custom solu