Data Warehouse Specialist
TheKey Open At a glance
Mid-level Data Engineering role at TheKey. La Jolla · full-time · $160,992 base.
dataroles summary, based on the employer's posting.
What you'll do
- Track down data quality issues and correct them across the warehouse
- Pull data on request and prepare exports for internal teams and external partners
- Explore incoming data sources before they are added to the data lake
- Build BigQuery tables and views, then document them in data dictionaries and related materials
- Check overnight processes that load analytical tables and address problems as they arise
What you bring
- A relevant master’s degree, or an equivalent foreign credential, plus five years in this or a related role
- Five years building data lake views for Workato and working with privacy rules such as PII, HIPAA and GDPR
- Five years designing relational tables and star schemas, with advanced SQL and DML skills
- Five years using Google Cloud Platform BigQuery and Google Cloud Data Fusion
Who this fits
This is a mid-level, full-time specialist position based in La Jolla, California, with remote work available. California-based applicants must pass the required fingerprint identification process.
From the employer
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 Talent@thekey.com
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
TheKey is an equal opportunity employer. TheKey prohibits discrimination and harassment of any type and affords equal employment opportunities to employees and applicants without regard to race, color, religion, sex, age, national origin, disability status, protected veteran status, or any other characteristic protected by law.
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.
Data Engineering work from LinkedIn, X, Reddit and Upwork, in one list.
Each morning you get everything that fits, strongest first.
Data Engineering$160k+
Find me workBy the team behind dataroles.