Data Architect (Snowflake & DBT)

Lorven Technologies Inc
Chicago, IL, United States
10 days ago
Apply on www.dice.com
Prepare application

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

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

2:15 min

Empowering domain teams with an open data platform

Sandhya Menon Sandhya Menon · World Congress 2026 Europe

2:46 min

Transforming data architecture from on-premise to cloud

Sandhya Menon Sandhya Menon · World Congress 2026 Europe

2:30 min

Leveraging BigQuery ML for scalable SQL-based segmentation experiments

Julian Joseph · LIVE

1:24 min

Moving the semantic layer upstream to avoid vendor lock-in

Piotr Menclewicz Piotr Menclewicz · Europe 2026 Virtual

1:46 min

Traditional data architecture before Microsoft Fabric

Dr. Alexander Wachtel Dr. Alexander Wachtel +1 · World Congress 2025

3:05 min

Audience questions on AI agents and pipeline vectorization

Joy Joy · World Congress 2024

Videos

See all

Related articles

See all