Data Architect Remote (CST Preferormation Architect

Data Architect- Remote (CST Preferred)

Engagement:

Contract-to-Hire (3-6 months with potential conversion)A growing organization in the insurance/reinsurance space is seeking a Data Architect to design and build a modern, scalable data platform leveraging Microsoft Fabric, Azure, and Snowflake.

This is a high-impact role where you'll take ownership of the data architecture and help stabilize and optimize an evolving environment. You'll work closely with leadership and a lean, distributed team to build a strong foundation for analytics and reporting.

We will not be accepting c2c/ third party candidates. Please do not apply or submit.

What You'll DoData Architecture & Platform DesignDesign and implement a modern data lake / data warehouse architecture using Microsoft Fabric and AzureDefine scalable data models, storage structures, and governance standards for large datasets (millions+ records)Establish secure data access, role-based permissions, and compliance controlsData Engineering & PipelinesBuild and optimize data pipelines for ingestion, transformation, and movement across Fabric/Azure environmentsDevelop and tune SQL queries for performance and scalabilityTroubleshoot and resolve performance bottlenecks and query timeoutsWorkflow Automation & EnablementDesign and implement automated data workflows (ETL/ELT pipelines)Create reusable frameworks/templates to support self-service capabilities for internal usersFocus on scalable platform solutions vs. one-off buildsReporting & VisualizationEnable downstream reporting via Power BI and/or TableauStructure datasets for efficient consumption and minimal latencyPartner with stakeholders to ensure reporting is reliable, performant, and scalablePerformance OptimizationIdentify system constraints and optimize compute, storage, and query performance within Microsoft FabricEnsure the platform scales with growing data volumes and user demand