Purpose of the Position: As a Senior Data Integration Architect (DBT), You will be responsible for development, and optimization of data solutions using Snowflake and DBT, ensuring efficient data integration, transformation, and real-time analytics. This role involves collaborating with cross-functional teams to translate business requirements into technical solutions, maintaining data integrity and compliance, and driving innovation in data engineering practices.
Key Result Areas and Activities:
Data Architecture and Pipeline Development: Design, build, and maintain robust Snowflake architectures and data pipelines using DBT to ensure efficient data integration and transformation.
Performance Optimization: Optimize the performance of Snowflake databases and DBT models to ensure high efficiency and scalability of data solutions.
Data Quality and Compliance: Ensure data integrity, quality, and compliance with data governance and security policies.
Collaboration and Stakeholder Management: Work closely with analysts, and business stakeholders to understand requirements and deliver effective data solutions.
Innovation and Continuous Improvement: Drive innovation in data engineering practices and continuously improve processes and tools to enhance data capabilities.
Must have:
Deep understanding of Snowflake architecture, data warehousing, and performance optimization, High proficiency in SQL
Collaborate with analysts and business stakeholders to gather requirements, translate them to business requirements, design scalable and reliable solutions
Strong skills in developing, testing, and deploying DBT models for data transformation and pipeline management.
Expertise in data modelling (both relational and dimensional) and designing efficient ETL processes.
Agile - SCRUM, JIRA and Prior experience in Analytics with PowerBI know how