Data and Analytics Architect

ABOUT THE ROLE:

We believe analyticsisnta back-office a reporting layer bolted onto the business after the real decisions get the foundation that tells you where riskactually lives where growth is hiding and where youremissing opportunitiesbefore its 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 weoperate. From underwriting to distribution to customer experiencewerebuilding a data culture where insight drives action.

It also means evolving how we think about the role of aDataand Analytics Architect.

The expectationisntjust technical . Ownership. The ability to step into ambiguity frame the problem and help guide the business toward better decisions.

WHAT YOULL DO:

In thisroleyou willbedesigningandgoverningscalable data platforms on the Microsoft cloud. Key responsibilities includebridging the gap between complex core insurance systems (Policy Admin Claims Billing) and our analytical consumers implementing datalakehousearchitectures ensuring data governance and leading cloud migrationsandplatform integrations. Ideal candidatesrequireexpert-levelproficiencyinAzure data services and data modeling.You will collaborate with data scientists analysts and business leaders to turn raw data into scalable production-ready assetsforreal-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 andDelta Lakepattern in close partnership withthe 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 usingPySpark Spark SQL and Python onAzure Databricksand Synapse Analytics.

• Define data abstraction layers ensuring third-party SaaS and legacy databases map cleanly to machine-readable schemas forefficient and measurableconsumption.

• Architect secure scalable Model Context Protocol (MCP) servers and gateways to connect LLMs and AI agents to internalanalyticaldata 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 stackin alignment withI & Ts strategyandbe 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-servicePowerBIimplementations.

• Architect high-throughput batch and streaming pipelines to ingest structuredtransactionalpolicy/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 forfutureML models and applications.

Governance Quality & Security

• Implement automated data quality monitoring data lineage tracking and metadata management frameworksacross the data lifecycle.

• Partner withthe Enterprise Technology andSecurityand Compliance teams to enforce role-based access control (RBAC) data masking and compliance standards (SOC 2 GDPR CCPA).

Architectural Leadership

• Partner with theI & Tarchitecture team tobuild andoptimizecomplex ETL/ELT workflowsutilizingAzure Data FactoryandMicrosoft Fabric Data Pipelines.

• Work closelywith Data Engineers Data Scientists and business stakeholders to deploy AI/ML models and Business Intelligence solutions (e.g. Power BI).

WHAT WERE LOOKING FOR:

• Education:
• Bachelors orMasters degree in Computer Science Engineering Mathematics or a related quantitative field.

• United States Citizen or Green Card holderrequired.

Experience:

• 7 years in enterprise data architecture withdemonstratedexpertisein leading data platform initiatives and modernizing data estates.

• Expert inAzure Data Lake Storage Gen2Azure Synapse AnalyticsAzure DatabricksAzure Data Factory andMicrosoft Fabric.

• Strong knowledge of relational and NoSQL systems likeAzure SQL DatabaseandAzure Cosmos DB.

• Experience designing real-timearchitectureusingAzure Event HubsandStream Analytics.

• HighproficiencyinPythonSQLPySpark andSpark SQL.

• Ability to integrateGeospatialdata types and visualization platforms for locationintelligencethat removesdata fragmentation and technical bottlenecks.

• Preferred credentials includeMicrosoft Certified: Azure Data Engineer AssociateorAzure Solutions Architect Expert.

Skills & Attributes:

• Excellent analytical problem-solving andcritical-thinkingskills.

• Strong communicationand collaboration abilities across technical and non-technical teams.

• Ability to manage multiple projects in a fast-pacedresults-driven environment

This position is 100% onsite in our Irving TX location

We are interested in candidates whoare developingcapabilities aligned with modern forward-looking analytics practices. This includes experience or familiarity with semantic data modeling and governed metric layers working within scalable cloud data platforms (e.g. Snowflake Databricks) and integrating analytics within broader data engineering workflows. Exposure to emerging capabilities such as AI-assisted analysis automated insight generation and advanced data visualization techniques is highly valued.

WHATS IN IT FOR YOU:

Join Our Team & Make an Impact! At Orion180 we dont just meet expectations we exceed them. If youre ready to take your career to the next level and be part of a growing forward-thinking company apply today!

• 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 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 to request assistance.

Required Experience:

Staff IC