Algotale Group is seeking a highly skilled Snowflake Data Engineer to design, build, and optimize scalable data solutions. The role involves collaborating with business stakeholders to deliver high-quality data models and insights while managing CI/CD pipelines and ensuring data governance compliance.
Responsibilities:
- Design and implement scalable data models in Snowflake
- Build and maintain transformation pipelines using dbt
- Develop optimized star/snowflake schemas for analytics and reporting
- Implement data quality checks and validation tests
- Optimize Snowflake warehouses for cost and performance
- Develop reports and dashboards using Power BI
- Build and manage datasets and semantic models
- Develop Paginated Reports (RDL)
- Implement DAX calculations and Row-Level Security
- Collaborate with stakeholders for business requirements
- Manage CI/CD pipelines using Azure DevOps
- Maintain version control using Git
- Deploy across Dev/Test/Prod environments
- Ensure data governance and security compliance
Requirements:
- 5–8 years in Data Engineering or BI
- Strong experience with Snowflake, dbt, SQL, Python
- Power BI (Data Modeling, DAX)
- Power BI Paginated Reports (RDL)
- Azure DevOps (CI/CD)
- Dimensional data modeling knowledge
- Design and implement scalable data models in Snowflake
- Build and maintain transformation pipelines using dbt
- Develop optimized star/snowflake schemas for analytics and reporting
- Implement data quality checks and validation tests
- Optimize Snowflake warehouses for cost and performance
- Develop reports and dashboards using Power BI
- Build and manage datasets and semantic models
- Implement DAX calculations and Row-Level Security
- Collaborate with stakeholders for business requirements
- Manage CI/CD pipelines using Azure DevOps
- Maintain version control using Git
- Deploy across Dev/Test/Prod environments
- Ensure data governance and security compliance
- Strong problem-solving ability
- Independent working capability
- Excellent communication skills
- High ownership and attention to detail
- Azure cloud experience
- Data security & compliance knowledge
- Agile/Scrum experience
- ADF or Airflow exposure