Skip to main content
Posted January 25, 2022
CertiK

Data Warehouse Administrator

New York / Seattle / Bay Area / Remote Remote Full Time

Why Us? CertiK is the leading blockchain security company. Our clients include leading projects such as Aave, Polygon, Binance Smart Chain, Terra,...

Why Us?
CertiK is the leading blockchain security company. Our clients include leading projects such as Aave, Polygon, Binance Smart Chain, Terra, Yearn, and Chiliz. We just raised over $140 million in funding rounds in 2021. Our investors include top VCs like Coatue, Tiger Global, Sequoia, and Hillhouse Capital.

About you
You are responsible and trustworthy who like to get things organized. For you, it is important that the books in the library are properly indexed and the streets on the map are properly labeled. It is important that the users in a data warehouse have just the right amount of access to achieve a balance between security and flexibility. For you, visibility is important. Who is using each table? How often are they using them? How much computing capacity are we using? What data are we storing in the warehouse? All these questions need to be answered. You are a star communicator who can interface with a large user base to manage their accounts and enforce agreements such as the naming convention. You write succinct documentation and embrace asynchronous communication during remote work. You work closely with the vendors -- such as Snowflake -- and are on top of the vendor-side upcoming changes and their implications for us. You balance reliability with efficiency and take great pride in giving the rest of the team peace of mind in storing and processing their data.

About the role
This role manages our main data warehouse on Snowflake. The warehouse stores almost all of the data related to CertiK's data products and is rapidly growing. As the data warehouse administrator, you'll ultimately be responsible for its wellbeing. This includes but is not limited to data organization (DB/schema/table), team organization, accounts organization, and access control. This role might also include usage monitoring and cost management. Part of the job is to interface with Snowflake to understand the upcoming changes and their implications. This role is expansive and can cover more scope as you see fit. Ultimately we want the rapidly growing data sets to be organized in a readable, flexible, accessible, and secure fashion.



Responsibilities

  • Data architecture and organization, data warehouse design and management (DB/schema/table)
  • Organizing data for different teams, ensuring data availability, data integrity, and security
  • Performance management and tuning, optimize data structure, SQL query, application logic
  • Storage management and capacity planning
  • Coordinating data organization refactoring at different scales
  • Manage user accounts and access control
  • Write succinct documentation to explain conventions such as naming convention
  • Maintain succinct documentation for the data curated in the warehouse (manual or programmatically)
  • (Optionally) Give training to users on data warehouse usage
  • Be a resource to all of the users of the warehouse
  • Work with stakeholders to architect the data organization
  • Any other responsibilities you consider appropriate for this role
  • Qualifications
  • 2 years of experience managing a data warehouse for a sizable team
  • Experience in managing access control for a complex team
  • Experience in at least one major data warehouse data organization refactoring
  • Experience in handling data warehouse incidents
  • Strong written and oral communication
  • Familiarity with the Snowflake data warehouse
  • Experience in managing Snowflake using SQL commands
  • Some basic knowledge in data processing
  • A passion for blockchain


  • Preferred Qualifications

  • Python programming
  • Experience in blockchain technology
  • Experience in data warehouse cost control

  • CertiK is proud to offer medical, vision, and dental insurance, 401(k) plan with company matching, life and accidental death and dismemberment insurance, HSA (with high deductible plan), FSA, and other benefits to all full-time employees, along with flexible paid time off and holidays.

    In compliance with federal law, all persons hired will be required to verify identity and eligibility to work in the United States and to complete the required employment eligibility verification form upon hire.

    CertiK is proud to be an equal opportunity employer. We will not discriminate against any applicant or employee on the basis of age, race, color, creed, religion, sex, sexual orientation, gender, gender identity or expression, medical condition, national origin, ancestry, citizenship, marital status or civil partnership/union status, physical or mental disability, pregnancy, childbirth, genetic information, military and veteran status, or any other basis prohibited by applicable federal, state or local law.

    CertiK will consider for employment qualified applicants with criminal histories in a manner consistent with local and federal requirements.

    All CertiK employees are expected to actively support diversity on their teams, and in the Company.

    This listing expired on Feb 24. Applications are no longer accepted.

    Below are some other jobs we think you might be interested in.