> Markdown version of [/jobs/ext/2988802-data-architect-snowflake-dbt](https://www.wearedevelopers.com/jobs/ext/2988802-data-architect-snowflake-dbt). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Data Architect (Snowflake & DBT) - **Company:** Lorven Technologies Inc - **Location:** Chicago, IL, United States - **Experience:** Expert - **Contract:** Permanent contract - **Skills:** Airflow, Amazon Web Services, Data Analysis, Microsoft Azure, BigQuery, Information Systems, Continuous Integration, Data Architecture, Information Engineering, Data Governance, Extract Transform Load (ETL), Data Transformation, Data Sharing, Data Systems, Data Vault Modeling, Data Warehousing, Python (Programming Language), Query Optimization, Power BI, Cloud Services, Standard Sql, Tableau (Software), Workflow Management Systems, Google Cloud, Snowflake, Data Build Tool (dbt), Information Technology, Tools for Reporting, Looker Analytics, Data Pipelines - **Published:** September 18, 2026 - **Apply:** https://www.dice.com/job-detail/e2655d04-2790-4686-a813-e69585bc9004 ## About the Role * Bachelor's or Master's degree in Computer Science, Engineering, Information Systems, or related field. * 12+ years of overall work experience and 5+ years of experience in data architecture, data engineering, or similar roles. * Strong hands-on expertise in Snowflake (data warehouse design, query optimization, security, data sharing, etc.). * Proficient in DBT (developing models, tests, documentation, deployment, etc.). * Solid experience with ELT/ETL solutions and orchestration tools (e.g., Airflow, Prefect). * Proficient in SQL; experience with Python is a plus. * Experience with BI/reporting tools (e.g., Looker, Tableau, Power BI) is a plus. * Strong understanding of data modeling techniques and best practices for analytics. * Excellent communication and collaboration skills. Preferred Qualifications: * Experience with additional cloud data platforms (e.g., Big Query, Redshift). * Familiar with data governance, security, and compliance frameworks. * Exposure to CI/CD tools and practices for data pipelines. * Experience in Agile/Scrum environments. ## Description * We are seeking a skilled Data Architect with deep expertise in cloud data warehousing, particularly with Snowflake, and experience building robust data transformation pipelines using DBT (Data Build Tool). * The ideal candidate will design scalable data architectures, implement best practices for data modelling, and collaborate with cross-functional teams to ensure data quality, accessibility, and security., * Architect and implement scalable, high-performance data solutions using Snowflake and the cloud (AWS/Azure/Google Cloud Platform). * Design and maintain data models (star/snowflake schemas, data vault, etc.) and data pipelines leveraging DBT. * Develop, optimize, and document ELT/ETL workflows, ensuring adherence to best practices in data transformation and governance. * Collaborate with Data Engineers, Analysts, and Business Stakeholders to gather requirements and deliver end-to-end data solutions. * Establish and enforce data quality, integrity, and security standards. * Monitor and optimize Snowflake performance, costs, and resource utilization. * Advise on data architecture strategy, new tools, and process improvements. * Mentor and guide junior data engineers and analysts on data modelling, transformation, and Snowflake/DBT best practices. * Stay updated on emerging trends in cloud data warehousing, data modelling, and analytics. ## Related Videos - [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt) - [Data Science in Retail](https://www.wearedevelopers.com/videos/586-data-science-in-retail) - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag) - [Making Data Warehouses fast. A developer's story.](https://www.wearedevelopers.com/videos/302-making-data-warehouses-fast-a-developer-s-story) - [Data Governance in the Era of AI](https://www.wearedevelopers.com/videos/1622-data-governance-in-the-era-of-ai) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers) - [Best US AI Conferences for CTOs in 2026: Build vs. Buy, Vendor Evaluation, and Peer Intelligence](https://www.wearedevelopers.com/magazine/736-best-us-ai-conferences-for-ctos-in-2026-build-vs-buy-vendor-evaluation-and-peer-intelligence)