Data Engineer III

About the Role

WHO WE ARE: 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, 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 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, identifying issues and resolving them proactively. Work on cloud-based...