What are the responsibilities and job description for the Data Warehouse Engineer (Snowflake) position at Adaptive Technology Insights?
Job Overview:
We are seeking a skilled Data Warehouse Engineer with expertise in Snowflake to design, implement, and manage scalable data warehousing solutions. The ideal candidate will have strong knowledge of data architecture, ETL processes, and cloud-based technologies, ensuring efficient and secure data solutions for business needs.
Key Responsibilities:
- Design, develop, and maintain scalable Snowflake-based data warehouses.
- Optimize data models for performance, scalability, and reliability.
- Stay updated with Snowflake capabilities and best practices for data warehousing.
- Collaborate with stakeholders to gather requirements and translate them into technical solutions.
- Implement and enforce data security and governance best practices.
- Monitor data warehouse performance and troubleshoot issues proactively.
- Work closely with data analysts and business teams to ensure seamless data accessibility.
Required Skills and Experience:
- 10 yrs of experience as a Data Warehouse Engineer or similar role.
- In-depth expertise in Snowflake architecture, concepts, and administration.
- Proficient in SQL for data transformation and querying.
- Strong experience with ETL/ELT tools like Informatica, Matillion, or Talend.
- Familiarity with cloud platforms such as AWS, Azure, or Google Cloud.
- Understanding of data modeling concepts (e.g., star schema, snowflake schema).
- Experience with scripting languages like Python or Shell scripting for data pipeline automation.
- Strong problem-solving skills and attention to detail.
Preferred Qualifications:
- Certification in Snowflake or relevant cloud platforms.
