[Hiring] Data Warehouse Specialist @TheKey

Role Description

TheKey, LLC dba TheKey Management LLC has a full-time opening for a Data Warehouse Specialist in LaJolla, CA. Duties include:

• Finding and resolving data quality problems
• Ad-hoc data pulls for export to internal and external partners
• Performing data discovery on new sources being brought into the data lake
• Designing and creating new views and tables in BigQuery
• Creating data dictionaries and other documentation
• Monitoring nightly batch jobs which load analytic tables
• Additional duties as assigned by your supervisor

Qualifications

• Master’s degree (or foreign equivalent) in Computer Science, Management Information Systems, Data Science, Business Analytics, or a related field
• 5 years’ experience in the job offered or a related position(s)

Requirements

• 5 years of experience in creating data lake views as data source for Workato iPaaS (Integration Platform as a Service)
• Data privacy concerns such as PII, HIPAA, and GDPR
• Architecture and ability to design relational tables and star schemas
• SQL scripting with advanced SQL skills including DML
• Google Cloud Platform BigQuery database
• Google Cloud Data Fusion

Benefits

• Medical/Dental/Vision Insurance
• TouchCare VirtualCare
• Life Insurance
• Health Savings Account
• Flexible Spending Account
• 401(k) Matching
• Employee Assistance Program
• PTO Plan for Non-Exempt Employees
• Flexible PTO Plan for Exempt Employees
• Holidays and Floating Holidays
• Pet Insurance