Snowflake Data Engineer

Tekniforce - Raleigh, NC

Full-time - Mid Level

Raleigh, NC

Professional, Scientific, and Technical Services

About the position

The Snowflake Data Engineer will be responsible for designing, implementing, and optimizing database solutions, specifically focusing on migrating an on-prem SQL/SSIS data analytics platform to Snowflake in the cloud. This role requires collaboration with cross-functional teams and technical leadership to ensure data integrity and security while contributing to data modernization efforts.

Responsibilities

• Design and implement scalable efficient data pipelines to support various data-driven initiatives.
• Build reusable data solutions.
• Rewrite and optimize SQL queries to improve execution times and reduce resource consumption, ensuring efficient data retrieval and manipulations.
• Create and maintain technical specification documents for Snowflake.
• Document database design, optimization strategies, and procedures.
• Demonstrate technical leadership.
• Collaborate with cross-functional teams.
• Contribute to data modernization efforts by leveraging cloud solutions.
• Ensure data integrity and security.

Requirements

• 7+ years of hands-on experience designing, migrating, and implementing enterprise data platforms.
• 5+ years with data warehousing.
• Strong understanding of Kimball style dimensional models, data architecture, and database design.
• Mastery of SQL, Python, and Snowflake.
• Azure experience is a huge plus.
• Expert with data and analytics, dimensional model, ETL, data collection, and transformation.
• Knowledge of machine learning.
• Continuous learning and personal development.
• Ability to translate business requirements into technical specifications.
• Ability to lead decision-making processes.
• Ability to communicate well.
• Strong analytical skills.
• Understanding of agile and scrum practices.

Nice-to-haves

• Experience with machine learning techniques.
• Familiarity with Azure cloud services.