Data Warehouse Specialist

TheKey • San Diego, CA

6d

About The Position

TheKey, LLC dba TheKey Management LLC is hiring a full-time Data Warehouse Specialist in La Jolla, California. The role supports the company's data warehouse and analytics operations, including data quality, data discovery, data modeling, documentation, and nightly batch processing. Remote work benefit is available.

Requirements

• Master’s degree or foreign equivalent in Computer Science, Management Information Systems, Data Science, Business Analytics, or a related field.
• Five years of experience in the job offered or a related position.
• Five years of experience creating data lake views as data sources for Workato iPaaS (Integration Platform as a Service).
• Five years of experience with data privacy concerns such as PII, HIPAA, and GDPR.
• Five years of experience with architecture and designing relational tables and star schemas.
• Five years of experience with SQL scripting and advanced SQL skills, including DML.
• Five years of experience with Google Cloud Platform BigQuery database.
• Five years of experience with Google Cloud Data Fusion.

Responsibilities

• Find and resolve data quality problems.
• Perform ad-hoc data pulls for export to internal and external partners.
• Perform data discovery on new data sources being brought into the data lake.
• Design and create new views and tables in BigQuery.
• Create data dictionaries and other documentation.
• Monitor nightly batch jobs that load analytic tables.
• Perform additional duties as assigned by the supervisor.

Benefits

• Medical, dental, and 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
• Remote work benefit

What This Job Offers

• Job Type: Full-time
• Career Level: Senior