JOB DESCRIPTION

How You Will Contribute:

The Snowflake Data Engineer will be responsible for developing data solutions for Ciena. The individual will be responsible in both data acquisition and data transformation within the snowflake platform. Work with multiple stakeholders to gather the requirement and ensure agile delivery of projects. Exhibit leadership in building data pipelines across the organization to support data needs of multiple teams.

• Having a programmer mind-set
• Delivery of data pipelines leveraging streaming platforms
• Ensure best practices are followed for snowflake design.
• Performance tuning of snowflake workloads
• Supports ad hoc requests to support the business needs.
• Work closely with architecture teams & cross functional IT teams to ensure solution alignment.
• Willingness to adapt to technology shift.
• Support migration of the ETL process from Oracle / Informatica into Snowflake
• Service Operation and end to end delivery responsibility.
• Recognizing and implementing improvement opportunities for business needs
• Analyzing data related challenges and propose alternate solutions.

What Does Ciena Expect of You?

• Initiative – you’re a self-starter who works with limited direction and is committed to delivering against aggressive deadlines.
• A customer first mentality – what’s important to the customer is also important to you.
• Agility – you are readily able to manage competing and ever-changing priorities and maintain a balanced and methodical approach to problem solving.
• Communication expertise – you possess the ability to tailor your message and ideas to the audience to ensure understanding and consensus.
• The flexibility to work independently and as part of a broader team – you thrive in a team environment, are comfortable working independently, and know how to get things done in a virtual environment.
• Relationship builder – with a proven ability to influence, you’re able to quickly develop trusted connections and get work done through others.

The Must Haves:

• Bachelor's degree in computer science, MIS, Business, or IT related field (or minimum 5 years of hands-on, relevant, technical work experience).
• Strong experience in implementing data management solutions using snowflake
• Prior Working knowledge of Informatica / Data Integration Tool is a must
• Proficient in SQL
• Experience with data warehouse technical architectures, ETL/ELT, reporting/analytic tools, and scripting
• Experience in Agile / Scrum delivery model & strong communications skills
• Strong understanding of Snowflake and it’s foundational concepts
• Experience in building data ingestion pipeline using AWS data services.
• Knowledge of Data Build Tool (DBT)
• Knowledge of Informatica
• Have good Knowledge in ETL and hands on experience in ETL.
• Previous experience with end-to-end implementation of Snowflake cloud data warehouse or end to end data warehouse implementations on-premises
• Experience working in an Agile team.
• Experience in DevOps and Familiar with Jenkins, docker

Assets:

• Experience in Data Build Tool is a plus