Analytics Engineer (Power BI)
Role Overview
Orion180 is investing in analytics as a foundation for understanding risk, growth, and opportunities.
The role involves designing, developing, and scaling enterprise reporting and analytics solutions across the organization.
Primary mandate is to build and maintain centralized semantic models, develop high-performance Power BI solutions, and partner with business stakeholders to transform data into actionable insights.
The role advances the modern data and analytics platform, enabling self-service reporting, standardized business metrics, and data-driven decision making.
Key Skills for This Role
Full Job Posting
About the Role
Orion180 is investing in analytics as a foundation for understanding risk, growth, and opportunities.
The role involves designing, developing, and scaling enterprise reporting and analytics solutions across the organization.
Primary mandate is to build and maintain centralized semantic models, develop high-performance Power BI solutions, and partner with business stakeholders to transform data into actionable insights.
The role advances the modern data and analytics platform, enabling self-service reporting, standardized business metrics, and data-driven decision making.
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.
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.
- 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.
Required Skills
- Power BI
- DAX
- Power Query (M)
- SQL Server / T-SQL
- Data Modeling
- Star Schema Design
- Semantic Models
- Report Performance Optimization
Preferred Skills
- Microsoft Fabric
- OneLake
- Fabric Data Warehouse
- Lakehouse Architecture
- Data Products
- CI/CD for Analytics
- Azure Data Factory
- Fabric Pipelines
Benefits
- Competitive base pay and performance bonuses.
- Medical, dental, vision, 401k, paid holidays, PTO and more.
- Mentorship, growth tracks, and professional development.
- Dynamic on-site role with a fast-paced and collaborative team culture.
Apply for this job in 1 click
Skip the repetitive application forms
Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.
Trusted by over 500,000 job seekers on Base Career