This job has closed.

Atrium · 1 month ago

Snowflake Data Engineering Lead

United States

Full-time

Remote

Senior Level

6+ years exp

Atrium is a consulting firm that specializes in AI-driven solutions. As a Snowflake Data Engineering Lead, you will design and optimize data architecture, mentor teams, and ensure data integrity for various projects.

Business IntelligenceCloud ComputingConsultingCRMInformation Technology

Growth Opportunities

H1B Sponsor Likely

Responsibilities

Lead the design and architecture of end-to-end data warehousing and data lake solutions, focusing on the Snowflake platform, incorporating best practices for scalability, performance, security, and cost optimization

Assemble large, complex data sets that meet functional / non-functional business requirements

Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc

Lead and mentor both onshore and offshore development teams, creating a collaborative environment

Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL, DBT, Python, AWS, and Big Data tools

Development of ELT processes to ensure timely delivery of required data for customers

Implementation of Data Quality measures to ensure accuracy, consistency, and integrity of data

Design, implement, and maintain data models that can support the organization's data storage and analysis needs

Deliver technical and functional specifications to support data governance and knowledge sharing

Qualification

SnowflakeData WarehousingSQLPythonETL/ELT toolsApache AirflowData Quality measuresProject managementProblem-solvingCommunication skillsTeam player

Required

Bachelor's degree in Computer Science, Software Engineering, or equivalent combination of relevant work experience and education

6+ years of experience delivering consulting services to medium and large enterprises. Implementations must have included a combination of the following experiences: Data Warehousing or Big Data consulting for mid-to-large-sized organizations

3+ years of experience specifically with Snowflake, demonstrating deep expertise in its core features and advanced capabilities

Strong analytical skills with a thorough understanding of how to interpret customer business needs and translate those into a data architecture

Hands-on experience with Python (Pandas, Dataframes, Functions)

Strong proficiency in SQL (Stored Procedures, functions), including debugging, performance optimization, and database design

Strong Experience with Apache Airflow and API integrations

Solid experience in any one of the ETL/ELT tools (DBT, Coalesce, Wherescape, Mulesoft, Matillion, Talend, Informatica, SAP BODS, DataStage, Dell Boomi, etc.)

Strong project management, problem-solving, and troubleshooting skills with the ability to exercise mature judgment

Enthusiastic, professional, and confident team player with a strong focus on customer success who can present effectively even under adverse conditions

Strong presentation and communication skills

Preferred

SnowPro Core certification is highly desired

Nice to have: Experience in Docker, DBT, data replication tools (SLT, Fivetran, Airbyte, HVR, Qlik, etc), Shell Scripting, Linux commands, AWS S3, or Big data technologies

Company

Atrium

Glassdoor4.3

Atrium is a consulting firm that specializes in delivering data-driven CRM strategy.

Founded in 2018

Bozeman, Montana, USA

201-500 employees

https://atrium.ai

H1B Sponsorship

Atrium has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)

Distribution of Different Job Fields Receiving Sponsorship

Represents job field similar to this job

Trends of Total Sponsorships

2025 (1)

2022 (1)

2021 (1)