Data Modeling Lead

Are you a data architecture professional who is passionate about building the trusted foundation that powers enterprise analytics Orion180 is seeking a Semantic Model Manager to own the suite of semantic models that drive analytics across underwriting claims finance sales and executive reporting. You will be the steward of oursingle sourceof truthensuring that the right data is available in the right dimensions to power every aspect of Orion180s business.

At Orion180 we expect ouranalytics teamto go beyond maintenance and serve as architectural partners to the business. The ideal candidatedemonstratesstrong intellectual curiosity and ownership by proactively understanding not just how a model performs today butwhyit is structured as it is and how it must evolve to meet tomorrows analytical demands. This role requires a self-starter who is comfortable operating with ambiguity asks thoughtful and targeted questions and translates loosely defined business needs into durable well-governed data structures.

Success in this role depends on the ability to balance performance stability and flexibility while workinghand-in-handwith Analysts and Data Scientists. We are looking for someone who not onlymaintainsmodels but shapes how the entire organization consumes and trusts its data.

WHAT YOULL DO:

Semantic Model Ownership & Architecture

• Own the design structure and full lifecycle of the semantic models that power Orion180s analytics across underwriting claims finance sales and executive reporting.

• Architect dimensional models(facts dimensions hierarchies and relationships)that deliver the right data in the right grain for every business domain.

• Drive the evolution of the model portfolio including decomposition into certified core and satellite models to balance reuse performance and domain ownership.

Performance Stability & Governance

• Monitor diagnose andoptimizemodel performance resolving problematic relationships calculation bottlenecks and refresh stability issues before they reach the business.

• Establish and enforce governance standards(naming conventions certified datasets documentation and data lineage)tomaintaina trustedsingle sourceof truth.

• Define and steward the metric and measure library ensuring consistent validated business logic across every reporting surface.

Enablement & Collaboration

• Partnerhand-in-handwith Analysts and Data Scientists to ensure the data they need is modeled accessible and dimensioned to power their analyses and machine learning workflows.

• Translate evolving business questions into model enhancements proactivelyanticipatingthe dimensions and measures the business will need next.

• Document model architecture and designdecisions andmentor analysts on best practices for consuming the semantic layer.

WHAT WERE LOOKING FOR:

Education:

• Bachelors degree in Computer Science Information Systems Data Engineering Statistics or a related field (Masterspreferred).

Experience:

• Proven experience owning or developing enterprise semantic models and governed metric layers within the insurance or financial services industry.

• Demonstrated experience owning models at enterprise scaleincluding fact tables exceeding one billion rowswhile sustaining query and refresh performance under concurrent high-throughput workloads.

• Deepproficiencyin dimensional modeling SQL optimization DAX (or equivalent semantic modeling languages) and data transformation tooling such asdbt.

• Hands-on experience with modern cloud data platforms such asAzureSnowflake and Databricks and BI platforms such as Power BI and Tableau.

• Strong understanding of model performance tuning relationship and cardinality management and data governance principles.

Skills & Attributes:

• Excellent analytical problem-solving and architectural-thinking skills.

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

• Ability to balance competing priorities and manage the evolution of shared data assets in a fast-paced results-driven environment.

We are especially interested in candidates who bring a forward-looking perspective to the semantic layer. This includes familiarity with semantic model decomposition and certified dataset strategies automated documentation and lineage tooling AI-assisted model analysis and emerging approaches to scalable self-service analytics across the enterprise.

WHATS IN IT FOR YOU:

Join Our Team & Make an Impact!

At Orion180 wedontjust meet expectationswe exceed them. Ifyoureready to take ownership of the data foundation behind a growing forward-thinking company apply today!

Dynamic Environment:On-site role with a collaborative fast-moving team culture where your work powersreal businessimpact.

Compensation:Competitive base salary with performance-driven bonuses.

Career Growth:Opportunities for mentorship technical certifications and professional development.

Benefits:Comprehensive benefits package including medical dental vision 401(k) 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.