Data Warehouse Specialist

About the role

For nearly 20 years, TheKey has helped clients achieve successful long-term aging at home with comprehensive, concierge-based care. Ensuring the dignity, safety, and independence of its clients, TheKey is committed to changing how the world lives and ages at home. Employee-teams get the training, resources, and support they need to deliver an exceptional care experience for clients and their families. Founded in Silicon Valley, TheKey has grown from a single location to service coverage throughout North America enabling clients to live life on their own terms, in their own homes.

TheKey, LLC dba TheKey Management LLC has a full-time opening for a Data

Warehouse Specialist in LaJolla, CA.

Duties are to find and resolve data quality problems; ad-hoc data pulls for export to internal and external partners; perform data discovery on new sources data being brought into data lake; design and create new views and tables in BigQuery; create data dictionaries and other documentation; monitor nightly batch jobs which load analytic tables; and additional duties as assigned by your supervisor.

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

Specific skill sets: 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; and Google Cloud Data Fusion. Remote work benefit available.

Annual Salary: $160,992. Apply at Thekey.com or Email Resume to

#LI-DNI

Benefits for full time employees

• 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

California Residents Only

In accordance with Article 2 of the California Health and Safety Code - California Community Care Facilities Act, TheKey requires timely and accurate positive fingerprint identification of California based applicants as a condition of employment. If an applicant has been convicted of a non-exemptible crime, and in compliance with all applicable state and local laws, their conditional offer will be rescinded.

#LI-TK