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 www.aspida.com 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:

As a Snowflake Senior Data Engineer, you will be responsible for architecting, developing, and optimizing data warehouse and Lakehouse solutions using the Snowflake platform and integrating with internal systems. This role will design, build, and maintain robust and scalable data pipelines and infrastructure using modern cloud-based technologies (AWS and Azure). Experience with Python, SQL Server, Snowflake, DBT Core, Airflow, and GIT is required.
 

You will collaborate closely with data architects, data engineers, and business stakeholders to ensure data ingestion, storage, and access solutions on Snowflake meet performance, security, and compliance requirements for migration and analytics.  This role reports to the VP of Data Engineering 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. 

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.