SageSure

AWS Data Engineer

Job description

We are looking for a Senior Analytics Engineer to join our growing team of experts. 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 Analytics Engineer will support our software teams, data analysts, and data scientists on data initiatives, ensure optimal data delivery architecture is consistent throughout ongoing projects and be integral to the 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 lake house

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
If shaping the future of an industry sounds exciting, you’ll love working at SageSure! As a Business Insurance Best Places to Work in Insurance recipient two years in a row (2020-2021), we’ve created an environment where employees can thrive, enjoy their work and contribute to our overall growth. We provide generous health benefits and perks, including tuition reimbursement, wellness allowance, paid volunteer time off, a matching 401K plan and more. SageSure fosters inclusion, creating an environment where everyone can bring their whole self to work.

We have nine office locations—Jersey City, NJ; Mountain View, CA; Atlanta, GA; Chicago, IL; Tallahassee, FL; Cincinnati, OH; Houston, TX; Mt. Laurel, NJ; and Cheshire, CT—as well as numerous remote employees across the country. We’re energetic, forward-thinking problem solvers; come join our team! For more information on SageSure, visit www.sagesure.com/careers/.
SageSure is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, disability, veteran status, gender identity, national origin or any other factor protected by applicable federal, state or local laws.

Please let the company know that you found this position on this Job Board as a way to support us, so we can keep posting cool jobs.

Similar jobs

Browse All Jobs