Data Engineer III

Zinnia

Alpharetta (GA)

Hybrid

USD 110,000 - 165,000

Full time

3 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Health/dental insurance
Parental leave
401(k)
Bonus opportunity
Tuition reimbursement

Job summary

Zinnia is seeking a Senior Data Engineer to design, build, and optimize scalable ETL pipelines across diverse data sources. You will develop data models using Google BigQuery and Snowflake, implement DBT transformations, and automate data workflows with Airflow.

The role emphasizes collaboration with data scientists and analysts, ensuring data reliability, security, and timely delivery on AWS infrastructure. A strong Python background and cloud experience are essential.

Qualifications

  • Bachelor's degree in CS, IT, or a related field.
  • 4+ years of hands-on data engineering experience.
  • Strong proficiency in Google BigQuery; Snowflake as an alternative.
  • Knowledge of dbt for data transformation and model management.
  • Proficiency in Python for data engineering tasks.
  • Experience with Apache Airflow for orchestration.
  • Experience building and maintaining ETL pipelines.
  • Familiarity with AWS cloud services (S3, Lambda, Redshift, Glue).

Responsibilities

  • Design, develop, and optimize complex ETL pipelines integrating large data sets from various sources.
  • Build and maintain high-performance data models using BigQuery and Snowflake for transformation.
  • Develop Python scripts for data ingestion, transformation, and automation.
  • Implement and manage data workflows using Airflow for scheduling and orchestration.
  • Collaborate with data scientists, analysts, and stakeholders to ensure data availability and performance.
  • Troubleshoot and optimize data systems, proactively resolving issues.
  • Work with AWS cloud platforms to leverage scalability and storage for pipelines.
  • Ensure data integrity, consistency, and security across systems.
  • Take ownership of end-to-end data engineering tasks and mentor juniors.
  • Continuously improve processes and technologies for efficient data delivery.
  • Contribute to developing and supporting complex data architectures.

Skills

BigQuery
Python
ETL pipelines
Data modeling
SQL
Airflow

Education

Bachelor’s degree in CS/IT or related field

Tools

DBT
Snowflake
AWS
S3
Redshift
Glue

Job description

Zinnia is the leading technology platform for accelerating life and annuities growth. With innovative enterprise solutions and data insights, Zinnia simplifies the experience of buying, selling, and administering insurance products. All of which enables more people to protect their financial futures. Our success is driven by a commitment to three core values: be bold, team up, deliver value – and that we do. Zinnia has over $180 billion in assets under administration, serves 100+ carrier clients, 2500 distributors and partners, and over 2 million policyholders.

WHO YOU ARE:

As a seasoned Data Engineer specializing in data engineering, you bring extensive expertise in optimizing data workflows using various database tools like Oracle, BigQuery, and SQL Server. You possess a deep understanding of ELT/ETL processes, data integration, and have a strong command of Python for data manipulation and automation tasks. You will possess advanced expertise in working with data platforms like Google Big Query, Snowflake, DBT, Python, and Airflow. Responsible for designing and maintaining scalable ETL pipelines, optimizing complex data systems, and ensuring smooth data flow across different platforms. As a Senior Data Engineer, you will also be required to work collaboratively in a team and contribute to building data infrastructure that drives business insights.

WHAT YOU'LL DO:
  • Design, develop, and optimize complex ETL pipelines that integrate large data sets from various sources.
  • Build and maintain high-performance data models using Google BigQuery/ Snowflake and DBT for data transformation.
  • Develop Python scripts for data ingestion, transformation, and automation.
  • Implement and manage data workflows using Apache Airflow for scheduling and orchestration.
  • Collaborate with data scientists, analysts, and other stakeholders to ensure data availability, reliability, and performance.
  • Troubleshoot and optimize data systems, identify issues, and resolve them proactively.
  • Work on cloud-based platforms, particularly AWS, to leverage scalability and storage options for data pipelines.
  • Ensure data integrity, consistency, and security across systems.
  • Take ownership of end-to-end data engineering tasks while mentoring junior team members.
  • Continuously improve processes and technologies for more efficient data processing and delivery.
  • Act as a key contributor to developing and supporting complex data architectures.
WHAT YOU'LL NEED:
  • Bachelor’s degree in computer science, Information Technology, or related field.
  • 4+ years of hands-on experience in Data Engineering or related fields, with a strong background in building and optimizing data pipelines
  • Strong proficiency in Google Big Query, including designing and optimizing queries or other equivalent Datawarehouse (Snowflake).
  • Knowledge of dbt for data transformation and model management.
  • Proficiency in Python for data engineering tasks, including scripting, data manipulation, and automation.
  • Solid experience with Apache Airflow for workflow orchestration and task automation.
  • Extensive experience in building and maintaining ETL pipelines.
  • Familiarity with cloud platforms, particularly AWS (Amazon Web Services), including tools like S3, Lambda, Redshift, or Glue.
  • Excellent problem-solving and troubleshooting abilities.
  • Strong communication and collaboration skills with the ability to work effectively in a team environment.
  • Self-motivated, detail-oriented, and able to work with minimal supervision.
  • Ability to manage multiple priorities and deadlines in a fast-paced environment.
  • Experience with other cloud platforms (e.g., AWS, Azure) is a plus.
  • Knowledge of data warehousing best practices and architecture.
WHAT’S IN IT FOR YOU?

Zinnia offers excellent career progression and competitive compensation. We offer great benefits, including health/dental insurance, parental leave, 401(k), incentive/bonus opportunity, tuition reimbursement,and so much more. We’re looking for the best and brightest innovators in the industry to join our team. At Zinnia, you collaborate with smart, creative professionals who are dedicated to delivering cutting-edge technologies, deeper data insights, and enhanced services to transform how insurance is done. Visit our website at www.zinnia.com for more information. We are an Equal Opportunity employer committed to a diverse workforce. We do not discriminate based on race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability.

Notice for California residents: Information about how we collect and use your personal information can be found here.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Engineer III
Data Engineer III

Zinnia • Atlanta (GA)

On-site
USD 140,000 - 190,000
Health/Dental insurance
Parental leave
401(k)
+2
Software Engineer III
Software Engineer III

Zinnia • Alpharetta (GA)

On-site
USD 100,000 - 120,000
Health/dental insurance
Parental leave
401(k)
+2
Staff Software Engineer
Staff Software Engineer

Zinnia • Alpharetta (GA)

On-site
USD 140,000 - 180,000
Health/dental insurance (provided by Z
Parental leave
401(k)
+2
Senior Data Engineer - ETL Architect (BigQuery, Airflow)
Senior Data Engineer - ETL Architect (BigQuery, Airflow)

Zinnia • Atlanta (GA)

On-site
USD 140,000 - 190,000
Health/Dental insurance
Parental leave
401(k)
+2
Senior Product Manager (Technical)
Senior Product Manager (Technical)

Zinnia • New York (NY), Short Hills (NJ)

Hybrid
USD 115,000 - 155,000
Health insurance
Dental insurance
Parental leave
+3
Senior Software Engineer I
Senior Software Engineer I

Policygenius • Alpharetta (GA)

On-site
USD 140,000 - 180,000
Health insurance
Parental leave
401(k)
+2
Staff Software Engineer
Staff Software Engineer

Zinnia • Georgia

Hybrid
USD 120,000 - 180,000
Staff Software Engineer
Staff Software Engineer

AVP • Alpharetta (GA)

On-site
USD 130,000 - 180,000
Health insurance
401(k)
Tuition reimbursement
Senior Director, Strategic Account Management
Senior Director, Strategic Account Management

AVP • New York (NY)

On-site
USD 200,000 - 230,000
Senior Product Manager (Technical)
Senior Product Manager (Technical)

Zinnia • Greenwich (CT)

On-site
USD 115,000 - 155,000
Health insurance
Parental leave
401(k)
+2