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)