Cloud Architect
Resource Informatics Group, Inc, Milwaukee, WI, United States
Job Title: Technology Lead | Cloud Integration | Azure Data Factory (ADF) with Snowflake
Work Location: Milwaukee, WI 53209 (Hybrid) – 1 or 2 days
Detailed Job Description
Design, build, and maintain ADF pipelines, dataflows, and orchestrations for ingestion, transformation, and load processes.
Implement Snowflake ELT pipelines including Snowpipe, Streams, Tasks, and stored procedures.
Develop incremental and batch data ingestion patterns from multiple source systems (APIs, files, databases, cloud systems).
Snowflake Development
Create and optimize Snowflake objects (databases, schemas, warehouses, roles, tables, views, UDFs).
Optimize performance using clustering, micro-partitions, query tuning, and warehouse sizing.
Work with Azure services: ADLS Gen2, Azure SQL, Key Vault, Databricks (preferred).
Implement DevOps CI/CD for ADF and Snowflake using Azure DevOps/Git.
Collaborate with data architects, analysts, and SMEs to understand business requirements.
Document technical designs, data flows, lineage, and development standards.
Minimum years of experience required: 8-10 years
#J-18808-Ljbffr
Work Location: Milwaukee, WI 53209 (Hybrid) – 1 or 2 days
Detailed Job Description
Design, build, and maintain ADF pipelines, dataflows, and orchestrations for ingestion, transformation, and load processes.
Implement Snowflake ELT pipelines including Snowpipe, Streams, Tasks, and stored procedures.
Develop incremental and batch data ingestion patterns from multiple source systems (APIs, files, databases, cloud systems).
Snowflake Development
Create and optimize Snowflake objects (databases, schemas, warehouses, roles, tables, views, UDFs).
Optimize performance using clustering, micro-partitions, query tuning, and warehouse sizing.
Work with Azure services: ADLS Gen2, Azure SQL, Key Vault, Databricks (preferred).
Implement DevOps CI/CD for ADF and Snowflake using Azure DevOps/Git.
Collaborate with data architects, analysts, and SMEs to understand business requirements.
Document technical designs, data flows, lineage, and development standards.
Minimum years of experience required: 8-10 years
#J-18808-Ljbffr