Design, build, and maintain cloud-based ELT data pipelines and analytics-ready datasets using Snowflake, dbt, and integration tools (Fivetran/Airbyte). Implement CDC and incremental loading, optimize Snowflake performance, enforce data quality and monitoring, create dimensional models for reporting, enable CI/CD for dbt projects, and collaborate with analytics and stakeholder teams to support reporting and advanced analytics.
This is a remote position.
Job SummaryWe are seeking a skilled Data Engineer with hands-on experience in Snowflake, dbt, and modern data integration tools such as Fivetran or Airbyte. The ideal candidate will have a strong background in building scalable cloud data platforms, developing ELT pipelines, implementing data transformation frameworks, and delivering reliable, analytics-ready datasets.
The candidate should be experienced in integrating data from multiple enterprise applications, designing efficient data models, and collaborating with analytics, business intelligence, and data science teams to support reporting and advanced analytics initiatives.
- Design, develop, and maintain scalable cloud-based data pipelines using Snowflake and modern ELT tools.
- Build and manage data ingestion pipelines using Fivetran, Airbyte, or similar integration platforms.
- Develop modular, reusable, and well-documented data transformation models using dbt (Data Build Tool).
- Design and optimize dimensional data models (Star Schema and Snowflake Schema) for analytics and reporting.
- Develop incremental data loading strategies and Change Data Capture (CDC) processes.
- Optimize Snowflake performance through clustering, partitioning, query tuning, and warehouse optimization.
- Implement data quality checks, validation rules, and monitoring to ensure data accuracy and reliability.
- Collaborate with business analysts, data architects, and stakeholders to translate business requirements into technical solutions.
- Integrate data from ERP, CRM, eCommerce, finance, and third-party SaaS applications.
- Troubleshoot pipeline failures, resolve performance bottlenecks, and support production environments.
- Implement CI/CD processes for dbt projects and data pipelines.
- Create and maintain technical documentation, data lineage, and metadata.
- 5+ years of experience in Data Engineering or Data Integration.
- Strong hands-on experience with Snowflake.
- Proficiency in dbt (Data Build Tool).
- Experience with modern ELT/integration platforms such as Fivetran or Airbyte.
- Strong SQL skills, including complex joins, CTEs, window functions, stored procedures, and query optimization.
- Experience working with structured, semi-structured (JSON, XML), and unstructured data.
- Strong understanding of data warehousing concepts and dimensional modeling.
- Experience building data pipelines using ELT/ETL methodologies.
- Familiarity with Git-based source control and version management.
- Experience working in Agile/Scrum environments.
Similar Jobs
Information Technology • Professional Services • Analytics • Consulting
Design, build, and optimize Snowflake-based data warehouses and dbt transformation pipelines. Develop scalable ETL/ELT ingestion, tune SQL and warehouse performance, implement data quality/testing (dbt tests), and maintain CI/CD and version-controlled data workflows while collaborating with analysts, data scientists, and stakeholders.
Top Skills:
Apache AirflowAWSAzureCRMDagsterDbtDbt CloudDbt CoreGCPGitGithub ActionsGitlab CiOraclePrefectPythonSAPScalaSnowflakeSnowpipeSQL
.png){kind=logo}
Artificial Intelligence • Fintech • Software • Financial Services
The Technical Product Manager will manage product development lifecycle, collaborate with engineering and stakeholders, and advocate for user-focused solutions in a fast-paced environment.
Top Skills:
APIsProduct Management ToolsSaaS
Blockchain • Fintech • Payments • Financial Services • Cryptocurrency • Web3
Lead and execute Circle National Trusts internal audit program for fiduciary and bank-related audits. Test controls across treasury, trust operations, and technology risk. Partner with senior leadership, risk owners, and examiners; prepare regulatory reporting; perform annual risk assessments and support broader internal audit work across Circle.
Top Skills:
ChatgptClaudeCodexCoso 2013U.S. Gaap
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
