Snowflake Data Engineer

Role & responsibilities

• Provide Snowflake Technical leadership for the enterprise reporting and analytics team
• Lead the development and optimization of data models and SQL scripts within Snowflake to support analytical and reporting needs
• Create and maintain data pipelines for ingestion, transformation and validation.
• Create and configure alerts and task monitoring within Snowflake related to job status, task failure / successes, security events, data quality, etc.
• Understand the current state reporting and automation solution, identify & work on improvement areas
• Work with stakeholders including the Executive, Product, Data and Design teams to assist with data-related technical issues and support their data reporting needs.
• Build analytics tools that utilize the data pipeline to provide actionable insights into customer acquisition, operational efficiency, and other key business performance metrics.
• Assemble large, complex data sets that meet functional / non-functional business requirements.
• Utilizing knowledge of ETL and Data modeling drive and execute systems with a variety of large structured and unstructured sources. Work with data and drive analytics.
• Drive all aspects of the Digital transformation, Data management, Reporting and Data Science capabilities through PoCs, Projects to introduce new capabilities.
• Engage with external vendors / internal teams on all aspects of project execution.
• Build the infrastructure required for ELT from a wide variety of data sources.
• Responsible for system administration, design, architecture, and continuous improvement across the Snowflake platform

Preferred candidate profile

• Bachelors degree in Computer Science, Business, Math, Statistics, Engineering or related field or equivalent is required.
• 10 + years of Business & Technical experience utilizing EDW tools like Snowflake, ETL tools - Alteryx and Data Visualization Tools like Tableau
• Strong technical experience working directly in Snowflake.
• Proficiency in SQL, Python and cloud-based technologies
• Strong experience in working directly with business users to identify, define, analyze, test and implement reporting needs and platforms
• Experience with and in developing data visualizations through tools such as Tableau, SAC, PowerBI to deliver thought-provoking analytical information to the business
• Sound knowledge of ETL, Data modeling, Statistical and Data Science concepts
• Experience in handling structured and unstructured data

Preferred Qualifications:

• Master’s or other advanced degree in Computer Science, Business, Math, Statistics, Engineering or related field preferred.
• SnowPro Core Certification or other Data Analytics / Data Engineering Certifications
• Manufacturing or business experience with a solid understanding of business operations /processes
• Working knowledge of systems like SAP, SAP BW, Salesforce, etc.
• Exposure to cloud technologies: Azure (Preferred)/AWS/GCP, etc
• Experience in tools ETL like Alteryx/Informatica or similar environments
• Knowledge of SAP ECC 6.0 Modules (SD, MM, PP , FI/CO, QM, PM)