Sr. Data Engineer

Aspida Financial Services LLC•Durham, NC

49d•Onsite

About The Position

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.

Requirements

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.

Responsibilities

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.