Skip to content
Search jobs inside your AI agent. Claude, ChatGPT, Claude Code, Codex, Gemini, Cursor and Grok
Connect

Pyramid Consulting, Inc

NewBe an early applicant

Senior Data Engineer

Posted

Summary

Senior data engineer designing scalable Snowflake data warehouse solutions and building/maintaining dbt transformation pipelines, applying Data Vault 2.0 modeling (hubs, links, satellites, facts/dimensions) with data quality checks, CI/CD, and query/performance optimization. Requires 10+ years software engineering, including 4–5 years hands-on with Snowflake, dbt, Data Vault, and enterprise data m

Role Overview

We are seeking a Senior Data Engineer with **10+ years of overall software engineering experience**, including **4–5 years of hands-on experience with Snowflake, dbt, Data Vault, and data modeling**. The role will focus on designing scalable data platforms, developing reliable transformation pipelines, and delivering high-quality analytical data solutions.


Key Responsibilities

- Design and develop scalable data warehouse solutions using Snowflake.

- Build, test, document, and maintain data transformation pipelines using dbt.

- Apply Data Vault 2.0 principles for scalable and auditable data architecture.

- Design conceptual, logical, and physical data models for analytics and reporting.

- Develop reusable data structures, hubs, links, satellites, dimensions, and facts.

- Implement data quality checks, validation rules, lineage, and documentation.

- Optimize Snowflake queries, warehouse usage, storage, and pipeline performance.

- Collaborate with business analysts, data architects, software engineers, and stakeholders.

- Support CI/CD, version control, automated testing, and deployment of data solutions.

- Troubleshoot data issues and contribute to production support and root-cause analysis.


Required Qualifications

- 10+ years of overall software engineering or technology experience.

- 4–5 years of hands-on experience with:

- Snowflake

- dbt

- Data Vault or Data Vault 2.0

- Enterprise data modeling

- Strong SQL and relational database experience.

- Experience developing data warehouses, data marts, and analytical data platforms.

- Knowledge of dimensional modeling, normalization, and data integration concepts.

- Experience with Git, CI/CD, testing frameworks, and Agile development practices.

- Strong problem-solving, communication, and technical documentation skills.

Skills

What Senior Data Engineering jobs ask for — and how much of it you have →
Apply

See also

Data Engineering jobs by country — openings, pay and top skills →