We are looking for an experienced Solution Architect to join an international project focused on building and modernizing a cloud-based data platform. In this role, you will be responsible for designing end-to-end data solutions with Snowflake as the core data platform, setting architectural standards, and providing technical leadership to the project team.
Solution Architect (Snowflake)
Your responsibilities
- Design and architect end-to-end data solutions using Snowflake as the primary cloud data platform;
- Implement and maintain Medallion architecture (Bronze, Silver, Gold), including a robust dimensional data model for the Gold layer;
- Define, implement, and oversee data transformation processes using Coalesce.io;
- Manage data extraction and loading processes using Airbyte;
- Integrate and modernize legacy data systems built on SQL Server / SSIS, with limited use of Azure Data Factory when required;
- Design and optimize the BI semantic layer to enable self-service analytics in Power BI;
- Collaborate closely with business and technical stakeholders to translate business requirements into scalable data architecture solutions;
- Establish and enforce best practices for data modeling, data pipelines, and version control using GitHub;
- Track project progress, tasks, and deliverables using Jira;
- Provide technical leadership, guidance, and mentorship to the project team.
Our requirements
- Proven experience as a Data Architect or Solution Architect with a strong background in cloud-based data platforms;
- Hands-on expertise with Snowflake, Power BI, Coalesce.io, Airbyte, SQL Server / SSIS; some exposure to Azure Data Factory;
- Deep understanding of Medallion architecture and dimensional data modeling;
- Strong knowledge of designing and maintaining BI semantic models for self-service analytics;
- Experience establishing and enforcing data engineering standards, frameworks, and best practices;
- Familiarity with Jira (project management) and GitHub (version control);
- Excellent communication and collaboration skills, able to work across business and technical teams;
- Availability for a minimum 4-hour overlap with US Central Time