Senior Data Engineer (Snowflake)

About the role

Solvd, an AI-native consulting and technology services firm, is looking for a Senior Data Engineer to join a small, cross-functional engineering team modernizing a data platform for a global financial services client. The role is hands-on with Snowflake and dbt, involving data model design, migration of legacy Oracle-based ETL processes and contribution to architectural decisions alongside client stakeholders. It is a delivery-oriented position with real ownership of assigned components.

Key responsibilities

• Design, develop and optimize data models and transformation workflows using Snowflake and dbt.
• Contribute to the design and implementation of scalable data architecture covering raw through semantic data layers.
• Support modernization of existing Oracle-based ETL and reporting processes.
• Investigate and address data performance, consistency and reconciliation challenges.
• Develop and maintain data processing, transformation and automation solutions using Python.
• Participate in solution design discussions and architectural decisions.
• Support DevOps-related activities such as deployment, configuration and operation of the data platform.
• Take ownership of assigned technical components and deliverables, and take part in client-facing technical discussions and project meetings.

Required profile

• Strong hands-on experience with Snowflake, including data transformation, modeling and performance optimization.
• Practical experience with dbt and ETL/ELT processes and modern data pipelines.
• Good communication skills, able to collaborate with client stakeholders and discuss technical matters regularly with US-based teams; English sufficient for those discussions.
• Preferred: experience with Oracle databases and Oracle ETL, prior data platform modernization or migration from Oracle to Snowflake, Power BI and semantic reporting models, Snowflake professional certification, experience with distributed engineering teams, and a background in insurance, reinsurance or financial services.
• Availability for occasional business trips to St. Louis, USA, about once every three weeks for one to two days.

Required skills

• Snowflake and dbt
• Python for data engineering, scripting and automation
• Data modeling and data architecture
• ETL/ELT and modern data pipeline development
• DevOps practices and containerized environments including Kubernetes