Quick Summary
Design, develop, and optimize complex ETL pipelines that integrate large data sets from various sources.
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.
Responsibilities
~1 min read- →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.
- 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.
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. Apply by completing the online application on the careers section of our website. 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
Location & Eligibility
About this job
- Who can apply
- United States
- Posted
- Today
Listing Details
- Posted
- November 17, 2026
- First seen
- November 17, 2026
- Last seen
- November 17, 2026
Posting Health
- Days active
- 0
- Repost count
- 1
- Trust Level
- 56%
- Scored at
- November 17, 2026
Signal breakdown
Stay ahead of the market
Get the latest job openings, salary trends, and hiring insights delivered to your inbox every week.
No spam. Unsubscribe at any time.