Snowflake Data Engineer

Barrow Wise Consulting•Rockville, MD

2d•$100,000 - $155,000•Remote

About The Position

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

Requirements

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
A meticulous eye for detail and a commitment to accuracy
Ability to work collaboratively in a team-focused environment

Nice To Haves

Snowflake Certification

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.