You and the process

With a person
Anna, in-house recruiter
9 years hiring engineers
30 minutes with a real recruiter
They read your CV with you, on a call, and say where the offers are being lost.
Didn’t find what you were looking for? Tell us what to build
Zinnia

Data Engineer III

  • Hybrid
  • 3-6 years

Salary

Not stated

Similar roles pay $145K - 210K a year · our estimate

AI summary

For members

The whole posting in a few lines. Sign up to read it here and on every role you open.

Sign Up to Read

Description

The company is a technology platform for life and annuities, providing enterprise software and data insights that simplify buying, selling and administering insurance products.

It manages over $180 billion in assets under administration, works with more than 100 carrier clients, 2500 distributors and partners, and over 2 million policyholders.

Responsibilities

  • Design, build and tune complex ETL pipelines that bring together large data sets from many sources.
  • Create and maintain high-performance data models in Google BigQuery or Snowflake, using dbt for transformation.
  • Write Python scripts that handle data ingestion, transformation and automation.
  • Set up and run data workflows in Apache Airflow for scheduling and orchestration.
  • Work with data scientists, analysts and other stakeholders to keep data available, reliable and fast.
  • Find and fix problems in data systems before they cause trouble, and improve their performance.
  • Use cloud platforms, mainly AWS, to take advantage of scalable compute and storage for pipelines.
  • Protect the integrity, consistency and security of data across systems.
  • Own end-to-end data engineering tasks and mentor junior team members.
  • Keep improving processes and tools so data is processed and delivered more efficiently.
  • Act as a key contributor to building and supporting complex data architectures.

Requirements

  • Bring deep experience optimizing data workflows with databases such as Oracle, BigQuery and SQL Server.
  • Understand ELT and ETL processes and data integration well.
  • Be strong in Python for data manipulation and automation.
  • Have advanced hands-on skills with Google BigQuery, Snowflake, dbt, Python and Airflow.
  • Design and maintain scalable ETL pipelines and keep data flowing smoothly across platforms.
  • Work well in a team and help build data infrastructure that supports business insights.
  • Hold a bachelor's degree in computer science, information technology or a related field.
  • Have 4+ years of hands-on data engineering or related experience, including building and optimizing data pipelines.
  • Design and optimize queries in Google BigQuery or an equivalent data warehouse such as Snowflake.
  • Know dbt for transformation and model management.
  • Use Python for data engineering tasks such as scripting, data manipulation and automation.
  • Have solid experience with Apache Airflow for orchestration and task automation.
  • Have extensive experience building and maintaining ETL pipelines.
  • Be familiar with AWS, including S3, Lambda, Redshift or Glue.
  • Solve problems and troubleshoot with skill.
  • Communicate and collaborate well within a team.
  • Stay self-motivated and detail-oriented, and work with little supervision.
  • Juggle multiple priorities and deadlines in a fast-moving setting.
  • Knowledge of data warehousing best practices and architecture.
  • Experience with other cloud platforms such as Azure is a plus.

Conditions

Work with minimal supervision in a fast-moving environment with several competing deadlines.

Equal opportunity employer; applicants are considered without regard to race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status or disability.

Benefits

  • Career progression and competitive compensation.
  • Health and dental insurance, parental leave, 401(k), incentive or bonus opportunity and tuition reimbursement.
  • Work alongside smart, creative professionals building new technology, deeper data insights and better services for insurance.
  • Notice for California residents about how personal information is collected and used is available from the company.

Where you’d work

Part of the week in the office

About the company

Zinnia

  • Industry: FinTech

Office in GA, United States

Also hiring in New York City, United States and NJ, United States

Your chances

We've checked whether it's still hiring and how crowded it is.

  • 19 checks run
  • 0 red flags

Still hiring?

13 checks

No red flags

How crowded?

6 checks

No red flags

Fits Me

How well does this role fit you?

Answer a few questions or drop your CV, and every role gets a fit score with the reasons, this one first.

  • Your field
  • Level
  • Stack
  • Work model
  • Salary floor
  • Must-haves
Details10 facts · Role, Location, Compensation, Company
Tech stack
  • Python
  • SQL
  • AWS
  • dbt
  • Azure
  • Snowflake
  • Airflow
  • BigQuery
Industry
FinTech
Specialty
Data Engineering
Region
United States
Pay period
Annual
Show 5 more factsShow less

Role

Category
Data & Analytics
Specialty
Data Engineering
Experience
4+ years
Tech stack
  • Python
  • SQL
  • AWS
  • dbt
  • Azure
  • Snowflake
  • Airflow
  • BigQuery

Location

Work model
Hybrid
Region
United States
Office
  • GA, United States

Compensation

Salary
Salary by agreement
Pay period
Annual

Company

Industry
FinTech

Something wrong with this vacancy?

Similar vacancies

Share this vacancy

What's wrong with it?

The employer never sees who reported.

Reason