Data Solution Architect
Perfict Global, Inc.
Dublin, CA
Apply
JOB DETAILS
LOCATION
Dublin, CA
POSTED
30+ days ago
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.
- 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
About the Company
P