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