Data Architect

Data ArchitectRequired 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. Experience designing and implementing enterprise data warehouse solutions. Strong experience with data migration, data integration, and ETL/ELT processes. Hands-on experience with Snowflake. Experience with data governance, data quality, and data management best practices. Experience moving data from legacy systems into modern cloud-based platforms. Strong understanding of SQL and relational database concepts. Experience collaborating with both technical and business stakeholders. Ability to lead initiatives while remaining hands-on with architecture and implementation (technologies used): Snowflake, Fivetran, dbt, Power BI, SQL, AWS, Enterprise Data Warehousing, Data Governance, Data Modeling, Data Architecture.Nice to Have Skills & Experience: Experience with Fivetran for data ingestion and integration. Experience with dbt for data transformation and modeling. Experience with Power BI for reporting and visualization. Experience working with AWS-based data environments. Exposure to data modernization or enterprise transformation initiatives. Experience rebuilding or modernizing a failed or legacy data platform. Experience creating data governance frameworks and organizational data standards. Insurance, property and casualty, or claims experience: claims lifecycle, carrier and adjuster workflows, or property claims billing. Salesforce as a data source inside a broader enterprise architecture, as distinct from Salesforce administration. AWS, or equivalent cloud, at an architectural level. Access-control design, PII handling, and audit or regulatory readiness such as SOC 2 or CCPA. Data readiness for AI and machine learning: feature stores, vector data, retrieval pipeline preparation. Data 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.This 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.