Analytics 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 Analytics Engineer. In this role, you'll lead a talented team of engineers tasked with creating authoritative and dependable data foundations across the organization. Your team will focus on converting raw base-layer data into highly optimized, curated datasets, and disseminating this information to key stakeholders. The Analytics Engineer will partner with data's end-users to comprehend their needs, while liaising with our Data Engineering team to ensure the delivery of high-quality data solutions. The ideal candidate will be energized by the opportunity to be a part of an evolving team, with ample scope for career progression, all while working on state-of-the-art AWS technology to develop and support our lake house architecture. 

What you’d be doing: 

• Collaborate with Data Engineering to identify and source essential data for fulfilling your deliverables. 
• Promote data-driven culture and awareness throughout the organization. 
• Drive and maintain a robust data dictionary for curated datasets with the team. 
• Create data pipelines that generate well-curated datasets. 
• Design and oversee the ETL workflow processes, transitioning base-layer data into curated datasets. 
• Transform lake house data into consumable datasets within Athena and Redshift platforms. 
• Write reusable code and modules for executing data transformation logic. 
• Design data delivery systems for high-volume, near real-time reporting. 

We’re looking for someone who has: 

• Bachelor's Degree in Computer Science, Applied Math, Economics, Statistics or a related discipline is preferred but not required. 
• Strong SQL, data analysis, and business analysis skills.  
• Proficiency in PySpark and Python programming. 
• Proficiency in AWS architecture, including S3, networking, and database solutions. 

Highly preferred candidates also have: 

• Proficiency in AWS Glue infrastructure. 
• Proficiency tuning ETL processes and warehouse databases (such as RedShift) 

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.