Data and Analytics Architect

Orion180; Irving (TX); On-site; USD 130,000 - 190,000; Full time

Benefits offered by this job

Medical

Dental

Vision

401k

Paid holidays

PTO

Job summary

Orion180 in Irving, TX is seeking a Data and Analytics Architect to lead modern data platform initiatives on Azure. You will design scalable data architectures, govern data quality, and partner with data scientists and business leaders to deliver production‑ready analytics assets including Power BI data models.

You will drive data modeling, ETL/ELT workflows, and secure access controls, while mentoring engineers and aligning architecture with SOC 2, GDPR, and privacy standards.

Qualifications

• Bachelor’s or Master’s degree in a quantitative field.
• 7+ years of enterprise data architecture experience.
• Expertise with Azure data services and data modeling.
• Strong Python/SQL skills and experience with PySpark.
• Experience designing real-time or near-real-time analytics platforms.

Responsibilities

• Design secure, scalable data architectures in Azure and guide data platform modernization.
• Lead data modeling across relational, dimensional, and Data Vault approaches.
• Develop high-performance data processing using PySpark on Azure Databricks and Synapse.
• Govern data quality, lineage, and security with RBAC and compliance controls.
• Architect data product structures to power Power BI self-service implementations.
• Collaborate with Data Science and ML teams to enable production analytics and AI initiatives.

Skills

Python

SQL

PySpark

Spark SQL

Education

Bachelor’s or Master’s degree in Computer Science, Engineering, Mathematics, or related quantitative field

Tools

Azure Data Lake Storage Gen2

Azure Synapse Analytics

Azure Databricks

Azure Data Factory

Microsoft Fabric

Azure SQL Database

Azure Cosmos DB

Power BI

Job description

At Orion180, we don’t just stand out for what we do; we shine because of how we do it. Our mission is to deliver an exceptional insurance experience through innovative technology, unparalleled customer service, and a comprehensive suite of products. Our vision is to be the premier global provider of insurance solutions and redefine the insurance industry.

Orion180 is proud to call three vibrant cities home. Our headquarters on Florida’s stunning Space Coast in Melbourne offers an exceptional quality of life, with affordable housing, excellent transportation, and close proximity to major cities like Orlando, Tampa, and Miami. Our Irving, Texas, office places us in a dynamic center of culture, business, and entertainment, keeping us closely connected to innovation and growth. Our Draper, Utah, location, nestled in the heart of the Salt Lake Valley, connects us to a rapidly growing tech ecosystem and provides access to the outdoor lifestyle and natural beauty the region is known for.

About The Role

We believe analytics isn’t a back‑office function. It’s not a reporting layer bolted onto the business after the real decisions get made. It’s the foundation that tells you where risk actually lives, where growth is hiding, and where you’re missing opportunities before it’s too late to do anything about it.

That belief is driving real investment in our people, platforms, and in how deeply analytics is woven into the way we operate. From underwriting to distribution to customer experience, we’re rebuilding a data culture where insight drives action.

It also means evolving how we think about the role of a Data and Analytics Architect.

The expectation is not just technical execution. It’s curiosity, ownership, the ability to step into ambiguity, frame the problem, and help guide the business toward better decisions.

What You’ll Do

In this role you will be designing and governing scalable data platforms on the Microsoft cloud. Key responsibilities include bridging the gap between complex core insurance systems (Policy Admin, Claims, Billing) and our analytical consumers, implementing data lakehouse architectures, ensuring data governance, and leading cloud migrations and platform integrations. Ideal candidates require expert-level proficiency in Azure data services and data modeling. You will collaborate with data scientists, analysts, and business leaders to turn raw data into scalable, production‑ready assets for real‑time analytics engines, portfolio risk platforms, and client‑facing digital products.

Data Architecture & Modeling

• Design secure, scalable, and resilient data architectures using the medallion (Bronze/Silver/Gold) pattern and Delta Lake pattern in close partnership with the Enterprise Innovation & Technology (I & T) organization.
• Lead physical and logical data modeling efforts across relational, dimensional (Kimball / Star Schema), and Data Vault methodologies.
• Develop high-performance data processing logic using PySpark, Spark SQL, and Python on Azure Databricks and Synapse Analytics.
• Define data abstraction layers ensuring third-party SaaS and legacy databases map cleanly to machine-readable schemas for efficient and measurable consumption.
• Architect secure, scalable Model Context Protocol (MCP) servers and gateways to connect LLMs and AI agents to internal analytical data repositories.

Platform & Engineering Standards

• Establish architectural patterns and best practices for data ingestion, transformation, and pipeline orchestration.
• Evaluate, benchmark, and recommend components of our modern data stack in alignment with I & T’s strategy and be an active participant/contributor to the Architecture Review Board.
• Work closely with Data Engineers to conduct architecture reviews and mentor engineers on scalability and pipeline efficiency.
• Architect semantic layer solutions and data product structures to power self‑service Power BI implementations.
• Architect high-throughput batch and streaming pipelines to ingest structured transactional policy/claims data as well as unstructured data (e.g., adjuster loss notes, FNOL images, aerial and satellite imagery surveys).
• Collaborate with Data Science and Machine Learning teams to ensure clean, structured feature stores and data pipelines for future ML models and applications.

Governance, Quality & Security

• Implement automated data quality monitoring, data lineage tracking, and metadata management frameworks across the data lifecycle.
• Partner with the Enterprise Technology and Security and Compliance teams to enforce role‑based access control (RBAC), data masking, and compliance standards (SOC 2, GDPR, CCPA).

Architectural Leadership

• Partner with the I & T architecture team to build and optimize complex ETL/ELT workflows utilizing Azure Data Factory and Microsoft Fabric Data Pipelines.
• Work closely with Data Engineers, Data Scientists, and business stakeholders to deploy AI/ML models and Business Intelligence solutions (e.g., Power BI).

What We’re Looking For

• Education:
• Bachelor’s or Master’s degree in Computer Science, Engineering, Mathematics, or a related quantitative field.
• United States Citizen or Green Card holder required.

Experience

• 7+ years in enterprise data architecture with demonstrated expertise in leading data platform initiatives and modernizing data estates.
• Expert in Azure Data Lake Storage Gen2, Azure Synapse Analytics, Azure Databricks, Azure Data Factory, and Microsoft Fabric.
• Strong knowledge of relational and NoSQL systems like Azure SQL Database and Azure Cosmos DB.
• Experience designing real-time architecture using Azure Event Hubs and Stream Analytics.
• High proficiency in Python, SQL, PySpark, and Spark SQL.
• Ability to integrate Geospatial data types and visualization platforms for location intelligence that removes data fragmentation and technical bottlenecks.
• Preferred credentials include Microsoft Certified: Azure Data Engineer Associate or Azure Solutions Architect Expert.

Skills & Attributes:

• Excellent analytical, problem‑solving, and critical‑thinking skills.
• Strong communication and collaboration abilities across technical and non-technical teams.
• Ability to manage multiple projects in a fast‑paced, results‑driven environment.

This position is 100% onsite in our Irving, TX location

What’s In It For You

• Dynamic Environment: On‑site role with a fast‑paced and collaborative team culture. Results‑driven office where your contributions make a real impact.
• Compensation: Competitive base pay and performance bonuses.
• Career Growth: Mentorship, growth tracks, and professional development.
• Benefits: Medical, dental, vision, 401k, paid holidays, PTO and more!

The office environment is fast‑paced and collaborative. An employee must be willing and able to work their regularly assigned work schedule onsite, and in times of need, be able to work an extended schedule depending on company or departmental needs, project requirements, or customer demands.

While performing general duties for this position, the employee is regularly required to sit, stand, and/or walk around (including the use of stairs). Other demands include the ability to openly communicate with others by talking, listening, comprehending, and reading; being able to lift light objects (<25 lbs); and using standard office equipment such as computers, printers, and phones. In addition, there is an occasional need to bend, twist, or squat down to open/close cabinets and reach for files or other standard office-type objects.

Orion180 is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or protected veteran status.

Reasonable accommodations are available for qualified individuals with disabilities during the application process. Applicants who need accommodations may email [e-mail] to request assistance.