The Senior Snowflake Data Engineer will lead the creation of a data vault and warehouse on Snowflake, develop automated data pipelines, and work closely with architects to deliver insights for business operations.
This is a remote position.
The senior snowflake data engineer will be the lead engineer for the creation of a data vault and data warehouse on Snowflake. The candidate will work closely with the solution architect and data scrum lead to implement stable data pipelines that will provide the business with insights into operations and management. The data engineer will embrace an automate first philosophy to data engineering.
Responsibilities:
- Be a technical lead in the development of automated data transformation pipelines to drive decisions and have a tangible beneficial impact on business results
- Design and implement efficient data transformation pipelines to integrate data from SAP and other sources into data marts
- Implement data model changes that align with data vault and mart standards
- Design and implement backfill or other warehouse data management processes
- Develop and execute testing scenarios to ensure high-quality data
Requirements
- 3+ years working in the Snowflake environment
- 3+ years SAP BODS
- 3+ years SAP Landscape Transformation Replication Server (SLT)
- 5+ years working with data transformation automation tools
- 5+ years of data engineering and transformation
- 3+ years of python data engineering preferred
- Strong SQL knowledge
- Solid understanding of Data Vault 2.0 methodology and data models
- Solid understanding of Kimball design methodology and data models
- Experience with Agile methodology
Similar Jobs
Software
Design, develop, and maintain scalable ETL/ELT pipelines and Snowflake data models; optimize performance; ensure data quality and integrations with CRM/ERP/billing systems; collaborate with stakeholders and evolve a Snowflake/dbt cloud-native data platform.
Top Skills:
MatillionSnowflakeSQL
Consulting
Design, build, and optimize enterprise Snowflake data solutions and scalable ELT/ETL pipelines. Implement Snowflake-native ingestion (Snowpipe, Streams, Tasks, Dynamic Tables), Snowpark, SQL-based transformations, governance (RBAC), performance tuning, production support, and integrations across cloud, on‑prem, API, and SaaS sources. Support AI initiatives using Snowflake Cortex and Snowpark.
Top Skills:
AWSAzureCdcCi/CdDbtDynamic TablesEltETLGCPGitInfrastructure As CodePythonRbacSnowflakeSnowflake CortexSnowparkSnowpipeSQLStored ProceduresStreamsTasksUdfs
Artificial Intelligence • Information Technology • Machine Learning • Software • Analytics • Consulting • Financial Services
Lead design and development of web UI and REST middleware within an Agile team. Define requirements and acceptance criteria, implement Java/Spring and Angular solutions, build CI/CD pipelines, work with Product Owner and testers, and produce/update design documentation.
Top Skills:
AngularAngular MaterialCi/CdCSSHibernateHTMLJava (Jdk 11+)JSONPostgresRestful ApisSpring Data JpaSpring MvcTypescript
What you need to know about the Boston Tech Scene
Boston is a powerhouse for technology innovation thanks to world-class research universities like MIT and Harvard and a robust pipeline of venture capital investment. Host to the first telephone call and one of the first general-purpose computers ever put into use, Boston is now a hub for biotechnology, robotics and artificial intelligence — though it’s also home to several B2B software giants. So it’s no surprise that the city consistently ranks among the greatest startup ecosystems in the world.
Key Facts About Boston Tech
- Number of Tech Workers: 269,000; 9.4% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Thermo Fisher Scientific, Toast, Klaviyo, HubSpot, DraftKings
- Key Industries: Artificial intelligence, biotechnology, robotics, software, aerospace
- Funding Landscape: $15.7 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Summit Partners, Volition Capital, Bain Capital Ventures, MassVentures, Highland Capital Partners
- Research Centers and Universities: MIT, Harvard University, Boston College, Tufts University, Boston University, Northeastern University, Smithsonian Astrophysical Observatory, National Bureau of Economic Research, Broad Institute, Lowell Center for Space Science & Technology, National Emerging Infectious Diseases Laboratories
