Senior Data Engineer

Description :

About the job :

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) 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 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.

- 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 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/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, were small and flexible enough for every person to take initiative and make things happen.

- But were big enough in our portfolio, and reach, for those actions to have a global impact.

- Thats a pretty sweet spot to be in and were always striving to keep it that way.