Take your career to the next level with the only consulting firm born in AI and delivering with AI.
At Atrium, we’re not simply adapting to an AI-driven world — we’ve helped define it since we were founded. Our clients partner with us because we turn potential into measurable impact, reshaping industries, realizing exponential value, and empowering organizations to thrive in an era of unprecedented technological advancement.As pioneers in AI-assisted delivery, we’re constantly optimizing how we deliver services for greater speed, accuracy, and efficiency. This commitment allows us to repeatedly deliver outcomes that other Salesforce and Snowflake partners merely promise. Care to join us?
Who are you?
You are smart, collaborative and take ownership to get things done. You love to learn and are intellectually curious in business and technology tools, platforms and languages. You are energized by solving complex problems and bored when you don’t have something to do. You love working in teams, and are passionate about pulling your weight to make sure the team succeeds.
What will you be doing at Atrium?
At Atrium, you'll be at the forefront of shaping our data landscape. You'll leverage your deep expertise in Snowflake to build robust, scalable, and high-performing data architectures that drive critical business insights. You'll not only design the future of our data but also guide our teams in its successful execution, ensuring our data strategy aligns perfectly with our business goals. Your contributions will directly impact our ability to make data-driven decisions and innovate.
In This Role, You Will
- Lead the design and implementation of end-to-end data solutions within the Snowflake ecosystem, covering data ingestion, transformation, storage, and consumption layers
- Define and enforce best practices for Snowflake usage, including data modeling, query optimization, security frameworks, access control, and cost management strategies
- Architect and build scalable data pipelines using a variety of integration tools (e.g., Fivetran, Stitch, custom ETL/ELT frameworks) to efficiently load data into Snowflake
- Collaborate closely with data engineers to develop efficient ELT/ETL processes, stored procedures, and robust data quality checks directly within Snowflake
- Optimize Snowflake warehouse usage, leveraging features like clustering, materialized views, and other advanced capabilities to ensure optimal performance and cost-efficiency
- Provide technical leadership and mentorship to data engineering teams, fostering a culture of excellence and continuous improvement in data practices
- Conduct performance tuning, troubleshooting, and root cause analysis for any Snowflake-related issues, ensuring system stability and reliability
- Stay abreast of the latest Snowflake features, updates, and industry best practices, evaluating new technologies to continually enhance our data platform capabilities
- Work with business stakeholders to comprehensively understand their data requirements and translate them into precise technical specifications and architectural designs
- Ensure strict adherence to data security, privacy, and compliance standards within the entire Snowflake environment
- Support pre-sales solutioning efforts, including some hands on keyboard development supporting various POC’s.
- Help Architect and Build various pre-sales demos and best practice accelerators that contribute to Atrium’s IP Library.
In This Role, You Will Have
- Bachelor's or Master's degree in Computer Science, Engineering, or a related quantitative field
- Proven experience 8+ years in data warehousing, data architecture, or senior data engineering roles
- Minimum of 4+ years of hands-on experience as a Snowflake Architect, demonstrating extensive practical knowledge of Snowflake's core features and advanced capabilities
- Deep understanding of modern data warehousing concepts, dimensional modeling, and data lake architectures
- Expertise in SQL and proven experience with performance tuning complex queries on very large datasets
- Strong experience with major cloud platforms (AWS, Azure, GCP) and seamless integration of Snowflake with various cloud services
- Proficiency with a range of data integration tools and techniques (e.g., Python, Spark, Fivetran, DBT, Matillion, Airflow)
- Deep Experience with version control systems (Git) and establishing CI/CD pipelines for data solutions
- Excellent communication, interpersonal, and presentation skills, with the ability to articulate complex technical concepts clearly to both technical and non-technical audiences
- The ability to work both independently and collaboratively within a fast-paced, agile environment
- Certifications in Snowflake are highly desired.
Next Steps
Our recruitment process is highly personalized. Some candidates complete the hiring process in one week, others may take longer as it’s important we find the right position for you. It's all about timing and can be a journey as we continue to learn about one another. We want to get to know you and encourage you to be selective - after all, deciding to join a company is a big decision!At Atrium, we believe a diverse workforce allows us to match our growth ambitions and drive inclusion across the business. We are an equal opportunity employer and all qualified applicants will receive consideration for employment.
