Principal BI Engineer

Overview: 

If you're looking for the stability of a profitable, growing company with the entrepreneurial spirit of a startup, we’re hiring. SageSure, a leader in catastrophe-exposed property insurance, is seeking a Principal BI Engineer to join our dynamic Business Intelligence team and play a pivotal role in converting complex data into actionable insights that drive strategic decisions across our organization.  In this role, you’ll be responsible for both designing and building complex data models as well as providing architectural guidance to our growing team of developers. This is a unique opportunity to lead from the front as both a strategic thinker and an expert implementer, working on cutting-edge big data technologies and leading initiatives that drive real impact. 

The Principal BI Engineer will play a pivotal role in helping shape the future of SageSure’s data capabilities, building advanced BI Solutions and providing the architectural direction necessary to ensure excellence across the team. The development and optimization of data pipelines and structures that support reporting, analytics, and decision-making processes. You’ll have the unique opportunity to lead the design of highly scalable solutions while mentoring a team of 15 BI developers, ensuring best practices across the board. 

What you’d be doing: 

In this role, you will take the lead in designing, implementing, and maintaining scalable ETL/ELT processes, transforming business rules into structured datasets using tools like SQL, Python, AWS Redshift, and more. You will be responsible for reviewing and optimizing data development projects across the team, ensuring that projects adhere to best practices and architectural standards. A key part of your work will involve designing automation strategies to replace manual data processes, improving efficiency and accuracy across the company’s data landscape.  

You will collaborate closely with cross-functional teams to ensure the BI architecture supports the increasing demand for advanced analytics and data science initiatives. Additionally, you'll take the lead on complex data modeling as the team migrates from SQL to Redshift, ensuring that the data infrastructure meets both current and future business needs. You will also play an active role in architectural discussions, promoting the use of best-in-class tools and ensuring alignment with business requirements. 

Your role involves: 

•  Architect & Design: Lead the design of scalable data models and architecture to support the BI and analytics needs of the company. Design and implement best practices and standards. 
• Consult & Guide: Provide architectural guidance to BI developers across the team, reviewing code and ensuring adherence to the highest standards. 
• Build & Implement: Contribute directly to development by building high-performance datasets and automated workflows using AWS Redshift, SQL, Python, and other cutting-edge tools. 
• Performance Optimization: Ensure that all BI solutions are designed with performance and scalability in mind. Continuously review and optimize data pipelines and reporting processes. 
• Leadership & Mentoring: Provide leadership to a team of 15 BI developers, offering both technical mentorship and guidance on project execution. Lead by example as a senior resource who can contribute directly to projects. 
• Data Governance: Oversee the creation of reusable data assets, enforce data quality standards, and ensure that established data governance best practices are adhered to across the team. 
• Cross-functional Collaboration: Work closely with Engineering, Product, and Executive teams to translate complex business requirements into technical BI solutions that drive actionable insights. 

We’re looking for someone who has: 

• 7+ years of experience with SQL, Python, and other programming languages related to ETL/ELT and data transformation. 
• 7+ years of experience building data solutions for broad consumption and reporting solutions using leading BI tools (Tableau, Qlik, PowerBI, Domo, etc.). 
• Proven experience leading and mentoring data developers, ensuring adherence to best practices in both coding and architecture. 
• A track record of implementing large-scale data projects, from data analysis, through to implementation.  
• Strong experience in performance tuning, troubleshooting, and optimizing SQL queries and data models. 
• Excellent communication and problem-solving skills, able to interface with both technical teams and business users to align on solutions. 
• Experience working in cloud-based environments (AWS preferred), with a focus on data warehousing (Redshift/Azure) and related technologies. 
• Familiarity with automated testing frameworks for validating data integrity. 
• A Bachelor's degree in Computer Science, Data Science, Engineering, or a related field (preferred, but not required). 

Highly preferred candidates also have: 

• Proficiency in AWS infrastructure (Redshift/Athena) or similar platforms (Google, Snowflake etc).  
• Proficiency tuning ETL processes and warehouse databases  
• Experience in Insurance specifically Property & Casualty data systems

About SageSure:

As a Best Places to Work in Insurance Recipient for four years in a row (2020-2023), SageSure, one of the largest residential property insurance managing general underwriter (MGU) in the United States, is pioneering ways people protect their American Dream.

A leader in catastrophe-exposed property insurance, SageSure was founded in 2009 to deliver reliable products, exceptional customer experiences, and strong underwriting results in challenging insurance markets. SageSure currently operates in 14 states and provides home, flood, and commercial coverage on behalf of its highly rated carrier partners.

We have more than 600 employees working remotely or hybrid in one of our eight offices—Jersey City, NJ; Mountain View, CA; Chicago, IL; Tallahassee, FL; Cincinnati, OH; Houston, TX; Mt. Laurel, NJ; and Cheshire, CT—who are tackling the industry’s toughest challenges.  

We provide generous health benefits and perks, including tuition reimbursement, wellness allowance, paid volunteer time off, a matching 401K plan, and more.

SageSure is a proud Equal Opportunity Employer committed to building a workforce that reflects the spectrum of perspectives, experiences, and abilities of the world we live in. We recognize that our differences make us strong, and we actively seek out diverse candidates through partnerships with organizations, institutions and communities that represent various backgrounds. We champion belonging and inclusion for all identities, including, but not limited to, race, ethnicity, religion, sexual orientation, age, veteran status, ability status, gender, and country of origin, striving to create a culture where all individuals feel valued, respected, and empowered to bring their authentic selves to work.

Our nimble, highly responsive culture nurtures critical thinkers who run toward problems and engineer solutions. We relentlessly pursue better outcomes by investing in the technology, talent, and tools that position us to succeed in demanding markets. Come join our team! Visit sagesure.com/careers to find a position for you.