Senior Data Engineer (DBT + Snowflake Required)
Litera · Denver, CO · 3 wk ago
HybridInformation Technology$140k–$180k/yrFull-time
About the role
This is a hybrid role based in Denver, Colorado with the expectation to be in the office at least 3 days a week for collaboration and connection.
Responsibilities
- Design, build, and maintain production-grade data pipelines and ELT workflows at scale.
- Develop and own a Snowflake-based data warehouse using dbt best practices (models, tests, documentation, incremental strategies).
- Partner with analytics and business stakeholders to translate requirements into well-modeled, reliable datasets.
- Write and optimize complex SQL for large analytical datasets, ensuring performance and accuracy.
- Apply strong software engineering practices to data work, including version control, testing, and CI/CD.
- Integrate data from third-party SaaS platforms such as CRM, product analytics, and finance systems.
- Produce clear technical documentation, including pipeline designs and data flow diagrams.
- Take end-to-end ownership of data solutions, ensuring quality, performance, and long-term maintainability.
Requirements
- 5+ years of experience designing, building, and operating production-grade data platforms, including scalable data pipelines and cloud data warehouses.
- 2+ years of production experience using dbt to build scalable, well-tested data warehouse solutions.
- Strong SQL expertise, including complex analytical queries, performance optimization, and working with large datasets.
- Hands-on experience with Snowflake (or similar cloud data warehouses) in a production analytics environment.
- Solid data engineering and software engineering fundamentals, including data modeling, version control (Git), testing, documentation, and collaboration with cross-functional stakeholders.
Qualifications
- Advanced Snowflake expertise, including performance tuning, query profiling, and warehouse optimization (nice-to-have).
- Experience with dimensional and enterprise data modeling methodologies (e.g., Kimball, Inmon) (nice-to-have).
- Experience owning analytics solutions for business domains such as Finance, Sales, or Marketing (nice-to-have).
- Advanced Python experience and/or multiple production dbt implementations with mature practices (testing, CI/CD, multi-environment deployments) (nice-to-have).
Skills
- Must have 5+ years of experience designing, building, and operating production-grade data platforms, including scalable data pipelines and cloud data warehouses.
- Must have 2+ years of production experience using dbt to build scalable, well-tested data warehouse solutions.
- Must have strong SQL expertise, including complex analytical queries, performance optimization, and working with large datasets.
- Must have hands-on experience with Snowflake (or similar cloud data warehouses) in a production analytics environment.
- Must have solid data engineering and software engineering fundamentals, including data modeling, version control (Git), testing, documentation, and collaboration with cross-functional stakeholders.
Benefits
- Pay transparency for Colorado applicants: Base salary range is $140,000 to $180,000.
- Comprehensive benefits package including medical, dental, and vision coverage, a 401(k) with company match, and incentive and recognition programs.
Pay
The base salary range for this role is $140,000 to $180,000. Final compensation will be determined based on experience, skills, education, and other relevant qualifications.
Schedule
This is a hybrid role based in Denver, Colorado with the expectation to be in the office at least 3 days a week for collaboration and connection.