200+ applicants

Company

Original Job Post

SageSure · 4 days ago

Senior Data Engineer

United States

Full-time

Remote

Senior Level

5+ years exp

Wonder how qualified you are to the job?

Maximize your interview chances

Property InsuranceReal Estate

H1B Sponsorship

Insider Connection @SageSure

Discover valuable connections within the company who might provide insights and potential referrals, giving your job application an inside edge.

Responsibilities

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.

Qualification

Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.

Data LakeData WarehouseSource ControlCICD PipelinesAWS InfrastructureScalaPythonSQLAWS GlueDB TechnologiesRedShiftAthenaPostgresS3Warehouse DesignReal-time IngestionETL ProcessesLarge DatasetsETL TuningCommunicationCollaborationInsurance industry experienceAWS Aurora experienceAWS Data Migration Service experienceEnvironment refreshes

Required

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

Preferred

Insurance industry experience

AWS Aurora experience

AWS Data Migration Service experience

Environment refreshes (data and schema)

Benefits

Generous health benefits

Tuition reimbursement

Wellness allowance

Paid volunteer time off

Matching 401K plan

Company

SageSure

SageSure is a managing general underwriter specializing in coastal residential and commercial property markets.

Founded in 2005

Jersey City, New Jersey, USA

501-1,000 employees

https://www.sagesure.com/

H1B Sponsorship

SageSure has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)

Distribution of Different Job Fields Receiving Sponsorship

Trends of Total Sponsorships

2023 (4)

2022 (2)

2021 (1)

2020 (1)