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.
Qualification:
To perform this job successfully, an individual must be able to perform each essential job duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required.
Essential Duties and Responsibilities:
● Troubleshoot data related issues in Tableau reports
● 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 warehouse
●Designing and creating new views and tables in BigQuery
● Create data dictionaries and other documentation
● Monitor nightly batch jobs which load analytics tables
● Additional duties as assigned by your supervisor
Required Skills, Education and Certifications:
• Self driven individual with good problem solving skills
• Bachelor's degree in Computer Science, MIS, Data Science or equivalent experience
• Strong in data analysis with ability to relate data to business processes
• Understanding of data privacy concerns such as PII, HIPA and GDPR
• Knowledge of data architecture and ability to design relational tables and star schemas
• 5+ years SQL scripting with advanced SQL skills including DML
• Minimum of 1 year experience with Google Cloud Platform BigQuery database
• 3+ years database and/or data pipeline development experience
• Experience with Google Cloud Data Fusion ETL tool preferred
• Experience with sFTP, Bitbucket, Jira, Confluence, Trello, and Freshdesk tools a plus
Physical Requirements:
● Ability to lift and carry up to 10-15 pounds
● Ability to sit, stand and walk for prolonged periods of time throughout the work day
● Ability to use standard office equipment such as personal computer, laptop, telephone, photocopy machine, etc.
Benefits for full time employees
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.
#LI-TK