Data Architect

Required Skills & Experience 10+ years in data engineering or data architecture, including 3+ years owning architecture, modeling, or governance decisions rather than executing someone else's.\nExperience designing and implementing enterprise data warehouse solutions\nStrong experience with data migration, data integration, and ETL/ELT processes\nHands-on experience with Snowflake\nExperience with data governance, data quality, and data management best practices\nExperience moving data from legacy systems into modern cloud-based platforms\nStrong understanding of SQL and relational database concepts\nExperience collaborating with both technical and business stakeholders\nAbility to lead initiatives while remaining hands-on with architecture and implementation\n(technologies used) \nSnowflake\nFivetran\ndbt\nPower BI\nSQL\nAWS\nEnterprise Data Warehousing\nData Governance\nData Modeling\nData Architecture Nice to Have Skills & Experience Experience with Fivetran for data ingestion and integration\nExperience with dbt for data transformation and modeling\nExperience with Power BI for reporting and visualization\nExperience working with AWS-based data environments\nExposure to data modernization or enterprise transformation initiatives\nExperience rebuilding or modernizing a failed or legacy data platform\nExperience creating data governance frameworks and organizational data standards\nInsurance, property and casualty, or claims experience: claims lifecycle, carrier and adjuster workflows, or property claims billing.\nYou have taken over a platform built by a consulting partner and made it yours.\nSalesforce as a data source inside a broader enterprise architecture, as distinct from Salesforce administration.\nAWS, or equivalent cloud, at an architectural level.\nAccess-control design, PII handling, and audit or regulatory readiness such as SOC 2 or CCPA.\nData readiness for AI and machine learning: feature stores, vector data, retrieval pipeline preparation.\nData integration works with large property carriers. Job Description Our client is seeking a Data Architect to lead a critical enterprise data transformation initiative. This individual will serve as a player-coach, responsible for both hands-on data architecture and strategic oversight of a company-wide data modernization program. The organization is rebuilding its enterprise data warehouse after a previous platform initiative was unsuccessful and is investing in a new data repository and governance framework to support future growth.\n \nThis role will partner with technical and business stakeholders to establish a scalable data foundation, improve data quality and governance, and help foster a more data-driven culture across the organization. The initial program is expected to span approximately 18 months and will play a key role in ensuring operational success and long-term scalability. Insight Global