Snowflake Data Engineer

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

Enjoy problem-solving, need a venue to display your creativity, and emerging technologies pique your interest; if so, Barrow Wise Consulting, LLC is for you. As a multi-disciplined leader, you understand the gifts that set you apart from everyone else. Demonstrate innovative solutions to our clients. Join Barrow Wise Consulting, LLC today.

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.

An ideal candidate has the following:

• U.S. Citizenship
• 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.
• Experience building reproducible ETL/ELT pipelines using Snowflake Streams, Tasks, and external stages.
• Ability to package Python/R modeling code into Snowpark stored procedures
• Snowflake Certification
• A meticulous eye for detail and a commitment to accuracy
• Ability to work collaboratively in a team-focused environment

Join the team at Barrow Wise Consulting, LLC, for a fulfilling and engaging experience! Our team is dedicated to providing innovative solutions to our clients in an ethical and diverse work environment. We offer competitive compensation packages, excellent benefits, and opportunities for growth and advancement. Barrow Wise is an equal-opportunity, drug-free employer committed to diversity in the workplace. Minority/Female/Disabled/Protected Veteran/LGBT are welcome to apply.

Our employees stand behind Barrow Wise's core values of integrity, quality, innovation, and diversity. We are confident that Barrow Wise's core values, business model, and team focus create positive career paths for our employees. Barrow Wise will continue to lead the industry in delivering new solutions to clients and persevere until the client is overjoyed.