Data and Analytics Architect
About The Position
Orion180 is investing in analytics as a foundation for business decisions across underwriting, distribution, and customer experience. The Data and Analytics Architect will design and govern scalable data platforms on Microsoft cloud, bridge core insurance systems such as policy administration, claims, and billing with analytical users, implement lakehouse architectures, support data governance, and lead cloud migrations and platform integrations. The role combines technical execution with curiosity, ownership, and the ability to frame ambiguous problems and guide the business toward better decisions. The architect will partner with the Enterprise Innovation & Technology organization, data engineers, data scientists, analysts, security and compliance teams, and business leaders. The position develops production-ready data assets for real-time analytics, portfolio risk platforms, machine learning, business intelligence, and client-facing digital products. It is 100% onsite in Irving, Texas, in a fast-paced, collaborative office environment. Employees must work their assigned onsite schedules and may need to work extended schedules depending on business, project, or customer needs.
Requirements
- Bachelor’s or Master’s degree in Computer Science, Engineering, Mathematics, or a related quantitative field.
- United States citizenship or Green Card holder status is required.
- At least 7 years of enterprise data architecture experience, with demonstrated expertise leading data platform initiatives and modernizing data estates.
- Expert proficiency in Azure Data Lake Storage Gen2, Azure Synapse Analytics, Azure Databricks, Azure Data Factory, and Microsoft Fabric.
- Strong knowledge of relational and NoSQL systems, including Azure SQL Database and Azure Cosmos DB.
- Experience designing real-time architectures 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.
- 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.
- Willingness and ability to work the assigned schedule onsite and, when needed, an extended schedule based on company or departmental needs, project requirements, or customer demands.
- Ability to sit, stand, and/or walk around, including using stairs; communicate by talking and listening, comprehend and read; lift light objects under 25 pounds; and use standard office equipment. Occasional bending, twisting, or squatting may be required.
Nice To Haves
- Microsoft Certified: Azure Data Engineer Associate or Azure Solutions Architect Expert.
- Experience or familiarity with semantic data modeling and governed metric layers.
- Experience working within scalable cloud data platforms such as Snowflake or Databricks and integrating analytics into broader data engineering workflows.
- Exposure to AI-assisted analysis, automated insight generation, and advanced data visualization techniques.
Responsibilities
- Design secure, scalable, and resilient Microsoft cloud data architectures using medallion (Bronze/Silver/Gold) and Delta Lake patterns in partnership with Enterprise Innovation & Technology.
- Lead physical and logical data modeling 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 that map third-party SaaS and legacy databases to machine-readable schemas for efficient, measurable consumption.
- Architect secure, scalable Model Context Protocol (MCP) servers and gateways connecting LLMs and AI agents to internal analytical data repositories.
- Establish architectural patterns and best practices for data ingestion, transformation, and pipeline orchestration.
- Evaluate, benchmark, and recommend modern data stack components aligned with the I & T strategy, and participate in the Architecture Review Board.
- Review architectures with Data Engineers and mentor engineers on scalability and pipeline efficiency.
- Architect semantic layer solutions and data product structures to support self-service Power BI implementations.
- Architect high-throughput batch and streaming pipelines for structured policy and claims data and unstructured data such as adjuster notes, FNOL images, and aerial or satellite imagery.
- Collaborate with Data Science and Machine Learning teams on clean, structured feature stores and data pipelines for future models and applications.
- Implement automated data quality monitoring, data lineage tracking, and metadata management across the data lifecycle.
- Partner with Enterprise Technology and Security and Compliance teams to enforce role-based access control, data masking, and compliance standards.
- Partner with the I & T architecture team to build and optimize ETL/ELT workflows using Azure Data Factory and Microsoft Fabric Data Pipelines.
- Work with Data Engineers, Data Scientists, and business stakeholders to deploy AI/ML models and business intelligence solutions such as Power BI.
- Collaborate across technical and non-technical teams and manage multiple projects in a fast-paced, results-driven environment.
Benefits
- Competitive base pay and performance bonuses.
- Mentorship, growth tracks, and professional development.
- Medical, dental, and vision benefits.
- 401(k).
- Paid holidays.
- PTO.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
