Data Architect- Remote (CST Preferormation...

Robert Half
Milwaukee, United States of America
18 days ago

Role details

Contract type
Temporary contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English

Job location

Milwaukee, United States of America

Tech stack

Query Performance
Adaptable Database Systems
Computing Platforms
Azure
Big Data
Data Architecture
Information Engineering
ETL
Data Security
Data Visualization
Data Warehousing
Performance Tuning
Power BI
SQL Databases
Systems Integration
Tableau
Sql Optimization
Snowflake
Build Management
Microsoft Fabric
Data Lake
Integration Frameworks
Data Pipelines

Job description

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 Do

Data Architecture & Platform Design

  • Design and implement a modern data lake / data warehouse architecture using Microsoft Fabric and Azure

  • Define scalable data models, storage structures, and governance standards for large datasets (millions+ records)

  • Establish secure data access, role-based permissions, and compliance controls

Data Engineering & Pipelines

  • Build and optimize data pipelines for ingestion, transformation, and movement across Fabric/Azure environments

  • Develop and tune SQL queries for performance and scalability

  • Troubleshoot and resolve performance bottlenecks and query timeouts

Workflow Automation & Enablement

  • Design and implement automated data workflows (ETL/ELT pipelines)

  • Create reusable frameworks/templates to support self-service capabilities for internal users

  • Focus on scalable platform solutions vs. one-off builds

Reporting & Visualization

  • Enable downstream reporting via Power BI and/or Tableau

  • Structure datasets for efficient consumption and minimal latency

  • Partner with stakeholders to ensure reporting is reliable, performant, and scalable

Performance Optimization

  • Identify system constraints and optimize compute, storage, and query performance within Microsoft Fabric

  • Ensure the platform scales with growing data volumes and user demand

Requirements

Required Experience

  • Strong hands-on experience with Microsoft Fabric and Azure

  • Expertise in data architecture and pipeline development

  • Advanced SQL skills (query performance tuning and transformations)

  • Experience with Power BI or similar BI/visualization tools

  • Experience with Snowflake and large-scale data environments

  • Background in insurance, reinsurance, or other high-risk industries

  • Experience building automated workflow and data frameworks

  • Exposure to integrating with external or proprietary systems

Environment & Tools

  • Microsoft Fabric, Azure

  • Snowflake

  • Power BI / Tableau

  • SQL, All applicants applying for U.S. job openings must be legally authorized to work in the United States. Benefits are available to contract/temporary professionals, including medical, vision, dental, and life and disability insurance. Hired contract/temporary professionals are also eligible to enroll in our company 401(k) plan. Visit roberthalf.gobenefits.net for more information.

Benefits & conditions

Robert Half works to put you in the best position to succeed. We provide access to top jobs, competitive compensation and benefits, and free online training. Stay on top of every opportunity - whenever you choose - even on the go. Download the Robert Half app (https://www.roberthalf.com/us/en/mobile-app) and get 1-tap apply, notifications of AI-matched jobs, and much more.

About the company

Robert Half is the world's first and largest specialized talent solutions firm that connects highly qualified job seekers to opportunities at great companies. We offer contract, temporary and permanent placement solutions for finance and accounting, technology, marketing and creative, legal, and administrative and customer support roles.

Apply for this position