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
Artificial Intelligence • Healthtech • Machine Learning • Natural Language Processing • Biotech • Pharmaceutical
Pharmaceutical sales role promoting migraine therapy within a defined territory. Drives sales through in-person and virtual HCP engagement, develops and executes territory call plans, leverages analytics and approved clinical information, collaborates cross-functionally, and completes administrative and compliance requirements.
.png)
Greentech • Hardware • Internet of Things • Machine Learning • Software • Business Intelligence • Agriculture
Drive new business and customer success across SE Wyoming by prospecting, performing in-field sales and onboarding, expanding accounts, meeting sales targets, gathering field feedback, collaborating with support, and representing Halter at industry events. Frequent travel and hands-on ranch work required.
What you need to know about the Colorado Tech Scene
With a business-friendly climate and research universities like CU Boulder and Colorado State, Colorado has made a name for itself as a startup ecosystem. The state boasts a skilled workforce and high quality of life thanks to its affordable housing, vibrant cultural scene and unparalleled opportunities for outdoor recreation. Colorado is also home to the National Renewable Energy Laboratory, helping cement its status as a hub for renewable energy innovation.
Key Facts About Colorado Tech
- Number of Tech Workers: 260,000; 8.5% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Lockheed Martin, Century Link, Comcast, BAE Systems, Level 3
- Key Industries: Software, artificial intelligence, aerospace, e-commerce, fintech, healthtech
- Funding Landscape: $4.9 billion in VC funding in 2024 (Pitchbook)
- Notable Investors: Access Venture Partners, Ridgeline Ventures, Techstars, Blackhorn Ventures
- Research Centers and Universities: Colorado School of Mines, University of Colorado Boulder, University of Denver, Colorado State University, Mesa Laboratory, Space Science Institute, National Center for Atmospheric Research, National Renewable Energy Laboratory, Gottlieb Institute
