Job description

Key Responsibilities:

Database Design & Architecture:

Design, develop, and optimize Snowflake databases for both OLTP and OLAP systems.
Create and maintain data models, including conceptual, logical, and physical models.
-evelop and implement database schemas, tables, views, indexes, and other database objects.

Data Integration & ETL Processes:

Design and manage data integration solutions, including ETL/ELT processes.
Collaborate with data engineers to implement data pipelines for data ingestion, transformation, and loading into Snowflake.

Performance Tuning & Optimization:

Analyze and optimize database performance, including query performance, indexing strategies, and storage management.
Monitor and troubleshoot database performance issues and implement solutions to improve efficiency.

Collaboration & Communication:

Work closely with cross-functional teams, including data engineers, analysts, and business stakeholders, to understand data requirements and deliver database solutions.
Provide technical guidance and mentorship to junior database designers and developers.

Documentation & Compliance:

Maintain comprehensive documentation of database designs, architectures, and processes.
Ensure data security, privacy, and compliance with relevant regulations and best practices.

Technical Skills

Soft Skills

Preferred Qualifications:

Snowflake certification.
Experience with cloud platforms such as AWS,
Familiarity with other database technologies (e.g.MySQL, PostgreSQL, Oracle etc.).
Experience with data visualization and reporting tools (e.g., Tableau, Power BI).

Required profile