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 Senior AWS Data Engineer. The hire will be responsible for expanding and optimizing our data and data pipeline architecture, as well as optimizing data flow and collection for cross-functional teams. The ideal candidate is an experienced data pipeline builder and data wrangler using AWS architecture who enjoys optimizing and building data systems from the ground up. The Senior Data Engineer will support our software teams, data analysts, and data scientists on data initiatives, ensure optimal data delivery architecture is shape of data architecture moving into the future.
What you’d be doing:
- Designing and managing the ETL process workflows
- Modeling lake house data in all stages (raw, discovery, curated, and optimized warehouse database schemas)
- Coding transformation logic by writing reusable code and modules
- Developing QA strategies for data ingestion and transformation processes
- Defining and implementing standards for data cleansing and masking
- Working with business users' requirements to deliver data usable across the organization
- Defining and implementing security standards into the data lake.
We’re looking for someone who has:
- 5+ years of Data Lake and Warehouse experience
- Experience with source control and/or CICD pipelines
- Production experience with AWS infrastructure
- Proficiency with Scala, Python, and SQL
- Experience with AWS Glue infrastructure.
- Production experience with DB technologies such as RedShift, SQL Server, Athena, and Postgres
- High volume production experience with AWS architecture such as S3, networking and DB technologies
- Experience in production level warehouse design with high volume near real time ingestion and reporting
- A successful history of manipulating, processing, and extracting value from large, disconnected datasets
- Hands-on experience tuning ETL processes and warehouse databases such as RedShift
- The ability to communicate and collaborate effectively with Product Owners, Developers, QA, Operations, and Security Engineers
Highly preferred candidates also have:
- Insurance industry experience
- AWS Aurora experience
- AWS Data Migration Service experience
- Environment refreshes (data and schema)
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.
Top Skills
What We Do
SageSure is an innovation-focused insurance and technology company specializing in underserved property markets. As the leading homeowners insurtech organization in the U.S. measured by premium and profitability, we offer more than 40 competitively priced insurance products on behalf of our carrier partners, serving 300,000+ policyholders. SageSure partners with a growing network of insurance agents and brokers in 14 coastal states.
_0.jpg)
