Senior Data Engineering

Logitech is the Sweet Spot for people who want their actions to have a positive global impact while having the flexibility to do it in their own way 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 The Media and Marketing Data Enginee role will include participating in the loading and extraction of data including external sources through API Storage buckets S3 Blob storage and marketing specific data integrations 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 you ll 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 data architects analysts and business stakeholders to gather requirements and translate them into data solutions Participate in the design discussion with enterprise architects and recommend design improvements Develop and maintain conceptual logical and physical data models with their corresponding metadata Work closely with cross-functional teams to integrate data solutions Create and maintain clear documentation for data processes data models and pipelines Integrate Snowflake with various data sources and third-party tools Manage code versioning and deployment of Snowflake objects using CI CD practices Key Qualifications For consideration you must bring the following minimum skills and behaviors to our team A total of 6 to 10 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 Snowflake AI ML and stored procedures Worked on API based integrations and marketing data Design and develop complex data pipelines and ETL workflows in Snowflake using advanced SQL UDFs UDTFs and stored procedures JavaScript SQL Comprehensive expertise in databases data acquisition ETL strategies and the tools and technologies within Pentaho DI and Snowflake Experience in working with complex SQL Functions Transformation of data on large data sets 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 Snowflake s 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 Exposure to Marketing data platform like Adverity Fivertran etc Exposure to Customer data platform Education BS BTech MCA MS in computer science Information Systems or a related technical field or equivalent industry expertise Fluency in English 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 All qualified applicants will receive consideration for employment without regard to race sex color religion sexual orientation gender identity national origin protected veteran status or on the basis of disability Across Logitech we empower collaboration and foster play We help teams collaborate learn from anywhere without compromising on productivity or continuity so it should be no surprise that most of our jobs are open to work from home from most locations Our hybrid work model allows some employees to work remotely while others work on-premises Within this structure you may have teams or departments split between working remotely and working in-house Logitech is an amazing place to work because it is full of authentic people who are inclusive by nature as well as by design Being a global company we value our diversity and celebrate all our differences Don t meet every single requirement Not a problem If you feel you are the right candidate for the opportunity we strongly recommend that you apply We want to meet you We offer comprehensive and competitive benefits packages and working environments that are designed to be flexible and help you to care for yourself and your loved ones now and in the future We believe that good health means more than getting medical care when you need it Logitech supports a culture that encourages individuals to achieve good physical financial emotional intellectual and social wellbeing so we all can create achieve and enjoy more and support our families We can t wait to tell you more about them being that there are too many to list here and they vary based on location All qualified applicants will receive consideration for employment without regard to race sex age color religion sexual orientation gender identity national origin protected veteran status or on the basis of disability If you require an accommodation to complete any part of the application process are limited in the ability are unable to access or use this online application process and need an alternative method for applying you may contact us toll free at 1-510-713-4866 for assistance and we will get back to you as soon as possible