Data Architect II

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.

Skills and Requirements

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 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. You have taken over a platform built by a consulting partner and made it yours. 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.

We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal employment opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment without regard to race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or the recruiting process, please send a request to [email protected].