Perfict

Design and implement data architecture solutions focusing on Snowflake, data ingestion, transformation, and reporting. | Experience with Snowflake, CDC, DBT, data modeling, and reporting tools like Power BI and MicroStrategy. | Job Title : Data Solution Architect Location : Contract - Long Term Location : Dublin, CA Type : Hybrid – 3 days in Onsite Role Need & Responsibilities • The position is for a Solution Data Architect focused on the SVT (Single Version of Truth) project, which aims to enable Snowflake as the target data platform. • The architect will be involved from the initial design phase, contributing to architecture, data modeling, ingestion, transformation, and enabling reporting/consumption use cases. • The architect will participate in the overall architecture and design, working closely with both internal teams and SI partner architects. • Responsibilities include evaluating and potentially improving current ingestion approaches (currently using StreamSets), supporting DBT-based transformation, and ensuring the architecture supports downstream analytics and reporting (Power BI, MicroStrategy). • The architect should be able to contribute to discussions on CDC, initial vs. incremental loads, and best practices for data modeling and transformation. Key Must-Haves • Strong hands-on experience with Snowflake as a data platform. • Solid understanding of data ingestion patterns, including CDC and batch/initial loads. • Experience with DBT for data transformation. • Familiarity with data modeling tools (e.g., SQL DBM) and practices. • Exposure to reporting/consumption tools such as Power BI and MicroStrategy. • Ability to work in a hybrid onsite model in Dublin, with flexibility for 2-3 days onsite as per company policy. • Understanding of data governance concepts (Alation is used, but deep expertise not required). • Willingness to be part of a long-term team, starting as a contractor with the intent to convert to FTE. • We have an SI partner who is bringing in Architects already, this person is higher level, part of the design, road mapping, etc. • Future – chatbot queries, AI use cases for future