Senior Analytics Engineer (PowerBi and Fabric)

Orion180 Insurance Services•Irving, TX

11d•Onsite

About The Position

We believe analytics isn't a back-office function. 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. This 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 building a data culture where insight drives action. The expectation isn’t just technical execution. It’s curiosity. Ownership. The ability to step into ambiguity, frame the problem, and help guide the business toward better decisions. In this role you will design, develop, and scale enterprise reporting and analytics solutions across the organization. Your primary mandate is to build and maintain centralized semantic models, developing high-performance Power BI solutions, and partnering with business stakeholders to transform data into actionable insights. This role will play a critical part in advancing our modern data and analytics platform, enabling self-service reporting, standardized business metrics, and data-driven decision making across the enterprise. You'll collaborate with leaders in data, analytics, engineering, and business operations to create capabilities that directly influence company growth and performance.

Requirements

Bachelor’s degree in Statistics, Data Science, Computer Science, Mathematics, or a related field
U.S. Citizen or Green Card Holder is required
5+ years developing enterprise BI solutions.
3+ years of advanced Power BI development experience, including enterprise semantic modeling and performance optimization.
Proven experience in data analysis, modeling, and visualization within the insurance or financial services industry.
Experience using Python and SQL for data analysis, automation, and data quality validation.
Required Power BI DAX
Power Query (M)
SQL Server / T-SQL
Data Modeling
Star Schema Design
Semantic Models
Report Performance Optimization

Nice To Haves

Microsoft Fabric
OneLake
Fabric Data Warehouse
Lakehouse Architecture
Data Products
CI/CD for Analytics
Azure Data Factory
Fabric Pipelines
Experience designing enterprise semantic models.
Experience working with large-scale datasets and performance tuning.
Excellent communication and stakeholder management skills.
Strong analytical and problem-solving abilities.
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.

Responsibilities

Design, build, and maintain enterprise Power BI dashboards, reports, and scorecards.
Create advanced DAX calculations, measures, KPIs, and calculation groups.
Implement report performance tuning and optimization best practices.
Design, build, and maintain enterprise semantic models, reusable datasets, and certified data products that support self-service analytics.
Establish BI development standards, documentation, deployment processes, and governance practices.
Collaborate with sales, underwriting, claims, actuarial, and operational teams to deploy reporting solutions, semantic models, and analytical data products.
Design and implement Row-Level Security (RLS) and data access controls to ensure secure and governed access to analytics assets.
Establish visualization standards and dashboard design guidelines.
Design and optimize data models that support enterprise reporting and self-service analytics.
Conduct data analysis and validation activities to ensure data integrity, consistency, and business rule adherence across enterprise data assets.
Document semantic models, business definitions, governance processes, and data lineage to support auditability and regulatory compliance.
Design and maintain scalable star schema and dimensional data models.
Develop and govern enterprise business metrics and KPI definitions.
Create centralized semantic models to support multiple business domains.
Partner with Data Engineering and Stewardship teams to ensure reliable, high-quality data pipelines.
Promote consistency of business logic across reporting and analytics platforms.
Build intuitive dashboards and data visualizations using Power BI that translate complex insights into clear business intelligence.
Communicate findings and recommendations to cross-functional teams, including leadership and technical partners.
Stay current with industry trends and emerging analytics, Power BI, Microsoft Fabric, and data engineering technologies.
Leverage Microsoft Fabric, OneLake, Data Warehouse, and Lakehouse capabilities.
Develop data access and reporting solutions using Fabric data assets.
Support implementation of enterprise analytics architecture and governance frameworks.
Collaborate on data product development and lifecycle management.
Work directly with business leaders, analysts, and operational teams to gather requirements.
Translate business needs into scalable reporting and analytical solutions.
Provide recommendations based on data analysis and industry best practices.
Deliver executive-ready dashboards and presentations.