Snowflake & DBT Data Architect — Scalable Cloud Data

Lorven Technologies Inc.; Chicago (IL); On-site; USD 140,000 - 210,000; Full time

Job summary

Lorven Technologies Inc. is seeking a Data Engineer / Architect with deep Snowflake, DBT, and cloud data warehousing expertise to design scalable data architectures and robust ELT pipelines.

You will lead data modelling, optimize Snowflake performance and costs, and collaborate with analytics teams to deliver trusted data across the business. Ideal candidates have 12+ years of experience and strong communication skills.

Qualifications

• Bachelor’s or Master’s degree in Computer Science, Engineering, Information Systems, or related field.
• 12+ years of overall work experience and 5+ years in data architecture/engineering or similar roles.
• Strong hands-on Snowflake expertise for data warehouse design, security, sharing, and performance.
• Proficiency with DBT for modelling, tests, and deployment; experience building robust pipelines.
• Solid experience with ELT/ETL solutions and orchestration tools (Airflow, Prefect).
• Proficient SQL; Python is a plus.
• Experience with BI/reporting tools (Looker/Tableau/Power BI) is advantageous.
• Excellent communication and collaboration skills.

Responsibilities

• Architect and implement scalable data solutions using Snowflake and cloud platforms (AWS/Azure/GCP).
• Design and maintain data models (star/snowflake, data vault) and pipelines with DBT.
• Develop, optimize, and document ELT/ETL workflows and governance practices.
• Collaborate with data engineers, analysts, and stakeholders to collect requirements and deliver end-to-end data solutions.
• Establish data quality, integrity, and security standards across environments.
• Monitor Snowflake performance, costs, and resource usage; optimize accordingly.
• Advise on data architecture strategy, tooling, and process improvements.
• Mentor junior data engineers and analysts on modelling, transformation, and Snowflake/DBT best practices.
• Stay current with trends in cloud data warehousing and analytics.

Skills

SQL

Data architecture

Data modelling

Cloud data warehousing

ETL/ELT design

BI tooling knowledge

Education

Bachelor’s or Master’s in CS/Engineering/Information Systems

Tools

Snowflake

DBT

Airflow

Prefect

Looker

Tableau

Power BI

Python

Job description

Lorven Technologies Inc. is seeking a Data Engineer / Architect with deep Snowflake, DBT, and cloud data warehousing expertise to design scalable data architectures and robust ELT pipelines.

You will lead data modelling, optimize Snowflake performance and costs, and collaborate with analytics teams to deliver trusted data across the business. Ideal candidates have 12+ years of experience and strong communication skills.