Role OverviewWe are seeking a Senior Technical Lead with strong hands-on expertise in Snowflake-based cloud data warehousing and modern ELT development using dbt (Core or Cloud). The candidate must have experience designing scalable, production-grade ELT pipelines, implementing CI/CD for dbt, integrating orchestration tools, and enforcing data quality through automated testing and observability frameworks.
What You Will Do
Develop and maintain dbt models on Snowflake, build reliable, tested, and documented data transformation pipelines, implement data quality checks, lineage, and governance standards, optimize SQL queries and dbt models for performance and cost, and collaborate with data engineering, BI, analytics, and business teams.
Why It Might Be a Fit
The role involves developing dbt models, tests, macros, documentation, and reusable data assets to support analytics, reporting, and business decision-making. Experience in Informatica to DBT conversion is also required.
Requirements
- Strong SQL and data modeling skills
- Informatica
- Hands-on experience with dbt Core or dbt Cloud
- Experience working with Snowflake
- Knowledge of ELT pipelines, testing, documentation, and version control
- Understanding of analytics engineering
Benefits
- Medical, dental, vision, pharmacy, life, accidental death & dismemberment, and disability insurance
- Employee assistance program
- 401(k) retirement plan
- 10 days of paid time off per year
- 10 paid holidays per year
]]>