Lead Snowflake Data Engineer

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're a smart collaborator who likes solving complex problems and takes ownership to get things done. You stay up to date with the latest and greatest in business and technology tools, platforms, and languages — and want to ensure your clients do too. You love working across teams and are enthusiastic about doing your part to ensure everyone succeeds.

As a Lead Snowflake Data Engineer, you will be responsible for expanding and optimizing the data and data pipeline architecture, as well as optimizing data flow and collection for cross-functional teams. You will support the software developers, database architects, data analysts, and data scientists on data initiatives and will ensure optimal data delivery architecture is consistent throughout ongoing projects.

In This Role, You Will

• Create and maintain optimal data pipeline architecture.
• 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 the timely delivery of required data for customers.
• Implement 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.

In This Role, You Will Have

Next steps

Recruiting at Atrium is highly personalized. While some candidates may complete the hiring process quickly, others may take a bit longer, depending on the role and its requirements. We're excited to get to know you and ensure you get to know our team along the way.

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.

Skills Required

Big Data, Sql, ELT, Apache Airflow, Data Quality, Docker, snowflake , dbt, Data Warehousing, Python, Etl, Aws