Data Solution Architect

Data Solution ArchitectLocation: Contract - Long Term, Dublin, CA, Hybrid – 3 days in onsiteRole Need & ResponsibilitiesThe 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-HavesStrong 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