Senior Analytics Engineer (PowerBi and Fabric)

Job description

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. Describe the role and team the candidate will be joining 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: 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. 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. This position is 100% onsite in our Irving, TX location We are interested in candidates who are developing capabilities aligned with modern, forward-looking analytics practices. This includes 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 is highly valued. 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: M entorship, 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 to request assistance. At Orion180, we don’t just stand out for what we do; we shine because of how we do it. Our mission is to deliver an exceptional insurance experience through innovative technology, unparalleled customer service, and a comprehensive suite of products. Our vision is to be the premier global provider of insurance solutions and redefine the insurance industry. O rion180 is proud to call three vibrant cities home. Our headquarters on Florida’s stunning Space Coast in Melbourne offers an exceptional quality of life, with affordable housing, excellent transportation, and close proximity to major cities like Orlando, Tampa, and Miami. Our Irving, Texas, office places us in a dynamic center of culture, business, and entertainment, keeping us closely connected to innovation and growth. Our Draper, Utah, location, nestled in the heart of the Salt Lake Valley, connects us to a rapidly growing tech ecosystem and provides access to the outdoor lifestyle and natural beauty the region is known for.