Role: Senior Data Engineer
Location: Remote
Senior Data Engineer (Snowflake) to join a high-impact delivery pod supporting a major client in financial services. The engagement centers on a critical data source migration — transitioning from a legacy internal data platform to a new vendor-sourced digital/web data feed. This role emphasizes scalable engineering, data modeling best practices, and operational reliability within the Snowflake ecosystem.
Key Responsibilities:
Pipeline & Data Model Development
Design and implement Snowflake-based ingestion and transformation pipelines to support the data source migration
Build and optimize fact and dimension models for analytical consumption in Snowflake''''s data warehousing environment
Implement sessionization and event-based modeling patterns
Support the gap analysis between legacy and new-source datasets to ensure no data elements are lost during the transition
Engineering Excellence
Apply best practices for testing, monitoring, logging, and cost optimization
Partner with analysts on data contracts and source-to-target mappings
Contribute reusable patterns and technical documentation
Leverage Python for orchestration, transformation, and scripting tasks
Work within AWS cloud-native architectures and CI/CD practices
Collaboration & Delivery
Collaborate closely with pod members, client stakeholders, and subject matter experts
Participate in sprint planning, retrospectives, and daily stand-ups — integrating into the client''''s existing Agile cadence
Support a phased delivery approach across multiple workstreams
Required Experience & Skills
10+ years of data engineering experience
Strong Snowflake SQL and analytical data modeling expertise — specifically building facts and dimensions in a data warehousing context
Hands-on experience with Python-based orchestration or transformation frameworks
AWS / Cloud — foundational cloud experience is essential
Very strong SQL skills — this is a baseline expectation
Familiarity with cloud-native data architectures and CI/CD practices
Strong problem-solving and collaboration skills
Experience with digital interaction / web analytics data (e.g., Adobe Analytics or similar platforms) — highly preferred, as the engagement involves working with vendor-sourced digital data
Experience in large-scale or regulated enterprise environments, particularly financial services
Familiarity with Azure Virtual Desktop environments
Never miss an opportunity! Create an alert based on the job you applied for.
