Remote Snowflake Data Engineer - Scalable Pipelines

Barrow Wise Consulting; Maryland; On-site; USD 120,000 - 180,000; Full time

Job summary

Barrow Wise Consulting, LLC, is seeking an experienced Data Engineer to architect, optimize, and secure Snowflake-based data environments. You will build large-scale pipelines, automate ETL/ELT processes, and ensure reproducible modeling workflows across federal datasets, while maintaining high standards for security and data quality.

Ideal candidates bring 6 years in large-scale data projects, 3 years with Snowflake, SQL, and cloud data engineering, plus Snowpark stored procedures expertise.

Qualifications

• Bachelor's degree in a related field.
• 6 years of experience performing large-scale data engineering projects.
• 3 years using the Snowflake platform, SQL, and cloud data engineering.

Responsibilities

• Perform data warehousing and scalability.
• Architect, optimize, and secure the cloud data environment that powers all data modeling tasks.
• Build and maintain Snowflake-based pipelines that ingest large-scale datasets; support reproducible modeling workflows; and ensure security requirements.
• Design and maintain Snowflake warehouses, databases, schemas, and role structures.
• Implement Snowflake best practices for compute scaling, micro-partitioning, clustering, and query optimization.
• Automate ingestion, harmonization, and validation of federal datasets required for statistical modeling.
• Clean, harmonize, and validate datasets.
• Build automated reproducibility workflows and modeling pipelines.
• Conduct anomaly detection, sensitivity analysis, and cross-dataset validation.
• Work remotely.

Skills

Snowflake

SQL

Python

ETL/ELT

Cloud

Education

Bachelor's degree

Tools

Snowpark

Snowflake Streams

Job description

Barrow Wise Consulting, LLC, is seeking an experienced Data Engineer to architect, optimize, and secure Snowflake-based data environments. You will build large-scale pipelines, automate ETL/ELT processes, and ensure reproducible modeling workflows across federal datasets, while maintaining high standards for security and data quality.

Ideal candidates bring 6 years in large-scale data projects, 3 years with Snowflake, SQL, and cloud data engineering, plus Snowpark stored procedures expertise.