Azure Data Architect: Enterprise Analytics & AI Pipelines

Orion180 Insurance Co.; Irving (TX); On-site; USD 120,000 - 180,000; Full time

Benefits offered by this job

Medical, dental, vision

401k

Paid holidays

PTO

Job summary

Orion180 Insurance Co. seeks a Data and Analytics Architect to design and govern scalable data platforms on Microsoft cloud, bridging core insurance systems with analytics consumers.

You will implement data lakehouse architectures, ensure governance, and lead cloud migrations and platform integrations. The role requires expert Azure data services, data modeling, and collaboration with data scientists, analysts, and business leaders to deliver production-ready analytics assets for real-time

Qualifications

• 7+ years in enterprise data architecture with leading data platform initiatives.
• Strong knowledge of relational and NoSQL systems (Azure SQL Database, Azure Cosmos DB).
• Expertise with Python, SQL, PySpark, Spark SQL.

Responsibilities

• Design secure, scalable data architectures using Bronze/Silver/Gold and Delta Lake patterns.
• Lead data modeling across relational, dimensional (Kimball/Star) and Data Vault.
• Develop high-performance data processing with PySpark on Azure Databricks and Synapse.
• Define data abstraction layers mapping third-party/legacy data to machine-readable schemas.
• Architect MCP servers/gateways to connect LLMs to data repositories.
• Establish patterns for data ingestion, transformation, and pipelines.
• Evaluate and align with I&T strategy and Architecture Review Board.

Skills

Azure data services

Python

SQL

PySpark

Spark SQL

Data modeling

Delta Lake

Power BI

Cloud data architecture

Education

Bachelor’s or Master’s in CS/Engineering/Math

Tools

Azure Databricks

Synapse Analytics

Azure Data Factory

Microsoft Fabric Data Pipelines

Power BI

Job description

Orion180 Insurance Co. seeks a Data and Analytics Architect to design and govern scalable data platforms on Microsoft cloud, bridging core insurance systems with analytics consumers.

You will implement data lakehouse architectures, ensure governance, and lead cloud migrations and platform integrations. The role requires expert Azure data services, data modeling, and collaboration with data scientists, analysts, and business leaders to deliver production-ready analytics assets for real-time