Snowflake Data Engineer

Barrow Wise Consulting, LLC; Rockville (MD); Remote; USD 120,000 - 150,000; Full time

Benefits offered by this job

Competitive compensation

Excellent benefits

Growth opportunities

Job summary

Barrow Wise Consulting, LLC is seeking a Snowflake Data Engineer to design, build, and optimize Snowflake-based data pipelines for large-scale datasets. The role emphasizes secure cloud data environments and reproducible modeling workflows.

The ideal candidate will bring 6+ years of data engineering experience, 3+ years with Snowflake, SQL, and cloud data platforms, plus a Snowflake certification. Remote work is available, with collaboration in a team-focused environment.

Qualifications

• U.S. Citizenship required.
• 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.

Skills

Team collaboration

Attention to detail

Problem solving

Education

Bachelor's Degree in a related field

Snowflake Certification

Tools

Snowflake

SQL

Snowpark

Python/R

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:

The Snowflake Data Engineer will support Barrow Wise and perform the following duties:

• 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.