Data Architect (Snowflake & DBT)
Lorven Technologies Inc
Chicago, IL, United States
10 days ago
- Discuss this with your agent
- Open in Claude
- Open in ChatGPT
Apply on www.dice.com
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Role details
Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
5 years minimum
Working hours
Regular working hours
Job source
Tech stack
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
+18 more
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
Job 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.
Requirements
- 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.
Apply for this position
This job is hosted externally. Click below to view the full posting and apply.
Apply on www.dice.com
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Good distractions
Talks and stories from around this role — technically off-topic, practically not.
Moments
Explore playlistsVideos
See allRelated articles
See all
BB
Benedikt Bischof
about 4 years ago
DS
Dhannush Subramani
Top Big Data Technologies That You Need to Know
about 4 years ago
EM
Eli McGarvie
Highest Paying Tech Companies for Developers
over 3 years ago
EM
Eli McGarvie
Data Engineer Salary UK
over 3 years ago
AJ
Austin Joy
What Are The Top Skills Required For Azure Developers?
over 4 years ago
CS
Christina Schaireiter
Best US AI Conferences for CTOs in 2026: Build vs. Buy, Vendor Evaluation, and Peer Intelligence
4 months ago