Analytics Engineer (Power BI)

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 building a data culture where insight drives action.

It also means evolving how we think about the role of a Sr. Business Intelligence Developer.

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.

WHAT YOU’LL DO:

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.

Power BI Development

• 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.

Modeling & Analysis

• 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.

Visualization & Communication

• 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.

Business Partnership

• 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.

WHAT WE’RE LOOKING FOR:

Education and Work Authorization

• Bachelor’s degree in Statistics, Data Science, Computer Science, Mathematics, or a related field

• U.S. Citizen or Green Card Holder is required

Experience:

• 2+ years of experience with a degree, additional years of experience accepted in lieu of degree.
• 2+ 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.

• Hands-on experience with Microsoft Azure and Microsoft Fabric preferred.
• Required
• • Power BI
  • DAX
  • Power Query (M)
  • SQL Server / T-SQL
  • Data Modeling
  • Star Schema Design
  • Semantic Models
  • Report Performance Optimization
• Preferred
• • 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.

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.

WHAT’S IN IT FOR YOU:

Join Our Team & Make an Impact! At Orion180, we don’t just meet expectations, we exceed them. If you’re 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 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 [email protected] to request assistance.