Senior Data Analyst

Job description

For nearly 20 years, TheKey (formerly Home Care Assistance) 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. View our video to learn more about TheKey.

The Sr. Data Analyst (Data Quality Engineer) has the primary responsibility to support the data warehouse in BigQuery and ensure that data is accurate and available for reporting, analytics, and other stakeholders. Our ideal candidate for the Sr. Data Analyst is experienced in making sense of data thru performing data analysis using sql queries and then creating structures that are easy to understand and use for reporting and analytics.

  • Designing and developing Data Quality monitoring systems and alerts
  • Creating new tables and views in BigQuery for analytics and reporting
  • Reconciling metrics in existing tables and views
  • Troubleshooting data related issues or inconsistencies in reports
  • Finding and resolving data quality problems
  • Performing data discovery on new sources of data being brought into the data warehouse
  • Creating data dictionaries and other documentation
  • Creating and updating shared data sources on Tableau Server
  • Ad-hoc data pulls for export to internal and external partners

Education And/or Experience:
  • Bachelor's degree in Computer Science, MIS, Data Science or related field
  • 8+ years data warehousing and/or business intelligence

Technical Skills:
  • 5+ years SQL scripting with advanced SQL skills including DML
  • Minimum 1 year experience with Google BigQuery or other cloud database
  • 3+ years experience database and/or data pipeline development experience
  • Bitbucket or other version control
  • Experience with GCP Data Fusion tool preferred
  • sFTP, Bitbucket, Jira, Confluence and Freshdesk tools a plus
  • some Tableau experience a plus

Other Qualifications:
  • Self driven individual with good problem solving skills
  • Ability to assess downstream impacts of data load errors
  • Can analyze data quality issues to determine root cause and propose a solution
  • Good communication skills and willingness to ask questions
  • Ability to manage multiple priorities at once and meet project deadlines
  • Prefer Data Modeling experience including relational and dimensional table design
  • Understanding of data privacy concerns such as PII, HIPA and GDPR is a plus

Benefits For Full Time Employees
  • Medical/Dental/Vision Insurance
  • Life Insurance
  • Health Savings Account
  • Flexible Spending Account
  • 401(k) Matching
  • Employee Assistance Program
  • Flexible PTO Plan
  • 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.


Please let the company know that you found this position on this Job Board as a way to support us, so we can keep posting cool jobs.

Similar jobs

Browse All Jobs
December 9, 2022
Sii Poland
December 9, 2022

Senior Data Engineer

December 9, 2022