Sr. Data Engineer

Company Description:

Aspida is a tech-driven, nimble insurance carrier. Backed by Ares Management Corporation, a leading global alternative asset manager, we offer simple and secure retirement solutions and annuity products with speed and precision. More than that, we’re in the business of protecting dreams; those of our partners, our producers, and especially our clients. Our suite of products, available through our elegant and intuitive digital platform, focuses on secure, stable retirement solutions with attractive features and downside protection. A subsidiary of Ares Management Corporation (NYSE: ARES) acts as the dedicated investment manager, capital solutions and corporate development partner to Aspida. For more information, please visit or follow them on LinkedIn .

Who We Are:

Sometimes, a group of people come together and create something amazing. They don’t let egos get in the way. They don’t settle for the status quo, and they don’t complain when things get tough. Instead, they see a common vision for the future and each person makes an unspoken commitment to building that future together. That’s the culture, the moxie, and the story of Aspida.
Our business focuses on annuities and life insurance. At first, it might not sound flashy, but that’s why we’re doing things differently than everyone else in our industry. We’re dedicated to developing data-driven tech solutions, providing amazing customer experiences, and applying an entrepreneurial spirit to everything we do. Our work ethic is built on three main tenets: Get $#!+ Done, Do It with Moxie, and Have Fun. If this sounds like the place for you, read on, and then apply at aspida.com/careers.

What We Are Looking For:

This position will be responsible for leading projects at Aspida, acting as an overall point of accountability and ensuring business outcomes that support our strategic goals. The role includes all aspects of project leadership—including understanding objectives & requirements, breaking down the work into realistic plans, coordinating with teams & stakeholders, and driving progress to successful completion. This role requires strong business acumen combined with the ability to lead diverse cross-functional team members, including IT, software development, external vendors, finance, legal/compliance/regulatory, and insurance product specialists.

In addition to leading projects, we are looking for someone who can act as an example of project excellence for other project leaders within the organization (most of whom are not professional project managers), acting as a mentor & coach within the extended PMO team. This role reports to the Director, PMO and is required to be onsite 3 days a week at our Durham, NC office.

What You Will Do:

• Design and implement Snowflake lakehouse architectures.
• Develop and optimize Snowflake SQL queries, stored procedures for curating data.
• Manage Snowflake account configurations, resource monitors, virtual warehouses, and access controls.
• Integrate Snowflake with Oracle Financials and other 3rd party sources.
• Implement best practices for data partitioning, clustering, and caching to optimize performance and cost-efficiency.
• Participate in data ingestion automation, metadata management, and monitoring within Snowflake environments.
• Collaborate with security teams to enforce data governance, encryption, and compliance policies in Snowflake.
• Support CI/CD and automation of Snowflake deployment and pipeline orchestration.
• Provide KT and technical guidance to team members and business stakeholders.

What We Provide:

• Salaried, DOE
• Long-Term Incentive Plan
• Full-Time
• Full Benefits Package Available

What We Believe:

At Aspida Financial Services, LLC, we are committed to creating a diverse and inclusive environment and are proud to be an equal opportunity employer. As such, Aspida does not and will not discriminate in employment and personnel practices on the basis of race, sex, age, handicap, religion, national origin or any other basis prohibited by applicable law. Hiring, transferring and promotion practices are performed without regard to the above listed items.

Requirements

What We Require:

• BS/MS in Computer Science, Data Engineering, Information Systems, or a related field.
• 7+ years in data warehousing and cloud data platforms with 5+ years of hands-on Lakehouse experience
• Experience working on Snowflake migration is preferred.
• Retail Insurance or Reinsurance experience and data governance knowledge are a plus
• Agile and DevOps experience with automation and pipeline deployment.
• Certifications like SnowPro Core Certification or relevant cloud certifications are desirable
• Deep expertise in Snowflake data warehouse platform, including performance tuning and cost optimization.
• Strong SQL skills and experience with Snowflake-specific features such as Time Travel, Zero Copy Cloning, Streams, and Tasks.
• Experience with cloud ecosystems (Azure, AWS) and data orchestration tools (DBT, Airflow).
• Understanding of data security, role-based access control (RBAC), and compliance in Snowflake.
• Knowledge of data modeling principles for enterprise data warehouses.
• Excellent communication and collaboration skills to work with data teams.