Tivity Health, Inc.

Data Engineer - remote opportunity

Job description

Description/Responsibilities:

If you join our Tivity Health Data Management team as our newest Data Engineer/Developer, you will have the opportunity to assist us with developing a migration plan to move all our data from On Prem SQL servers into the cloud, Snowflake DB. We are seeking someone who is curious and innovative to be part of a strong team of intelligent problem solvers.


Currently, our team is responsible for all the data needs of the enterprise, and we work on multiple projects for new products, services, and API’s; along with maintaining the tables and views and nightly ETL’s in production. Every day is something new and exciting and we want you to be a part of supporting our business clients (Business Analytics, Business Intelligence, Finance, Accounting, Sales & Marketing) by providing clean, accurate, secure and readily accessible data.


Please take a look at the job responsibilities and qualifications, and please apply if you are interested in an exciting career in the health and data industry!

Primary responsibilities:

  • Work directly with Business User to further gather details for the User story and Design Solution to the business problem (enhancement, project, production break/fix)
  • Work directly with data architect or on own to document the job details (ETL), data structure (system input/output), data mapping, data model and solution proposed
  • Develop the code (SQL or Cube) using DM standards and practices (attaching installation scripts and rollback scripts for deployer team)
  • Unit Test the code/ send code to Code Review
  • Ability to present solutions to business teams
  • Ability to work through vague specifications
  • Experience in leading requirement gathering sessions
  • Code review other’s code development, offer suggestions for improvement or clarity
  • Support QA with understanding what changes were made, where to find the job (ETL)
  • Demonstrate the Code in Sprint Review for Business Users
  • Participate/ engage with Scrum Team using Agile methodology
Qualifications:

  • 3+ years experienced SQL/ETL Developer
  • Strong SQL/data background
  • Analytical services, data warehousing and Normalization/Denormalization of databases
  • Extensive experience in enterprise integration deployment, administration, scheduling jobs and maintenance
  • Basic understanding of Star schemas, snowflake schemas
  • Basic understanding of Snowflake data cloud and some experience migrating data from SQL DB into Snowflake
  • Ability to write Snowflake stored procedures
  • Strong experience with dimensional modeling and reporting tools, operations Data Store concepts, Data Marts and OLAP technologies
  • Ability to create complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load
  • Strong experience with coding in multi-dimensional or tabular Cube
  • Ability to work under pressure, self-starter, excellent communication skills, curiosity to learn new concepts and share solution ideas
  • Basic understanding of navigation through Collibra data warehouse/governance
  • Basic understanding (or certifications) of AWS
  • Working knowledge of Lambda and Glue
7220
#LI-CM1

About Tivity Health, Inc.
Tivity Health® Inc. is a leading provider of healthy life-changing solutions, including SilverSneakers®, Prime® Fitness and WholeHealth Living®. We plan to become the modern destination for healthy living by expanding beyond fitness as a digital engagement platform company. We are continuously developing the SilverSneakers suite of digital offerings and services to provide seniors with everything they need to maintain and improve their health, including physical activity, social connection, community involvement, volunteer opportunities and mental enrichment. Our goal is to partner with payers and service providers to enable a personalized, interactive, and intuitive experience to offer the right solutions to each member. We deliver solutions that help adults feel better, work better and live better, and improve health outcomes while reducing healthcare costs. Learn more at Tivity Health.

Tivity Health is an equal employment opportunity employer and is committed to a proactive program of diversity development. Tivity Health will continue to recruit, hire, train, and promote into all job levels without regard to race, religion, gender, marital status, familial status, national origin, age, mental or physical disability, sexual orientation, gender identity, source of income, or veteran status.

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.