Snowflake Data Engineer

Role & responsibilities

The Role:

We are looking for a candidate to join our team who will be involved in the ongoing development of our Enterprise Data Warehouse (EDW) and supporting our POS [Point of Sale] Channel Data Management team. This role will include participating in the loading and extraction of data, including POS to and from the warehouse. The ideal candidate will be involved in all stages of the project lifecycle, from initial planning through to deployment in production. A key focus of the role will be data analysis, data modeling, and ensuring these aspects are successfully implemented in the production environment.

Your Contribution:

Be Yourself. Be Open. Stay Hungry and Humble. Collaborate. Challenge. Decide and just Do. These are the behaviors youll need for success at Logitech. In this role you will:

• Design, Develop, document, and test ETL solutions using industry standard tools.
• Ability to design Physical and Reporting Data models for seamless cross-functional and cross-systems data reporting.
• Enhance point-of-sale datasets with additional data points to provide stakeholders with useful insights.
• Ensure data integrity by rigorously validating and reconciling data obtained from third-party providers.
• Collaborate with data providers and internal teams to address customer data discrepancies and enhance data quality.
• Work closely across our D&I teams to deliver datasets optimized for consumption in reporting and visualization tools like Tableau
• Collaborate with channel data and cross-functional teams to define requirements for POS and MDM data flows.
• Support Customer MDM & POS Adhoc Requests and Data Clarification from the Channel Data Team and the Finance Team.
• Collaborate with the BIOPS team to support Quarter-end user activities and ensure compliance with SOX regulations.
• Should be willing to explore and learn new technologies and concepts to provide the right kind of solution.

Key Qualifications:

For consideration, you must bring the following minimum skills and behaviors to our team:

• A total of 6+ years of experience in ETL design, development, and populating data warehouses. This includes experience with heterogeneous OLTP sources such as Oracle R12 ERP systems and other cloud technologies.
• At least 3 years of hands-on experience with Pentaho Data Integration or similar ETL tools.
• Practical experience working with cloud-based Data Warehouses such as Snowflake and Redshift.
• Significant hands-on experience with Snowflake utilities, including SnowSQL, SnowPipe, Python, Tasks, Streams, Time Travel, Optimizer, Metadata Manager, data sharing, and stored procedures.
• Comprehensive expertise in databases, data acquisition, ETL strategies, and the tools and technologies within Pentaho DI and Snowflake.
• Demonstrated experience in designing complex ETL processes for extracting data from various sources, including XML files, JSON, RDBMS, and flat files.
• Exposure to standard support ticket management tools.
• A strong understanding of Business Intelligence and Data warehousing concepts and methodologies.
• Extensive experience in data analysis and root cause analysis, along with proven problem-solving and analytical thinking capabilities.
• A solid understanding of software engineering principles and proficiency in working with Unix/Linux/Windows operating systems, version control, and office software.
• A deep understanding of data warehousing principles and cloud architecture, including SQL optimization techniques for building efficient and scalable data systems.
• Familiarity with Snowflakes unique features, such as its multi-cluster architecture and shareable data capabilities.
• Excellent skills in writing and optimizing SQL queries to ensure high performance and data accuracy across all systems.
• The ability to troubleshoot and resolve data quality issues promptly, maintaining data integrity and reliability.
• Strong communication skills are essential for effective collaboration with both technical and non-technical teams to ensure a clear understanding of data engineering requirements.

In addition, preferable skills and behaviors include:

• Exposure to Oracle ERP environment,
• Basic understanding of Reporting tools like OBIEE, Tableau

Education:

• BS/BTech/MS in computer science Information Systems or a related technical field or equivalent industry expertise.

Logitech is the sweet spot for people who are passionate about products, making a mark, and having fun doing it. As a company, we're small and flexible enough for every person to take initiative and make things happen. But we're big enough in our portfolio, and reach, for those actions to have a global impact. That's a pretty sweet spot to be in and we're always striving to keep it that way.