Data Engineer II

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:

You are a skilled and experienced engineer with a strong background in both legacy and modern data technologies. You are comfortable working with established platforms like .NET, SQL Server, and Oracle, while also staying on the cutting edge with new ETL tools such as dbt, Apache Airflow, and Google BigQuery. With a deep understanding of data integration and transformation, you're capable of balancing ongoing support for current processes with the drive to adopt and implement future-focused technology solutions. Your ability to lead projects and collaborate with cross-functional teams allows you to ensure data integrity and operational efficiency.

WHAT YOU'LL DO:

• Support and maintain existing data processes utilizing .NET, SQL, and Oracle technologies.
• Lead the transition to new ETL frameworks, such as dbt, Apache Airflow, and Google BigQuery, to modernize the current process.
• Design, build, and optimize data workflows, ensuring seamless data integration across both legacy and new systems.
• Collaborate with stakeholders and cross-functional teams to understand business requirements and translate them into technical solutions.
• Provide technical expertise in troubleshooting and resolving complex data-related issues.
• Stay up-to-date with industry trends and recommend best practices for data engineering and integration.
• Mentor and guide junior engineers in the team, fostering a culture of innovation and continuous learning.

WHAT YOU'LL NEED:

• Bachelor's degree in Computer Science, Information Technology, or a related field.
• 4+ years of experience in data operations, data engineering, or a similar role, with a proven track record of leadership and project management within the data engineering domain.
• Strong expertise in data integration, transformation, and scheduling processes using tools like Oracle, BigQuery, SQL Server, and Python for scripting and automation.
• Proficiency in ELT/ETL processes and tools such as Spark,Informatica, DBT, Airbyte, , Meltano, Apache Airflow or similar within the context of data engineering.
• In-depth understanding of data warehousing concepts, practices, and technologies relevant to data engineering.
• Knowledge of data quality and governance principles, with experience implementing best practices within the data lifecycle.
• Familiarity with cloud-based environments and technologies, including data platforms and services, as they relate to data engineering.
• Excellent communication, leadership, and interpersonal skills, with the ability to collaborate effectively across teams and levels of the organization.
• Proven ability to adapt to changing priorities, manage multiple projects simultaneously, and drive results in a fast-paced environment within the Interface team.

WHAT'S IN IT FOR YOU?

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 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.