Snowflake Data Engineering Consultant

Atrium is a consulting firm specializing in AI-driven solutions, helping clients achieve measurable impact through innovative technology. As a Snowflake Data Engineering Consultant, you will design, build, and maintain data pipelines while collaborating with teams to ensure data integrity and support data initiatives.

Responsibilities:

• Create and maintain optimal data pipeline
• Integrate data from multiple sources, both internal and external, ensuring data consistency and accuracy
• Help in building the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL, AWS, and Big Data technologies
• Implement the Data Quality checks to ensure accuracy, consistency, and integrity of data. Also monitoring processes to ensure data integrity and reliability
• Design, implement, and maintain data models that can support the organization's data storage and analysis needs
• Create and maintain documentation for data pipelines, data dictionaries, and data lineage
• Provide support for data-related issues and assist with troubleshooting and problem resolution

Requirements:

• Bachelor's degree in Computer Science, Software Engineering, or equivalent combination of relevant work experience and education
• 2+ years of experience with Snowflake
• 1+ year of experience delivering consulting services to medium and large enterprises
• Hands-on experience with Python (Pandas, Dataframes, Functions)
• Hands-on experience with SQL (Stored Procedures, functions), including debugging, performance optimization, and database design
• Experience with Apache Airflow and API integrations
• Experience with any one of the ETL/ELT tools (DBT, Coalesce, Wherescape, Mulesoft, Matillion, Talend, Informatica, SAP BODS, DataStage, Dell Boomi, etc.)
• 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
• SnowPro Core certification is highly desired