📁
IT
📅
210001ZT Requisition #

The Data Warehouse Engineer will be an integral member of Genesys IT Ops group. They will be responsible for effective administration of Snowflake Cloud Data Warehouse and perform activities as explained in responsibilities. In this hands-on role, the Data Warehouse Engineer will help us on our journey to become a more data driven company and to operate on enterprise standards.

 

Responsibilities:

In this role, the primary areas of responsibilities will include (but are not limited to):

  • Lead all aspects of administration activities (few below) both at infrastructure and application level
  • User Role administration
  • Schema/Database administration
  • Service Account/password administration
  • Task Scheduling / Business Process Automation
  • Usage Monitoring
  • User Clean-up (Terminated users)
  • SOX / ITGC activities
  • Technical documentation
  • Define and automate DBA functions (term employee clean-up, Audit reports for ITGC)
  • Evangelize best practices in database usage and end to end architecture
  • Analyze production workloads and develop strategies to run Snowflake database with scale and efficiency
  • Articulate and implement Snowflake standard methodologies and find inventive way of implementing them
  • Provide production support for Data Warehouse issues such data load problems, transformation/translation problems, etc.
  • Communication with key business users, cross functional IT teams

 

Requirements:

Minimum (Required) Qualifications:

  • Bachelor’s Degree in Computer Science, Information Technology, Business Intelligence, or a related discipline 

  • 5+ years of work-related experience in database administration

  • Experience with Snowflake in administration, Monitoring, security, managing roles and permissions

  • Experience in Snowflake performance tuning, usage/utilization monitoring

  • Should have knowledge of snowflake pricing model and experience in implementing enterprise-wide best practices to optimize usage and pricing

  • Strong knowledge and hands on experience with SQL

  • Experience with Snowflake SnowSQL and writing user defined functions

  • Should have experience in working with snowflake support in resolution of issues

  • Experience with GitHub, CI/CD pipeline tools like Jenkins is a plus

  • Good to know Snowflake concepts like Snowpipe, SnowSQL, Clustering, usage of materialized views

  • Knowledge of how to implement security features like SSO, column masking, role-based administration

  • Experience of semi-structured (XML, JSON) and unstructured data handling and streaming data loads

  • Good to have SnowPro certification (basic) or SnowPro Architect Certification

  • Good to have knowledge on ITGC activities and process

  • Excellent written and verbal communication skills

  • Ability to innovate and to effectively deal with rapid change in a positive manner

  • Proven customer service and support focus

#LI-AR3

Covid-19

Safety for our employees and our communities is a key priority for Genesys. We continue to experience rapid growth during the Covid-19 pandemic and are conducting remote hiring and onboarding processes. All hiring and onboarding processes are being conducted remotely at this time. We utilize Zoom video meetings and phone calls during the interview process. We will be working remotely through at least December 31, 2021, in most locations, and we are re-evaluating the opening date of all the Genesys offices on an ongoing basis. 


About Genesys:

Every year, Genesys® orchestrates more than 70 billion remarkable customer experiences for organizations in more than 100 countries. Through the power of our cloud, digital and AI technologies, organizations can realize Experience as a Service℠, our vision for empathetic customer experiences at scale. With Genesys, organizations have the power to deliver proactive, predictive, and hyper personalized experiences to deepen their customer connection across every marketing, sales, and service moment on any channel, while also improving employee productivity and engagement. By transforming back-office technology to a modern revenue velocity engine Genesys enables true intimacy at scale to foster customer trust and loyalty. Visit www.genesys.com.


Genesys is an equal opportunity employer committed to diversity in the workplace. We evaluate qualified applicants without regard to race, color, age, religion, sex, sexual orientation, gender identity or expression, marital status, domestic partner status, national origin, genetics, disability, military and veteran status, and other protected characteristics.

Previous Job Searches

Activity Feed

65259
Job shares through Genesys
Someone applied to the Sr. Assistant Corporate Counsel position. 27 minutes ago
Someone applied to the Lease Administration Analyst position. 27 minutes ago
Someone applied to the Senior Treasury Analyst position. 43 minutes ago
Someone applied to the Team Lead, Cloud Infrastructure Engineer position. 43 minutes ago
Someone applied to the Sales Development Representative position. 43 minutes ago

Similar Listings

United States, California, Daly City, Virtual Office (California)

📁 IT

Requisition #: 210002RO

United States, California, Daly City, Virtual Office (California)

📁 IT

Requisition #: 210001CY

United States, California, Daly City, Virtual Office (California)

📁 IT

Requisition #: 210002TB